Zenler Player
Your course is loading. Hang tight.
Essential Excel Skills for The Savvy Assistant - Module 3
Back to curriculum
0% Complete
0% Complete
Welcome to Module 3
Recap Absolute Cell References
Partial Absolute Cell References
Named Ranges
Define a Named Range and its Scope
SUMIF AVERAGEIF and more
SUMIFS
The IF Statement
Nested IF
VLookup
Match a Value
Index and Match
XLookup
Formula Auditing
Create a Chart
Linking the Chart to Word or PowerPoint
A Selection of Text Functions
Paste Special - paste your data without the formulae
Some Date Functions
Macros an Introduction
Record a Macro
Add a Macro to the QAT
What is the Personal Macro Workbook?
Please complete the feedback form
Untitled lesson
Introduction
Welcome to Module 3
Preview
Absolute and Partial Absolute Cell References
Recap Absolute Cell References
Partial Absolute Cell References
Named Ranges
Named Ranges
Define a Named Range and its Scope
Conditional Calculations
SUMIF AVERAGEIF and more
SUMIFS
The IF Statement
Nested IF
VLookup
Match a Value
Index and Match
XLookup
Auditing your Spreadsheet
Formula Auditing
Charts
Create a Chart
Linking the Chart to Word or PowerPoint
Text Functions
A Selection of Text Functions
Paste Special - paste your data without the formulae
Date Funcitions
Some Date Functions
Introduction to Basic Macros
Macros an Introduction
Record a Macro
Add a Macro to the QAT
What is the Personal Macro Workbook?
Hurrah! You did it!
Please complete the feedback form
Download the ebooks
Untitled lesson
×
This is an unpublished lesson. This lesson will not be shown for students unless you set it as Public.
Back to Dashboard
No contents are available in this lesson!
No lessons available !
Back to Dashboard
Lesson contents locked
Enroll to unlock this lesson.
Enroll to unlock
Next Lesson