Excel Pro Tips: Formatting

Transform Excel worksheets into clear and polished reports using powerful formatting tools

 

What's Inside

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


The focus for this course is formatting, which admittedly may not sound like the most thrilling of topics. But listen, we’re not here to talk about cell fill and font color -- we’re here to turn your plain old spreadsheets into downright beautiful (and functional!) works of art. We’ll practice freezing panes, hiding text, defining formula-driven rules, creating advanced custom number formats, and much more.

It's time to start working smarter, not harder. If you're ready to bring your workbooks to life and take your formatting 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 customize the design and style of their workbooks
  • Analysts looking to build clear, intuitive and user-friendly reports, dashboards and tools
  • Anyone seeking to explore some of Excel’s most useful formatting tools & techniques

Get started now!



951+ Students
20 Lectures
1+ Hours of Video
Lifetime Access
24/7 Support
Your Instructor
Excel Maven

Chris Dutton is a certified Microsoft Excel Expert, analytics consultant, and best-selling instructor with more than a decade of experience specializing in business intelligence, marketing analytics and data visualization.

He founded Excel Maven in 2014 to provide high-quality, applied analytics training and consulting to clients around the world, and now mentors 150,000+ students in more than 190 countries. He has developed award-winning data analytics and visualization tools, featured by Microsoft, the New York Times, and the Society of American Baseball Research.

Instructor Rating
Popular Bundles