Excel Training

Excel Level 1 - Introduction to Excel 

Standard Duration:  1 Day

This course is designed for students who want to gain the necessary skills to create, edit, format, and print basic Microsoft Excel 2016 worksheets.

Excel Level 2 – Intermediate Excel

Standard Duration: 1 Day

This class is meant for students who want to advance their skill set by learning to work with advanced formulas, lists, and illustrations. Students will also work with charts and advanced formatting including styles.

Excel Level 3 – Advanced Excel

Standard Duration: 1 Day

This Advanced training class is designed for students to gain the skills necessary to use pivot tables, audit and analyze worksheet data, utilize data tools, collaborate with others, and create and manage macros.

Data Analysis with PivotTables

Standard Duration: 1 Day

Students taking this course are experienced Excel users who are seeking to advance their data analysis capabilities by using PivotTables.

Power Pivot and Power Query for Excel 2016

Standard Duration: 2 Days

This course will cover techniques for manipulating and querying data, the structure of DAX functions, ways to distribute and visualize data using Pivot Charts, Slicers, Sparklines, Timelines, Power View and 3D maps.

Analyzing Data with Power BI (20778)

Standard Duration: 3 Days

The main purpose of the course is to give students a good understanding of data analysis with Power BI. The course includes creating visualizations, the Power BI Service, and the Power BI Mobile App.

Analyzing Data with Excel (20779)

Standard Duration:  3 Days

The main purpose of the course is to give students the ability to add BI techniques to Excel data analysis. The course goes beyond the capabilities of tables and charts and uses Pivot Charts, the Excel Data Model, and Power BI.

Course Reviews

X