Overview
This class is will assist the Intermediate to Advanced Excel user in the functionality of Excel. As you know, Excel is a spreadsheet application that enables the calculation and display of complex mathematical formulas (functions) with a facility for extensive formatting. Functions are predefined calculations that may be included in any given Excel cell to perform specific manipulation of data. Using MS Excel, data could be imported from a variety of sources.
Audience
The course is for the Intermediate to Advanced Excel user.
Length
1 day
Outline
Data in Excel
- Database Concepts
- Pasting Data from Another File
- Data Validation
- Sorting
- Filtering
- Subtotaling Data
- Naming Ranges
- Printing
Functions
- Ranking Items
- Insert Function Library
- Function Arguments
- Absolute References
- Max and Min Values
- Looking up a Value
- Counting Cells
- Combining Cells
Tables
- PivotTables
- Scenarios
- Data Tables