Overview
-
How to prepare your data for analysis
2 mins
-
Applying custom sorting options to our data set
10 mins
-
Applying number filters
16 mins
-
Converting our data sets into excel tables
23 mins
-
Removing duplicate values from the data set
31 mins
-
Important consideration while removing duplicate values in excel
35 mins
Course Description
Excel is one of the most widely used spreadsheet programs in the world.
People have been using it for the last 30 years and throughout these years, it has been upgraded with more and more features. While the number of companies that are going completely digital is increasing, many firms prefer viewing documents and filing them in paper form.
Have you ever come across huge data in excel which you find difficult to work with?
Dealing with huge datasets in excel becomes tedious if we don’t know how to use the excel features for the same. A dataset is a range of contiguous cells on an Excel worksheet containing data to analyze.
Excel provides several features to simplify data and make them easier to work with.
Join this Excel CPE Webinar to learn the easiest ways to work with datasets and master the art of data management.
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 analyze to work with Excel datasets
- To discuss how to sort datasets
- To discuss the filter datasets
- To analyze how to remove duplicates
- To use a subtotal command
Recommended For
- This CPE webinar is recommended for CPAs, CVAs, CMAs, and other individuals who want to understand the most powerful spreadsheet program Microsoft Excel its datasets to better assist their clients.
Who Should Attend?
- Accountant
- Accounting Firm
- Accounting Managers
- Accounts Payable Manager
- Bookkeepers & Accountants & Tax Preparers
- Certified Management Accountant (CMA)
- Certified Public Accountant (CPA)
- Chief Accounting Officer
- Cloud Accountants
- CPA (Industry)
- CPA - Mid Size Firm
- CPA - Small Firm
- CPA in Business
- Entrepreneurial CPA
- Senior Accountant
- Staff of Accounting Firm
- Young CPA