Online Excel Training Course

Course Description: This virtual course is designed for people wish to learn how to create and work with multiple worksheets whether it be consolidating data or calculating across worksheets.  In this course we will also create and format charts, work with headers and footers and use Excel Filtering to extract the data you require.

Prerequisites: Delegates attending this course should have a basic knowledge of Excel.

Course Content

• Consolidating data from multiple worksheets:

• Consolidate by Position
• Consolidate by Category
• To consolidate data by Position over several worksheets or workbooks
• To Consolidate By Category selected rows and columns from several worksheets or workbooks

• Calculate across multiple worksheets:

• 3D Cell Reference within the same workbook
• 3D Cell References using different workbooks
• Using a Copy and Paste Link
• Managing Links
• Edit Links
• Change the StartUp Prompt
• Remove Links

• Work with Headers and Footers

• Insert Headers and Footers
• Insert Header and Footer Elements
• Header and Footer Navigation
• Header and Footer Options

• Create and Format Charts

• Understanding Charts
• New Charts in 2016
• Create a Chart
• Modify and Format a Chart
• Add or Remove Chart Data
• Creating Dual Axis Charts
• Add a Trendline to a Chart

• Analyse Data Using Sparklines
• Use the auto filter to sort and filter lists including settings

• Apply basic Filters
• Text Filtering
• Number Filtering
• Use Advanced Filters
• Filter Settings

This course will run 3 hours with a 15-minute break.  Morning sessions will be 09:30 until 12:30.  Afternoon sessions will be from 13:00 until 16:00 with a 15-minute break.