Copy of Excel for Financial Professionals - Practice Exercises
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
Excel for Financial Professionals: Practice Exercises
3
4
5
Prepared by Amanda M. Wilkson, CPA
6
7
awilkson@batescarter.com
8
9
Table of Contents:
10
Tab 1
Shortcuts
11
Tab 2
CTRL + Arrow Keys (1)
12
Tab 3
CTRL + Arrow Keys (2)
13
Tab 4
Select Large Data
14
Tab 5
Delete Rows and Columns
15
Tab 6
Insert Rows and Columns
16
Tab 7
AutoSum Exercise
17
Tab 8
Function Basics
18
Tab 9
LEFT MID Exercise (1)
19
Tab 10
LEFT MID Exercise (2)
20
Tab 11
IF Statements
21
Tab 12
IF Statements Exercise
22
Tab 13
ISERROR() Exercise
23
Tab 14
Conditional Formatting
24
Tab 15
Conditional Formatting Example (1)
25
Tab 16
Conditional Formatting Example (2)
26
Tab 17
Conditional Formatting Example (3)
27
Tab 18
Conditional Formatting Exercise
28
Tab 19
Sparklines Exercise
29
Tab 20
Charts & Graphs Exercise
30
Tab 21
Named Ranges Example and Exercise
31
Tab 22
Data Filters
32
Tab 23
Data Filters Exercise
33
Tab 24
Pivot Table Exercise
34
Tab 25
VLOOKUP Exercise (1)
35
Tab 26
VLOOKUP Exercise (2)
36
Tab 27
VLOOKUP Exercise (3)
37
Tab 28
Index Match Exercise (1)
38
Tab 29
Index Match Exercise (2)
39
Tab 30
Index Match Exercise (3)
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
Loading...
Main menu