Getting started with Excel
Create and Open Workbooks
Excel 2016 Interface
Enter Data in a Worksheet
Moving Data in Excel 2016
Deleting and Hiding Excel Data
Managing Excel Worksheets
Modify Excel Document Properties
Saving a Workbook in Excel
Saving to External Locations
Exporting Excel Data
Practical Exercise
Formatting Data
Format Numerical Data
Applying Text Formatting
Custom Formatting
Borders and Fills
Using Cell Styles
Custom Cell Styles
Copy Cell Formatting with Format Painter
Columns and Rows
Aligning Cell Data
Merging and Splitting
Practical Exercise
Data Presentation Strategies
Using Auto Fill to Copy Data
Complete a Series Using Auto Fill
Using Flash Fill with Data Lists
Adding Hyperlinks
Custom Conditional Formatting
Advanced Sparklines
Practical Exercise
Formulas and Functions
Basic Formulas
Formula Operators
Order of Operations
Defining Named Cell Ranges
Using Named Cell Ranges in Formulas
The SUM Function
AutoSum Functions
Basic Logical Functions
IF Function
IFERROR Function
Practical Exercise
Charts, Tables, and Images
Using Tables and Modify a Table
Creating Charts and Modify a Chart
Adjust the Appearance of a Chart
Insert an Image and a Screenshot
Modify an Image
Adding Header and Footer Information
Practical Exercise
Customizing Views, Styles, and Templates
Personalizing Display Options
Configuring Workbook Views
Configuring Window Views
Customizing the Quick Access Toolbar
Customizing the Ribbon, Columns and Rows, Custom Templates
Customizing Themes and Colors
Modifying Cell Styles
Creating Form Fields
Practical Exercise00:00:00
Custom Visual Effects
Text Boxes & Format Text Boxes
Using Shapes
SmartArt & Modifying SmartArt
Adding Watermarks
Excel Themes & Customizing Themes
Converting Text to Columns
Practical Exercise
Working with Data
Basic Sorting
Color Sorting
Custom Sorts
Group and Ungroup Data
Using Subtotals & Filters
Refining Filters & Filters
Adding Basic Data Validation
Customizing Data Validation
Find and Replace Data
Practical Exercise
Macros and Advanced Queries
Using Macros
Running Macros
Create Macros
Running Macros From the Interface
NOW and TODAY Functions
DATE Function
NETWORKDAYS Function
Transposing Data
VLOOKUP and HLOOKUP
LOOKUP Function
Applying Functions within Formulas
SUMIFS, AVERAGEIFS, and COUNTIFS
Practical Exercise
PivotTables and Advanced Charts
Creating PivotTables
Edit PivotTable Data
Styling PivotTables
Filter PivotTable Data
Create a PivotChart
Create a PivotChart from a PivotTable
Modifying PivotCharts
Using Trendlines
Dual Axis Charts
Chart Templates
Practical Exercise
Power Pivot, Custom Formatting, Fills, and Forms
Setting up Power Pivot
Connecting Tables
Custom Number Formats
Custom Date and Time Formats
Custom Accounting Formats
Custom Fill Series
Custom Conditional Formatting
Altering Custom Rules
Advanced Filters
Practical Exercise00:00:00
Working With Data In 3D Maps
Working With Layers
Managing Layers
Adding Data To A Map
Adding Timestamps
Using Charts
Customizing Charts
Managing The Map Display
Using Filters
Customizing Map Data
Practical Exercise
Accessibility, Transforming Data, and Errors
Checking Accessibility
Adjusting the Tab Order
Displaying Data in International Formats
Get & Transform
Unpivot Data
Checking for Errors00:00:00
Tracing Errors
Troubleshoot Formulas
Practical Exercise
Share, Review, & Collaborate
Sharing Your Work
Working With Others
Link to Other Workbooks
Link to Access Databases
Protecting Your Workbook
Multiple Workbooks
Reviewing Workbooks
Practical Exercise