• Handling large MS Excel spreadsheets
• Split screen and freeze panes
• Custom views
• Tracking changes
• Conditional statements
• Conditional formatting
• Creating and editing charts
• Using an outline
• Sorting a list
• Auto filter and advanced filtering
• Automatic subtotalling
• Creating a pivot table

Who is it for? This course is suitable for people who have some experience using MS Excel or attended the MS Excel Introduction course and would like to learn about additional features and produce spreadsheets more efficiently.

Building on your existing knowledge of MS Excel this course includes tools for handling large Excel spreadsheets and managing lists of data. You will also understand how to control Excel worksheets that are being edited by several people.

This course will enable you to create, build and customise graphs including plotting trend lines and summarise a large Excel worksheet using the outlining tools. You will also learn about making decisions using conditional statements and formatting.

“Very informative and Sarah is a very good trainer. I feel the course has helped a lot in my duties at work."

SB, Capespan Ltd

"Great, just the right mix of tips and tricks as well as full discussion of main points. It has given me more tools to effectively handle information management in my job.”

AY, Business Link Kent