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
Computer and Windows Fundamentals: Mastering Windows 10
Course Description
Welcome to “Computer and Windows Fundamentals: Mastering Windows 10,” your comprehensive guide to becoming proficient in using Windows 10. Whether you’re a beginner or looking to refresh your skills, this course will provide you with the essential knowledge and hands-on experience needed to navigate and customize Windows 10 like a pro.
What you’ll learn
– Navigate Windows 10 efficiently using built-in features and apps
– Work with desktop applications, including Microsoft Office
– Browse the web securely and effectively with Microsoft Edge
– Customize the Windows 10 environment to suit your preferences
– Utilize Windows 10 security features to protect your data and privacy
Course Content
Introduction to Windows 10
– Overview of the Windows 10 interface
– Basic navigation: Start Menu, Taskbar, Action Center
Using Windows Store Apps and Navigation Features
– Introduction to Windows Store and its apps
– Downloading and installing apps
– Multitasking with Snap Assist and Virtual Desktops
Working with Desktop Applications
– Managing desktop applications: installation and updates
– Using Microsoft Office applications (Word, Excel)
Using Microsoft Edge
– Key features of Microsoft Edge
– Customizing and optimizing your browsing experience
Customizing the Windows 10 Environment
– Personalization settings: background, themes, Start Menu
– Configuring system settings: display, notifications, power options
Using Windows 10 Security Features
– Overview of Windows Security: Windows Defender, Firewall
– User account management and parental controls
Requirements
– A computer with Windows 10 installed
– Basic computer skills (e.g., using a mouse and keyboard)
– Internet access for downloading apps and browsing
Who this course is for
– Beginners who are new to Windows 10
– Individuals looking to enhance their Windows 10 skills
– Users transitioning to Windows 10 from an older version or another OS
Course Features
Duration: 8 Hours of facilitator-led instruction
Practical Exercises: Hands-on activities to reinforce learning
Quizzes: Short quizzes to assess understanding
Interactive Q&A: Opportunities to ask questions and get real-time answers
Certification: Certificate of completion will be awarded to successful candidates
Course Outcomes
By the end of the Computer and Windows Fundamentals course, you will have a thorough understanding of Windows 10, enabling you to use the operating system confidently and efficiently. You’ll be equipped to customize your workspace, manage applications, secure your data, and navigate the digital world with ease.
How to register
- Click the “Add to basket” button and follow the instructions to buy.
- Supreme ICT Academy will email you the confirmation of registration within 24 Business Hours of a successful purchase.
- Please do not hesitate to contact us in case of difficulties with registration or if you need additional information.
- Please check the scheduled course date and venue below else contact us to confirm dates .
Refund Policy
- A full refund is payable if cancellation is received 7 days or more before the scheduled start date, in case of cancellation by the participant.
- A 10% cancellation fee is deducted from the refund payable if is received between 2 days and 6 days before the scheduled start date, in case of cancellation by the participant.
- No refund will be payable on the start date, however, in case of legal or medical emergencies the candidate participants may be accommodated in subsequent scheduled classes.
- If Supreme ICT Academy initiates the cancellation, an alternate date will be proposed to the candidate participants. If the alternative date does not suit the candidate, she/he can apply for a refund.
Date & Venue
Eersterus: Please see the schedule for other course dates
Durban Central: no schedule yet
KwaThema: no schedule yet
