Mastering Excel Features: From Beginner to Advanced

1 Day, 9:00-4:00, 6 Hours

Course Overview

This instructor-led class unlocks the full potential of Excel, taking you from a beginner to an advanced user. Whether you’re just getting started or looking to master Excel’s most powerful features, this course covers essential skills that will transform how you work with data. Learn how to effortlessly manipulate dates and times, harness the power of dynamic arrays for efficient data analysis, and explore PivotTables to organize and summarize data with ease.

Course Objectives

Use a variety of statistical and text functions
Work with large lists of data, apply filters, and use tables
Create PivotTables to analyze and summarize data
Understand Dynamic Array Functions
Use the XLOOKUP function to locate values from a table or range

Course Outline

Back to Basics

Changing Column Widths
Copying Formatting from One Cell to Another
Aligning Data in Cells
Centering Data Across Columns
Wrapping Text within Cells
Formatting Numbers and Formulas
Formatting Dates
Applying Borders
Applying Fill Color
Inserting and Deleting Columns or Rows
Formatting Multiple Worksheets Simultaneously
Grouping Multiple Worksheets
Ungrouping Worksheets

Working with Statistical and Logical Functions

Understanding Absolute vs. Relative Cell References
Using the IF Function to Perform an Action Based on a Condition
Writing IF Statements
Using the IFS Function for More Than Two Outcomes
Using the SWITCH Function to Display Results
Using the COUNT Function to Count a List of Numbers
Using the COUNTA Function to Count Non-Empty Cells
Using the COUNTBLANK Function to Count Blank Cells
Using the COUNTIF Function to Count Based on a Criterion
Using the COUNTIFS Function to Count Based on Multiple Criteria

Working with Dynamic Array Functions

Understanding Arrays
Working with Dynamic Array Functions
Using the SEQUENCE Function
Using the XLOOKUP Function
Using the UNIQUE Function
Using the SORT Function
Using the FILTER Function
Validating Data Entry
Applying Data Validation

Working with Large Lists of Data

Design Concepts for Structuring Large Lists
Header Row (Fields)
Data Range (Records)
Filtering Lists
Applying Filters
Applying Top 10 and Custom Filters
Working with Advanced Filters
Criteria Range
Applying Advanced Filters
Converting Lists of Data to Excel Tables
Creating and Naming Tables
Using Table Elements and Features

Creating PivotTables to Analyze Data

Creating PivotTables
Adding and Removing Fields
Grouping Data and Rearranging Fields
Using Report Filters
Changing Value Field Settings
Refreshing Data in PivotTables

Cost and Delivery Format Options

We offer the above listed class as a private group class in the following delivery formats:

Live Virtual
1-4 students	$950
5-8 students	$1400
9-12 students*	$1600
*$100 per additional student

At Your Location
1-4 students	$1200
5-8 students	$1650
9-12 students*	$1850
*$100 per additional student

Private Group Training

Volume discounts of 5% to 20% are available when five or more training days are scheduled. For classes conducted at your location, you are responsible for the classroom setup which should include:

A computer for each student (with the appropriate software installed), and
An instructor workstation connected to a visual display (e.g., projector, smartboard, etc.).

Customization

Softek can easily customize a training course that covers the specific topics you require and integrate examples relevant to your work environment. Course customization is billed at $150 per hour and covers time needed to meet, discuss, prepare, and incorporate any specific examples into the training program. Once we have a better idea of what you have in mind, we will be glad to provide a specific price quote for the customization.