025003-01
Using multiple worksheets and workbooks to track, retrieve, consolidate, and report on data can all be done in Microsoft® Excel® 2016. Whether you are using formulas, 3-D formulas and functions, links to external data (meaning other worksheets or workbooks), or consolidating data from identical worksheets, this course will show you how Excel's tools can help you do the job.
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 Links and External References
- Linked Cells
- Linked Cell Syntax
- The Edit Links Dialog Box
- External References in Formulas and Functions
- How to Use Linked Cells
- Creating Links
Topic B: Use 3-D References
- Grouped Worksheets
- 3-D References
- 3-D References in Summary Functions
- How to Use 3-D References
- Using 3-D References
Topic C: Consolidate Data
- Data Consolidation
- The Consolidate Dialog Box
- How to Consolidate Data
- Consolidating Data
| SKU | 025003-01S |
|---|---|
| Course Number | FOCUS CHOICE |
| Page Count | 42 |
| Product Type | Print and Digital Courseware |
| Isbn | 1424628067 |
| Electronic | 1 |
| Publication Date | 2017-12-15 00:00:00 |
| Curriculum Library | Excel |
| Secondary Category | Microsoft Office |