Formatting Excel Spreadsheets the Right Way

Formatting Excel Spreadsheets the Right Way
K2E Canada Inc. presents a broad curriculum of technology-focused on-demand webinars. Participants who take these webinars will have the opportunity to learn from an award-winning team of instructors with literally hundreds of years of experience in helping professionals identify, address, and solve issues through the practical application of technology. Webinars address a variety of topics, including Excel, QuickBooks, PDFs, accounting solutions, and Microsoft Office.



NOTE: Course login details are normally sent to registrants within one week from date of registration.

KE22230221

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.

CONTENT 

  • 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
Upon completing this session, you should be able to:

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

PREREQUISITE
Fundamental knowledge of Excel 
Program Level: Intermediate
Advance Preparation: None

WHO WILL BENEFIT
Business professionals seeking to work more efficiently and effectively when formatting Excel-based reports

CPD: 2 Hours

When
4/1/2022 - 3/31/2023 11:59 PM
Where
On-demand