• Some experience of working in Microsoft Excel would be beneficial.
• Attendees must be comfortable opening, closing and saving files, and be able to navigate through files and folders. Delegates should also be familiar with the cut, copy and paste commands.
• This course is suitable for anyone using Excel 2010, 2013, 2016, 2019 or Excel 365. If you're attending at a QA location, the course will be delivered on Microsoft Excel 2016.

• Master the Excel user interface
• Use keyboard fundamentals – selecting, formatting and navigating Excel
• Modify and manage worksheets
• Create and audit formulas
• Work with advanced functions including named ranges, VLOOKUPS, TEXT etc.
• Create and modify Excel tables
• Understand PivotTable fundamentals
• Use Excel’s Quick Analysis Tools
• All with an emphasis on the keyboard

Module 1 - Introducing the Keyboard

• Excel Fundamentals
• The Fluent User Interface
• General Hotkeys
• Navigating Cells in Worksheets

Module 2 - Modifying a Workbook

• The Cut, Copy and Paste Commands
• Flash Fill
• AutoFill Options
• Find and Replace
• Spelling
• Undo and Redo Commands
• Selecting, Inserting and Deleting Columns, Rows and Cells
• Column Width and Row Height
• Hide and Unhide Options

Module 3 - Formatting an Excel Worksheet

• The Font Group
• Number Group
• Cell Alignment

Module 4 - Managing Worksheets and Workbooks

• Managing Worksheets
• Freezing Rows and Columns
• Split Screen
• Arranging Workbooks
• Viewing Workbooks Side By Side
• Workbook Windows

Module 5 - Using Formulas and Functions

• Relative and Absolute References
• The Order of Operations
• Auto Calculate
• Inserting Functions
• Using AutoSum
• Copying a Formula
• Creating an Absolute Formula
• Using Mixed References in Calculations

Module 6 - Advanced Functions and Exploring Excel’s Function Categories

• Function Categories
• Working with Range Names
• Applying Lookup Functions
• Using Logical Functions
• Calculating across Worksheets
• Analysing Data based on Criteria
• Working with Text Functions

Module 7 - Mastering Excel Tables

• Introducing Excel Tables
• Using Advanced Table Tools

Module 8 - An Introduction to PivotTables

• Understanding PivotTables
• Analyse data with Recommended PivotTables

Module 9 - Using Excel’s Quick Analysis Tools

Appendices

• Comprehensive list of Excel keyboard shortcuts