My Profile   |   Contact Us   |   Your Cart   |   Sign In
Webcast: Mastering Data Preparation and Analysis in Excel (WBEXCL216)
Tell a Friend About This EventTell a Friend
 

8/17/2016
When: 08/17/2016
1:00 PM until 3:00 PM
Where: Webcast
AICPA
1168339:127E1C8104472D692C84BEF5A727E62C
United States
Presenter: Bryan L. Smith, CPA, CITP, CISA


Online registration is closed.
« Go to Upcoming Event List  

Acronym WBEXCL216
CPE 2 hours
Vendor AICPA
Category
Management
Level Intermediate
Prerequisite A good understanding of Excel
Who should attend Excel users who want to be more efficient analyzing data in Excel
Members $99
CPA Non-Members $129

The Member rate applies to LCPA members, reciprocal state society members, and non-CPA staff of LCPA members. To register online, use the ‘Register’ button above. To register by phone, call the LCPA Member Service Center at 800.288.5272 or 504.464.1040, Monday through Friday, 8am to 5pm.

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

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

Community Search
Sign In


Forgot your password?

Not a member? Join now!

News & Tax Alerts
CPE/Events

Society of Louisiana
Certified Public Accountants

2400 Veterans Memorial Blvd., Suite 500
Kenner, LA 70062-4739

504.464.1040
800.288.5272 Map/Directions


Advertise/Exhibit

Classifieds

CPA Locator

Press Room

Staff Directory

Facility Rental

Privacy & Terms

About LCPA