Learn essential skills across the complete Microsoft Office suite in this comprehensive bootcamp covering PowerPoint, Outlook, Word, and Excel. Master PowerPoint by creating engaging presentations with custom themes, animations, multimedia elements, and advanced formatting options. Navigate through Word's document creation features including formatting, citations, tables, and mail merge capabilities. Develop Excel proficiency from basic functions and charts through advanced analytics, pivot tables, and macros. Explore Outlook's email and calendar management tools. Progress from fundamental concepts to advanced techniques in each application, gaining practical skills for creating professional documents, analyzing data, designing impactful presentations, and streamlining workflow. Practice hands-on with real-world exercises covering everything from basic navigation to complex features like data validation, custom templates, and automated reporting tools.
Overview
Syllabus
- PowerPoint Level I
- Create new PowerPoint Presentations
- Choose appropriate slide layouts & add content (text, images, etc.)
- Add photos, graphics, & how to adjust them (size, crop, etc.)
- Build Diagrams using SmartArt
- Draw Shapes & Lines
- Align & Evenly Space Objects
- Work with Tables & Charts
- Add Transitions
- Run a PowerPoint Presentation (Slide Show)
- PowerPoint Level II
- Design Custom PowerPoint Themes
- Work with Theme Colors, Fonts, Backgrounds, & Slide Layouts
- Add Animations for Stand Out Presentations
- Incorporate Video
- Customize the Look of Charts & Animate Charts
- Bring in Tables from Excel
- Manage Large Presentations with Sections, Hidden Slides, and Custom Shows
- Collaborate with Others using Comments
- Microsoft Outlook Level I
- Microsoft Outlook Level II
- Microsoft Word Level I
- Navigating through documents
- How to format documents
- Working with text and paragraphs
- Tables in Word
- Lists
- Endnotes, footnotes, and citations
- Adding Images to Word Documents
- Microsoft Word Level II
- Working with multiple documents
- Tracking changes
- Advanced formatting
- Reference tables
- Forms and mail merge
- Custom style sets and templates
- Excel Level I: Fundamentals
- Learn how to use functions to speed up your workflow
- Add formatting and other visual effects
- Turn data into visual charts, including line, column, and pie charts
- Learn tips and tricks for easy workbook management
- Excel Level II: Intermediate
- Learn to split and join text, add data validation, and named ranges
- Use database functions and logical statements
- Create Pivot Tables to quickly summarize large databases
- Create advanced combo charts from multiple charts
- Excel Level III: Advanced
- Cell management including cell locking, auditing, and hot keys
- Special formatting for calculating dates
- Use advanced functions and advanced analytical toolsÂ
- Record macros and relative reference macros for ad hoc reporting
Taught by
Garfield Stinvil and Dan Rodney
