Expires in:
Expires in:
Expires in:
Self-paced course
Self-paced course
Excel Formulas & Functions
Excel Formulas & Functions
Rating 4.6
13,047 reviews
13,047 reviews
13,047 reviews
Course Description
This course is all about using formulas and functions to turn basic Excel worksheets into dynamic, powerful analytics tools.
We’ll cover 75+ core functions through hands-on demos that focus on real-world use cases—not just syntax. The goal isn’t memorization—it’s learning how to think like Excel.
By the end, you’ll be able to build interactive dashboards, automate repetitive tasks, and manipulate data using text functions, logical tests, time intelligence, dynamic arrays, and more.
Whether you’re brushing up on the basics or aiming for expert-level formula skills, you’ve come to the right place.
Course Description
This course is all about using formulas and functions to turn basic Excel worksheets into dynamic, powerful analytics tools.
We’ll cover 75+ core functions through hands-on demos that focus on real-world use cases—not just syntax. The goal isn’t memorization—it’s learning how to think like Excel.
By the end, you’ll be able to build interactive dashboards, automate repetitive tasks, and manipulate data using text functions, logical tests, time intelligence, dynamic arrays, and more.
Whether you’re brushing up on the basics or aiming for expert-level formula skills, you’ve come to the right place.
Course Content
24.0 video hours
Skills you'll learn in this course
Master lookup, math & logical functions to solve tasks
Create robust nested formulas that eliminate manual edits
Audit & debug workbook logic professionally
Boost productivity with named ranges & dynamic arrays
Meet your instructors
Chris Dutton
Founder & CPO
Chris is an EdTech entrepreneur and best-selling Data Analytics instructor. As Founder and Chief Product Officer at Maven Analytics, his work has been featured by USA Today, Business Insider, Entrepreneur and the New York Times, reaching more than 1,000,000 students around the world.
Student reviews
I really enjoyed this course. I thought it was well planned and layed out, easy for me to follow. The work load(h.w. & test)was just enough, so i could finish everything with enough time, learn about the topics and not feel over loaded and rushed. Also,it helped me a lot in my projects. Thank you so much ❤️
Tapur Jain
This course is a game-changer! The instructor's clear explanations and practical examples made learning Excel fun and easy. I'm amazed at how much I've learned in such a short time. From basic formulas to advanced techniques, this course covers it all. I'm now more confident in my Excel skills and can't wait to apply what I've learned. Thank you, Maven Analytics, for this fantastic course! Love from India! 🇮🇳
Bhushan Janardan Gawali
I recently completed the Microsoft Excel: Formulas & Functions course, and I was very impressed with the quality of the content. The lessons were well-structured and easy to follow, and the instructor did a great job of explaining complex concepts in a clear and concise manner. I particularly enjoyed the hands-on exercises, which helped me solidify my understanding of the material. I've already started applying the skills I learned in my daily work, and I've seen a significant increase in my productivity. I would highly recommend this course to anyone looking to improve their Excel skills.
Sonika
Included learning paths
Course credential
You’ll earn the course certification by completing this course and passing the assessment requirements
Excel Formulas & Functions
Excel Formulas & Functions
CPE Accreditation
CPE Credits:
0
Field of Study:
Information Technology
Delivery Method:
QAS Self Study
Maven Analytics LLC is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have the final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org.
For more information regarding administrative policies such as complaints or refunds, please contact us at admin@mavenanalytics.io or (857) 256-1765.
*Last Updated: May 25, 2023
Course Description
This course is all about using formulas and functions to turn basic Excel worksheets into dynamic, powerful analytics tools.
We’ll cover 75+ core functions through hands-on demos that focus on real-world use cases—not just syntax. The goal isn’t memorization—it’s learning how to think like Excel.
By the end, you’ll be able to build interactive dashboards, automate repetitive tasks, and manipulate data using text functions, logical tests, time intelligence, dynamic arrays, and more.
Whether you’re brushing up on the basics or aiming for expert-level formula skills, you’ve come to the right place.
Course Description
This course is all about using formulas and functions to turn basic Excel worksheets into dynamic, powerful analytics tools.
We’ll cover 75+ core functions through hands-on demos that focus on real-world use cases—not just syntax. The goal isn’t memorization—it’s learning how to think like Excel.
By the end, you’ll be able to build interactive dashboards, automate repetitive tasks, and manipulate data using text functions, logical tests, time intelligence, dynamic arrays, and more.
Whether you’re brushing up on the basics or aiming for expert-level formula skills, you’ve come to the right place.
Curriculum
1
Orientation & Benchmark Assessment
1
Orientation & Benchmark Assessment
1
Orientation & Benchmark Assessment
2
Getting Started
2
Getting Started
2
Getting Started
3
Excel Formulas 101
6 MIN
6 MIN
6 MIN
6 MIN
6 MIN
6 MIN
6 MIN
3
Excel Formulas 101
6 MIN
6 MIN
6 MIN
6 MIN
6 MIN
6 MIN
6 MIN
3
Excel Formulas 101
6 MIN
6 MIN
6 MIN
6 MIN
6 MIN
6 MIN
6 MIN
4
Conditional & Logical Operators
4
Conditional & Logical Operators
4
Conditional & Logical Operators
5
Statistical Functions
6 MIN
6 MIN
6 MIN
5
Statistical Functions
6 MIN
6 MIN
6 MIN
5
Statistical Functions
6 MIN
6 MIN
6 MIN
6
Lookup/Reference Functions
6 MIN
6 MIN
6 MIN
6 MIN
6 MIN
6
Lookup/Reference Functions
6 MIN
6 MIN
6 MIN
6 MIN
6 MIN
6
Lookup/Reference Functions
6 MIN
6 MIN
6 MIN
6 MIN
6 MIN
7
Text Functions
7
Text Functions
7
Text Functions
8
Date & Time Functions
6 MIN
6 MIN
6 MIN
6 MIN
6 MIN
8
Date & Time Functions
6 MIN
6 MIN
6 MIN
6 MIN
6 MIN
8
Date & Time Functions
6 MIN
6 MIN
6 MIN
6 MIN
6 MIN
9
Formula-Based Formatting
6 MIN
9
Formula-Based Formatting
6 MIN
9
Formula-Based Formatting
6 MIN
10
Dynamic Array Formulas
6 MIN
6 MIN
6 MIN
6 MIN
10
Dynamic Array Formulas
6 MIN
6 MIN
6 MIN
6 MIN
10
Dynamic Array Formulas
6 MIN
6 MIN
6 MIN
6 MIN
11
Bonus Functions
11
Bonus Functions
11
Bonus Functions
12
Final Assessment
6 MIN
12
Final Assessment
6 MIN
12
Final Assessment
6 MIN
13
Course Feedback & Next Steps
13
Course Feedback & Next Steps
13
Course Feedback & Next Steps
Meet your instructors
Chris Dutton
Founder & CPO
Chris is an EdTech entrepreneur and best-selling Data Analytics instructor. As Founder and Chief Product Officer at Maven Analytics, his work has been featured by USA Today, Business Insider, Entrepreneur and the New York Times, reaching more than 1,000,000 students around the world.
Student reviews
I really enjoyed this course. I thought it was well planned and layed out, easy for me to follow. The work load(h.w. & test)was just enough, so i could finish everything with enough time, learn about the topics and not feel over loaded and rushed. Also,it helped me a lot in my projects. Thank you so much ❤️
Tapur Jain
This course is a game-changer! The instructor's clear explanations and practical examples made learning Excel fun and easy. I'm amazed at how much I've learned in such a short time. From basic formulas to advanced techniques, this course covers it all. I'm now more confident in my Excel skills and can't wait to apply what I've learned. Thank you, Maven Analytics, for this fantastic course! Love from India! 🇮🇳
Bhushan Janardan Gawali
I recently completed the Microsoft Excel: Formulas & Functions course, and I was very impressed with the quality of the content. The lessons were well-structured and easy to follow, and the instructor did a great job of explaining complex concepts in a clear and concise manner. I particularly enjoyed the hands-on exercises, which helped me solidify my understanding of the material. I've already started applying the skills I learned in my daily work, and I've seen a significant increase in my productivity. I would highly recommend this course to anyone looking to improve their Excel skills.
Sonika
Included learning paths
Course credential
You’ll earn the course certification by completing this course and passing the assessment requirements
Excel Formulas & Functions
Excel Formulas & Functions
CPE Accreditation
CPE Credits:
0
Field of Study:
Information Technology
Delivery Method:
QAS Self Study
Maven Analytics LLC is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have the final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org.
For more information regarding administrative policies such as complaints or refunds, please contact us at admin@mavenanalytics.io or (857) 256-1765.
*Last Updated: May 25, 2023
More courses you may like
