Collection: Excel Intermediate Level 2
EXCE301
This program assumes knowledge of our EXCE201 – Excel Intermediate Level One program.
Course Overview
This course is designed to elevate your Excel proficiency. Delve into advanced techniques to streamline your data analysis and reporting processes. Master the art of creating dynamic pivot tables, automate repetitive tasks with VBA macros, and use Goal Seek to solve complex problems.
Leverage quick analysis tools to rapidly format data, generate charts, and apply conditional formatting. Understand and apply Boolean logic to create complex formulas and filter data effectively. Explore powerful functions like CHOOSE and LOOKUP to enhance your data manipulation and analysis capabilities.
By the end of this course, you'll be equipped to efficiently analyse data, create interactive reports, and automate tasks.
What you’ll Receive
• Workbook
• Participation Certificate
• Post Course Support
Pricing
$199 + GST (Per Person)
Key Topics Covered
- Create dynamic pivot tables to summarize and analyse large datasets.
- Utilize quick analysis tools for fast data formatting, charting, and calculations.
- Automate repetitive tasks with VBA macros.
- Find optimal solutions to complex problems with Goal Seek.
- Filter data based on multiple criteria and conditions with advanced filtering techniques.
- Understand and apply Boolean operators (AND, OR, NOT) to create complex formulas.
- Use the CHOOSE function to select values from a list based on an index number.
- Use the LOOKUP function to search for a value in a range and return a corresponding value.
Who Is This Course Ideal For?
Our Excel Intermediate Level 2 course is designed for care professionals, administrators, finance and accounting staff who want to enhance their data analysis and reporting skills to improve efficiency and decision-making.