* 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.
Discover the tools you will use for effective data management in Excel and a guide on how to use these tools.
Lets 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.
Down to Basics ñ Design the Spreadsheet
ï Who's Your Audience?
ï What Data Are You Wanting to Communicate?
ï Rows and Columns
ï Absolute vs. Relative Cells
ï Cell Formats, Numbers, Text, etc.
ï Cell Comments
ï Protect or Not Protect
Sort and Filter
ï Trace Precedents/Trace Dependents
ï Difference Between TODAY and NOW
ï COUNT and COUNTIF
ï Data Validation
ï CONCATENATE (Text to Columns)
ï INDEX and MATCH
To Macro or Not to Macro
Jill A. Trehearne with FatDAWGS.com
AIPB ,IAPP ,CPE ,Additional credit may be available upon request.