Excel: Cell Formatting and Worksheet Adjustments

Course Description

There are many spreadsheet programs but from all of them, Excel is most widely used. 

People have been using it for the last 30 years and throughout these years, it has been upgraded with more and more features. The best part about Excel is, it can apply to many business tasks, including statistics, finance, data management, forecasting, analysis, inventory, billing, and business intelligence.

It is a perfect tool for anyone working in the finance and accounting fields due to its versatility and specific financial applications. Mastery of Microsoft Excel is a must-have skill for accountants these days and a key to their professional growth. Whether you’re just starting or have been in the field for some time.

Join this excel CPE webinar to understand how to effectively adjust an excel worksheet by using keyboard shortcuts saving your time and effort.

But staring at Excel spreadsheets for hours on end can put a strain on accountants’ eyes. The good news is you don’t have to ramp up the font to a cartoonish size to get relief.

All the effort that you put into perfecting data would go in vain if the viewer finds it disinteresting and decide to stop halfway. An employer or client would prefer data that is well presented over data that lacks quality visualization.

How to make a visually pleasing worksheet?

• By formatting texts
• By creating attractive tables
• By aligning cells uniformly
• By highlighting important areas to grab the attention of the viewer.

This Excel CPE course also helps you to understand how to use functions in Excel that allow users to make the data much easier on the eyes.

You can learn different techniques and shortcuts to learn how to make an excel worksheet Visually Pleasing and:

• Become more PRODUCTIVE at using Excel which will SAVE YOU HOURS each Day & ELIMINATE STRESS at work!
• Work in Excel with ease by a much better presentation of data that in turn would impress your employer.
• Reduce the chances of client turnover by providing them with the most effective visually pleasing accurate data.

It doesn’t matter what version of the PC or Mac operating system you’re using. The techniques we will cover in this CPE webinar will work similarly in Excel for PC and Mac

Learning Objectives

• To describe how to move around in a spreadsheet
• To discuss how to select, cut, copy and paste data in seconds
• To describe how to add or delete rows and columns
• To describe how to adjust column width and row height
• To discuss how to hide or unhide rows and columns
• To describe how to move sheets across workbooks
• To describe how to move around in a spreadsheet
• To format texts and highlight them in order of relevance
• To make data attractive
• To print data 
• To format cells by conditions
• To align data in a worksheet

Recommended For

• This excel CPE course is recommended for CPAs, CMAs, CIAs, CFAs, Accounting, and Tax Professionals, and Staff of Accounting or Tax Firm desiring to learn how to do formatting in Excel.
• This excel CPD course will prove beneficial for Canadian CPAs, Accounting and Tax Professionals, and Other Professionals using excel for their daily tasks.

Who Should Attend?

Webinar Qualifies For

• 1 CPE Credit for Qualification in Internal Audit Leadership (QIAL)
• 1 CE Credit for Maryland Tax Preparer (MRTP)
• 1 CPE Credit for Internal Audit Practitioner (IAP)
• 1 CPD Credit for Chartered Professional Accountant (CPA Canada)
• 1 PL Credit for Chartered Financial Analyst (CFA)
• 1 CPE Credit for Certified Valuation Analyst (CVA)
• 1 CPE Credit of Computer Software and Applications for Certified Public Accountants (CPA-US)
• 1 CPE Credit for Certified Management Accountants (CMA)
• 1 CPE Credit of Accounting & Auditing for Certified Internal Auditors (CIA)

FAQs content