Sale!

IT Fundamentals Exam Voucher

Original price was: R1,061,00.Current price is: R1,031,00. Excl VAT

IT Fundamentals Exam Voucher gives you access to the CompTIA IT Fundamentals exam which verifies you as a successful candidate that you have the essential IT skills and knowledge needed to perform tasks commonly performed by advanced end-users and entry-level IT professionals alike, including: Using features and functions of common operating systems and establishing network connectivity; Identifying common software applications and their purpose; and Using security and web browsing best practices

Category:

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

IT Fundamentals Exam Voucher gives you access to the CompTIA IT Fundamentals exam which verifies you as a successful candidate that you have the essential IT skills and knowledge needed to perform tasks commonly performed by advanced end-users and entry-level IT professionals alike, including: Using features and functions of common operating systems and establishing network connectivity; Identifying common software applications and their purpose; and Using security and web browsing best practices.

How to register

  • Click the “Add to basket” button and follow the instructions to buy.
  • Supreme ICT Academy will email you the Exam Voucher details within 24 Business Hours of a successful purchase.
  • Please do not hesitate to contact us in case of difficulties with your purchase or if you need additional information.
  • Please ensure to use your exam voucher within 12 months from the date of purchase.