Advanced Microsoft Excel Course

R2,000,00 Excl VAT

Advanced Microsoft Excel: A Facilitator-Led Course.
Welcome to the Supreme ICT Academy’s 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.

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

  1. 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.
  2. Data Validation and Analysis: Learn powerful data validation techniques and advanced data analysis tools to extract meaningful insights from large datasets.
  3. PivotTables Mastery: Harness the full potential of PivotTables and PivotCharts to create dynamic reports and visually compelling dashboards that drive decision-making.
  4. Automation with Macros: Streamline repetitive tasks by mastering Excel macros. Automate processes, increase efficiency, and save valuable time in your day-to-day operations.
  5. Advanced Charting Techniques: Create stunning visualizations with advanced charting features. Impress your audience with insightful and dynamic charts that convey complex information effortlessly.
  6. 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