Self-paced course
Self-paced course
Excel Formulas & Functions
Excel Formulas & Functions
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
16 course hours
9 assignments & solutions
9 quizzes
9 skill assessments
16 CPE credits
Who should take this course
Analysts looking to extract insight from raw data, and develop expert-level formula skills
Excel users who want to build interactive models or dashboards (forecasts, financial models, scenario tests, etc)
Anyone seeking to improve productivity and work more efficiently with data
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.
Featured review
"I just completed the course and can honestly say that it's the best course I've taken in my life. Chris has a real gift of explaining the more difficult Excel functions and making them accessible and understandable. I thought I already knew Excel well but I have learned so much and have already put a lot of it into practice at work. I can't wait to get started on the next one!"
Jon K.
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:
16
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
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 just completed the course and can honestly say that it's the best course I've taken in my life. Chris has a real gift of explaining the more difficult Excel functions and making them accessible and understandable. I thought I already knew Excel well but I have learned so much and have already put a lot of it into practice at work. I can't wait to get started on the next one!
Jon K.
Labelling the course as 'Awesome' would be an understatement! Chris is an outstanding instructor with impeccable teaching skills. I loved the refreshing course content, competitive assessments, and streamlined approach to applying complex formulas. Kudos to the Maven Team for creating such intuitive lessons and making us fall in love with Excel forever!
Faizan Qadri
I have undertaken Excel training previously but this is next level! I learned soo much and it was so well presented that I remained engaged and clearly understood the explanations. I liked the examples and homework files and trust I'll refer back to them in future. Totally recommend this course to anyone using Excel.
Mark Smith
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:
16
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
