Boost Your Microsoft Excel Skills
Syllabus
Course Description
This recoded course consist of several sessions. Each session is about 10 mins long, followed by a practice exercise to test that you have learned the material. Each practice exercise include a deadline to help you stay on track.
Topics include
- Advanced Data Entry
- Creating Formulas
- Creating and Formatting Tables
- Cell References
- Filtering and Sorting Data
- IF Function
- Pivot Tables
- Making and Designing Charts
- Conditional Formatting
- Statistical Functions
- Dealing with Dates and Texts
- Data Validation
- Lookup Functions