Excel 2016 for Advanced Users

Thumbnail image
Introduction
Channel: Microsoft Excel
Instructor: Sara
Duration: 3:00
Thumbnail image
Converting a Range Into a Table
Channel: Microsoft Excel
Instructor: Sara
Duration: 3:44
Thumbnail image
Inserting or Deleting Rows and Columns
Channel: Microsoft Excel
Instructor: Sara
Duration: 4:33
Thumbnail image
Table Style Options and Table Styles
Channel: Microsoft Excel
Instructor: Sara
Duration: 4:18
Thumbnail image
The Total Row
Channel: Microsoft Excel
Instructor: Sara
Duration: 4:56
Thumbnail image
What is a Structured Reference
Channel: Microsoft Excel
Instructor: Sara
Duration: 3:06
Thumbnail image
Elements in a Structured Reference
Channel: Microsoft Excel
Instructor: Sara
Duration: 2:49
Thumbnail image
Renaming a Table
Channel: Microsoft Excel
Instructor: Sara
Duration: 2:54
Thumbnail image
Escaping Special Characters in a Column Identifier
Channel: Microsoft Excel
Instructor: Sara
Duration: 3:11
Thumbnail image
Special Identifiers
Channel: Microsoft Excel
Instructor: Sara
Duration: 2:15
Thumbnail image
Syntax for Referencing a Table or a Column in a Table
Channel: Microsoft Excel
Instructor: Sara
Duration: 5:24
Thumbnail image
Syntax for Referencing a Part of a Column
Channel: Microsoft Excel
Instructor: Sara
Duration: 3:21
Thumbnail image
Syntax for Referencing a Single Cell
Channel: Microsoft Excel
Instructor: Sara
Duration: 3:43
Thumbnail image
Syntax for Referencing a Column Range
Channel: Microsoft Excel
Instructor: Sara
Duration: 3:14
Thumbnail image
Syntax for Referencing Part of a Column Range
Channel: Microsoft Excel
Instructor: Sara
Duration: 4:09
Thumbnail image
Qualifying Structured References Part 1
Channel: Microsoft Excel
Instructor: Sara
Duration: 2:29
Thumbnail image
Qualifying Structured References Part 2
Channel: Microsoft Excel
Instructor: Sara
Duration: 3:28
Thumbnail image
Creating a Calculated Column
Channel: Microsoft Excel
Instructor: Sara
Duration: 4:30
Thumbnail image
Structured References Using Point and Click
Channel: Microsoft Excel
Instructor: Sara
Duration: 4:06
Thumbnail image
Formula Autocomplete
Channel: Microsoft Excel
Instructor: Sara
Duration: 4:49
Thumbnail image
Structured References Outside of the Table
Channel: Microsoft Excel
Instructor: Sara
Duration: 4:39
Thumbnail image
Limitation with Structured References
Channel: Microsoft Excel
Instructor: Sara
Duration: 4:39
Thumbnail image
Copying vs Filing Structured References
Channel: Microsoft Excel
Instructor: Sara
Duration: 5:45
Thumbnail image
Rearranging Columns Easily
Channel: Microsoft Excel
Instructor: Sara
Duration: 2:26
Thumbnail image
Converting a Table to a Normal Range
Channel: Microsoft Excel
Instructor: Sara
Duration: 2:51
Thumbnail image
Nested IF Statements Part 1
Channel: Microsoft Excel
Instructor: Sara
Duration: 3:46
Thumbnail image
Nested IF Statements Part 2
Channel: Microsoft Excel
Instructor: Sara
Duration: 4:15
Thumbnail image
Nested IF Statements Part 3
Channel: Microsoft Excel
Instructor: Sara
Duration: 2:28
Thumbnail image
Nested IF Statements Part 4
Channel: Microsoft Excel
Instructor: Sara
Duration: 4:43
Thumbnail image
Nested IF Statements Part 5
Channel: Microsoft Excel
Instructor: Sara
Duration: 6:17
Thumbnail image
Nested IF Statements OTV Tip Inserting Line Breaks
Channel: Microsoft Excel
Instructor: Sara
Duration: 2:46
Thumbnail image
IFS Function Part 1
Channel: Microsoft Excel
Instructor: Sara
Duration: 3:38
Thumbnail image
IFS Function Part 2
Channel: Microsoft Excel
Instructor: Sara
Duration: 3:27
Thumbnail image
IFS Function Part 3
Channel: Microsoft Excel
Instructor: Sara
Duration: 4:28
Thumbnail image
IFS Function Part 4
Channel: Microsoft Excel
Instructor: Sara
Duration: 7:40
Thumbnail image
IFS Function Part 5
Channel: Microsoft Excel
Instructor: Sara
Duration: 5:54
Thumbnail image
IFS Function Part 6
Channel: Microsoft Excel
Instructor: Sara
Duration: 2:38
Thumbnail image
VLOOKUP Function Part 1
Channel: Microsoft Excel
Instructor: Sara
Duration: 5:09
Thumbnail image
VLOOKUP Function Part 2
Channel: Microsoft Excel
Instructor: Sara
Duration: 3:46
Thumbnail image
VLOOKUP Function Part 3
Channel: Microsoft Excel
Instructor: Sara
Duration: 1:49
Thumbnail image
VLOOKUP Function Part 4
Channel: Microsoft Excel
Instructor: Sara
Duration: 2:30
Thumbnail image
Boolean Data Type Part 1
Channel: Microsoft Excel
Instructor: Sara
Duration: 3:07
Thumbnail image
Boolean Data Type Part 2
Channel: Microsoft Excel
Instructor: Sara
Duration: 5:15
Thumbnail image
VLOOKUP Function Part 5
Channel: Microsoft Excel
Instructor: Sara
Duration: 4:31
Thumbnail image
VLOOKUP Function Part 6
Channel: Microsoft Excel
Instructor: Sara
Duration: 2:33
Thumbnail image
VLOOKUP Function Part 7
Channel: Microsoft Excel
Instructor: Sara
Duration: 3:13
Thumbnail image
VLOOKUP Function Part 8
Channel: Microsoft Excel
Instructor: Sara
Duration: 4:53
Thumbnail image
VLOOKUP Function Part 9
Channel: Microsoft Excel
Instructor: Sara
Duration: 4:49
Thumbnail image
HLOOKUP Function
Channel: Microsoft Excel
Instructor: Sara
Duration: 5:20
Thumbnail image
VLOOKUP Function Part 10
Channel: Microsoft Excel
Instructor: Sara
Duration: 6:05
Thumbnail image
VLOOKUP Function Part 11
Channel: Microsoft Excel
Instructor: Sara
Duration: 4:43
Thumbnail image
IFERROR Function Part 1
Channel: Microsoft Excel
Instructor: Sara
Duration: 2:45
Thumbnail image
IFERROR Function Part 2
Channel: Microsoft Excel
Instructor: Sara
Duration: 3:45
Thumbnail image
VLOOKUP Function Part 12
Channel: Microsoft Excel
Instructor: Sara
Duration: 5:28
Thumbnail image
VLOOKUP Function Part 13
Channel: Microsoft Excel
Instructor: Sara
Duration: 4:58
Thumbnail image
VLOOKUP Function Part 14
Channel: Microsoft Excel
Instructor: Sara
Duration: 4:14
Thumbnail image
Index Match Nested Function Part 1
Channel: Microsoft Excel
Instructor: Sara
Duration: 2:36
Thumbnail image
Index Match Nested Function Part 2
Channel: Microsoft Excel
Instructor: Sara
Duration: 2:30
Thumbnail image
Index Match Nested Function Part 3
Channel: Microsoft Excel
Instructor: Sara
Duration: 5:16
Thumbnail image
Index Match Nested Function Part 4
Channel: Microsoft Excel
Instructor: Sara
Duration: 3:03
Thumbnail image
Index Match Nested Function Part 5
Channel: Microsoft Excel
Instructor: Sara
Duration: 5:08
Thumbnail image
Index Match Nested Function Part 6
Channel: Microsoft Excel
Instructor: Sara
Duration: 6:07
Thumbnail image
Index Match Nested Function Part 7
Channel: Microsoft Excel
Instructor: Sara
Duration: 4:43
Thumbnail image
Formula Auditing Introduction
Channel: Microsoft Excel
Instructor: Sara
Duration: 3:18
Thumbnail image
Tracing Precedents
Channel: Microsoft Excel
Instructor: Sara
Duration: 5:31
Thumbnail image
More on Tracing Precedents
Channel: Microsoft Excel
Instructor: Sara
Duration: 4:03
Thumbnail image
Tracing Dependents
Channel: Microsoft Excel
Instructor: Sara
Duration: 3:04
Thumbnail image
More on Tracing Dependents
Channel: Microsoft Excel
Instructor: Sara
Duration: 5:17
Thumbnail image
Evaluating Formulas with F9
Channel: Microsoft Excel
Instructor: Sara
Duration: 3:13
Thumbnail image
More on Evaluating Formulas with F9
Channel: Microsoft Excel
Instructor: Sara
Duration: 4:03
Thumbnail image
Evaluating Formulas with Evaluate Formula
Channel: Microsoft Excel
Instructor: Sara
Duration: 4:52
Thumbnail image
Error Checking Rules
Channel: Microsoft Excel
Instructor: Sara
Duration: 2:38
Thumbnail image
Error Smart Tag Options
Channel: Microsoft Excel
Instructor: Sara
Duration: 3:23
Thumbnail image
Introduction to Data Validation
Channel: Microsoft Excel
Instructor: Lana
Duration: 1:55
Thumbnail image
Limiting Values to Whole Numbers
Channel: Microsoft Excel
Instructor: Lana
Duration: 5:45
Thumbnail image
Copying Data Validation Rules
Channel: Microsoft Excel
Instructor: Lana
Duration: 2:48
Thumbnail image
Editing and Deleting Data Validation Rules
Channel: Microsoft Excel
Instructor: Lana
Duration: 2:42
Thumbnail image
Finding Data Validation Rules Using Go To Special
Channel: Microsoft Excel
Instructor: Lana
Duration: 2:54
Thumbnail image
Limiting Entries to Whole Numbers Using a Formula
Channel: Microsoft Excel
Instructor: Lana
Duration: 3:59
Thumbnail image
Limiting Entries to Decimal Values
Channel: Microsoft Excel
Instructor: Lana
Duration: 3:34
Thumbnail image
Limiting Entries to Date Values
Channel: Microsoft Excel
Instructor: Lana
Duration: 5:12
Thumbnail image
Limiting Entries to List Values Part 1
Channel: Microsoft Excel
Instructor: Lana
Duration: 3:49
Thumbnail image
Limiting Entries to List Values Part 2
Channel: Microsoft Excel
Instructor: Lana
Duration: 3:27
Thumbnail image
Limiting Values to a Specific Length
Channel: Microsoft Excel
Instructor: Lana
Duration: 2:15
Thumbnail image
Introduction on Creating Custom Data Validation Rules
Channel: Microsoft Excel
Instructor: Lana
Duration: 2:07
Thumbnail image
Limiting Values to Unique Entries
Channel: Microsoft Excel
Instructor: Lana
Duration: 3:36
Thumbnail image
Limiting Values to Email Addresses Part 1
Channel: Microsoft Excel
Instructor: Lana
Duration: 4:33
Thumbnail image
Limiting Values to Email Addresses Part 2
Channel: Microsoft Excel
Instructor: Lana
Duration: 3:41
Thumbnail image
Limiting Values to Dates Within 30 Days of Today
Channel: Microsoft Excel
Instructor: Lana
Duration: 4:54
Thumbnail image
Limiting Values to Custom Text Strings
Channel: Microsoft Excel
Instructor: Lana
Duration: 5:11
Thumbnail image
Introduction to Pivot Tables
Channel: Microsoft Excel
Instructor: Lana
Duration: 3:56
Thumbnail image
Structure of a Pivot Table
Channel: Microsoft Excel
Instructor: Lana
Duration: 4:34
Thumbnail image
Structure of A Pivot Table Part 2
Channel: Microsoft Excel
Instructor: Lana
Duration: 4:09
Thumbnail image
Creating a Pivot Table
Channel: Microsoft Excel
Instructor: Lana
Duration: 5:36
Thumbnail image
Moving and Deleting a Pivot Table
Channel: Microsoft Excel
Instructor: Lana
Duration: 2:30
Thumbnail image
Field List
Channel: Microsoft Excel
Instructor: Lana
Duration: 4:39
Thumbnail image
Pivot Table Layout Part 1
Channel: Microsoft Excel
Instructor: Lana
Duration: 4:12
Thumbnail image
Pivot Table Layout Part 2
Channel: Microsoft Excel
Instructor: Lana
Duration: 5:27
Thumbnail image
Showing or Hiding Totals
Channel: Microsoft Excel
Instructor: Lana
Duration: 3:29
Thumbnail image
Pivot Table Styles
Channel: Microsoft Excel
Instructor: Lana
Duration: 3:25
Thumbnail image
Automatically Sorting Field Items
Channel: Microsoft Excel
Instructor: Lana
Duration: 3:53
Thumbnail image
Manually Sorting Field Items
Channel: Microsoft Excel
Instructor: Lana
Duration: 2:17
Thumbnail image
Sorting by Total Values
Channel: Microsoft Excel
Instructor: Lana
Duration: 3:57
Thumbnail image
Changing the Summary Calculation
Channel: Microsoft Excel
Instructor: Lana
Duration: 4:22
Thumbnail image
Showing Values as a Percentage of Grand Total Part 1
Channel: Microsoft Excel
Instructor: Lana
Duration: 4:51
Thumbnail image
Showing Values as a Percentage of Grand Total Part 2
Channel: Microsoft Excel
Instructor: Lana
Duration: 2:59
Thumbnail image
Showing Values as a Percentage of Row or Column Totals
Channel: Microsoft Excel
Instructor: Lana
Duration: 2:57
Thumbnail image
Changing Number Format of Value Area Fields
Channel: Microsoft Excel
Instructor: Lana
Duration: 3:02
Thumbnail image
Displaying Source Records for a Summarized Value
Channel: Microsoft Excel
Instructor: Lana
Duration: 2:47
Thumbnail image
Selecting Item Labels and Values
Channel: Microsoft Excel
Instructor: Lana
Duration: 5:54
Thumbnail image
Manually Formatting the Pivot Table
Channel: Microsoft Excel
Instructor: Lana
Duration: 2:28
Thumbnail image
Grouping Items Part 1
Channel: Microsoft Excel
Instructor: Lana
Duration: 3:04
Thumbnail image
Grouping Items Part 2
Channel: Microsoft Excel
Instructor: Lana
Duration: 3:08
Thumbnail image
Filtering Items in the Row or Column Area
Channel: Microsoft Excel
Instructor: Lana
Duration: 5:34
Thumbnail image
Filtering Items Using the Filter Area
Channel: Microsoft Excel
Instructor: Lana
Duration: 4:10
Thumbnail image
Filtering Row Or Column Items Using Slicers
Channel: Microsoft Excel
Instructor: Lana
Duration: 4:32
Thumbnail image
Filtering Value Area Using Slicers
Channel: Microsoft Excel
Instructor: Lana
Duration: 4:04
Thumbnail image
Filtering Using a Timeline
Channel: Microsoft Excel
Instructor: Lana
Duration: 5:54
Thumbnail image
Grouping Dates by a Time Unit
Channel: Microsoft Excel
Instructor: Lana
Duration: 6:07
Thumbnail image
Grouping Dates by Multiple Time Units
Channel: Microsoft Excel
Instructor: Lana
Duration: 4:22
Thumbnail image
Grouping Dates by Day Units Part 1
Channel: Microsoft Excel
Instructor: Lana
Duration: 4:05
Thumbnail image
Grouping Dates by Day Units Part 2
Channel: Microsoft Excel
Instructor: Lana
Duration: 3:15
Thumbnail image
Grouping Numbers
Channel: Microsoft Excel
Instructor: Lana
Duration: 3:43
Thumbnail image
Introduction to Macros
Channel: Microsoft Excel
Instructor: Lana
Duration: 3:23
Thumbnail image
Example of a Macro
Channel: Microsoft Excel
Instructor: Lana
Duration: 3:33
Thumbnail image
Macros Are Stored in Modules
Channel: Microsoft Excel
Instructor: Lana
Duration: 2:40
Thumbnail image
Macro Enabled File Types
Channel: Microsoft Excel
Instructor: Lana
Duration: 3:16
Thumbnail image
Accessing and Running Macros
Channel: Microsoft Excel
Instructor: Lana
Duration: 3:59
Thumbnail image
The Personal XLSB Workbook
Channel: Microsoft Excel
Instructor: Lana
Duration: 2:29
Thumbnail image
The Developer Tab
Channel: Microsoft Excel
Instructor: Lana
Duration: 2:30
Thumbnail image
Visual Basic Editor
Channel: Microsoft Excel
Instructor: Lana
Duration: 3:56
Thumbnail image
Creating a Module
Channel: Microsoft Excel
Instructor: Lana
Duration: 6:27
Thumbnail image
Creating a Macro
Channel: Microsoft Excel
Instructor: Lana
Duration: 4:05