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 live demonstrations and hands-on activities for increased skill development.
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.
Course Content
-
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
