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
Mastering Advanced PowerPoint Techniques
Course Description
Welcome to the Advanced PowerPoint Course, a comprehensive facilitator-led course designed to elevate your PowerPoint skills to the next level. Whether you’re a business professional, educator, or anyone seeking to enhance their knowledge and application of advanced PowerPoint features to enhance your presentations and communication impact, this course is tailored for you.
Key Features
- Hands-On Learning: Dive into practical exercises that cover advanced features, ensuring you gain a deep understanding of PowerPoint’s capabilities.
- Customized Templates: Learn to create professional and visually appealing templates that align with your brand or personal style.
- Data Visualization Mastery: Explore advanced charting and data visualization techniques to make your data-driven presentations both informative and engaging.
- Interactive Elements: Discover how to incorporate interactive elements like hyperlinks, buttons, and dynamic content to captivate your audience’s attention.
- Mastering Animation: Take your presentations to the next level by mastering advanced animation techniques, bringing your slides to life without overwhelming your audience.
- Collaboration and Sharing: Understand the best practices for collaborative editing, sharing, and presenting online, making your workflow seamless and efficient.
Course Benefits
- Boost Your Professional Presence: Gain the skills to create polished and impactful presentations that leave a lasting impression on your audience.
- Efficient Workflow: Learn time-saving techniques and shortcuts to streamline your PowerPoint workflow, increasing productivity.
- Stay Updated: Keep pace with the latest features and updates in PowerPoint, ensuring you stay at the forefront of presentation technology.
Target Audience
- Business Professionals
- Educators
- Marketing and Sales Teams
- Anyone looking to enhance their PowerPoint proficiency
Prerequisites
Basic knowledge of PowerPoint or completion of an introductory course is recommended.
Instructor
Our expert instructor brings years of experience in both ICT and Management, ensuring a holistic approach to advanced PowerPoint techniques.
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 ensure to use your exam voucher within 12 months from the date of purchase.
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: 30-31 July 2024. Please see the schedule for other course dates
Durban Central: no schedule yet
KwaThema: no schedule yet
