K2's Formatting Excel Spreadsheets Correctly 26-27

Overview

Stop wasting time formatting your Excel spreadsheets! Custom Formats, Templates, Styles, the Accounting Format, and Precision As Displayed are all options to improve Excel formatting. Join us in this session to learn best practices for formatting your spreadsheets.

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 Microsoft Excel

Objectives

• Identify the benefits of using Styles for formatting
• Distinguish between various Custom Format codes used for specific situations
• Identify some of the advantages of using Excel template files
• Choose examples of when using the Accounting format is useful

Preparation

None