025013-03
Excel 2016 has all the features and data-crunching power you’ve come to expect from Microsoft's flagship spreadsheet product, with a few key updates for the 2016 release. Knowing how to use these new and improved features will allow you to input your data quickly and easily; analyze your data to fully understand trends; and share your data and findings in an easy-to-understand manner.
This course is designed for individuals who already have foundational knowledge and skills in Office 2007 or Office 2010, and are interested in transitioning from an earlier Office version to Office 2016.
Topic A: Streamline Workflow in Excel Using Templates
- Excel Templates
- How to Streamline Workflow in Excel Using Templates
- Selecting a Template in Excel
Topic B: Accelerate Data Entry with Flash Fill
- Flash Fill
- How to Accelerate Data Entry with Flash Fill
- Updating Email Addresses with Flash Fill
Topic C: Incorporate Charts
- Chart Types
- Recommended Charts
- Combo Charts
- Chart Formatting
- Data Labels
- How to Incorporate Charts
- Inserting and Formatting a Chart
Topic D: Analyze Data
- Quick Analysis
- Adding Conditional Formatting to Data with Quick Analysis
- Data Cards
- Search Functionality in Field Lists
- Timeline Slicers
- Adding a Timeline Slicer
- Time Groups
- PivotChart Drill Down
- Power Pivot
- Quick Explore
- Power View
- The Data Model and Relationships
- Automatic Relationship Detection
- Power Query
- Forecasting
- How to Analyze Data
- Drilling Deeper into Your Data with Other Functions
| SKU | 025013-03SE |
|---|---|
| Weight | 0.0000 |
| Coming Soon | No |
| Days of Training | No |
| Audience | Student |
| Product Family | FocusCHOICE |
| Product Type | Digital Courseware |
| Electronic | Yes |
| ISBN | 1424629616 |
| Language | English |
| Page Count | No |
| 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-18 00:00:00 |
