K2's Formatting Excel Spreadsheets The Right Way

Course Details

Date

Friday, June 24, 2022

8:00am – 9:50am

Field of Study

Technology

Course Number

A3437036

CPE Credit

2.0 hours CPE credit

Level of Knowledge

Intermediate

Vendor

ACPEN

Prerequisites

None

Description

Some estimates indicate that business professionals spend as much as half their time in Excel working on formatting. If you are interested in getting better formatting results in less time, participate in this session to learn the best practices for applying formats in Excel. 

In this session, you will learn the right way to apply 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 amounts of time when working in Excel.

Highlights

  • 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

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

Designed For

Business professionals desiring to learn the most effective and efficient ways to format Excel spreadsheets

Registration for this course has passed.

Course Pricing

Member Fee

Applicable if you are a HSCPA member in good standing.

$79.00
Non-Member Fee

Applicable if you are not a HSCPA member.

$109.00
Your Price $109.00

CPE Choice

Learn more about CPE Choice.
This course does not qualify for CPE Choice.

View All Webcasts