Microsoft Office Fundamentals Bootcamp

• Get comfortable with the Excel interface and learn multiple ways to enter and organize data in a worksheet.
• Work with rows, columns, and worksheets by inserting, deleting, hiding, grouping, and managing spreadsheet elements.
• Build foundational Excel skills with Autofill, basic calculations, AutoSum, and essential functions such as SUM, AVERAGE, MAX, MIN, and COUNT.
• Use formulas more effectively with absolute references, logical true/false tests, text functions, and multi-input functions.
• Format spreadsheets for clarity with cell formatting and conditional formatting that highlights data based on specific rules.
• Create visual reports with column charts, line charts, pie charts, sparklines, and Excel Tables.
• Manage workbooks more efficiently using Freeze Panes, printing tools, display options, templates, and essential keyboard shortcuts and Excel tips.
• Reinforce key concepts through end-of-class projects designed to review what you learned.

This beginner-friendly PowerPoint course covers the core skills needed to create engaging and professional presentations. From building slides to working with images, charts, and transitions, you'll learn how to design visually compelling presentations and deliver them with confidence.

• Build new presentations from templates and customize layouts, themes, and content structure
• Add and edit text, bullets, and numbered lists using Outline View and other formatting tools
• Insert and enhance photos, SmartArt, and shapes with effects, cropping, and alignment tools
• Create and format tables, add connector lines, and import charts from Excel to display data
• Apply transitions, manage presenter notes, and use presentation tools for live or virtual delivery
• Save, print, and export presentations to PDF, with options tailored for professional use

Learn essential Microsoft Word skills to work faster and more efficiently, with no prior experience required. This hands-on class covers everything from basic formatting to advanced features like mass emails, citations, and time-saving shortcuts.

• Navigate documents efficiently and format text, paragraphs, and page layouts with confidence
• Work with tables and lists to organize and present information clearly
• Add and manage images within Word documents
• Insert endnotes, footnotes, and citations for professional and academic writing
• Save time with productivity shortcuts and formatting fixes for cleaner, more polished documents

This one-day class concentrates on how to use Outlook quickly and effectively for daily work tasks or to become a Microsoft Office Specialist: Outlook Associate. By the end of this class, you will be able to reduce hours of repetitive work by setting up rules and search folders to automate email, manage your calendar and to-do lists, manage huge amounts of email with ease, manage complex scheduling, organize all your contacts and track your correspondence.

• Outlook settings
• Working with messages
• Calendar management
• Notes, tasks, and journals
• Contacts and groups