EXCEL TRAINING COURSES

Course 1 : Excel Fundamentals

Learn the basics of Excel, from navigating the interface to creating simple formulas and managing data. Perfect for professionals new to Excel or those who need a refresher of the basics to build a solid foundation. This training features hands-on activity and will have an opportunity for one-on-one time with the instructor.

Course Content

    • Menus and Ribbons

    • File Types

    • Page Layout

    • Working with Rows and Columns

    • Data Entry

    • Cell and Data Formatting

    • Identifying and Assigning Data Types

    • Filling and Dragging Data into columns and rows

    • Inserting and Deleting Cells, Columns and Rows

    • Overview of formulas and formula types/groups

    • Review of Fundamental Arithmetic Functions – Sum, Count, CountA, Average, Max, Min

    • Single IF statements

    • Overview of Errors

    • Creating, naming and formatting tables

    • Inserting and Formatting Charts

    • Conditional Formatting

    • Organizing, Labeling and Formatting Data and Worksheets

Course 2: Advanced Excel - Data Analysis and Visualization

This course will equip participants with advanced Excel skills that are essential for enhancing productivity, improving data accuracy, and facilitating informed decision-making. The course will focus on practical, hands-on learning to ensure participants can immediately apply their newfound skills in their roles. Participants will be given the opportunity to practice their skills and create dashboards and reports using a provided example or using actual data from their day-to-day positions.

This course assumes basic level understanding and fluency in MS Excel. Knowledge of the following topics is highly recommended: Copy and Pasting data, Transposing Data, Inserting new columns/rows/worksheets, Creating tables, and Basic arithmetic functions like SUM, COUNT, and AVERAGE.

    • Advance sorting and filtering

    • Removing duplicates

    • Data validation

    • Data set-up and structure

    • Look-up Formulas - MATCH, INDEX-MATCH, VLOOKUP, and HLOOKUP

    • Nested IF statements

    • Aggregate Formulas - SUMIF/SUMIFS, COUNTIF/COUNTIFS, AVERAGEIF/AVERAGEIFS

    • Relative and Absolute References

    • Drag and Dropping Formulas

    • Effective Data and Worksheet Organization

    • Understanding Existing Data Sets

    • Data Prep for Pivot Table Creation

    • Data Clean Up Formulas and Functions – TRIM, Text to Columns

    • Creating Pivot Tables

    • Sorting and Filtering Pivot Tables

    • Formatting Pivot Tables

    • Creating Pivot Charts

    • Adding Slicers

    • Linking tables for merged Pivot

    • Tips and best practices for creating dashboards and reporting tools

    • Participants will create their own report or dashboard using a provided example or personal project

Course Content

See Course Brochure for dates and pricing!