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

Instructor : Bruce McVicar

MICROSOFT EXCEL – LEVEL 2 (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!


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.


Awareness and accomplished attendance


Course Details

Course Outline:
Section 1: Working with Range Names What are Range
Section 2: Using Specialized Functions
Section 3: Analyzing Data with Logical and Lookup Functions
Section 4: Using Financial Functions
Section 5: Auditing Worksheets
Section 6: Organizing Worksheet Data with Tables What Are Tables?
Section 7: Sorting and Filtering Data
Section 8: Using Subtotal and Database Functions to Calculate Data
Section 9: Visualizing Data with Charts
Section 9.1: Inserting Charts
Section 9.2: Modifying and Formatting Charts
Section 9.3: Adding Trendlines

For payment information email: [email protected]