FREE Course
Self-paced course
Self-paced course
Excel Pro Tips: Formulas
Excel Pro Tips: Formulas
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
4 course hours
1 quizzes
Who should take this course
Excel users who want to learn best practices for writing or troubleshooting formulas
Analysts or BI professionals looking to master advanced formula techniques and complex nested functions
Anyone seeking to explore some of Excel's most useful formula-related tools
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
"Extremely useful and well-documented course, with a passionate teacher who knows what he is talking about and how to teach students in the best possible way. Highly recommended for beginners and experts alike -- this course will make you an Excel pro, as promised!"
Roger H.
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
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
Extremely useful and well-documented course, with a passionate teacher who knows what he is talking about and how to teach students in the best possible way. Highly recommended for beginners and experts alike -- this course will make you an Excel pro, as promised!
Roger H.
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
