Intermediate Excel:

They should be able to create and format a workbook containing various types of data; use AutoSum and other simple formulae, and use page setup to ensure the workbook fits on the page when printed.

The course covers:

• Use Excel functions
• Customise the Quick Access Toolbar
• Insert, name, move, copy, delete and group worksheets
• Use multiple worksheets and workbooks
• Use various features to manipulate and print large worksheets
• Create more advanced formulae; use relative and absolute cell references
• Name cells and ranges and use these in formulae
• Insert cell comments
• Use Go To and Paste Special
• Use advanced formatting techniques
• Sort and Filter a Worksheet using various types of criteria
• Create and print at least 2 types of charts

Please contact us for further information or you can book below via Eventbrite to secure your place on our next course.