Sale!

CompTIA A+ Core 2 Exam Voucher

Original price was: R1,950,00.Current price is: R1,758,00. Excl VAT

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

CompTIA A+ Core 2 Exam Voucher

Description

Unlock your potential in the dynamic world of IT with the CompTIA A+ Core 2 Exam Voucher. This voucher provides you with access to one of the most respected certifications in the industry, recognized globally by employers as a benchmark for entry-level IT professionals.

With the Core 2 Exam Voucher, you’ll be prepared to demonstrate your expertise in critical areas such as installation and configuration of operating systems, expanded security, software troubleshooting, and operational procedures.

Why choose CompTIA A+? Because it’s not just a certification; it’s a pathway to exciting career opportunities in IT support, technical services, and much more. Plus, with the convenience of online testing, you can take the exam from the comfort of your own home or office.

Invest in your future today with the CompTIA A+ Core 2 Exam Voucher and take the first step towards a successful career in information technology.

Key Features

  • Access to the CompTIA A+ Core 2 Exam
  • Globally recognized certification
  • Demonstrates essential IT skills and knowledge
  • Convenient online testing option
  • Valid for one exam attempt

Specifications

  • Exam Code: 220-1002
  • Exam Duration: 90 minutes
  • Number of Questions: Maximum of 90

How to purchase a Voucher

  • 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.