Master 75+ Excel tips to build advanced Excel skills: formulas, pivot tables, charts, data analysis & data visualization
Build tools to help you automate, streamline, and absolutely revolutionize your workflow with Excel
Explore 75+ unique tips, tools and case studies that you won’t find in ANY other Excel course, guaranteed
Get LIFE access to resources, Excel project files, quizzes, and 1-on-1 expert support
Master Excel’s powerful data analysis tools like Goal Seek, Scenario Manager, Solver, and Analysis ToolPak
Practice with fun, interactive, and highly effective lessons from a best-selling Excel instructor
Become an absolute Excel POWER USER
Microsoft Excel 2007-2019 or Office 365 (Note: some tips may not apply to all versions of Excel)
Experience with formulas & functions, basic charts, and PivotTables strongly encouraged (but not required)
This course is designed for PC users (some tips & tools may not be available for Mac)
COURSE DESCRIPTION:
This course is designed to transform everyday people into Excel POWER USERS.
It’s not about comprehensive, 101-style deep dives into Excel’s core capabilities, or about showing off cheesy, impractical Excel “hacks”. It’s about featuring some of the most powerful and effective tools & techniques used by Excel professionals, and sharing them through crystal clear demos and unique, real-world case studies.
Unlike most Excel courses, this one is non-linear and constantly evolving. This means that you can jump to different sections or individual lectures freely, and explore brand new Excel tips added on a regular basis. Each video is designed to be an independent and self-contained Excel demo, to help you learn these tools and techniques in quick, bite-sized lessons.
The best part I’m including a able Excel workbook and solution file containing every single Excel demo and dataset covered in the course, ranked by difficulty (1-5 stars), organized by category, and hyperlinked for quick and easy access.
The Excel tips and techniques covered in this course fall into six core categories:
Excel Productivity Tips (navigation, flash fill, cell protection, advanced sorting & filtering, etc.)
Excel Formatting Tips (freeze panes, row/column grouping, advanced custom formats, etc.)
Excel Formula Tips (formula auditing tools, fuzzy lookups, detecting duplicates, randomization, etc.)
Excel Visualization Tips (sparklines, filled maps, custom templates, Excel form controls, etc.)
Excel Pivot Table Tips (slicers & lines, custom layouts, value calculations, etc.)
Excel Analytics Tips (outlier detection, monte carlo simulation, forecasting, CUBE functions, etc.)
While the level of difficulty varies considerably, the Excel demos generally start simple and become progressively more complex within each section. There are no strict prerequisites for this course, but keep in mind that some demos may be challeg without a strong foundational knowledge of the underlying Excel concepts (like Excel Pivot Tables or formulas, for example).
It’s to start working smarter, not harder. If you’re looking to maximize your efficiency, supercharge your productivity, and become an absolute Excel POWER USER, this is the course for you.
Join today and get immediate, life access to the following:
10+ hours of high-quality video
