Take Excel Spreadsheets to the Next Level-Advanced Features

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.

Highlights

Some of the specific topics that will be covered 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

Upon completing this course, you will have the ability to:

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

Designed For

Anyone who uses Excel and wants to build better spreadsheets.