Formatting Excel Spreadsheets The Right Way (On-Demand - K2E)
Overview
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, attend this session to learn the best practices for applying formats in Excel.
Access expires 180 days from purchase date |
Course Description
Applicable for
Learning Objectives
- 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
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
Course Content Created: April 2024
The information is current as of the creation or last updated date. While we strive to keep our inventory updated and periodically remove outdated titles, changes in accounting, tax, legislation and technology may occur. Purchasers should note the date and verify for themselves if the course is still relevant to their needs.About This Product
On-Demand Courses by K2E. For over three decades, the team of professionals at K2E has created and presented the finest in technology-focused education. Today, their focus remains unchanged – delivering outstanding value to customers with every interaction.
Please note that not all on-demand courses include downloadable materials such as course notes or slides.
How to get started
Upon completion of purchase, go to mylms.bccpa.ca and log in using your CPABC Online Services credentials. Click “Go to your Courses and Materials” to go to your Learning Center, then find and click on your course title.
Course Dates & Registration
- 2
- CPD Hours
- 0
- Ethics Hours
- 0
- AML Hours
- 3
- Credits
Starting April 1, 2026, a 2.1% fee will be applied to all credit card transactions. Learn more about this fee and how it relates to PD registrations.
Formatting Excel Spreadsheets The Right Way (On-Demand - K2E)
- 2
- CPD Hours
- 0
- Ethics Hours
- 0
- AML Hours
- 3
- Credits
Overview
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, attend this session to learn the best practices for applying formats in Excel.
Access expires 180 days from purchase date |
Course Description
Applicable for
Learning Objectives
- 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
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
Course Content Created: April 2024
The information is current as of the creation or last updated date. While we strive to keep our inventory updated and periodically remove outdated titles, changes in accounting, tax, legislation and technology may occur. Purchasers should note the date and verify for themselves if the course is still relevant to their needs.About This Product
On-Demand Courses by K2E. For over three decades, the team of professionals at K2E has created and presented the finest in technology-focused education. Today, their focus remains unchanged – delivering outstanding value to customers with every interaction.
Please note that not all on-demand courses include downloadable materials such as course notes or slides.
How to get started
Upon completion of purchase, go to mylms.bccpa.ca and log in using your CPABC Online Services credentials. Click “Go to your Courses and Materials” to go to your Learning Center, then find and click on your course title.
Course Dates & Registration
Starting April 1, 2026, a 2.1% fee will be applied to all credit card transactions. Learn more about this fee and how it relates to PD registrations.