Microsoft Excel Intermediate

Microsoft Excel

Level: Intermediate

Duration: 1 day

This course will allow the delegate to create more effective spreadsheets and to some extent automate their work

Intended Course Content

The following are suggested topics for this level of the package and it is not intended that every subject will be covered. The actual content can be decided prior to the day or after discussion with the delegates. It will be dependent upon the skill levels of each individual

• Revision of introductory topics
• Understanding Page Set Up
• Named Cells and Ranges
• Working with multiple sheets – linking and 3d formulae
• Excel as a database – how to create a list
• Sorting information
• Using Autofilters
• Subtotalling
• Introducing pivot tables
• Charts – creating and modifying graphs and charts
• Introduction to functions – calculating averages, counting information and text functions
• Outlining and Grouping
• Conditional Formatting
• Paste Special Functions
• Freezing and splitting your screen

Pre Learning Requirements

Delegates should be aware of the contents of the introductory level course and be able to create simple formulas