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