New MACPA.org Launching 4/1! Stay tuned for a brand new online experience.

Mastering Data Preparation and Analysis in Excel (11W349-16)

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.

Learning Objectives
  1. " Use Excel more efficiently Realize the importance of proper spreadsheet design
  2. Understand the power of using Excel for data analysis "
Major Topics
  1. " 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 "
Provider
AICPA
Course Level
Intermediate
CPE Field of Study
Computer Science*
2
Instructor(s)
Bryan Smith
Prerequisites
A good understanding of Excel
Location
Online
Event Information
When
May 10, 2016
11:00 am - 1:00 pm EST
Location
Online
Total CPE Credits
2
Format
Webcast Replay

MEMBER


$ (% off)
$99.00

NON-MEMBER


$ (% off)
$129.00
Become A Member

Register for this Event

Mastering Data Preparation and Analysis in Excel (11W349-16)


Loading
Your browser is out-of-date!

Update your browser to view this website correctly.

Update my browser now

×