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 Network+ Course (N10-008) eLearning plus CompTIA Labs
Course Overview: Join us at Supreme ICT Academy for a comprehensive CompTIA Network+ Course, this eLearning journey is designed to master the essential skills required for a successful career in networking. This all-inclusive CompTIA Network+ (N10-008) bundle combines in-depth theoretical knowledge with practical hands-on experience through access to CompTIA Labs.
Key Highlights
- Up-to-Date Content: Our course is meticulously crafted to cover the latest CompTIA Network+ (N10-008) objectives, ensuring you are well-equipped with the most relevant knowledge.
- Interactive Labs: Gain practical experience through CompTIA Labs, enabling you to apply theoretical concepts in real-world scenarios.
- Expert Instructors: Learn from seasoned professionals in the field, providing insights and guidance throughout your elearning journey.
- Comprehensive Materials: Access a wealth of resources, including video lectures, reading materials, and practice exams, to reinforce your understanding.
Course Format
- Self-Paced Learning: Study at your own pace, allowing for flexibility in balancing your professional and personal commitments.
- Multimedia Content: Engage with a variety of multimedia resources, including videos, interactive quizzes, and hands-on labs.
- Discussion Forums: Connect with fellow learners, share experiences, and seek clarification on concepts in our dedicated online forums.
Who Should Attend
This course is tailored for aspiring IT professionals, network administrators, and anyone looking to solidify their networking skills. Whether you’re starting your career or enhancing existing knowledge, this bundle provides a comprehensive foundation in networking principles.
Prerequisites
While no specific prerequisites are mandatory, a basic understanding of IT concepts and familiarity with general computer use will enhance your learning experience.
Certification
Upon completion of the course, you will be well-prepared to take the CompTIA Network+ (N10-008) certification exam. Earning this globally recognized certification validates your proficiency in networking and opens doors to diverse career opportunities in the IT industry.
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.
