Skip to main content
Self-Study Courses

Creating Reader-Friendly Spreadsheets

2 CPE Credits $41.00/credit hour
★ ★ ★ ★ ★ 5.0 (1 rating)

In this presentation, author and Excel expert David H. Ringstrom, CPA, will guide you through the essential techniques for creating reader-friendly spreadsheets using Excel for Windows. You'll learn how to enhance your Excel documents by creating and applying cell styles, customizing theme colors and fonts, and managing borders and column widths for optimal clarity. David will also demonstrate how to format cells based on specific values, add total rows to Excel tables, and use text boxes to clarify content. Additionally, you'll explore features like the Accessibility Checker, Freeze Panes, and methods for protecting your worksheets from unwanted edits. Join us to elevate your Excel skills and make your spreadsheets more accessible and visually appealing!

David H. Ringstrom, CPA, has more than 30 years of experience as a spreadsheet and accounting software consultant and speaker. He has presented over 2,500 live webinars and is the author or co-author of ten books, including “Microsoft 365 Excel All-in-One for Dummies”, “Microsoft 365 Excel for Dummies”, “Exploring Microsoft Excel’s Hidden Treasures”, and “QuickBooks Online for Dummies”.

In his webinars, David demonstrates every technique twice: first on a PowerPoint slide with numbered steps and then live in Excel for Microsoft 365 for Windows. He highlights any differences in Excel 2024, 2021, or 2019 during the presentation and in his detailed handouts. Attendees also receive an Excel workbook containing most of the examples he uses, making it easy to follow along and apply the techniques later. David additionally supports Excel for Mac users by answering their follow-up questions via email.

Publication Date: September 2026

Designed For
Professionals seeking to enhance their Excel skills for creating accessible, visually appealing spreadsheets and effectively presenting data.

Topics Covered

  • Formatting specific words within a column of text using Conditional Formatting
  • Customizing table styles in Excel
  • Creating reusable cell styles for consistent formatting
  • Most features and functions work in Excel for Mac as well but expect differences
  • Freezing rows to keep headings visible while scrolling
  • Transforming dates and numbers into various formats without retyping by way of custom number formats
  • Securing worksheet logic by protecting cells that are hidden, preventing both edits and formula visibility
  • Avoiding the need to retype data or clunky formulas by way of Excel’s Text to Columns command
  • Grouping related rows and columns to allow quick collapse, expansion, and simplified worksheet views
  • Contrasting using menu commands and keyboard shortcuts for applying formatting
  • Avoiding the need to merge cells—use the Text Box feature for paragraphs of text instead

Learning Objectives

  • Recall which command enables you to import cell styles from another open workbook
  • Identify the location of the Accessibility Checker within the ribbon in Excel 2019 and later
  • State which menu in Excel contains the Custom Views command
  • State the primary purpose of an Excel workbook theme
  • Identify the purpose of deleting the dash from the custom number format

Level
Basic

Instructional Method
Self-Study

NASBA Field of Study
Computer Software & Applications (2 hours)

Program Prerequisites
None

Advance Preparation
None

Instructor

David H. Ringstrom

David H. Ringstrom, CPA, is an author and nationally recognized instructor who teaches over 200 webinars each year. His Excel courses are based on over 30 years of consulting and teaching experience. David’s catchphrase is “Either you work Excel, or it works you,” so he focuses on what he sees users don’t, but should, know about Microsoft Excel. His goal is to empower you to use Excel more effectively. He's currently writing a book titled "Exploring Excel's Hidden Treasures". To learn more about David, you can view his LinkedIn profile and follow him on Facebook or Twitter (@excelwriter).
$82.00 / 2 CPE
NASBA Registered Sponsor
CPAs, EAs, CTECs Approved Credentials
QAS Quality Assured
Since 1996 Trusted Provider
CCH CPELink Chat - Support
By using our chat feature, you agree that your conversation may be recorded by Wolters Kluwer and agree to our Privacy Policy.