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 Training with CompTIA Labs
Course Overview
Embark on a comprehensive journey through the CompTIA A+ Core 2 course with our meticulously crafted eLearning course. Designed to provide a thorough understanding of IT operational roles and technical support, this course is an essential stepping stone for anyone aspiring to excel in the IT industry.
Key Highlights
- In-Depth Core 2 Coverage: Delve into the intricacies of the CompTIA A+ Core 2 exam objectives, covering essential topics like operating systems, security, software troubleshooting, and operational procedures.
- Hands-On Experience with CompTIA Labs: Gain practical insights through hands-on labs, reinforcing theoretical knowledge and ensuring you’re well-prepared for real-world scenarios.
- Expert Instruction: Benefit from expert-led instruction, combining industry expertise with engaging teaching methods to make complex concepts accessible.
Course Format
- Self-Paced Learning: Enjoy the flexibility of learning at your own pace, allowing you to balance professional commitments while mastering the material.
- Video Lectures: Access high-quality video lectures that break down complex topics, making them easy to understand and apply.
- Interactive Quizzes: Reinforce your learning with interactive quizzes to assess your progress and solidify key concepts.
Who Should Attend
This course is tailored for:
- IT Professionals seeking to enhance their skills and advance their careers.
- Entry-level technicians aspiring to kickstart their IT journey.
- Individuals preparing for the CompTIA A+ Core 2 certification exam.
Prerequisites
While there are no mandatory prerequisites, a basic understanding of IT concepts and familiarity with computer hardware and software will be beneficial.
Certification
Upon successful completion of the course and labs, you’ll be well-prepared to ace the CompTIA A+ Core 2 exam. This certification validates your proficiency in IT operational roles and serves as a testament to your expertise in technical support. You need to pass CompTIA A+ Core 1 & Core 2 exams to get your A+ Certificate Award from CompTIA.
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.
