Advanced Excel Course
This training empowers Excel users to elevate their knowledge and skills in Microsoft Excel and apply them to perform data manipulation for work needs. This program is composed of 6 hours of instruction, divided into two sessions.
Session #1 (3 hours): Participants will learn the following Excel features.
LookUp
Index
Match
Advanced formulas
Conditional formatting
Macros
Data Models
Session #2 (3 hours): In a workshop setting, participants will gain hands-on practice with department-related worksheets that participants will bring to the session. Participants will solve data problems and transform workbooks for decision making, using the new concepts, formulas, and skills learned in the first session. Participants will receive instructor guidance throughout the process.
Skills / Knowledge
- LookUp
- Index
- Match
- Advanced Formulas
- Conditional Formatting
- Macros
- Data Models