At the end of the course participants will be able to: set up multiple sheets with a standard structure quickly and efficiently; work with formulas that use values in other sheets and even other Excel files (workbooks); document their work so that others can work with the same data more easily; protect parts of their spreadsheet from accidental or deliberate modification.

The course follows on from the basic Excel course. A third Excel course dealing with the use of Excel to simulate a database is not dependent on this course..

The course typically runs during a morning from 9.00 AM to 1.00 PM but could span four hours in the middle of the day if preferred. Participants may also be residential. For more detail of how our half day relax and learn modules operate please click here, for our rates click here and for details of how we schedule course please click here.

Top

Course Content

1. Manipulating Sheets Inserting, renaming, deleting and moving sheets.

2. Setting Up Constant Data Across Several Sheets Copying sheets; filling existing data across worksheets; and making changes to cells in multiple selected sheets..

3. Working With Formulas Working with formulas across worksheets and workbooks (files); moving or copying cells; the INDIRECT function; 3-D references in range addresses; using range names.

4. Documenting and Auditing Your Work Using: workbook properties; comments; formula tracing..

5. Data Security Protecting cells from modification;  protecting the structure of a workbook; hiding sheets; preventing unauthorised opening of a workbook.

6. Finding and Editing Data in Large Workbooks Finding and replacing text.

7. Keeping Headings in View Both on screen when scrolling and on multiple pages of printed sheets.

If you have any questions about this course please contact us using the contact details below.