Self-Paced Course

Excel Pro Tips: Formulas

Expand your Excel formula knowledge with helpful tips and advanced use cases, like detecting duplicates and configuring many-to-many lookups.

Course Hours4 hours

Skills Learned

Data Analysis

Tools

Excel

Course Level

Intermediate

Credentials

Course Description

The Excel PRO TIPS series is designed to transform everyday Excel jockeys into certified power users, by featuring the same tools and techniques used by top pros and MVPs.

In this course we'll sample some of Excel's most powerful formula tools, including basic options like calculation modes, line breaks and auditing tools, as well as more complex use cases like detecting duplicates, creating dynamic workbook links, randomizing lists, and configuring many-to-many lookups.

It's time to start working smarter, not harder. If you're ready to ramp up your formula skills and take your Excel analytics game to the next level, this is the course for you.

COURSE CURRICULUM:

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

COURSE REQUIREMENTS?

Microsoft Excel 2007-2019+ or Office 365 for PC/Windows (some demos may be unavailable for Mac or Excel Online)
Completing the full Excel Formulas & Functions course is recommended, but not required

Start learning for FREE, no credit card required!

Every subscription includes access to the following course materials

Interactive Project files
Downloadable e-books
Graded quizzes and assessments
1-on-1 Expert support
100% satisfaction guarantee
Verified credentials & accredited badges

Meet Your Instructor

Chris Dutton

Founder & Lead Instructor

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.

Qualifications

Best-selling Analytics & BI instructor
Certified Microsoft Excel Expert

Testimonials

"Chris is an outstanding instructor, and always explains not only the 'HOW' but also the 'WHY'. This helps me immediately understand how these tools and techniques can be applied to my own work."

- John M.
"This is the kind of course that makes you feel like a true Excel expert! Tips are ranked from basic to expert level, helping to gradually dive deeper into each topic. I can't recommend it enough -- thanks Chris!"

- Jean-Claude N.
"WOW! Top hints and tips for any type of Excel user. Worth every dollar (or in my case Euro) spent on the course, even if it was just for the fantastic PDF guide! I will sign up for every course Maven publishes."

- Adam M.

Ready to become a

data rockstar?

Start learning for free, no credit card required!