Mastering Data Preparation and Analysis in Excel

Date: December 28, 2016 Time: 10:00 am - 12:00 pm EST CPE: 2 Format: Webcast
EVENT 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 to take to jump start your Excel knowledge … This course is it. Be prepared to take Excel to the next level.

LEARNING OBJECTIVES
Upon completion of this webinar, participants will be able 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 .
EVENT DETAILS
PROFESSIONAL AREAS OF FOCUS
Technology
CPE FIELD OF STUDY
Computer Science (2 Credits)
INSTRUCTOR(S)
Bryan Smith
PREREQUISITES
A good understanding of Excel
COURSE LEVEL
Intermediate
LOCATION
Online Webcast

MACPA MEMBER


$ (% off)
$99.00
Price includes $xx early registration discount(s) - expires xx/xx

NON-MEMBER


$ (% off)
$129.00
Price includes $xx early registration discount(s) - expires xx/xx
REGISTER FOR THIS EVENT
Loading