Intermediate Excel Skills

Description

Our Intermediate Excel Skills training course provides users with a smart approach to working with spreadsheet data. Giving users useful and practical techniques for working with large spreadsheets and spreadsheets that require data analysis. You will practise using a range of time-saving and accuracy-ensuring features.

What you will learn

• Fast & efficient ways of navigating, selecting and entering data
• Relative & Absolute cell addressing
• Range Names
• Automatic subtotalling
• Conditional Formatting
• Logical Functions – IF Function
• Introduction to Lookups
• Data Consolidation
• Introduction of Pivot Tables
• Protection of cells, Worksheets and Workbooks