Productive Expertise & Efficiency
1 Students Enrolled
Continue expanding your Excel skills with more advanced settings and skills in this high powered class.
Modules include: Advanced Options and Techniques, Worksheet Grouping, Dates & Times, Linking within Excel, Linking to PowerPoint and Word, Data Validation (Drop Down Lists), IF Function with Dates, IF Function with Nested Functions, VLOOKUP Function, Protection in Excel, Pivot Tables Introduction, What If Modelling -- Scenarios and Goal Seek, Macros Introduction.
This class is packed with skills and techniques that will massively expand your capabilities with the program.
- Students are only required to have a basic understanding of how rows and columns are referenced in Excel
- Advanced Options and Techniques
- Worksheet Grouping
- Dates & Times
- Linking within Excel
- Linking to PowerPoint and Word
- Data Validation (Drop Down Lists)
- IF Function with Dates
- IF Function with Nested Functions
- VLOOKUP Function
- Protection in Excel
- Pivot Tables Introduction
- What If Modelling - Scenarios and Goal Seek
- Macros Introduction