Miss Excel's Workplace FUNdamentals
(For Students 12+)
This entertaining course is designed to teach students 12+ the most sought after technical and soft skills by top companies in the workplace.
Commonly Asked Questions:
Do I need to purchase any Microsoft Office Products to access the course?
No - this course uses all free web based programs from Microsoft Office for Web (Excel, PowerPoint, Word, etc.)
Do I need a specific type of laptop to access the courses?
All you need is internet access! All lessons are accessible on Chromebooks, Macs, PCs and Tablets.
How long will I have access to the course for?
Students will have lifetime access to all course materials to refer back to anytime throughout their career!
When does the course start?
Students can start at any time and move at their own pace!
Is this for college students too?
Yes! This course is great preparation for college students entering the workplace.
Is there a Completion Certificate?
Yes! Once a student completes the course they will receive a certificate. Great to hang on the fridge 😊
What topics are included?
Students will learn all the topics below (and I PROMISE I make it fun!!!)
Start Here! 👋
How to Access Microsoft Office for the Web
Download Course Files
Shortcut Guides & Template Library 📚
100: Meet PowerPoint (Web Version) 👋🏼
101: Getting Started in PowerPoint
102: Presentation Building Basics
103: Give your slides a Glow Up with Smart Art ✨
104: The Art of Using Images & Videos
105: Themes (the Presets of PowerPoint)
106: Dictate Tool (PowerPoint's Voice to Text) 🗣
107: Make Slides Dance with Animations & Transitions 🕺🏼
108: Vibe Check your Deck with Review Ribbon
109: The Aftermath: Print, Save, Share
110: Presenting Do's and Don'ts
111: Tips for Overcoming Presentation Anxiety 😳
200: Meet Microsoft Word (Web Version) 🙋🏼♂️
201: Getting Started in Microsoft Word
202: Document Formatting Basics
203: Insert Ribbon: Home of the Drip for your Docs 💎
204: Check Yourself with the Review Ribbon
205: Sharing Documents 👭
206: Printing / Saving as PDF Best Practices
300: Meet Excel 🙋🏼♀️
301: Anatomy of a Function 👨🏼⚕️
302: The Spreadsheet Shuffle
303: Formatting Basics
304: Remove Duplicates 🙅🏼♀️
305: Make Cells Change Color Automatically (Conditional Formatting)
306: Text to Columns (a fun tool!)
307: Flash Fill ⚡ Excel's Superhero
308: Sorting & Filtering (only seeing what you want!)
309: Freezing Cells in Place ❄
310: Pivot Tables
311: Creating Cool Charts
312: Grouping & Gridlines
313: Drop it like its hot with Drop Down Menus
314: Case Functions (Upper, Lower, Proper)
315: Extraction Functions (Where Toosie Slide meets Excel)
316: Date Functions 📆
317: Logical Functions (Sum or Count only the cells you want)
318: Statistical Functions (Find the Average, Maximum, Minimum etc.)
319: How to Combine Cells Together
320: Lookup Functions 🔎
321: Index / Match (the BFFs of Excel 👭)
322: Data Types
323: Filter Function (Lookup and Pull Multiple Results)
324: Absolute Referencing * SUPER IMPORTANT*
325: Images, Shapes & Links
326: Reviewing Sheets (Spell Check, Comments & Notes)
327: Print / Saving as PDF
328: Sharing Spreadsheets
400: All About Virtual Meetings
401: Teams Meeting 101
402: Teams Chat
403: Teams Calendar
404: Virtual Meeting Planning Tips
405: Virtual Meeting Attendee Etiquette
406: Active Listening
500: Writing Professional Emails 101
501: Anatomy of an Email 👩🏼⚕️
502: How to Write Clear & Efficient Emails
503: Writing Emails in Outlook
504: Formatting Emails in Outlook
505: Organizing Inbox in Outlook 📬
506: Organizing Calendar in Outlook 📆
507: Setting Out of Office Replies in Outlook 🌴
508: Crafting your Email Signature
509: Email Template - How to ask for something
510: Email Template - How to Follow Up
511: Email Template - How to Decline Something
512: Email Template - Thank You
513: Email Template - Late Deliverable
514: Email Template - Coordinating a date
515: Email Template - Reschedule a Meeting
516: Email Template - Ask for Feedback
517: Email Template - Ask for help
518: Email Template - How to Gracefully Admit Mistake
519: Email Template - Ask for time off
520: Email Template - How to address an error someone else made
521: Email Template - How to get out of something
600: What does Professionalism even mean?!
601: Professionalism in In-Person Meetings
602: How to be Professional in front of clients / team (and what NOT to do)
603: How to Handle Mistakes 😳
604: First Impressions
605: Office Dress Codes - Business Professional vs Business Casual vs Casual Friday 🤷🏼♀️
606: Confidence at Work (Even if you are new & don't know what you're doing yet 😇)
607: Art of the Handshake (Do we even handshake anymore?!)
608: Body Language (How others perceive you + how to read others)
609: Time Management Tips ⏰
610: When in doubt - Match Company Culture
611: Finding a Mentor
612: Keeping Track of Accomplishments
613: Staying Positive! 😊
700: Let's talk work!
701: Crafting your Elevator Pitch
702: Designing your Resume (+ Pre-Made Templates)
703: Job Fair Etiquette
704: All About Cover Letters (+ Pre-Made Templates)
705: How to Prepare for an Interview
706: Coping with Interview Anxiety
707: Interview Questions You May Be Asked
708: Networking Do's and Don'ts
709: How to Prepare for your First Internship / Job
CONGRATS YOU MADE IT!!!!!!!