In this self-paced course, you’ll master intermediate and advanced functions of Microsoft Office programs, including Excel, PowerPoint, Word, and Outlook. This comprehensive training package covers essential skills and time-saving techniques, with a focus on improving productivity and streamlining your workflow. You’ll dive into advanced Excel features like PivotTables, VLOOKUP, and macros, while also learning how to automate tasks and summarize data effectively.
You’ll also enhance your PowerPoint skills by creating reusable templates, importing Excel charts, and designing multimedia-rich presentations. In Word, you’ll learn to automate tasks like mail merge, create custom styles and templates, and write macros to boost efficiency. Finally, you’ll gain advanced Outlook skills, including configuring mail accounts, performing complex searches, managing spam, and optimizing calendar and contact management. By the end, you’ll have the skills to use Microsoft Office more effectively and efficiently in your daily work.
What You Will Learn
- Excel Level II and III: Dive deeper into advanced Excel features, including PivotTables, complex formulas, data analysis techniques, and automation with macros to streamline your workflow.
- PowerPoint Level II: Learn to create dynamic, professional presentations by mastering advanced features such as reusable templates, importing data from Excel, and incorporating multimedia elements.
- Word Level II: Master advanced document formatting, automation techniques like mail merge, and time-saving tools such as macros and custom styles to improve team productivity.
- Outlook Level II: Enhance your email management with advanced features like configuring mail accounts, setting up rules for automation, performing complex searches, and optimizing calendar and contact management.
This program is available for 150 days. You can choose when to start your access period. Once you activate, you will have 150 days to complete it (access the course materials, quizzes, projects and videos). You may request one extension of seven (7) days. Other extension requests will be evaluated on a case-by-case basis. Videos are not downloadable.