Microsoft Excel Pro Tips: Go from Beginner to Advanced Excel

Master 75+ Excel tips to build advanced Excel skills: formulas, pivot tables, charts, data analysis & data visualization

4.65 (5513 reviews)
Udemy
platform
English
language
Microsoft
category
instructor
Microsoft Excel Pro Tips: Go from Beginner to Advanced Excel
32,277
students
10.5 hours
content
Sep 2023
last update
$199.99
regular price

What you will learn

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 LIFETIME 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

Why take this course?

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 downloadable 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 & timelines, 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 challenging without a strong foundational knowledge of the underlying Excel concepts (like Excel Pivot Tables or formulas, for example).


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.


Join today and get immediate, lifetime access to the following:

  • 10+ hours of high-quality video

  • Downloadable PDF ebook

  • Excel project files & solutions

  • Expert-support and Q&A forum

  • 30-day money-back guarantee


Happy learning!

-Chris (Founder, Maven Analytics)


NOTE: Most Excel demos are compatible with Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019 or Office 365 (some may be unavailable in Excel for Mac or Excel Online)

__________

Looking for the full business intelligence stack? Search for "Maven Analytics" to browse our full course library, including Excel, Power BI, MySQL, and Tableau courses!


See why this is one of the TOP-RATED Excel courses 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 Excel courses!"

- Judit Bekker


"One of the very best Excel classes I've taken - great instructor, awesome production, very comprehensive and exceptionally useful. Well worth your time if you want to become an Excel pro!"

- Ernie Atkins


"I've been using Excel for over 20 years and consider myself to be an Excel "power user". As with every single course by Chris, I go in with pretty solid knowledge of the material (formulas, 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 Maven Analytics!"

-Ryan Hughes

Screenshots

Microsoft Excel Pro Tips: Go from Beginner to Advanced Excel - Screenshot_01Microsoft Excel Pro Tips: Go from Beginner to Advanced Excel - Screenshot_02Microsoft Excel Pro Tips: Go from Beginner to Advanced Excel - Screenshot_03Microsoft Excel Pro Tips: Go from Beginner to Advanced Excel - Screenshot_04

Reviews

Maksym
April 13, 2024
This is a great tool to learn from the start, especially for those who did not take any excel classes before!
Denny
March 27, 2024
I am learning a lot that will increase my efficiency. I was unfamiliar with many of the CTRL shortcuts. I wish I had taken the Formula/Function class first as well as the Pivot Table. Section 4 is really deep in the weeds without a firm grasp of those elements.
Stefan
March 25, 2024
This course offers a lot of good practical examples for everyday use in a compact format. If you have completed other courses with this lecturer, I would also recommend this course for revision purposes.
Nadine
March 17, 2024
Very well explained. The only thing that is bad is having time to try it yourself. You have to stop the presentation go out and try things.
Babalola
March 6, 2024
Nice and wonderful tips that could go a long way to solving data cleaning problems from my point of view.. Thanks
Vidiah
January 24, 2024
Listened to part at end of my data viz course, and was very impressed. Just had to have this course also.
Antonioo
January 16, 2024
The course turned out to be a real eye-opener. I enjoyed 90% of it, and the practical tips are useful. The course is really interesting. 5 stars is fair.
Sebastian
December 28, 2023
An enjoyable course: short intro to a tip followed by a practical example in Excel. I discovered several tips to apply in my future work. Another Maven's course delivered to a high standard.
Jaco
November 29, 2023
Absolutely one of the best excel courses and experts out there. Worth the time and money, very insightful and will upskill your excel skills and knowledge.
Nigel
November 29, 2023
The video demonstrations are easy to understand and help me learn useful tips to enhance productivity when doing Excel for data analysis.
Alex
November 18, 2023
This is a great course, I love the side by side work I can do with the provided material given by the instructor. I attempted a different Excel course and this one has blown the other one out of the water.
Eric
November 9, 2023
Not done with the course yet but I have enough done in the course to know this one is an E-Z 5 stars. Unlike other Excel courses I tried, the trainer is really focused on using shortcuts whenever it is possible and he tries to avoid functions and formulas when a few easy clicks can get the job done. The Spreadsheet that is included is worth its own weight in gold. Great job. Once I am done, I will make sure I can practice those skills in real-life situations. I believe the author might offer something along those lines on his site. I need to check again. In any case, I am getting my next courses from him when it comes to Excel.
Tinaye
March 27, 2023
The instructor was very clear throughout. I am close to a beginner and was still able to follow and mostly understand all lectures (the instructor points out cases when a beginner may need to learn basics before learning a more complex topic).
Fina
March 9, 2023
It helps you to refresh your memory for the shortcuts you used to do and teaches you new ways to simplify a report and to use non-hard coded formulas.
Victor
March 4, 2023
The efficiency with which you can use Named Ranges was the best trick I have added to my Excel goodie bag. Thank you.

Charts

Price

Microsoft Excel Pro Tips: Go from Beginner to Advanced Excel - Price chart

Rating

Microsoft Excel Pro Tips: Go from Beginner to Advanced Excel - Ratings chart

Enrollment distribution

Microsoft Excel Pro Tips: Go from Beginner to Advanced Excel - Distribution chart
1885612
udemy ID
8/30/2018
course created date
11/6/2019
course indexed date
Bot
course submited by