Next Level Excel (Virtual)
Master essential Excel functions like IF, IFS, VLOOKUP, and date/time tools—then learn how to create eye-catching charts that clearly tell your data’s story, and save your favorites as templates for future use.
What This Course Is About:
This hands-on course will focus on Excel Functions, including IF statements, IFS, VLOOKUPs, and date/time functions. We will also explore how to quickly summarize your data with the correct eye-catching chart and save commonly used chart types as templates.
What You’ll Learn:
Intermediate Functions
1) Basic IF Statement
2) New: IFS
3) Nest If Function
4) Use a formula within the IF Statement
5) Combine the IF function with the AND function
6) VLOOKUP
7) XLOOKUP (Office 365)
8) CONCAT vs. FlashFill
9) Text to Columns
10) SUMIF
11) TEXTJOIN
12) MINIFS
13) MAXIFS
14) SWITCH
15) NOW & TODAY
16) WORKDAY & NETWORKDAYS
17) YEARFRAC
Charting
1) Explore various types of Charts (Bar, Line, Area, Pie, etc.)
2) Chart Elements
3) Chart Color and Format
4) Chart Filtering
5) Switch Row/Column Data
6) Create a Chart with Two Axis
7) Customize Chart Elements
8) Add a Trend Line
9) Add a Data Table
10) Add Data to Chart using a Table
11) Create a Re-usable Chart Template
Why EDGE?
We’re known for responsive service, customized training, and a practical approach that meets the needs of today’s workplace. Our instructors tailor each session to your team’s experience level, ensuring relevant, hands-on learning that sticks.
Let’s turn spreadsheets into strategy—with Excel training that’s clear, powerful, and results-driven.