top of page
Introductory Notes.
Advanced Excel Formulas
Practically: Making Excel work for you, stop doing all the hard work and let this software handle some by creating automatic IF statements and Quick Table to Table references.
Outcomes: You will learn 2 key functions of Excel – IF and VLOOKUP. You will get to know their strengths and weaknesses as well as alternatives to both when they don’t fit your needs. These 2 functions help save a lot of time and make your life in Excel more automatic. After this class you will work a lot less and Excel will work a lot more for you!
Jonathan Denis
Reasons to communicate
1. Questions & Inquiries
2. Handouts & Exercicses
Your Trainer
LVL 3 - Advanced Excel
Training Schedule.
08:30 to 09:00 - Welcome to the zoom (Optional)
09:00 to 10:00 -
10:00 to 11:00 - Break & practice period
11:00 to 12:00 -
12:00 to 13:00 - Lunch period
13:00 to 14:00 -
14:00 to 15:00 - Break & practice period
15:00 to 15:30 - Final note and conclusion
15:30 to 16:00 - Question Period & Class Review
Other IF type formulas
IF Practically
LOGICAL FUNCTIONS
LOGICAL FUNCTIONS
15 minutes before - Welcome to the zoom (Optional)
First 45 minutes -
Last 15 minutes - Question Period & Class Review
Get the recordings
No Dates
Available
DAY 1
08:30 to 09:00 - Welcome to the zoom (Optional)
09:00 to 10:00 -
10:00 to 11:00 - Break & practice period
11:00 to 12:00 -
12:00 to 13:00 - Lunch period
13:00 to 14:00 -
14:00 to 15:00 - Break & practice period
15:00 to 15:30 - Final note and conclusion
15:30 to 16:00 - Question Period & Class Review
Other IF type formulas
IF Practically
LOGICAL FUNCTIONS
DAY 2
08:30 to 09:00 - Welcome to the zoom (Optional)
09:00 to 10:00 -
10:00 to 11:00 - Break & practice period
11:00 to 12:00 -
12:00 to 13:00 - Lunch period
13:00 to 14:00 -
14:00 to 15:00 - Break & practice period
15:00 to 15:30 - Final note and conclusion
15:30 to 16:00 - Question Period & Class Review
Date/text functions
Index/Match
LOOKUP FUNCTIONS
FIRST HALF
13:00 to 13:15 - Welcome to the CLASS (Optional)
13:15 to 14:15 -
14:15 to 14:30 - Break
14:30 to 15:30 -
15:30 to 16:00 - Question Period
IF Practically
LOGICAL FUNCTIONS
SECOND HALF
13:00 to 13:15 - Welcome to the CLASS (Optional)
13:15 to 14:15 -
14:15 to 14:30 - Break
14:30 to 15:30 -
15:30 to 16:00 - Question Period
Index/Match
LOOKUP FUNCTIONS
bottom of page