Microsoft Master Certification (Self-Paced)

In this beginner Excel workshop, you’ll learn the essentials of Microsoft Excel, including calculations, basic functions, graphs, formatting, and printing. This basic Excel class is perfect for those with limited experience looking to expand their proficiency.

• Become familiar with the interface and data entry
• Learn essential formulas and functions
• Format and print your work
• Create charts, including line, column, and pie charts
• Learn tips and tricks for easy workbook management
• Review key concepts in a final project

• Learn to split and join text, apply data validation, and create named ranges
• Use database functions such as VLOOKUP and HLOOKUP
• Write logical formulas using AND, OR, and IF functions
• Create Pivot Tables to efficiently summarize and analyze large datasets
• Apply statistical functions such as RANK, COUNTIFS, and SUMIFS
• Build advanced combo charts by combining multiple chart types
• Reinforce key concepts through a guided final project

• 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

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

This self-paced course covers core PowerPoint skills to create engaging, professional presentations. Learn how to design slides, work with images, charts, and transitions, and develop visually compelling presentations you can confidently present.

• Create presentations from templates and customize layouts, themes, and content structure
• Edit text, bullets, and numbered lists with Outline View and advanced formatting tools
• Insert and enhance images, SmartArt, and shapes using effects, cropping, and alignment options
• Format tables, add connector lines, and import Excel charts to display data
• Apply transitions, manage presenter notes, and use tools for live or virtual presentations
• Save, print, and export presentations to PDF with professional-use options

• Navigating and organizing documents
• Formatting text and documents
• Managing text and paragraphs
• Inserting and formatting tables
• Creating and managing lists
• Using endnotes, footnotes, and citations
• Inserting and editing images in Word documents

• Efficiently manage and work with multiple documents
• Track changes and collaborate using comments and revision tools
• Apply advanced formatting techniques for polished, professional documents
• Create and manage reference tables, including tables of contents and indexes
• Design forms and utilize mail merge to automate personalized communications
• Develop and apply custom style sets and templates for consistent formatting

This self-paced class focuses on using Outlook effectively for daily tasks and preparing you to become a Microsoft Certified Outlook Specialist. By the end, you'll know how to automate email management, organize your calendar, manage large volumes of email, schedule efficiently, and keep your contacts organized—all aimed at saving you time and increasing productivity.

• Customizing Outlook settings
• Managing messages
• Organizing and managing calendars
• Working with notes, tasks, and journals
• Managing contacts and groups 

• Edit messages and configure global settings
• Customize calendar settings
• Organize and search for messages
• Manage contacts and groups
• Handle mailboxes efficiently
• Manage tasks and activities
• Automate message management
• Share workspaces and collaborate effectively