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 Cloud Essentials+Course
Course Description
Welcome to the ultimate lessons to mastering the essentials of cloud computing with CompTIA Cloud Essentials+ Course. Whether you’re a seasoned IT professional or just starting your journey in the world of technology, this course is designed to provide you with a comprehensive understanding of cloud computing concepts and principles.
In this course, you’ll delve into the fundamentals of cloud computing, exploring topics such as cloud architecture, deployment models, and service models. You’ll learn how cloud computing is transforming the way organizations operate, enabling greater agility, scalability, and cost-efficiency.
Throughout the course, you’ll gain practical insights into implementing cloud solutions, managing cloud services, and ensuring security and compliance in the cloud environment. With hands-on labs and real-world scenarios, you’ll develop the skills and knowledge needed to excel in cloud computing roles.
Key Learning Objectives:
- Understand the basics of cloud computing and its benefits.
- Explore different cloud deployment models, including public, private, and hybrid clouds.
- Learn about cloud service models such as Infrastructure as a Service (IaaS), Platform as a Service (PaaS), and Software as a Service (SaaS).
- Gain insights into cloud security best practices and compliance considerations.
- Master the essentials of cloud management, including provisioning, monitoring, and optimization.
- Develop practical skills through hands-on labs and real-world scenarios.
- Prepare effectively for the CompTIA Cloud Essentials+ certification exam.
Who Should Take This Course:
- IT professionals interested in expanding their knowledge of cloud computing.
- System administrators seeking to transition to cloud-based environments.
- Technical managers responsible for cloud adoption and migration strategies.
- Anyone preparing for the CompTIA Cloud Essentials+ certification exam.
Enroll now and take the first step towards mastering the fundamentals of cloud computing with CompTIA Cloud Essentials+ certification!
Prerequisites
While no specific prerequisites are mandatory, a basic understanding of computer hardware, software, and operating systems is beneficial. This course is designed to accommodate learners with varying levels of experience, making it accessible to beginners and experienced professionals alike.
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.
