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 Security+ Instructor-led 5-day Course with CompTIA Labs
Course Overview
Our CompTIA Security+ course (Instructor-led), combined with hands-on CompTIA labs, is designed to equip participants with the essential skills and knowledge to excel in the field of cybersecurity. This comprehensive program covers a wide range of topics, ensuring that learners gain a deep understanding of security concepts, technologies, and best practices.
Key Highlights
- Interactive Labs: Engage in practical, real-world scenarios through our CompTIA labs, providing a hands-on approach to learning.
- Expert Instructors: Benefit from the expertise of our seasoned instructors with vast industry experience in cybersecurity.
- Comprehensive Curriculum: Covering the latest trends, threats, and solutions in the ever-evolving landscape of cybersecurity.
Course Format
The Security+ course is instructor-led and delivered through face-to-face physical classroom or virtual classroom attendance, offering a mix of lectures, interactive quizzes, and immersive labs. Participants can learn at their own pace, with lifetime access to course materials.
Who Should Attend
This course is ideal for:
- IT professionals aspiring to enhance their cybersecurity skills.
- Network administrators seeking to strengthen their understanding of security principles.
- Anyone preparing for the CompTIA Security+ certification exam.
Prerequisites
While there are no strict prerequisites, a basic understanding of networking concepts is recommended. This course is designed to accommodate learners with varying levels of experience in IT and cybersecurity.
Certification
Upon successful completion of the course, participants will receive a Supreme ICT Academy certificate of completion and will be well-prepared to take the CompTIA Security+ certification exam. This globally recognized certification validates the skills needed for a successful career in cybersecurity. NB Exam voucher certification exam is not part of this bundle
Enroll now to embark on a learning journey that will empower you with the knowledge and practical skills to thrive in the dynamic field of cybersecurity.
How to register
- Click the “Add to basket” button and follow the instructions to buy.
- Supreme ICT Academy will email you the registration confirmation with instructions within 24 Business Hours of a successful purchase to proceed with your studies.
- Please do not hesitate to contact us in case of difficulties with registration or if you need additional information.
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: Please see the schedule for other course dates
Durban Central: no schedule yet
KwaThema: no schedule yet
