Excel 2016 Master

Name: Excel 2016 Master
Brand: eBSI Export Academy
SKU: ITLU055

€40.00

Reliable shipping

Flexible returns

Buying for a team?
Choose 5 or 10 licences to purchase access for multiple learners at a reduced per-person rate. After purchase, eBSI will contact you to confirm the learner details and arrange course access for each participant.

Develop practical knowledge and confidence in Excel 2016 Master.

Excel 2016 Master : In this mastery course you will be taken to the highest level of proficiency in MS Excel 2016. Before attempting this course you should have completed the Essentials , Advanced and Expert courses.

Why this course matters

This course turns the subject into practical, structured learning you can apply in real business and workplace situations. It is designed to help you move beyond definitions and understand how the ideas, tools and decisions covered in the course fit together.

What you will gain

Use the key features and workflows covered in Excel 2016 Master with greater confidence.
Apply the tools and techniques to practical business tasks.
Recognise common mistakes and work more efficiently in day-to-day use.

Who is this course for?

This course is suitable for business users, administrators, managers and professionals who want to work more efficiently with everyday digital tools.

Course at a glance

Format: self-paced online learning.
Professional development: CPD course.

ITLU055 : Excel 2016 Master

Excel 2016 Master : In this mastery course you will be taken to the highest level of proficiency in MS Excel 2016. Before attempting this course you should have completed the Essentials, Advanced and Expert courses.

Objectives: This course takes users to a high level of knowledge using financial topics available in Excel such as Financial functions, auditing and Charts.

Completing this course will confer 2 CPD Credits towards internationally recognised Continuous Professional Development Requirements within organisations operating this kind of staff development methodology.

Unit Contents:

1. Getting Started
In this topic you will cover a basic introduction to the course unit and its objectives.

2. Working with Lists
In this topic you will cover:
Working with Lists
Creating a List
Maintaining a List
Editing Records Using the Data Form
Filtering a List
Using Subtotals in a List
Self-test Quiz

3. Macros and User Defined Functions
In this topic you will cover:
Macros and User Defined Functions
Recording and Using Macros
Assigning Macros
Using User-Defined Functions
Self-test Quiz

4. Basic Analysis Tools
In this topic you will cover:
Basic Analysis Tools
Performing “What If” Analyses
Working with Scenarios
Self-test Quiz

5. Advance Analysis Tools and External Data
In this topic you will cover:
Advance Analysis Tools and External Data
Querying a Database
Importing and Exporting Files
Protecting Data
Using Data Validation
Using Worksheet Protection
Password Protecting a Workbook
Self-test Quiz

6. Pivot Tables & Advanced Business Analysis Tools
In this topic you will cover:
Pivot Tables & Advanced Business Analysis Tools
Working with Pivot Tables and Pivot Charts
Identifying the Parts of a Basic Pivot Table
Pivot Table Reports
Create a PivotTable from worksheet data
Create a PivotTable from an external data source
Create a PivotChart report from an existing PivotTable report
Delete a PivotTable or PivotChart report
Slicers
Using slicers
Formatting slicers for a consistent look
Sharing slicers between PivotTables
Sparklines
Types of Sparklines
Create a sparkline
Customize sparklines
Control which value points are shown
Change the style of or format sparklines
Online Analytical Processing (OLAP)
Business intelligence
What is Online Analytical Processing (OLAP)?
OLAP features in Excel 2016
Self-test Quiz

7. Wrapping Up / Assessment Result
In this topic you will cover:
Course Conclusion
Wrapping up
Test Results Summary

Continue your learning

Part of this learning pathway: Microsoft Office & Windows

Learners also take: Excel 2016 Advanced | Excel 2016 Macros and VBA

Related training bundle: Excel 2016 Mastery Program

Course pathway: eBSI SME Academy > Microsoft Office & Windows > Excel 2016 Master

Explore more Microsoft Office & Windows training or return to the eBSI SME Academy.

Book a Free Video Consultation!

If you have any questions or would like to speak to one of our team before enrolling feel free to book a free video call with us by clicking the button below, we will be delighted to meet you on Google Meet!

Book your Free Video Call Now!