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.
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 Structure & Outline
- DOWNLOAD: Course Resources
- Setting Expectations
- Formatting Shortcuts
- Snap to Grid
- Hiding Workbook Elements
- Format Painter
- Color & Border Design
- Freezing Panes
- Center Across Selection
- Invisible Text Formatting
- Zip Codes & Phone Numbers
- Grouping Columns & Rows
- Formatting Errors with IFERROR
- Converting Text to Date Values
- Formula-Based Formats
- Advanced Number Formats
- QUIZ: Formatting Tips
- Course Feedback Survey
- Share the love!
- Next Steps
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
Ready to become a
Start learning for free, no credit card required!