ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Lynda Training VideosWho should watch
2
1. Getting Started with Excel 2013
3
What is Excel used for?Beginner
4
Using the menu systemBeginner
5
The Quick Access ToolbarALL (This will make your life easier)
6
The structure of a worksheet or workbookBeginner
7
Using the Formula barBeginner
8
Using the Status barALL (Trust me)
9
Navigation and mouse pointersBeginner
10
Shortcut menus and the Mini toolbarBeginner
11
Using the built-in helpBeginner
12
Creating new filesBeginner
13
2. Entering Data
14
Exploring data entry and editing techniquesBeginner
15
Entering data with AutoFillALL (Everyone needs to know this)
16
Working with dates and timesBeginner
17
Using Undo and RedoBeginner
18
Adding commentsBeginner
19
Using Save or Save AsBeginner
20
3. Creating Formulas and Functions
21
Creating simple formulas: Totals and averages
Beginner
22
Copying a formula for adjacent cellsBeginner and Middle
23
Calculating year-to-date profits
Beginner and Middle (Contains good thought processes for Excel )
24
Creating a percentage-increase formula
Beginner and Middle (Contains hierarchy of operations information)
25
Working with relative, absolute, and mixed references
Beginner and Middle (Contains relative and absolute references)
26
Using SUM and AVERAGEBeginner and Middle (Autosum Buttons)
27
Using other common functionsALL (Goes through a number of functions)
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100