ABOUT THE COURSE
This course is part of the Excel PRO TIPS series, designed to help everyday users develop expert-level skills by mastering the same tools and techniques used by top pros and Excel MVPs.
The series includes six separate Excel courses, including:
- Excel Pro Tips: Productivity Tools
- Excel Pro Tips: Formatting
- Excel Pro Tips: Formulas & Functions
- Excel Pro Tips: Data Visualization
- Excel Pro Tips: PivotTables
- Excel Pro Tips: Analytics Tools
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.
IMPORTANT NOTES:
- This is a non-linear series, so you can jump to individual courses or lectures freely. Each video is an independent and self-contained demo, to help you learn with quick, bite-sized lessons.
- Course includes a PDF ebook and downloadable Excel project file containing all demos and datasets, ranked by difficulty (1-5 stars), organized by category, and hyperlinked for quick access.
COURSE REQUIREMENTS:
- Microsoft Excel 2007-2019 or Office 365 recommended (some tips may not apply to all versions)
- This course is designed for PC users (some tools may not be available for Mac)
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
