Microsoft Excel L2 Intermediate – Live Virtual Bitesize Training Modules 1-4
Course Overview
This session is for you if you want work with multiple workbooks and worksheets. Linking sheet tabs, Link cells from different worksheets and view multiple sheets from one workbook at the same time
Microsoft Excel L2 Intermediate – Live Virtual Bitesize Training Modules 1-4
Module 1. Using Multiple Worksheets and Workbooks - 1½ Hours
This session is for you if you want work with multiple workbooks and worksheets. Linking sheet tabs, Link cells from different worksheets and view multiple sheets from one workbook at the same time
Course prerequisites –Candidates should have good working knowledge of Excel L1 This module will cover:
- Using Multiple Worksheets
- Inserting New Worksheets
- Renaming Worksheets
- Deleting Worksheets
- Creating Multiple Views
- Freezing Panes
- Viewing and Arranging Multiple Worksheet Windows
- Navigating in Multiple Workbooks
- Selecting and Viewing Multiple Workbooks
- Creating and Opening a Workspace
- Managing Multiple Worksheets and Workbooks
- Selecting Multiple Worksheets
- Linking formulas in across worksheets
- Moving and Copying Data between Worksheets
- Working with Lists
- Setting Subtotals
Module 2. Working with Named Ranges - 1½ Hours
In this session we cover how to name cells and use them in formulas. Using Named Ranges will help make formulas a lot easier to create, read and reuse.
Course prerequisites –Candidates should have good working knowledge of Excel L1 This module will cover:
- Creating and Using Named Ranges
- Automatically Naming Ranges
- Navigating with Named Ranges
- Using Range Names in Formulas
- Pasting a List of Named Ranges
- Deleting and Editing Range Names
- Creating Named Constants
Module 3. Charts - 1½ Hours
This session will take a set of data and help you make it meaningful by creating bar charts, pie charts and explore other charts.
Course prerequisites: Candidates will need to be confident setting up data in a spreadsheet, saving and locating the file.
This module will cover:
- Using Charts
- Creating a Chart
- Changing Chart Type, Style and Chart Sub-Type
- Changes to the Chart Source Data
- Add data to an existing chart
- Change the data in an existing chart
- Remove data from a chart
- Managing Chart Objects
- Moving and Resizing Chart Objects
- Deleting Chart Objects
- Adding Data Series and Objects to a Chart
- Changing the Chart Type
- Formatting Chart Objects
- Printing Charts
Module 4. Advance Formulas & Functions - 1½ Hours
If you are able to create spreadsheet layouts but now need more advanced Excel's calculating power, this session will be the one to choose.
Course prerequisites: Candidates need a good working knowledge of Excel at level 1 This module will cover:
- Vlookup
- Hlookup
- If functions
- Countif
- Sumif
- Using Dates
- Flash Fill
- Subtotal function
- Other functions and formulas etc
Bite Size training also available for Excel L1 Foundation & Excel L3 Advanced visit www.jcstraining.com for course details of these and other Excel training available through JCS training.
Microsoft Excel L2 Intermediate – Live Virtual Bitesize Training Modules 1-4
Course Overview
This session is for you if you want work with multiple workbooks and worksheets. Linking sheet tabs, Link cells from different worksheets and view multiple sheets from one workbook at the same time
Microsoft Excel L2 Intermediate – Live Virtual Bitesize Training Modules 1-4
Module 1. Using Multiple Worksheets and Workbooks - 1½ Hours
This session is for you if you want work with multiple workbooks and worksheets. Linking sheet tabs, Link cells from different worksheets and view multiple sheets from one workbook at the same time
Course prerequisites –Candidates should have good working knowledge of Excel L1 This module will cover:
- Using Multiple Worksheets
- Inserting New Worksheets
- Renaming Worksheets
- Deleting Worksheets
- Creating Multiple Views
- Freezing Panes
- Viewing and Arranging Multiple Worksheet Windows
- Navigating in Multiple Workbooks
- Selecting and Viewing Multiple Workbooks
- Creating and Opening a Workspace
- Managing Multiple Worksheets and Workbooks
- Selecting Multiple Worksheets
- Linking formulas in across worksheets
- Moving and Copying Data between Worksheets
- Working with Lists
- Setting Subtotals
Module 2. Working with Named Ranges - 1½ Hours
In this session we cover how to name cells and use them in formulas. Using Named Ranges will help make formulas a lot easier to create, read and reuse.
Course prerequisites –Candidates should have good working knowledge of Excel L1 This module will cover:
- Creating and Using Named Ranges
- Automatically Naming Ranges
- Navigating with Named Ranges
- Using Range Names in Formulas
- Pasting a List of Named Ranges
- Deleting and Editing Range Names
- Creating Named Constants
Module 3. Charts - 1½ Hours
This session will take a set of data and help you make it meaningful by creating bar charts, pie charts and explore other charts.
Course prerequisites: Candidates will need to be confident setting up data in a spreadsheet, saving and locating the file.
This module will cover:
- Using Charts
- Creating a Chart
- Changing Chart Type, Style and Chart Sub-Type
- Changes to the Chart Source Data
- Add data to an existing chart
- Change the data in an existing chart
- Remove data from a chart
- Managing Chart Objects
- Moving and Resizing Chart Objects
- Deleting Chart Objects
- Adding Data Series and Objects to a Chart
- Changing the Chart Type
- Formatting Chart Objects
- Printing Charts
Module 4. Advance Formulas & Functions - 1½ Hours
If you are able to create spreadsheet layouts but now need more advanced Excel's calculating power, this session will be the one to choose.
Course prerequisites: Candidates need a good working knowledge of Excel at level 1 This module will cover:
- Vlookup
- Hlookup
- If functions
- Countif
- Sumif
- Using Dates
- Flash Fill
- Subtotal function
- Other functions and formulas etc
Bite Size training also available for Excel L1 Foundation & Excel L3 Advanced visit www.jcstraining.com for course details of these and other Excel training available through JCS training.
