ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
xSession 1: Introduction
9
xSession 2: Entering, Editing and Formatting Data
19
xSession 3: Formatting Numbers
25
xSession 4: Managing Worksheets
32
xSession 5: Modifying Rows and Columns
33
Introduction
34
Inserting and Deleting Columns and Rows
35
Inserting & Deleting Cells
36
Inserting Multiple Columns & Rows
37
Modifying Cell Width and Height
38
Hiding and Unhiding Rows and Columns
39
xSession 6: Understanding Formulas
40
Introduction
41
Using Operations
42
Creating Formulas
43
AutoSum
44
Common Formulas
45
Searching for Formulas
46
Copying Formulas
47
Using Relative and Absolute References
48
xSession 7: Changing Views
49
Introduction
50
Workbook Views
51
Show/Hide
52
Zoom Features
53
Freeze Panes
54
Split Windows
55
Viewing Multiple Windows
56
Minimize The Ribbon
57
Worksheet Backgrounds
58
Watermarks
59
xSession 8: AutoFill and Custom Lists
60
Introduction
61
AutoFill a Series
62
AutoFill Non-Adjacent Cells
63
AutoFill on Multiple Sheets
64
Creating Custom Lists
65
Series Formatting
66
xSession 9: Conditional Formatting
67
Introduction
68
Highlight Cells Rules
69
Top/Bottom Rules
70
Data Bars
71
Color Scales
72
Custom Formatting Rule
73
xSession 10: Tables
74
Introduction
75
Insert a Table and Style Options
76
Add Rows and Columns
77
Perform a Function in a Table
78
Summarise With Pivot Table
79
xSession 11: Data Tools
80
Introduction
81
Data Validation
82
Drop-Down Lists
83
Removing Duplicates
84
Text To Columns
85
Goal Seek
86
Scenario Manager
87
xSession 12: Referencing Formulas
88
Introduction
89
Multiple Sheet References
90
Consolidating Data - With or Without Links
91
Trace the Precedents and Dependents
92
Using the Watch Window
93
xSession 13: Ranges and Dates
94
Introduction
95
Cell Names
96
Named Ranges
97
Formulas with Cell Names
98
Date Formulas
99
xSession 14: Lookups
100
Introduction
101
VLOOKUP
102
VLOOKUP Exact Match
103
HLOOKUP
104
HLOOKUP Exact Match
105
xSession 15: Conditional Logic
106
Introduction
107
IF Statement
108
Nested IF
109
AND
110
OR
111
NOT
112
IFERROR
113
SUMIF
114
AVERAGEIF
115
COUNTIF & COUNTIFS
116
SUMIFS
117
AVERAGEIFS
118
xSession 16: Text Formulas
119
Introduction
120
Case Formulas
121
Fix Number Fields
122
Trim Spaces
123
Substitute Text
124
xSession 17: Introduction to Charts
125
Introduction
126
Chart Types