Learn

Platform

For Business

Pricing

Resources

FREE Course

/

/

Excel Pro Tips: Formulas

Self-paced course

Self-paced course

Excel Pro Tips: Formulas

Excel Pro Tips: Formulas

COMING SOON

COMING SOON

COMING SOON

COMING SOON

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

FOR INDIVIDUALS

Master data & AI skills

Build data & AI skills to launch or accelerate your career (start for free, no credit card required).

FOR COMPANIES & TEAMS

Transform your workforce

Assess your team's data & AI skills and follow personalized learning plans to close the gaps.

FOR INDIVIDUALS

Master data & AI skills

Build data & AI skills to launch or accelerate your career (start for free, no credit card required).

FOR COMPANIES & TEAMS

Transform your workforce

Assess your team's data & AI skills and follow personalized learning plans to close the gaps.

FOR INDIVIDUALS

Master data & AI skills

Build data & AI skills to launch or accelerate your career (start for free, no credit card required).

FOR COMPANIES & TEAMS

Transform your workforce

Assess your team's data & AI skills and follow personalized learning plans to close the gaps.