Excel Cram Kit (Exam 1)
Cell References
3 Concepts
|
1 Practice Exercise
Relative
Absolute
When to use relative vs. absolute?
Cell References – Practice!
Basic Calculations
6 Concepts
|
1 Practice Exercise
SUM
AutoSUM
COUNT
COUNTA
ROUND
RANK
Basic Calculations – Practice!
Advanced Calculations
5 Concepts
|
1 Practice Exercise
PMT explained
PMT with loans
PMT with annuities
IF
Percent Change
Advanced Calculations – Practice!
Working with Dates
3 Concepts
|
1 Practice Exercise
YEAR, MONTH, DAY
WEEKDAY
WORKDAY
Working with Dates – Practice!
VLOOKUP
1 Concept
|
1 Practice Exercise
VLOOKUP
VLOOKUP – Practice!
Excel Charts
8 Concepts
|
1 Practice Exercise
Why are Excel charts necessary?
How to create an Excel chart
Insert Excel chart title
Change style of Excel chart
Edit the axis of Excel chart
Add data labels to Excel chart
Add trendline in Excel chart
Select data range for Excel chart
Excel Charts – Practice!
Text files
2 Concepts
|
1 Practice Exercise
Why use text files?
How to import a text file
Text files – Practice!
Practice Excel Exam 1, Module 1
Practice Excel Exam 1, Module 2
Practice Excel Exam 1, Module 3
Practice Excel Exam 1, Module 4
Next Module
Cell References
Excel Cram Kit (Exam 1)
Cell References
Module Content
0% Complete
0/3 Steps
Relative
Absolute
When to use relative vs. absolute?
Cell References – Practice!
Back to Cram Kit
Next Module
Close
Home
Pricing
Courses
BUS 104
ACC 221
CSE 148
ECO 201
ECO 202
ISA 225
MTH 141
Contact
About
FAQ
Terms & Conditions
Course File Upload
Login