Allison Roby
The five-week Microsoft® Excel Advanced Concepts course consists of 15 contact hours of hands-on instruction by a certified Microsoft® Excel Expert.
Participants acquire the following key competencies during this five-week program:
• Working with complex datasets using advanced functions and formulas in Excel.
• Presenting data insights using advanced charting techniques.
• Setting up forms for collaborative projects in the workplace.
• Preparing interactive pivot tables and pivot charts for professional distribution.
• Effectively using the 10 most important functions used in the workplace.
To complete the Excel Advanced Concepts course, each participant must:
• Work on dataset exercises.
• Complete short quizzes throughout the course.
• Demonstrate proficiency in course concepts.
• Complete the required coursework at a satisfactory level to earn a passing grade.
This badge was issued to participants upon successful completion of the program during the Spring 2023-Spring 2024 semesters.
Skills / Knowledge
- Excel
- pivot tables
- IF Statements
- Macros
- Functions
- Data validation
- Conditional Formatting
- Customized Ribbon
- Advanced Charting
- Analysis Tookpak
- Vlookup/Hlookup
- Flash Fill
- Index/Match
- Min/Max