Day 1: Advanced Formulas and Data Analysis
9:00 AM – 9:30 AM: Introduction and Course Overview
- Welcome and introduction
- Course objectives and structure
- Participant introductions
9:30 AM – 11:00 AM: Advanced Formulas and Functions
- Deep dive into VLOOKUP and HLOOKUP
- Understanding INDEX-MATCH for advanced lookups
- Exploring array functions for complex calculations
11:00 AM – 11:15 AM: Break
11:15 AM – 1:00 PM: Data Validation Techniques
- Creating drop-down lists and custom validation rules
- Using data validation for error prevention
- Applying advanced validation with formulas
1:00 PM – 2:00 PM: Lunch Break
2:00 PM – 3:30 PM: Advanced Data Analysis
- Using advanced filter and sorting options
- Introduction to data analysis tools (e.g., Goal Seek, Scenario Manager)
- Performing data consolidation and summarization
3:30 PM – 3:45 PM: Break
3:45 PM – 5:00 PM: PivotTables Mastery (Part 1)
- Creating and formatting PivotTables
- Grouping, filtering, and sorting PivotTable data
- Introduction to PivotCharts
Day 2: PivotTables, Macros, Charting, and Collaboration
9:00 AM – 9:30 AM: Review of Day 1 and Q&A
- Recap of key concepts from Day 1
- Participant questions and discussion
9:30 AM – 11:00 AM: PivotTables Mastery (Part 2)
- Advanced PivotTable calculations (e.g., calculated fields, calculated items)
- Using slicers and timelines for interactive reports
- Designing dynamic dashboards with PivotTables and PivotCharts
11:00 AM – 11:15 AM: Break
11:15 AM – 1:00 PM: Automation with Macros
- Introduction to Excel Macros and the VBA editor
- Recording and running macros
- Writing basic VBA code for automation
1:00 PM – 2:00 PM: Lunch Break
2:00 PM – 3:30 PM: Advanced Charting Techniques
- Creating combination charts and custom chart types
- Using sparklines for mini-data visualizations
- Enhancing charts with trendlines, error bars, and formatting
3:30 PM – 3:45 PM: Break
3:45 PM – 4:30 PM: Collaborative Work in Excel
- Sharing workbooks and protecting data
- Tracking changes and managing comments
- Co-authoring in real-time with Excel Online
4:30 PM – 5:00 PM: Final Q&A and Course Wrap-Up
- Participant questions and discussion
- Summary of key takeaways
- Course evaluation and feedback
5:00 PM: Course Completion and Certification
Description
Advanced Microsoft Excel: A Facilitator-Led Course
Course Description
Welcome to the Supreme ICT Academy’s 2-day Advanced Microsoft Excel Course! Take your Excel skills to new heights with this comprehensive and hands-on course, designed for professionals looking to unlock the full potential of Microsoft Excel.
What You’ll Learn
- Advanced Formulas and Functions: Dive deep into complex formulas and functions, including VLOOKUP, HLOOKUP, INDEX-MATCH, and array functions to enhance your data analysis capabilities.
- Data Validation and Analysis: Learn powerful data validation techniques and advanced data analysis tools to extract meaningful insights from large datasets.
- PivotTables Mastery: Harness the full potential of PivotTables and PivotCharts to create dynamic reports and visually compelling dashboards that drive decision-making.
- Automation with Macros: Streamline repetitive tasks by mastering Excel macros. Automate processes, increase efficiency, and save valuable time in your day-to-day operations.
- Advanced Charting Techniques: Create stunning visualizations with advanced charting features. Impress your audience with insightful and dynamic charts that convey complex information effortlessly.
- Collaborative Work in Excel: Explore collaborative features such as sharing workbooks, tracking changes, and utilizing Excel’s powerful collaboration tools for effective teamwork.
Why Choose Our Course
- Facilitator-Led Learning: Benefit from expert-led sessions where our experienced instructors guide you through each topic, ensuring a personalized and interactive learning experience.
- Real-world Applications: Apply your skills to real-world scenarios, with practical exercises and case studies that mirror the challenges faced in today’s professional environment.
- Certificate of Completion: Receive a prestigious certificate from Supreme ICT Academy upon successfully finishing the course, validating your expertise in Advanced Microsoft Excel.
Who Should Enroll
- Professionals seeking to enhance their Excel proficiency for improved job performance.
- Data analysts, finance professionals, and business managers aiming to leverage Excel for advanced data manipulation and analysis.
How to register
- Click the “Add to basket” button and follow the instructions to buy.
- Supreme ICT Academy will email you the confirmation of registration within 24 Business Hours of a successful purchase.
- Please do not hesitate to contact us in case of difficulties with registration or if you need additional information.
- Please ensure to use your exam voucher within 12 months from the date of purchase.
Refund Policy
- A full refund is payable if cancellation is received 7 days or more before the scheduled start date, in case of cancellation by the participant.
- A 10% cancellation fee is deducted from the refund payable if is received between 2 days and 6 days before the scheduled start date, in case of cancellation by the participant.
- No refund will be payable on the start date, however, in case of legal or medical emergencies the candidate participants may be accommodated in subsequent scheduled classes.
- If Supreme ICT Academy initiates the cancellation, an alternate date will be proposed to the candidate participants. If the alternative date does not suit the candidate, she/he can apply for a refund.
Date & Venue
Eersterus: 15-16 July 2024. Please see the schedule for other course dates
Durban Central: no schedule yet
KwaThema: no schedule yet
