Overview
-
Moving the data in the Excel sheet
2 mins
-
How to delete columns and rows in the Excel sheet
13 mins
-
Hiding multiple rows and colums
18 mins
-
How to protect the structure of the workbook
32 mins
-
how to make formatting of the Excel sheet so that it looks pleasing to the eye
41 mins
-
How to apply format painter to the Excel Report
51 mins
-
Putting an outside border to the notes
63 mins
-
Applying custom conditions formatting to data set
66 mins
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?
- Accountant
- Accounting Firm
- Accounting Managers
- Bookkeepers & Accountants & Tax Preparers
- Certified Management Accountant (CMA)
- Certified Public Accountant (CPA)
- Chartered Accountant
- Cloud Accountants
- CPA (Industry)
- CPA - Mid Size Firm
- CPA - Small Firm
- CPA in Business
- Entrepreneurial CPA
- Forensic Accountant
- Senior Accountant
- Staff of Accounting Firm
- Young CPA