Mobile Edition


Mastering Data Preparation and Analysis in Excel (AIMDPA10)

 
Date:Saturday, December 16, 2017
Time:10:00AM - 12:00PM
(Registration at 9:30 AM)
Facility:Webcast or Webinar, Online
CPE Credit:2.0 Technical Business
Instructor: Bryan L. Smith
Vendor:AICPA
Course Level:Intermediate
Early Bird Price:$99.00 FICPA Members, $129.00 Non-Members

Description:

Microsoft Excel is one of the most powerful programs available for CPAs. It includes many time-saving techniques that most CPAs never put into practice. In addition, Excel is the #1 data analysis tool for accountants. Yet many accountants have never learned the basics of data analysis using Excel or the tools that Excel offers to help with data analysis. Learn the logical progression of spreadsheet creation, including design concepts that EVERY CPA should incorporate into their spreadsheets. Then, we will discuss concepts to eliminate manual data entry and techniques to prepare your data for analysis. We will then show you the available tools in Excel that will take your data analysis to a new level. We will conclude with presenting the results of your calculations and analysis. If there is only ONE course lo take to jump start your Excel knowledge ... THIS course is it. Be prepared to take Excel to the next level.



Objectives:

After completing this class you will have the ability to:

 Use Excel more efficiently

Realize the importance of proper spreadsheet design

 Understand the power of using Excel for data analysis



Major Topics:

We will be providing an overview of these important topics: Design

Defined Names

Excel Tables

Proofing Data Gathering

Connecting to Data Sources Data Preparation

Text, Lookup, Math Functions Data Analysis

Formatting (cell styles & conditional formatting)

PivotTable

Power Bl Tools Data Presentation



Who Should Attend:
Excel users who want to be more efficient analyzing data in Excel

Prerequisite:
A good understanding of Excel

Session/Options

If listed below, select the appropriate sessions or options to continue with your purchase.

Registration Status: CLOSED - Online registration for this course is now closed. Please contact the Member Service Center at (800) 342-3197 if you wish to inquire about registering.