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
Comprehensive CompTIA PenTest+ Course (eLearning with CompTIA Labs)
Course Description
Welcome to the ultimate online learning experience for mastering penetration testing with the CompTIA PenTest+ Course. This comprehensive eLearning course, bundled with hands-on CompTIA Labs, is meticulously designed to equip you with the skills and knowledge needed to excel in the dynamic field of cybersecurity.
What You’ll Learn:
- Fundamentals of Penetration Testing: Gain a solid understanding of the principles, methodologies, and tools used in penetration testing.
- CompTIA PenTest+ Exam Objectives: Cover all exam objectives, ensuring you’re well-prepared for the certification exam.
- Real-world Scenarios: Dive into practical, real-world scenarios to apply your skills and reinforce your learning.
- Hands-on Labs: Access to CompTIA Labs provides a simulated environment for practical application, allowing you to sharpen your skills in a risk-free setting.
- Ethical Hacking Techniques: Explore ethical hacking techniques, vulnerability assessment, and exploitation methodologies.
Course Features:
- Comprehensive Video Lectures: Engaging video lectures delivered by industry experts provide in-depth insights into each topic.
- Interactive Quizzes: Reinforce your understanding with interactive quizzes after each module.
- CompTIA Labs Access: Hands-on experience in a virtual environment to practice and refine your skills.
- Course Materials: Downloadable resources, study guides, and reference materials for offline learning.
- Lifetime Access: Access the course content and updates for a lifetime, ensuring you stay current with industry trends.
Who Should Enroll:
- Cybersecurity professionals
- IT professionals interested in penetration testing
- Security enthusiasts seeking to enhance their skills
Prerequisites
Basic understanding of networking concepts and security fundamentals. By the end of this course, you’ll be well-prepared to tackle the CompTIA PenTest+ exam and apply your skills in real-world scenarios. Enroll now and take the first step towards becoming a certified penetration testing professional!
How to register
- Click the “Add to basket” button and follow the instructions to buy.
- Supreme ICT Academy will email you the credentials to the CompTIA eLearning platform 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.
- You have to complete your course within 12 months from the date of purchase.
