MICROSOFT EXCEL – LEVEL 3 (2013, 2016, 2019, 365)

Instructor : Bruce McVicar

MICROSOFT EXCEL – LEVEL 3 (2013, 2016, 2019, 365)

Who should take this course

Take a dive into advanced features of Excel’s navigation, functions, and custom formulas and become a power user!

Outlines

In this training you will:

Expand knowledge of notable functions in Excel.
Understand a wide variety of cell formatting to manipulate and interpret data.
Learn to create Pivot tables for data analyzation.
Understand options to restrict and protect data in Excel.
Utilize accessibility options in Excel using the Check Accessibility tool and how to add alternative text.

Certificate

Awareness and accomplished attendance

Perquisites

Course Details

Course Outline:
Section 1: Enhancing Workbooks
Section 1.1: Customizing Workbooks
Section 1.2: Preparing a Workbook for Multiple Audiences
Section 1.3: Managing Themes
Section 1.4: Creating and Using Templates
Section 2: Working with Multiple Workbooks
Section 2.1: Consolidating Data
Section 2.2: Linking Cells in Workbooks
Section 2.3: Merging Workbooks
Section 3: Analyzing and Presenting Data Section 3.1: Create Sparklines
Section 3.2: Create Scenarios
Section 3.3: Perform A What-if Analysis
Section 3.4: Perform A Statistical Analysis with the Analysis Toolpak
Section 4: Importing and Exporting Excel Data
Section 4.1: Exporting Excel Data
Section 4.2: Importing a Delimited Text File
Section 5: Analyzing Data with Pivot Tables, Slicers, and Pivot Charts
Section 5.1: Creating a Pivot Table
Section 5.2: Filtering Pivot Table Data
Section 6: Automating Worksheet Functionality
Section 6.1: Updating Workbook Properties Workbook Properties
Section 6.3: Applying Conditional Formatting
Section 6.4: Adding Data Validation Criteria



PAYMENT
For payment information email: [email protected]