K2's Formatting Excel Spreadsheets The Right Way

Overview

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.

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

Prerequisites

Fundamental knowledge of Excel

Designed For

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

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

Preparation

None

Notice

This course is provided by a third-party vendor. Please note that login instructions will not be available in the ‘My Upcoming CPE’ section of the NESCPA website. Instead, the login instructions will be sent directly to you via email by ACPEN. Upon completing the course, your hours will be recorded in the ‘My CPE Tracker’ section of the NESCPA website.