AMA Excel Training Series

Explore tools and techniques that can help you become a wiz at spreadsheets. By applying these skills, you’ll be able to leverage time- saving tips and analyze data that can help you make better business decisions.

540 Minutes | 6 Lessons | 0.90 CEUs

This OnDemand Course contains the following lessons:

• 

  Mastering Excel® PivotTables®: How to Crunch Numbers Like an Expert

  Take a step-by-step journey through the process of using the Excel PivotTable tool to quickly analyze data—even vast amounts—in less time than you ever thought possible.

• 

  Time-Saving Excel® Tips, Tricks and Shortcuts

  Learn about dozens of techniques Excel experts use to quickly create, manipulate, modify and deploy their spreadsheets.

• 

  Building PowerPoint™ Presentations from Excel® Data

  View demonstrations on how to format and extract key insights from your Excel data and then design effective charts and graphs to help you tell a great story.

• 

  Mastering Excel® Dashboard Reports

  Excel dashboards provide an excellent way of sharing a “snapshot" view of KPIs with colleagues. Learn how to convert your raw data into readable charts, diagrams and tables that can reveal unnoticed facts.

• 

  Mastering Excel® Formulas and Functions – Part 1

  Get familiar with many of the built-in analytical tools in Excel—and learn how you can quickly tackle myriad statistical, mathematical and financial challenges.

• 

  Mastering Excel® Formulas and Functions – Part 2

  Continue exploring the built-in analytical tools in Excel that can help you solve a wide range of data-related tasks and problems.