025003-02
This course will help you develop the ability to create the advanced functions and formulas you need to perform complex calculations in Excel. In addition, it will give you the skills to audit your workbook content to find, troubleshoot, and correct errors or issues in your Excel data.
This course is intended for students who are experienced Excel 2016 users and have a desire or need to advance their skills in working with some of the more advanced Excel features.
Topic A: Use Lookup Functions
- Lookup Functions
- The VLOOKUP Function
- The HLOOKUP Function
- The MATCH Function
- The INDEX Function
- The TRANSPOSE Function
- How to Use Lookup Functions
- Using Lookup Functions
Topic B: Trace Cells
- Precedent and Dependent Cells
- The Trace Precedents and Trace Dependents Commands
- Trace Arrows
- The Go To Dialog Box and Trace Arrows
- The Remove Arrows Options
- How to Trace Precedent and Dependent Cells
- Tracing Precedent and Dependent Cells
Topic C: Watch and Evaluate Formulas
- The Watch Window
- Formula Evaluation
- The Evaluate Formula Dialog Box
- How to Watch and Evaluate Formulas
- Watching and Evaluating Formulas
SKU | 025003-02S |
---|---|
Weight | 0.3720 |
Coming Soon | No |
Days of Training | No |
Audience | Student |
Product Family | FocusCHOICE |
Product Type | Print and Digital Courseware |
Electronic | Yes |
ISBN | 1424628083 |
Language | English |
Page Count | 44 |
Curriculum Library | Excel |
Year | 2016 |
Manufacturer's Product Code | No |
Current Revision | 1.0 |
---|---|
Revision Notes | No Revision Information Available |
Original Publication Date | 2017-12-15 00:00:00 |