Print Page   |   Contact Us   |   Sign In   |   Join
Take Excel Spreadsheets to the Next Level-Advanced Features - 5505
Tell a Friend About This EventTell a Friend
 

Chances are you use Excel on an everyday basis. If so, this course is designed to teach you a plethora of powerful features that Excel has to offer to take your data analysis and presentation to the next level. If you’re doing a lot with Excel already, this course will be invaluable because of the tools you will learn to help you build them quicker, more accurately and to provide more powerful data analysis.

 Export to Your Calendar 12/9/2016
When: Friday, December 9, 2016
7:00 AM - 3:00 PM
Where: Webinar/Webcast
United States
Contact: April Deneault

« Go to Upcoming Event List  

Acronym EX014L
CPE 8 hours
Category
Excel
Level Intermediate
Vendor CPA Crossings, LLC
Who should attend

Anyone who uses Excel and wants to build better spreadsheets.

Prerequisite
A good understanding of Excel
Fees: Early Bird
Standard
Member N/A
$199
Non-Member: N/A
$199

Description: 

Chances are you use Excel on an everyday basis. If so, this course is designed to teach you a plethora of powerful features that Excel has to offer to take your data analysis and presentation to the next level. If you’re doing a lot with Excel already, this course will be invaluable because of the tools you will learn to help you build them quicker, more accurately and to provide more powerful data analysis.
 

This IS NOT a hands-on course, but to get the most out of the presentation we recommend that you bring your laptop to follow along.  The instructor example files will be available prior to class.

Specific topics include:

  • Best practices for setting up your spreadsheets for data analysis and reporting.
  • Using the advanced features of Pivot Tables to optimize your data analysis capabilities.
  • Using external data connections to maximize the efficiency and accuracy of your spreadsheets when updating for new data.
  • Alternative methods for sharing your Excel workbooks across your organization.
  • New features in Excel 2013 that provide you with even more power to analyze and present data.
  • Leveraging the advanced features of conditional formatting to make your spreadsheets more relevant for your audience.
  • Taking Excel charting to the next level to present data summarized at the executive level for managing key performance indicators in a dashboard.
  • Advanced formula building and debugging.

Objectives

  • Use advanced analytical tools to present detailed data.
  • Understand the best methods to get electronic data into Excel.
  • Debug formulas and errors.

 REGISTER HERE

 

Membership Management Software Powered by YourMembership  ::  Legal