Expires in:
Expires in:
Expires in:
Self-paced course
Self-paced course
Excel Pro Tips: Formulas
Excel Pro Tips: Formulas
Rating 4.3
318 reviews
318 reviews
318 reviews
Course Description
Excel PRO TIPS is built to transform everyday Excel users into certified power users, featuring the same tools and techniques used by top Excel pros and MVPs.
This course focuses on Excel’s most powerful formula tools, from calculation modes and auditing tricks to advanced use cases like detecting duplicates, creating dynamic links, randomizing lists, and managing many-to-many lookups.
It’s time to work smarter, not harder. If you’re ready to boost your formula skills and level up your analytics game, this is the course for you.
Course Description
Excel PRO TIPS is built to transform everyday Excel users into certified power users, featuring the same tools and techniques used by top Excel pros and MVPs.
This course focuses on Excel’s most powerful formula tools, from calculation modes and auditing tricks to advanced use cases like detecting duplicates, creating dynamic links, randomizing lists, and managing many-to-many lookups.
It’s time to work smarter, not harder. If you’re ready to boost your formula skills and level up your analytics game, this is the course for you.
Course Content
6.0 video hours
Skills you'll learn in this course
Master dynamic arrays like FILTER, UNIQUE & XLOOKUP
Replace VLOOKUP with INDEX‑MATCH for flexibility
Build reusable named‑formula libraries that scale
Debug errors fast with Evaluate Formula & tracing tricks
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
This course provided great tips for using Excel formulas to a more advanced level. I found the parts that refer to INDEX, MATCH, and SUMPRODUCT very interesting, and I wish I had known about them earlier.
Andrew Hubbard
Included learning paths
Course credential
You’ll earn the course certification by completing this course and passing the assessment requirements
Excel Pro Tips: Formulas
Excel Pro Tips: Formulas
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
Excel PRO TIPS is built to transform everyday Excel users into certified power users, featuring the same tools and techniques used by top Excel pros and MVPs.
This course focuses on Excel’s most powerful formula tools, from calculation modes and auditing tricks to advanced use cases like detecting duplicates, creating dynamic links, randomizing lists, and managing many-to-many lookups.
It’s time to work smarter, not harder. If you’re ready to boost your formula skills and level up your analytics game, this is the course for you.
Course Description
Excel PRO TIPS is built to transform everyday Excel users into certified power users, featuring the same tools and techniques used by top Excel pros and MVPs.
This course focuses on Excel’s most powerful formula tools, from calculation modes and auditing tricks to advanced use cases like detecting duplicates, creating dynamic links, randomizing lists, and managing many-to-many lookups.
It’s time to work smarter, not harder. If you’re ready to boost your formula skills and level up your analytics game, this is the course for you.
Curriculum
1
Getting Started
1
Getting Started
1
Getting Started
2
Formula Tips
6 MIN
6 MIN
6 MIN
6 MIN
6 MIN
2
Formula Tips
6 MIN
6 MIN
6 MIN
6 MIN
6 MIN
2
Formula Tips
6 MIN
6 MIN
6 MIN
6 MIN
6 MIN
3
Course Feedback & Next Steps
3
Course Feedback & Next Steps
3
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
This course provided great tips for using Excel formulas to a more advanced level. I found the parts that refer to INDEX, MATCH, and SUMPRODUCT very interesting, and I wish I had known about them earlier.
Andrew Hubbard
Included learning paths
Course credential
You’ll earn the course certification by completing this course and passing the assessment requirements
Excel Pro Tips: Formulas
Excel Pro Tips: Formulas
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
