Print Page   |   Contact Us   |   Sign In   |   Join
Excel Data Analysis Series - Data Gathering - 5619
Tell a Friend About This EventTell a Friend
 

This session is designed to teach participants how to get electronic data into Excel. You will learn how to get data from a variety of sources such as accounting systems, databases, web systems, public data, report files, CSV files, etc. We will cover many of the data connections available today that will help you get the data you need for data analysis

 Export to Your Calendar 12/12/2016
When: 12:00 PM - 2:00 PM
Where: Webinar/Webcast
United States
Contact: April Deneault

« Go to Upcoming Event List  

Acronym EX132W
CPE 2 hours
Category
Excel
Level Intermediate
Vendor CPA Crossings, LLC
Who should attend

All CPAs and Accounting Professionals that want to learn how to analyze data

Prerequisite
Basic working knowledge of Excel features and functions
Fees: Early Bird
Standard
Member N/A
$79
Non-Member: N/A
$79

Description 
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. This session is designed to teach participants how to get electronic data into Excel.  You will learn how to get data from a variety of sources such as accounting systems, databases, web systems, public data, report files, CSV files, etc.  We will cover many of the data connections available today that will help you get the data you need for data analysis. Although this course will be technical, we will proceed at a pace that will provide all participants the knowledge necessary to access their data.


Specific topics include:

  • Getting data into the correct structure
  • Using Excel's Get External Data tools including ODBC
  • Importing data from text, CSV, delimited, report and XML filel

Objectives

  • Get up source data in Excel using proper data structure
  • Create data connections to access data
  • Reduce the need to manually enter data in Excel

 REGISTER HERE

 

Membership Management Software Powered by YourMembership  ::  Legal