Microsoft Excel Advanced Functions and Formulas
(2013, 2016, 2019, 2021, 365)
What You'll Learn in Microsoft Excel Advanced Functions and Formulas
Course Length:
Learning Objectives
After completing this course, students will be able to:
- Identify which function to use to generate results
- Employ a number of strategies for creating functions
- Build their own functions using the fx tool
- Add multiple worksheets together
- Utilize array formulas
Target Student
This course is designed for Excel users with some knowledge of entering financial data but would like to explore more mathematical functions.
Course Outline
Section 1: Working with Basic Formulas, Functions and Named Ranges
Creating Basic Functions
Absolute & Relative Cell References
Updating Values without Formulas (Paste Special)
Displaying & Highlighting Formulas
Named Ranges
Logical Functions
IF Logical Tests
COUNTIF, SUMIF, SUMIFS, and AVERAGEIF
Section 2: Text Functions
Locating Data with FIND, SEARCH, EXACT
Extracting Data with LEFT, RIGHT, and MID
Flash Fill
Combine Data from Different Cells Using CONCATENATE
Changing the Case of Text Using PROPER, UPPER, and LOWER
Section 3: Information Functions
ISERR, ISERROR, IFERROR
Section 4: Lookup Functions
VLOOKUP
MATCH (2 list comparison)
INDEX (pull info from a list based on column and row headings)
Section 5: Date and Time Functions
DAYS
WORKDAY
WORKDAY.INTL
NETWORKDAYS
Retrieving Dates in Excel
WEEKDAY
WEEKNUM
DATEDIF
Section 6: Statistical Functions
MEDIAN
MODE
RANK
COUNTBLANK
Section 7: Math Functions and Arrays
ROUND
ARRAY FORMULAS
Basic Array Formulas
Array Formulas with Basic Functions
Array Formulas with VLookup
Section 8: Database Functions
DSUM, DCOUNT, DAVERAGE
Microsoft Excel Advanced Functions and Formulas
Upcoming Classes
All Public classes are held onlinewith a live instructor
| Dates | Price | Qty |
|---|---|---|
| October 3, 2024 9:00 AM to 4:00 PM ET | $475.00 Online | |
| February 19, 2025 9:00 AM to 4:00 PM ET | $475.00 Online | |
| September 9, 2025 9:00 AM to 4:00 PM ET | $475.00 Online |
I want to talk to someone about private or customized training
Have questions about this course? See below or reach out to our training coordinators.
Group of 4 or more? Consider private training
The Great Canadian Training & Consulting Company Advantage
When you train with us, your training will not just check a box. We make sure it is GREAT!
- Experienced Trainers
- Guaranteed to run classes
- Learning Guarantee
- Anytime after-training support for 30 days
- Bilingual training, manuals & post-training support available
This course comes with
PDF Reference Guide
Take the Reference Guide anywhere and save the environment with an electronic copy of your training Reference Guide for use on any of your computers or devices
Use Your Own Files
Whether it's one-on-one or group training you can give us files to include in your training session and help you apply what you learn even more!
Printed Reference Guide
Instead of the PDF that comes with your course, purchase a printed paper Reference Guide for use during your class and future reference