| Microsoft Excel Intermediate covers more advanced topics, such as pivot tables, data analysis tools, macros, and VBA. |
-
Module 1: Pivot Tables
- Demonstrate an understanding of pivot tables.
- Identify the different types of pivot tables.
- Explain how to use pivot tables effectively.
- Module 2: Data Analysis Tools
- Demonstrate an understanding of data analysis tools.
- Identify the different data analysis tools available in Microsoft Excel.
- Explain how to use each tool effectively.
- Module 3: Macros and VBA
- Demonstrate an understanding of macros and VBA.
- Identify the different types of macros and VBA.
- Explain how to use macros and VBA effectively.
- Module 4: Advanced Formulas and Functions
- Demonstrate an understanding of advanced formulas and functions.
- Identify the different types of advanced formulas and functions.
- Explain how to use each formula and function effectively.
- Module 5: Working with Multiple Worksheets
- Demonstrate an understanding of how to work with multiple worksheets.
- Identify the different tools for working with multiple worksheets.
- Explain how to use each tool effectively.
- High school or equivalent
- Strong communication and interpersonal skills
- Interest in the course topic
- Good level of English
| 25 GLH |