Lesson 01 TipsTricks row references v2
Pain Free Excel
Lesson 01 TipsTricks row references v2
4:26
Lesson 01 TipsTricks moving and selecting v2
Pain Free Excel
Lesson 01 TipsTricks moving and selecting v2
5:38
Lesson 01 TipsTricks debugging v2
Pain Free Excel
Lesson 01 TipsTricks debugging v2
3:23
Lesson 01 TipsTricks Finding Formulas v2
Pain Free Excel
Lesson 01 TipsTricks Finding Formulas v2
7:41
Lesson 01 TipsTricks copy column formulas v2
Pain Free Excel
Lesson 01 TipsTricks copy column formulas v2
3:12
Lesson 01 TipsTricks Auditing cells v2
Pain Free Excel
Lesson 01 TipsTricks Auditing cells v2
7:33
Lesson 01 TipsTricks converting formulas to values v2
Pain Free Excel
Lesson 01 TipsTricks converting formulas to values v2
4:28
Lesson 01 Tips Tricks column references  v2
Pain Free Excel
Lesson 01 Tips Tricks column references v2
2:38
Test Review  (Production Dept)
Pain Free Excel
Test Review (Production Dept)
28:03
Excel Course Introduction
Pain Free Excel
Excel Course Introduction
1:10
Lesson 13   Topic 4   Creating Data Tables
Pain Free Excel
Lesson 13 Topic 4 Creating Data Tables
7:05
Lesson 13   Topic 3   Using Scenario Manager
Pain Free Excel
Lesson 13 Topic 3 Using Scenario Manager
9:16
Lesson 13   Topic 2   Using Solver
Pain Free Excel
Lesson 13 Topic 2 Using Solver
8:06
Lesson 13   Topic 1   Using Goal Seek
Pain Free Excel
Lesson 13 Topic 1 Using Goal Seek
10:09
Lesson 12  Topic 6   Deleting Duplicates
Pain Free Excel
Lesson 12 Topic 6 Deleting Duplicates
5:04
Lesson 12  Topic 5   Using Flash Fill for splitting and combining
Pain Free Excel
Lesson 12 Topic 5 Using Flash Fill for splitting and combining
7:18
Lesson 12  Topic 4   Splitting Text
Pain Free Excel
Lesson 12 Topic 4 Splitting Text
5:36
Lesson 12  Topic 3   Using Filters
Pain Free Excel
Lesson 12 Topic 3 Using Filters
7:13
Lesson 12  Topic 2   Inserting Subtotals
Pain Free Excel
Lesson 12 Topic 2 Inserting Subtotals
9:02
Lesson 12   Topic 1   Sorting Data
Pain Free Excel
Lesson 12 Topic 1 Sorting Data
8:06
Lesson 11   Topic 1   Securing Worksheets and Hiding Tabs
Pain Free Excel
Lesson 11 Topic 1 Securing Worksheets and Hiding Tabs
14:28
Lesson 11   Topic 2   Securing Workbooks
Pain Free Excel
Lesson 11 Topic 2 Securing Workbooks
5:22
Lesson 7  Topic 3   Format Charts and  Elements
Pain Free Excel
Lesson 7 Topic 3 Format Charts and Elements
7:17
Lesson 7  Topic 4   Sparklines
Pain Free Excel
Lesson 7 Topic 4 Sparklines
8:15
Lesson 7  Topic 2   Chart Types
Pain Free Excel
Lesson 7 Topic 2 Chart Types
11:22
Lesson 7  Topic 1   Creating Charts
Pain Free Excel
Lesson 7 Topic 1 Creating Charts
7:41
Lesson 6   Topic 3   Page Setup
Pain Free Excel
Lesson 6 Topic 3 Page Setup
6:43
Lesson 6   Topic 2   Page Break Preview
Pain Free Excel
Lesson 6 Topic 2 Page Break Preview
4:55
Lesson 6   Topic 1   Page Layout View
Pain Free Excel
Lesson 6 Topic 1 Page Layout View
15:39
Lesson 5   Topic 2   Hiding and unhiding Rows and Columns
Pain Free Excel
Lesson 5 Topic 2 Hiding and unhiding Rows and Columns
4:39
Lesson 5   Topic 3   Moving Copying and Inserting Data
Pain Free Excel
Lesson 5 Topic 3 Moving Copying and Inserting Data
9:59
Lesson 5   Topic 1   Insert and Delete Rows and Columns
Pain Free Excel
Lesson 5 Topic 1 Insert and Delete Rows and Columns
6:46
Lesson 5   Topic 4   Find and Replace
Pain Free Excel
Lesson 5 Topic 4 Find and Replace
7:18
Lesson 4   Topic 7   Creating and Customizing tables
Pain Free Excel
Lesson 4 Topic 7 Creating and Customizing tables
17:51
Lesson 4   Topic 4   Designing Borders
Pain Free Excel
Lesson 4 Topic 4 Designing Borders
8:16
Lesson 4   Topic 2   Adjusting Columns and Rows
Pain Free Excel
Lesson 4 Topic 2 Adjusting Columns and Rows
5:17
Lesson 4   Topic 5   Exploring Numeric and special formats
Pain Free Excel
Lesson 4 Topic 5 Exploring Numeric and special formats
12:53
Lesson 4   Topic 6   Using Conditional Formatting
Pain Free Excel
Lesson 4 Topic 6 Using Conditional Formatting
12:51
Lesson 4   Topic 3   Align and Merge
Pain Free Excel
Lesson 4 Topic 3 Align and Merge
4:29
Lesson 4   Topic 1   Fonts and Styles
Pain Free Excel
Lesson 4 Topic 1 Fonts and Styles
14:23
Lesson 15   Topic 1   Macro Basics
Pain Free Excel
Lesson 15 Topic 1 Macro Basics
20:51
Lesson 14   Topic 4    Grouping in Pivot Tables
Pain Free Excel
Lesson 14 Topic 4 Grouping in Pivot Tables
6:43
Lesson 14   Topic 1   Creating Pivot Tables
Pain Free Excel
Lesson 14 Topic 1 Creating Pivot Tables
9:50
Lesson 14   Topic 2   Manipulating Pivot Tables
Pain Free Excel
Lesson 14 Topic 2 Manipulating Pivot Tables
9:09
Lesson 14   Topic 3   Group by Date
Pain Free Excel
Lesson 14 Topic 3 Group by Date
5:25
Lesson 12  Topic 7   Data Validation Tools
Pain Free Excel
Lesson 12 Topic 7 Data Validation Tools
12:42
Lesson 14   Topic 6   Pivot Charts
Pain Free Excel
Lesson 14 Topic 6 Pivot Charts
9:00
Lesson 14   Topic 5   Pivot table Slicers
Pain Free Excel
Lesson 14 Topic 5 Pivot table Slicers
7:17
Lesson 8   Topic 2   Splitting Screens
Pain Free Excel
Lesson 8 Topic 2 Splitting Screens
3:58
Lesson 8   Topic 1   Frezzing and Unfreezing Panes
Pain Free Excel
Lesson 8 Topic 1 Frezzing and Unfreezing Panes
5:00
Lesson 8   Topic 3   Outlining
Pain Free Excel
Lesson 8 Topic 3 Outlining
5:27
Lesson 9   Topic 1   Viewing Multiple Workbooks and Worksheets
Pain Free Excel
Lesson 9 Topic 1 Viewing Multiple Workbooks and Worksheets
9:22
Lesson 9   Topic 3    Linking Worksheets and Workbooks with Formulas
Pain Free Excel
Lesson 9 Topic 3 Linking Worksheets and Workbooks with Formulas
21:09
Lesson 9   Topic 2   Working With Sheets
Pain Free Excel
Lesson 9 Topic 2 Working With Sheets
6:38
Lesson 10   Topic 2   Vlookup Approximate
Pain Free Excel
Lesson 10 Topic 2 Vlookup Approximate
6:03
Lesson 10   Topic 4   IF Family Functions
Pain Free Excel
Lesson 10 Topic 4 IF Family Functions
6:11
Lesson 10   Topic 3   Vlookup Exact with Function Assistance
Pain Free Excel
Lesson 10 Topic 3 Vlookup Exact with Function Assistance
5:48
Lesson 10   Topic 1   If functions and Vlookup
Pain Free Excel
Lesson 10 Topic 1 If functions and Vlookup
6:01
Lesson 3   Topic 7   Other Functions
Pain Free Excel
Lesson 3 Topic 7 Other Functions
12:02
Lesson 3   Topic 1   Creating Formulas and Functions
Pain Free Excel
Lesson 3 Topic 1 Creating Formulas and Functions
12:48
Lesson 3   Topic 6   Auto Sum and Auto  Average
Pain Free Excel
Lesson 3 Topic 6 Auto Sum and Auto Average
8:19
Lesson 3   Topic 5   Working with abosolute and relative references
Pain Free Excel
Lesson 3 Topic 5 Working with abosolute and relative references
10:55
Lesson 3   Topic 2   Copying a formula into an adjacent cell
Pain Free Excel
Lesson 3 Topic 2 Copying a formula into an adjacent cell
3:30
Lesson 3   Topic 4   Creating a percent change formula
Pain Free Excel
Lesson 3 Topic 4 Creating a percent change formula
3:44
Lesson 3   Topic 3   Calculating Year to date totals
Pain Free Excel
Lesson 3 Topic 3 Calculating Year to date totals
2:57
Lesson 2   Topic 1   Exploring data entry and editting techniques
Pain Free Excel
Lesson 2 Topic 1 Exploring data entry and editting techniques
6:40
Lesson 2   Topic 3   Working with dates and times
Pain Free Excel
Lesson 2 Topic 3 Working with dates and times
6:15
Lesson 2   Topic 2   Entering Data with Autofill
Pain Free Excel
Lesson 2 Topic 2 Entering Data with Autofill
6:08
Lesson 2   Topic 5   Adding Comments
Pain Free Excel
Lesson 2 Topic 5 Adding Comments
2:53
Lesson 2   Topic 4   Using Undo and Redo
Pain Free Excel
Lesson 2 Topic 4 Using Undo and Redo
2:36
Lesson 1   Topic 1   Introduction examples
Pain Free Excel
Lesson 1 Topic 1 Introduction examples
3:15
Lesson 1   Topic 2   Using the Menu System
Pain Free Excel
Lesson 1 Topic 2 Using the Menu System
11:01
Lesson 1   Topic 3   Using the Quick Access Toolbar
Pain Free Excel
Lesson 1 Topic 3 Using the Quick Access Toolbar
4:16
Lesson 1   Topic 4   Understanding Workbooks and Worksheets
Pain Free Excel
Lesson 1 Topic 4 Understanding Workbooks and Worksheets
5:55
Lesson 1   Topic 5   Using the Formula Bar
Pain Free Excel
Lesson 1 Topic 5 Using the Formula Bar
2:42
Lesson 1   Topic 6   Using the Status Bar
Pain Free Excel
Lesson 1 Topic 6 Using the Status Bar
3:55
Lesson 1   Topic 7   Using Navigation Tools
Pain Free Excel
Lesson 1 Topic 7 Using Navigation Tools
7:38
Lesson 1   Topic 8   Using Short Cut Menues and the Mini Toolbar
Pain Free Excel
Lesson 1 Topic 8 Using Short Cut Menues and the Mini Toolbar
3:26
Lesson 1   Topic 9   Using Excel Help
Pain Free Excel
Lesson 1 Topic 9 Using Excel Help
3:10