MS Excel 2016 – Level 3
- Course focuses on advanced Excel features like PivotTables, Data Validation, and Advanced Formulas.
- Students learn to validate data, use advanced formulas, and work with PivotTables.
- Delegates should have prior knowledge of Excel functions like Charts and Conditional Formatting.
- Course objectives include creating PivotTables, using Auditing Tools, and working with Templates.
- Modules cover topics such as Data Validation, Advanced Formulas, Auditing a Worksheet, and PivotTables.
Overview
The Excel 2016 Training course is designed for delegates seeking to enhance their Excel skills with advanced features like PivotTables, Data Validation, and Advanced Formulas. Participants should have prior knowledge of various Excel functions. By the end of the course, students will be able to validate data, utilize advanced formulas, work with PivotTables, and more. The training covers modules on Data Validation, Advanced Formulas, Auditing a Worksheet, Creating PivotTables and PivotCharts, Working with Templates, and Inserting Illustrations.
Who should attend
Delegates
Course Content
Course Description
In this 1 day course you will build on the previous Excel courses, introducing more advanced topics.
Who is this course for:
Delegates who wish to learn more about some of the additional advanced features of Excel, including PivotTables, Data Validation and Advanced Formulas.
Delegate Requirements: Before starting this course, students are should be able to do the following:
- Use Names Ranges
- Calculate across worksheets/workbooks
- Create and use Charts
- Use Basic Sort and Filters
- Work with Excel Tables
- Apply Conditional Formatting
- Protect Views
- Track Changes
- Merge Workbooks
Objectives
Upon successful completion of this course, students will be able to:
- Validate Data
- Use Advanced Formulas
- Use Auditing Tools
- Create and manipulate PivotTables and PivotCharts
- Work with Templates
- Insert Illustrations
Course Content:
Module 1: Work with Data Validation
Number Validation
Data List Validation
Message Prompts and Alerts
Conditional Data Validation
Data Validation Errors
Module 2: Advanced Formulas
Statistical Functions to include MAXIFS, MINIFS
Working with Text Functions
Calculating with Financial Functions
Date and Time Functions
Database Functions
Module 3: Auditing a Worksheet
Display formulas in worksheet cells
Show precedent and dependent cells
Finding and Resolving Errors
Using the Watch Window
Evaluating a Formula
Module 4: Creating PivotTables, PivotCharts and Slicers
Creating a PivotTable
Amending the fields in a PivotTable
Updating the PivotTable
Adding Calculations to a PivotTable
Add Grouping to a PivotChart
Creating a PivotChart
Create and use Slicers
PivotTable Timelines
Creating from Tables and Related Tables.
Work with PowerPivot
Module 5: Working with Templates
Create a Hyperlink
Creating and adding Cell Comments
Module 6: Inserting Illustrations
SmartArt
Insert Images into a Spreadsheet and/or with correct orientation
Insert Shapes into a Spreadsheet
Group and Layer Graphics
Quick Shape Formatting
Duration:1 Day
Cost:£235 + VAT