Seminar
K2's Formatting Excel Spreadsheets The Right Way
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.
Learning objectives
Upon completing this course, you should be able to:
- 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
Major topics
Who this is for
Accounting and financial professionals desiring to learn the most effective and efficient ways to format Excel spreadsheets
Prerequisites: Fundamental knowledge of Excel
What's included
Every registration comes with the course materials — yours to keep.
- Course handout PDF
Course details
- Recommended CPE credit
- 2 — Computer Software and Applications
- Field of study
- Computer Software and Applications
- Program level
- Intermediate
- Delivery method
- Group Internet Based
- Prerequisites
- Fundamental knowledge of Excel
- Advance preparation
- None
- Length
- 1h 40m
- Last revised
- Wednesday,
- Course number
- 24xndmgmt
- Provider
- K2 Enterprises
CPE Today (Devmatics, LLC) is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors (Sponsor ID 167619). State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website, nasbaregistry.org. For information about our refund, complaint, and program cancellation policies, see Company Policies or contact [email protected].
Every way to take this course
On its own
As part of a multi-day event
These seminars include this course on their agenda. One registration covers the event — you attend this course on its scheduled day, plus everything else that day offers.
Your instructor
Tommy Stephens
Partner · K2 Enterprises · ★ 4.6 instructor rating
Tommy Stephens received a Bachelor of Science in Business Administration degree (Major in Accounting) from Auburn University in 1985. In 1992, he earned a Master of Science degree (Major in Finance) from Georgia State University in Atlanta. Presently, Tommy is a Certified Public Accountant, a Certified Information Technology Professional, and a Chartered Global Management Accountant. In 1995, Tommy began...
Full profile →You might also like
Seminar
Seminar
Conference
Seminar