Data Management Best Practices in Excel®
1 hour 30 minutes
Discover the tools you will use for effective data management in Excel® and a guide on how to use these tools.
Let’s face it, using Microsoft® Excel® can get complicated really fast when you start adding large amounts of data. Think about what happens when you add data from multiple sources and none of them have the same data fields. A simple list of items can turn into a nightmare once you try to find individual items or do comparisons. This training will show best practices for using PivotTables, charts, and just ordinary plain lists and columns. You will learn the most common keyboard shortcuts, as well as common functions and formulas.
• You will be able to identify the most common keyboard shortcuts.
• You will be able to recognize common functions and formulas.
• You will be able to discuss best practices for using PivotTables, charts, and ordinary plain lists and columns.
• You will be able to explain absolute vs. relative cells.