Introduction
- Introduction
Customizing Excel
- Customizing the Ribbon
- Customizing the Quick Access Toolbar
- Customizing the General and Formula Options
- Customizing the AutoCorrect Options
- Customizing the Save Defaults
- Customizing Advanced Excel Options
Linking Workbooks and Worksheets
- Linking Workbooks and Worksheets
- Linking Worksheets with 3D References
- Understanding the Consolidate Feature
Working with Range Names and Advanced Formulas
- What are Range Names?
- Creating Range Names Using the Name Box and Define Name
- Creating Range Names Using Create from Selection
Analyzing Data with Common Logical Functions
- Working with the Most Common Logical Functions
- Evaluating Data with the AND Function
- Evaluating Data with the OR Function
- Understanding IF Functions
- Nesting AND and OR Inside an IF Function
Analyzing Data with Common Lookup Functions
- What are Lookup Functions?
- Using VLOOKUP
- Using HLOOKUP
Sorting and Filtering Range Data
- Understanding the Differences Between Sorting and Filtering
- Sorting Lists
- Filtering Lists
Analyzing and Organizing with Tables
- Creating Tables and Understanding the Benefits
- Understanding the Elements of a Table
- Formatting a Table
- Sorting Tables
- Filtering Tables
- Filtering with Slicers
- Calculating with Tables
- Removing Erroneous Table Data
- Exporting, Refreshing, and Converting Tables
Using Conditional Formatting
- What is Conditional Formatting?
- Conditional Formatting: Highlight Cells and Top Bottom Rules
- Conditional Formatting: Data Bars, Icon Sets, and Color Scales
- Using Custom Fonts and Colors
- Using Custom Conditional Formatting
- Modifying or Removing Conditional Formatting
Outlining with Subtotals and Grouping
- What are Subtotals and Grouping?
- Creating Subtotals
- Grouping and Ungrouping Data
Displaying Data Graphically
- What are Charts?
- Creating Charts
- Understanding Chart Elements
- Modifying Chart Elements
- Changing and Moving Charts
- Filtering a Chart
- Formatting Charts
- Adjusting Numbering
- Creating Dual Axis Charts
- Forecasting with Trendlines
- Creating a Chart Template
- Displaying Trends with Sparklines
Understanding PivotTables and PivotCharts and Filtering with Slicers
- What is a PivotTable?
- Creating a PivotTable
- Working with the PivotTable Fields Pane
- Basic Data Organization and Analysis with PivotTables
- Formatting PivotTables
- Creating a PivotChart
- Modifying and Formatting a PivotChart
- Adding Slicers and Timeline Slicers
- Formatting Slicers
Working with Flash Fill
- What is Flash Fill?
- Using Flash Fill and Autofill
- Filling Various Series
Working with Date and Time Functions
- What are Date and Time Functions?
- Using TODAY, NOW, and DAY Functions
- Using NETWORKDAYS and YEARFRAC Functions
Working with Common Text Functions
- What are Text Functions?
- Using CONCATENATE
- Using Text to Columns
- Using LEFT, RIGHT, and MID Functions
- Using UPPER, LOWER, and PROPER Functions
Conclusion
- Course Recap
Excel 2016 Intermediate Assessment
- Assessment Test
