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+ Course – eLearning Bundle
Course Overview: Embark on a comprehensive journey into the fundamentals of IT with our CompTIA A+ Course eLearning Bundle. This inclusive package covers both A+ Core 1 and A+ Core 2, providing a well-rounded understanding of essential IT skills. Additionally, gain hands-on experience through access to CompTIA Labs, ensuring practical proficiency in the concepts learned.
Key Highlights:
- Thorough Coverage: Delve into the intricacies of A+ Core 1 and Core 2, covering hardware, software, networking, security, and troubleshooting.
- Real-world Application: Access CompTIA Labs to apply theoretical knowledge in practical scenarios, enhancing your problem-solving skills.
- Expert Instructors: Learn from industry professionals with extensive experience in IT, gaining insights and best practices.
- Interactive Learning: Engage in interactive modules, quizzes, and assessments to reinforce your understanding at every step.
- Flexible Learning: Access course materials at your own pace, allowing for a customized learning experience.
Course Format
This eLearning CompTIA A+ Course employs a dynamic and user-friendly format, combining video lectures, interactive quizzes, and hands-on labs. Each module is designed to build on the previous one, ensuring a seamless learning experience. The format enables you to balance your professional commitments while advancing your IT skills.
Who Should Attend
- IT Enthusiasts and Beginners
- Entry-level IT Professionals
- Help Desk and Support Staff
- Individuals Pursuing a Career in IT
Prerequisites
No prior IT experience is required, making this course suitable for beginners. However, a basic understanding of computer operations and familiarity with the Windows operating system is beneficial.
Certification
Upon completion of the CompTIA A+ eLearning Course Bundle, participants will be well-prepared to take the CompTIA A+ certification exams (220-1001 for Core 1 and 220-1002 for Core 2). Earning the CompTIA A+ certification validates foundational IT skills and opens doors to various entry-level IT roles. NB The exam vouchers must be bought separately.
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.
