DISCLOSURE: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.
__________
 |
| Microsoft Excel - Pro Tips for Power Users |
See why Chris is one of the TOP-RATED instructors on Udemy:
"At first I just said to myself, "Wow, Excel is capable of that? It's amazing!" Then as I continued through the course I told myself "This guy is doing magic!", and now I feel like I'm capable of doing the same. I'm definitely buying his other courses!"
- Judit Bekker
"One of the very best Udemy classes I've taken - great instructor, awesome production, very comprehensive and exceptionally useful. Well worth your time!"
- Ernie Atkins
"I've been using Excel for over 20 years and consider myself to be a "power user". As with every single course by Chris, I go in with pretty solid knowledge of the material (VBA, Power Query, etc) and walk out twice as powerful as I walked in. This course is no different -- I PROMISE you, you will find absolute gems in this course. You will never regret an investment in your future with the Excel Maven!"
-Ryan Hughes
__________
COURSE DESCRIPTION:
This course is NOT an introduction to Excel.
It's not about comprehensive, 101-style deep dives into Excel's core capabilities, or about showing off cheesy, impractical "hacks". It's about featuring some of the most powerful and effective tools and techniques used by Excel professionals, and sharing them through crystal clear demos and unique, real-world case studies.
Unlike most 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 tips added on a regular basis. Each video is designed to be an independent and self-contained demo, to help you learn these tools and techniques in quick, bite-sized lessons.
The best part? I'm including a downloadable Excel workbook and solution file containing every singledemo and dataset covered in the course -- ranked by difficulty (1-5 stars), organized by category, and hyperlinked for quick and easy access.
__________
The tips and techniques covered in this course fall into six categories:
- Productivity Tips (navigation, flash fill, cell protection, advanced sorting & filtering, etc.)
- Formatting Tips (freeze panes, row/column grouping, advanced custom formats, etc.)
- Formula Tips (auditing tools, fuzzy lookups, detecting duplicates, randomization, etc.)
- Visualization Tips (sparklines, filled maps, custom templates, form controls, etc.)
- PivotTable Tips (slicers & timelines, custom layouts, value calculations, etc.)
- Analytics Tips (outlier detection, monte carlo simulation, forecasting, CUBE functions, etc.)
__________
While the level of difficulty varies considerably, the 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 challenging without a strong foundational knowledge of the underlying concepts (like PivotTables or advanced formulas, for example).
Students who have completed the full Excel Maven stack will be well-positioned to maximize the value from this course:
- Advanced Excel Formulas & Functions
- Data Visualization with Excel Charts & Graphs
- Data Analysis with Excel PivotTables
- Intro to Power Query, Power Pivot & DAX
__________
It's time 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.
See you in there!
-Chris (Founder, Excel Maven & Maven Analytics)
__________
NOTE: Most demos are compatible with Excel 2007-2016 or Office 365 (some may be unavailable for Mac or Excel Online)
__________
P.S. Looking to master the full Excel + Power BI stack? Complete the path below and emerge an analytics ROCKSTAR:
- Excel Pro Tips for Power Users
- Advanced Excel Formulas & Functions
- Data Visualization with Excel Charts & Graphs
- Data Analysis with PivotTables
- Intro to Power Query, Power Pivot & DAX
- Up & Running with Power BI Desktop
- Publishing to Power BI Service
Who this course is for:
- Excel users looking to level-up and master the same tools and techniques used by Excel MVPs
- Anyone hoping to maximize productivity, work more efficiently, and take their career to a new level
- Students looking for an engaging, hands-on, and highly interactive approach to Excel training
- This course is NOT suitable for absolute beginners (some prior experience with Excel is encouraged)
- Get the course
