Microsoft Excel L3 Advanced – Live Virtual Bitesize Training Modules 1-4
Course Overview
If you are looking to work with templates and also gather together your data from separate worksheets into a master worksheet then this is the module for you.
Microsoft Excel L3 Advanced – Live Virtual Bitesize Training Modules 1-4
Module 1. Saving Templates, Working with Data Consolidation & Worksheet Protection- 1½ Hours
If you are looking to work with templates and also gather together your data from separate worksheets into a master worksheet then this is the module for you.
Course prerequisites: Candidates should have attended Excel level 1 and level 2 training or have equivalent knowledge.
This module will cover:
- Saving Workbooks as Templates
- Data Consolidation
- Protection
- Outlining
Module 2. Using Data Analysis Tool - 1½ Hours
In this module we will Explore Excel’s powerful Data Analysis tool.
Course prerequisites: Candidates should have attended Excel level 1 and level 2 training or have equivalent knowledge.
This module will cover:
- Goal Seek
- Scenarios
- Data Tables
- Solver
Module 3. Advanced Database options- 1½ Hours
In this module we will be using Excels Advanced Filters and data validation. Advanced Filters allow you to extract your filtered data to another place in your worksheet/workbook or extract a unique list of records. You will also record your own Macros.
Course prerequisites: Candidates should have attended Excel level 1 and level 2 training or have equivalent knowledge.
This module will cover:
- Filter/ Advance Filter
- Using Data Validation
- Hyperlinks
- Working with Macros
Module 4 Pivot Tables & Dashboards - 1½ Hours
This session will help you take sets of data and quickly analyse them using the Pivot Table and Chart tools. We'll show you how to pick the right headings to ask meaningful questions of your data and how to edit a Pivot Table, so it shows exactly the information you need. We will also learn how to link and create a Dashboard.
Course prerequisites: Candidates will need a good working knowledge of Excel at an intermediate level and be confident setting up data in a spreadsheet, saving and locating the file.
This module will cover:
- Pivot Tables
- Understanding Pivot tables
- Create Pivot charts
- Use slicers
- Dashboards
- Link and create a dashboard.
Bite Size training also available for Excel L1 Foundation & Excel L2 Intermediate visit www.jcstraining.com for course details of these and other Excel training available through JCS training.
Microsoft Excel L3 Advanced – Live Virtual Bitesize Training Modules 1-4
Course Overview
If you are looking to work with templates and also gather together your data from separate worksheets into a master worksheet then this is the module for you.
Microsoft Excel L3 Advanced – Live Virtual Bitesize Training Modules 1-4
Module 1. Saving Templates, Working with Data Consolidation & Worksheet Protection- 1½ Hours
If you are looking to work with templates and also gather together your data from separate worksheets into a master worksheet then this is the module for you.
Course prerequisites: Candidates should have attended Excel level 1 and level 2 training or have equivalent knowledge.
This module will cover:
- Saving Workbooks as Templates
- Data Consolidation
- Protection
- Outlining
Module 2. Using Data Analysis Tool - 1½ Hours
In this module we will Explore Excel’s powerful Data Analysis tool.
Course prerequisites: Candidates should have attended Excel level 1 and level 2 training or have equivalent knowledge.
This module will cover:
- Goal Seek
- Scenarios
- Data Tables
- Solver
Module 3. Advanced Database options- 1½ Hours
In this module we will be using Excels Advanced Filters and data validation. Advanced Filters allow you to extract your filtered data to another place in your worksheet/workbook or extract a unique list of records. You will also record your own Macros.
Course prerequisites: Candidates should have attended Excel level 1 and level 2 training or have equivalent knowledge.
This module will cover:
- Filter/ Advance Filter
- Using Data Validation
- Hyperlinks
- Working with Macros
Module 4 Pivot Tables & Dashboards - 1½ Hours
This session will help you take sets of data and quickly analyse them using the Pivot Table and Chart tools. We'll show you how to pick the right headings to ask meaningful questions of your data and how to edit a Pivot Table, so it shows exactly the information you need. We will also learn how to link and create a Dashboard.
Course prerequisites: Candidates will need a good working knowledge of Excel at an intermediate level and be confident setting up data in a spreadsheet, saving and locating the file.
This module will cover:
- Pivot Tables
- Understanding Pivot tables
- Create Pivot charts
- Use slicers
- Dashboards
- Link and create a dashboard.
Bite Size training also available for Excel L1 Foundation & Excel L2 Intermediate visit www.jcstraining.com for course details of these and other Excel training available through JCS training.
