Self-Paced Course

Excel Pro Tips: Formatting

Transform worksheets into clear and polished reports using powerful formatting tools like frozen panes, grouped rows, formula-driven rules, and more.

Course Hours2 hours

Skills Learned

Data Visualization

Tools

Excel

Course Level

Basic

Credentials

Course Description

The Excel PRO TIPS series is designed to transform everyday Excel jockeys into certified power users, by featuring the same tools and techniques used by top pros and MVPs.

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.

COURSE CURRICULUM:

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

WHAT ARE THE COURSE REQUIREMENTS?

Microsoft Excel 2007-2019+ or Office 365 for PC/Windows (some demos may be unavailable for Mac or Excel Online)
Familiarity with basic Excel functionality is recommended

Start learning for FREE, no credit card required!

Every subscription includes access to the following course materials

Interactive Project files
Downloadable e-books
Graded quizzes and assessments
1-on-1 Expert support
100% satisfaction guarantee
Verified credentials & accredited badges

Meet Your Instructor

Chris Dutton

Founder & Lead Instructor

Chris is an EdTech entrepreneur and best-selling Data Analytics instructor. As Founder and Chief Product Officer at Maven Analytics, his work has been featured by USA Today, Business Insider, Entrepreneur and the New York Times, reaching more than 1,000,000 students around the world.

Qualifications

Best-selling Analytics & BI instructor
Certified Microsoft Excel Expert

Testimonials

"Chris has a great approach and methodology when it comes to explaining complex content. Crystal clear demos and step-by-step procedures. I'm already applying several of these tools to my day-to-day work."

- Ronaldi R.
"Excellent course! Very clear and easy to follow. All of the Maven courses are amazing and well worth the time and money."

- Giancarlo G.
"I really enjoyed the course. Chris always makes his courses engaging and informative, and I picked up a number of excellent tips that I can immediately apply at work. Thanks!"

- Mario F.

Ready to become a

data rockstar?

Start learning for free, no credit card required!