Excel Pro Tips: 75+ Tips to go from Excel Beginner to Pro

Preview this course

Master 75+ Excel tips and techniques and become a certified POWER USER, with unique hands-on demos and real-world projects to help you wrangle, analyze, and visualize your data in Excel.

Unlimited access to 750+ courses.
Enjoy a Free Trial. Cancel Anytime.

- OR -

30-Day Money-Back Guarantee
Full Lifetime Access.
98 on-demand videos & exercises
Level: Beginner
English
10hrs 32mins
Access on mobile, web and TV

What to know about this course

This course is not an introduction to Excel. It features some of the most powerful and effective tools and techniques used by Excel professionals, and shares them through crystal-clear demos and unique, real-world case studies. Unlike most Excel courses, this course is non-linear and constantly evolving, which means that you can jump to different sections or individual lectures freely. 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 Excel tips and techniques covered in this course fall into six categories:
•Productivity tips (navigation, flash fill, cell protection, advanced sorting & filtering, and more)
•Formatting tips (freeze panes, row/column grouping, advanced custom formats, and more)
•Formula tips (formula auditing tools, fuzzy lookups, detecting duplicates, randomization, and more)
•Visualization tips (sparklines, filled maps, custom templates, Excel form controls, and more)
•Pivot Table tips (slicers & timelines, custom layouts, value calculations, and more)
•Analytics tips (outlier detection, Monte Carlo simulation, forecasting, CUBE functions, and more)

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 underlying Excel concepts (such as Pivot Tables or formulas, for example). The codes are placed in the GitHub link as below- https://github.com/sanjanapackt/PacktPublishing-Excel-Pro-Tips-75--Tips-to-go-from-Excel-Beginner-to-Pro

Who's this course for?

This course is for Excel users looking to level-up and master tools used by Excel pros. Anyone hoping to maximize productivity, work more efficiently, and take their career to a new level will also benefit.
This course is also for anyone looking to pursue a career in analytics or Business Intelligence.
This course is designed for PC users with Excel 2010+ (some tips & tools may not be available for the Mac, or in earlier versions of Excel). Some prior experience with Excel is strongly encouraged.

What you'll learn

  • Build tools to help you automate and streamline.
  • How to revolutionize your Excel workflow.
  • Explore unique tips, tools, and case studies.
  • Master powerful data analysis tools such as Goal Seek, Scenario Manager, Solver, and Analysis ToolPak.
  • Complete fun and highly engaging demos and projects.

Key Features

  • The course explains how the exam is structured, the way that the questions should be approached and how to study successfully to pass.
  • The course also includes invaluable advice on the best way to prepare and what to expect from the testing process.

Course Curriculum

About the Author

Chris Dutton

Chris Dutton is a professional BI developer, certified Microsoft expert, and best-selling instructor with more than a decade of experience specializing in Business Intelligence, marketing analytics, and data visualization. He founded Maven Analytics in 2014 to provide high-quality, applied analytics training and consulting for clients around the world, and now mentors 200,000+ students in more than 190 countries. He has developed award-winning data analytics and visualization tools, which have been featured by Microsoft, the New York Times, and the Society of American Baseball Research.

40% OFF! Unlimited Access to 750+ Courses. Redeem Now.