Microsoft Excel 2016, Intermediate
Creating Advanced Formulas
- Apply Range Names
- Range Names
- Adding Range Names Using the Name Box
- Adding Range Names Using the New Name Dialog Box
- Editing a Range Name and Deleting a Range Name
- Using Range Names in Formulas
Use Specialized Functions
- Function Categories
- The Excel Function Reference
- Function Syntax
- Function Entry Dialog Boxes
- Using Nested Functions
- Automatic Workbook Calculations
- Showing and Hiding Formulas
- Enabling Iterative Calculations
Analyzing Data with Logical and Lookup Functions
Use Text Functions
- Text Functions
- The LEFT and RIGHT Functions
- The MID Function
- The LEN Function
- The TRIM Function
- The UPPER, LOWER, and PROPER Functions
- The CONCATENATE Function
- The TRANSPOSE Function
Use Logical Functions
- Logical Functions
- Logical Operators
- The AND Function
- The OR Function
- The IF Function
Use Lookup Functions
- Lookup Functions
- The LOOKUP Function
- The VLOOKUP Function
- The HLOOKUP Function
- Use Date Functions
- The TODAY Function
- The NOW Function
- Serializing Dates and Times with Functions
- Use Financial Functions
- The IPMT Function
- The PPMT Function
- The NPV Function
- The FV Function
Organizing Worksheet Data with Tables
Create and Modify Tables
- Tables
- Table Components
- The Create Table Dialog Box
- The Table Tools – Design Contextual Tab
- Styles and Quick Style Sets
- Customizing Row Display
- Table Modification Options
Sort and Filter Data
- The Difference Between Sorting and Filtering
- Sorting Data
- Advanced Filtering
- Filter Operators
- Removing Duplicate Values
Use Subtotal and Database Functions to Calculate Data
- SUBTOTAL Functions
- The Subtotal Dialog Box
- Summary Functions in Tables
- Database Functions
Visualizing Data with Charts
- Create Charts
- Charts
- Chart Types
- Chart Insertion Methods
- Resizing and Moving the Chart
- Adding Additional Data
- Switching Between Rows and Columns
Modify and Format Charts
- The Difference Between Modifying and Formatting
- Chart Elements
- Minimize Extraneous Chart Elements
- The Chart Tools Contextual Tabs
- Formatting the Chart with a Style
- Adding a Legend to the Chart
- Create a Trendline
- Trendlines
- Types of Trendlines
- Adding a Trendline
- The Format Trendline Task Pane
- Create Advanced Charts
- Dual Axis Charts
- Creating Custom Chart Templates
Viewing Chart Animations