Loading...

Formatting Excel® Spreadsheets the Right Way

Online

# of CPE Credits

2

Description

Please note: This course will expire on Wednesday, April 30, 2025 at 11:59 pm ET. Please complete the course AND submit credit before the deadline. 

For licensing purposes, all CPE applies to the calendar year in which a course was taken and completed.

Save a copy of your Certificate of Completion for your records. Once submitted, your CPE hours will also reflect in your official CPE transcript.  

 

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. 

Event Level: Intermediate 
Who Should Attend: Accounting and financial professionals desiring to learn the most effective and efficient ways to format Excel® spreadsheets 
Required Knowledge: Fundamental knowledge of Microsoft® Office® Excel® 
Advanced Preparation: Fundamental knowledge of Microsoft® Office® Excel® 
Vendor: K2 Enterprises 
Speaker: Stephens, Tommy

Objective

* 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

Credit Types

  • Computer Software & Applications: 2

Event Speaker(s)

Tommy Stephens

Event Level:Intermediate
Event Code:OD005524
Event Vendor:K2 Enterprises
Fields of Study:Computer Software & Applications
Tags:2 hour
Other fields:

    Registration Fees

    RegistrationTypePrice
    On Demand (2 hours)Members$100.00
    On Demand (2 hours)Non Members$225.00


    CPE Sponsors LogoThe North Carolina Association of Certified Public Accountants is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org/.

    For information regarding refund, complaint, program cancellation or other policies, visit our Registration Policies page or call 800-469-1352.