Crash Course Syllabus: Excel, Google Slides, and PowerPoint
This syllabus is designed to help you master Excel for data analytics and Google
Slides/PowerPoint for impactful presentations. With a mix of light weekday learning and in-
depth weekend practice, you'll build both skills and confidence.
Weekly Breakdown
Week 1: Excel Fundamentals
Focus: Get comfortable with Excel basics and data cleaning techniques.
Sunday (10:00–11:00 AM): Introduction to Excel: Interface, shortcuts, basic formulas (SUM,
AVERAGE).
Monday (10:00–11:00 AM): Sorting, filtering, removing duplicates.
Tuesday (10:00–11:00 AM): Conditional Formatting for insights.
Wednesday (10:00–11:00 AM): Introduction to Charts (Bar, Line, Pie).
Thursday (10:00–11:00 AM): Pivot Tables basics: Summarizing data.
Friday (10:00 AM–1:00 PM): Advanced formulas (VLOOKUP, HLOOKUP, INDEX-MATCH).
Saturday (10:00 AM–1:00 PM): Advanced data visualization: Combo charts, slicers,
dashboard creation.
Week 2: Advanced Excel & Introduction to Slides/PowerPoint
Focus: Data analysis, presentation basics.
Sunday (10:00–11:00 AM): Excel: Data Validation and Drop-down Lists.
Monday (10:00–11:00 AM): Excel: Intro to Macros and basic automation.
Tuesday (10:00–11:00 AM): Google Slides: Interface & basic slide design.
Wednesday (10:00–11:00 AM): Google Slides: Adding charts & images.
Thursday (10:00–11:00 AM): PowerPoint: Basic interface & templates.
Friday (10:00 AM–1:00 PM): Excel: Practical project – Sales analysis report with dashboard.
Saturday (10:00 AM–1:00 PM): Slides/PowerPoint: Presentation storytelling, animations,
transitions.
Week 3: WOW Presentations
Focus: Master Google Slides and PowerPoint for impactful visuals.
Sunday (10:00–11:00 AM): Google Slides: Collaborating with team.
Monday (10:00–11:00 AM): PowerPoint: Working with SmartArt & shapes.
Tuesday (10:00–11:00 AM): Advanced animations and transitions.
Wednesday (10:00–11:00 AM): Embedding videos, charts, and hyperlinks.
Thursday (10:00–11:00 AM): Practice: Redesign a simple sales deck.
Friday (10:00 AM–1:00 PM): Full Presentation Creation: Sales pitch with story flow.
Saturday (10:00 AM–1:00 PM): Present & Review: Mock pitch practice.
Week 4: Mastery & Final Project
Focus: Integration and application.
Sunday (10:00–11:00 AM): Excel: Scenario manager & what-if analysis.
Monday (10:00–11:00 AM): PowerPoint: Custom templates.
Tuesday (10:00–11:00 AM): Combining tools: Excel charts into slides.
Wednesday (10:00–11:00 AM): Google Slides: Interactive presentations.
Thursday (10:00–11:00 AM): Review and troubleshoot.
Friday (10:00 AM–1:00 PM): Final Project: Build a sales deck integrating Excel analytics.
Saturday (10:00 AM–1:00 PM): Presentation Showcase & Feedback Session.
Conclusion
By following this syllabus, you will gain practical skills in Excel, Google Slides, and
PowerPoint tailored to your needs in data analytics and sales presentations. Practice
consistently, use the suggested resources, and focus on building both knowledge and
confidence. Best of luck in your learning journey!
