Show Menu

Help  |  Pay an Invoice  |  My Account  |  CPE Log  |  Log in

Webinar

K2's Formatting Excel Spreadsheets the Right Way

Thursday, July 31, 2025
Noon-2 p.m. Central
2 CPE (2 non-technical)

Course code: 25WA-4696
View pricing

Register Me     Register Multiple

Firm administrators: Please log in before starting the employee registration process.


Some estimates indicate that business professionals spend almost half their time in Excel applying formats. If you want better formatting results in less time, participate in this session to learn the best practices for formatting your Excel spreadsheets.

In this session, you will learn best practices for applying formats in your workbooks. More specifically, you will learn about features such as Custom Format Codes, Templates, Styles, the Accounting Format, Precision as Displayed, date formats, and many others, all of which can save you substantial time when working in Excel.

Major subjects

  • Creating and using Styles in Excel
  • The Accounting Format and why you should use it
  • How to Create Custom Formats
  • Formatting dates for maximum impact
  • The advantages of storing formats in templates

Learning objectives

  • Identify the benefits of using Styles for formatting
  • Specify which Custom Format codes are necessary for specific situations
  • List advantages of using Excel template files
  • Cite examples of when using the Accounting format is useful

Who should take this program?

  • Accounting and financial professionals desiring to learn the most effective and efficient ways to format Excel spreadsheets

Pricing

Standard Member Fee $79.00
checkmark Standard Nonmember Fee $79.00
Our records indicate you are a nonmember. If you register, you will be charged $79.00 (Standard Nonmember Fee). Members: Please log in to receive member fee.
Register Me     Register Multiple

Firm administrators: Please log in before starting the employee registration process.

More program information

Instructor Tommy Stephens, CPA, CITP, CGMA
Location Online
Area
of study
Information technology
Field(s)
of study
Computer Software & Applications - Non-Technical (2.0)
Level Intermediate
Format Group Internet Based
Sponsor Business Professionals' Network, Inc.
NASBA ID#: 107810
Prerequisites Prereq. Fundamental knowledge of Excel
Advance
prep
None
Cancellation
policy
Receive a full refund if you cancel at least four business days before the event start date.
Learn more

Related programs

July 18, 2025 | Shortcuts That Excel Users Love | Webinar

July 18, 2025 | Taking Advantage of Array Formulas in Excel | Webinar

July 18, 2025 | Using ChatGPT with Excel | Webinar

July 18, 2025 | K2's Excel Tips, Tricks and Techniques for Accountants | Webinar

July 18, 2025 | K2's Excel Charting and Visualizations | Webinar

Search CPE catalog