0004 - Intermediate Excel
1022781
Delivery Options
On Campus
Loading...
Course Description
Learn to use Excel to analyze numbers, keep track of data, and graphically represent your information. Create and work with charts, create Pivot Tables and Pivot Charts, record and run macros and solve formula errors.
Course Outline
Course Outline:
- Use SmartArt and other objects in worksheets
- Trace precedent cells and dependent cells, as well as use other auditing tools
- Create and work with charts
- Create Pivot Tables and Pivot Charts
- Record and run macros
- Solve formula errors
- Use What If Analysis tools
- Use tools to manage rows, columns, duplicates, and validation
- Group and outline data
Prerequisites
Completion of Basic Excel class or working knowledge of Basic Excel skills (see Basic Excel).Loading...
Enroll Now - Select a section to enroll in
Required fields are indicated by .