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 Server+ Course (eLearning) with CompTIA Labs
Course Overview
Embark on a comprehensive journey into server technologies with our CompTIA Server+ eLearning course bundle. This course is meticulously designed to equip participants with the essential skills and knowledge required to excel in the dynamic field of server administration. Through a combination of engaging content and hands-on labs, this course ensures a deep understanding of server architecture, virtualization, storage, and security
Key Highlights
- In-depth coverage of CompTIA Server+ exam objectives.
- Practical, real-world scenarios to reinforce theoretical concepts.
- Access to CompTIA Labs for a hands-on, interactive learning experience.
- Expert-led instruction providing insights from industry professionals.
- Comprehensive study materials and resources for effective exam preparation.
Course Format
Our Server+ course bundle is delivered through the user-friendly CompTIA CertMaster Learn eLearning platform, offering flexibility and convenience. Participants can progress through the material at their own pace, with the freedom to revisit modules for reinforced learning. The course includes video lectures, interactive quizzes, and practical labs to ensure a well-rounded educational experience.
Who Should Attend
This course is ideal for IT professionals, system administrators, and anyone aspiring to specialize in server management. Whether you are starting your IT career or looking to advance your skills, this program caters to individuals seeking a solid foundation in server technologies.
Prerequisites
While there are no strict prerequisites, a basic understanding of IT concepts and networking fundamentals will be beneficial. This course is designed to accommodate participants with varying levels of experience, making it accessible to both beginners and seasoned IT professionals..
Certification
Upon successful completion of the course, participants will be well-prepared to take the CompTIA Server+ certification exam. Achieving this certification validates your expertise in server administration and enhances your professional credibility in the IT industry.
Embark on a transformative educational experience by enrolling in our CompTIA Server+ course. Gain the expertise and hands-on skills necessary to excel in the dynamic realm of server administration. Secure your spot now and pave the way for a successful career in the ever-evolving field of IT.
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.