Make better business decisions by harnessing the full capabilities of Excel?. Explore tools and techniques that can help you to 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.Course Objectives:
Build your skills with e-learning lessons on time-saving Excel? tips, tricks and shortcuts; crunch numbers like an expert with PivotTables?; building PowerPoint? presentations from Excel? data; creating advanced dashboard reports; and mastering formulas and functions.
540 Minutes | 0.90 CEUs
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.
All business professionals needing to expand their know-how to get the most out of Microsoft Excel?.