Demonstrate that you have the skills needed to get the most out Excel, Word and PowerPoint 2019/Office 365 by earning the Microsoft Office Specialist (MOS) certification. Join this preparatory class and prepare for your MOS Certification in under 21 Days.
Advanced Microsoft Word Training
Course Overview
Step your Word processing skills up a notch with our Advanced Microsoft Word Training course, designed to equip you with the tools you need for handling complex documents efficiently. Whether you’re managing lengthy business reports, collaborating with colleagues, or integrating extensive data, this course provides the expertise needed to master Word’s advanced features.
We begin with Working with Long Documents, where you’ll learn the ins and outs of creating and maintaining a Table of Contents, adding cross references, footnotes, and endnotes. This section also guides you through inserting citations and creating a comprehensive bibliography, adding an index, and including a Table of Figures and Authorities. Practical exercises will reinforce your skills, such as inserting and updating a Table of Contents and practicing footnotes.
Next, step into the collaborative space with our Reviewing and Collaborating on Documents lesson. You’ll discover how to add comments and track changes, providing real-time feedback and edits on documents. Exercises focus on viewing, accepting, and rejecting changes, fostering an efficient review process. You’ll also explore sharing options to ensure your documents can be accessed and edited by the right colleagues.
In Comparing and Combining Documents, you’ll master the tools to compare multiple versions of a document and merge changes seamlessly. Practical exercises will guide you through document comparison and combination, ensuring you can consolidate feedback from multiple sources effortlessly.
The Forms lesson covers the Developer Tab and using various content controls like date pickers, plain text, drop-down lists, check boxes, and rich text. You’ll also learn to restrict editing to certain form fields, enabling you to create and protect interactive forms efficiently. Hands-on exercises will solidify these skills with practical applications.
Our Managing Mailings lesson teaches you how to create envelopes and labels, as well as leverage mail merge for personalized bulk communications. Exercises in printing envelopes and using mail merge will provide you with the practical know-how to handle mailings with precision and ease.
In the Protecting Documents section, you’ll learn to enhance the security of your documents by marking them as final, adding passwords, removing metadata, and restricting formatting and editing. You’ll also explore watermarking options, with exercises to practice adding custom watermarks to maintain document integrity.
Finally, unleash the power of automation with our Macros lesson. You’ll understand how to use and record macros to streamline repetitive tasks, with practical exercises guiding you through the macro recording process.
By the end of this course, you and your team will have a robust command of advanced Microsoft Word features, empowering you to handle complex documents with professionalism and ease. These skills will streamline workflows, enhance collaboration, and ensure document security, making your business operations more efficient and effective.
Word Version: This course primarily targets Word 365 and Word 2021; however, we draw attention to features that are not supported in earlier versions of Word, and point out alternative options, when available.
Advanced Microsoft Excel Course
Course Overview
This advanced Excel course is designed for both individuals and teams aiming to upgrade their Excel capabilities, covering diverse topics from dynamic data visualization to complex functions and collaborative tools.
We begin with Using PivotTables, an essential feature for sophisticated data analysis. You will learn how PivotTables work, insert slicers and timeline filters for better data manipulation, group data, and create calculated fields. You will also explore PivotCharts and practice these concepts through hands-on exercises to solidify your understanding of working with PivotTables.
Next, we move on to Advanced Functions, where we break down complex function syntax. You will gain insight into essential functions such as ROWS, COLUMNS, INDEX, and XMATCH, along with learning about array formulas and methods to get unique values. The lesson includes practical exercises on using SORT, FILTER, and SORTBY functions, exploring lookup functions like XLOOKUP, and diving into the versatile LET and TRANSPOSE functions.
In Auditing Workbooks, we cover important techniques for maintaining the integrity of your Excel workbooks. Topics include inspecting a workbook, tracing precedents and dependents, utilizing the Watch Window, and evaluating formulas. You’ll also learn about error checking through practical exercises designed to give you robust auditing skills.
The Data Tools lesson is designed to enhance your data manipulation capabilities. You’ll discover how to import data from online sources, convert text to columns, and efficiently link to external data. This module also covers controlling calculation options, data validation, and consolidating data, along with practical exercises on What-If Analysis and using Goal Seek.
The Working with Others section focuses on collaborative features in Excel. You’ll learn to add comments and notes, protect worksheets and workbooks, and password-protect your files. Additionally, the module covers how to mark a workbook as final and addresses other sharing concerns to ensure smooth teamwork.
In Recording and Using Macros, we introduce you to automating repetitive tasks. You’ll learn to record and run macros, edit previously recorded macros, and add them to the Quick Access Toolbar for enhanced efficiency. This lesson includes hands-on exercises for recording and adding macros, helping you streamline your workflow.
By the end of this course, you will possess a strong command over advanced Excel functionalities, enabling you to analyze data more effectively, automate routine tasks, and collaborate seamlessly with your team. This training will prepare you to handle complex Excel tasks and elevate your organization’s data management prowess.
Excel Version: This course primarily targets Excel 365 and Excel 2021; however, we draw attention to features that are not supported in earlier versions of Excel, and point out alternative options, when available.
Advanced Microsoft PowerPoint
Course Overview
This course teaches advanced Microsoft PowerPoint features, equipping your team with the skills to create impactful and professional presentations. Designed for those who already have a basic understanding of PowerPoint, this course covers advanced features that can help take your presentations to the next level. You’ll gain hands-on experience with themes, slide masters, animations, SmartArt, multimedia, and more, perfect for enhancing your company’s presentations.
We start with Customizing Presentations, where you will learn to apply themes, format backgrounds, and add headers and footers. This section also covers the techniques for adding background images and concludes with practical exercises to personalize your presentation further.
The course continues with Presentation Masters, introducing the use of slide masters for consistent formatting. Topics include working with slide layouts, formatting slide masters, adding watermarks, and inserting slide numbers. You’ll also learn to modify notes and handout masters and perform exercises to master these skills.
In the Working with Special Effects section, you’ll explore advanced animation techniques. This includes animating bullets, using the animation painter, and implementing motion paths. You’ll also learn to animate charts and apply slide transitions, finishing with exercises to practice applying special effects to your presentations.
Moving on to Using SmartArt, you’ll discover how to insert, modify, resize, and reposition SmartArt objects. You’ll learn to insert text into SmartArt, add shapes, and ungroup SmartArt objects, along with exercises to solidify your understanding of SmartArt functionalities.
The Multimedia lesson covers creating and editing photo albums, inserting sounds and videos, and editing media clips. You’ll engage in exercises to add multimedia elements effectively to your presentations, enhancing the overall appeal.
In Setting up the Slide Show, you’ll learn about custom slide shows, creating hyperlinks, and adding action buttons. Topics include using features like Zoom, rehearsing timings, annotating presentations, and an exercise on recording slide shows to help you prepare for delivering presentations seamlessly.
The Outlines and Slides section will guide you through exporting handouts and outlines to Word, saving presentations as outlines, and saving slides as graphics. Practical exercises will help reinforce these skills, making it easy to distribute your presentation content in various formats.
Managing multiple presentations is addressed in the Managing Multiple Presentations lesson. You’ll learn to merge, view, and track changes across presentations, add comments, and engage in exercises to review changes effectively using PowerPoint’s tracking features.
The course concludes with Finalizing Presentations, teaching you to inspect presentations, encrypt them, and embed fonts. You’ll also learn to save presentations in PDF format, compress pictures, and mark presentations as final, ensuring your presentations are polished and secure before sharing.
By the end of this Advanced Microsoft PowerPoint Training, you’ll have developed the skills needed to create sophisticated, dynamic presentations. You’ll be adept at utilizing advanced features and techniques to enhance your presentations, making your training sessions or client meetings more engaging and effective.
PowerPoint Version: This course primarily targets PowerPoint 365 and PowerPoint 2021; however, we draw attention to features that are not supported in earlier versions of PowerPoint, and point out alternative options, when available.
Duration: 42 Hours
Cost: USD 330.00/KES. 39,500.00