Microsoft Access: Part 1
Data is everywhere. Most job roles today involve some form of data management. Virtually everyone is affected in some way by the need to manage data. A relational database application such as Microsoft Access can help you and your organization with this task.
This course is the first part of a three-course series that covers the skills needed to perform database design and development in Access.
Microsoft Access for Office 365 – Part 1 focuses on the design and construction of an Access database —viewing, navigating, searching, and entering data in a database, as well as basic relational database design and creating simple tables, queries, forms, and reports.
Course Code: MS-ACC-P1
Course No: ELK91–144_rev1.1
Course Length: 2 Days
CertiPort Exam No: MO-500
This Course is Available for Virtual Online Training
To ensure your success in this course, you should have end-user skills with any current version of Windows, including being able to start programs, switch between programs, locate saved files, close programs, and use a browser to access websites. It is recommended that you have completed Microsoft Excel for Office 365 – Part 1 or possess equivalent knowledge.
This course is designed for candidates looking to establish a foundational understanding of Microsoft Access for Office 365, including the skills necessary to create a new database, construct data tables, design forms and reports, and create queries.
In this course, you will create and manage an Access database. You will:
- Navigate within the Access application environment, create a simple database, and customize Access configuration options.
- Organize and manage data stored within Access tables.
- Use queries to join, sort, and filter data from different tables.
- Use forms to make it easier to view, access, and input data.
- Create and format custom reports.
Microsoft Access: Part 2
Your training and experience using Microsoft Access has given you basic database management skills, such as creating tables, designing forms and reports, and building queries. In this course, you will expand your knowledge of relational database design; promote quality input from users; improve database efficiency and promote data integrity; and implement advanced features in tables, queries, forms, and reports. Extending your knowledge of Access will result in a robust, functional database for your users.
This course is the second part of a three-course series that covers the skills needed to perform database design and development in Microsoft Access.
Microsoft Access for Office 365 – Part 2 focuses on optimization of an Access database, including optimizing performance and normalizing data, data validation, usability, and advanced queries, forms, and reports.
Course Code: MS-ACC-P2
Course No: ELK91–145_rev1.1
Course Length: 2 Days
CertiPort Exam No: MO-500
This Course is Available for Virtual Online Training
To ensure your success in this course, you should have end-user skills with any current version of Windows, including being able to start programs, switch between programs, locate saved files, close programs, and use a browser to access websites. It is recommended that you have completed Microsoft Access for Office 365 – Part 1 or possess equivalent knowledge.
This course is designed for candidates wishing to gain intermediate-level skills or individuals whose job responsibilities include constructing relational databases and developing tables, queries, forms, and reports in Microsoft Access for Microsoft 365.
In this course, you will optimize an Access database. You will:
- Provide input validation features to promote the entry of quality data into a database.
- Organize a database for efficiency and performance, and to maintain data integrity.
- Improve the usability of Access tables.
- Create advanced queries to join and summarize data.
- Use advanced formatting and controls to improve form presentation.
- Use advanced formatting and calculated fields to improve reports.
Microsoft Access: Part 3
You have covered many of the basic functions of Microsoft Access, and now you are ready to learn advanced Access features such as database management, advanced form design, packaging a database, encrypting a database, preparing a database for multiple-user access, and more. Knowledge of these features separate database professionals from the casual database users or occasional designers.
This course is the third part of a three-course series that covers the skills needed to perform basic database design and development in Microsoft Access.
Microsoft Access for Office 365 – Part 3 focuses on managing the database and supporting complex database designs, including import and export of data, using action queries to manage data, creating complex forms and reports, macros and VBA, and tools and strategies to manage, distribute, and secure a database.
Course Code: MS-ACC-P3
Course No: ELK91–146_rev1.1
Course Length: 2 Days
CertiPort Exam No: MO-500
This Course is Available for Virtual Online Training
To ensure your success in this course, you should have experience working with Access, including a working knowledge of database design and creation, form design and creation, report design and creation, and a working knowledge of database querying and the various table relationships. It is recommended that you have completed Microsoft Access for Office 365 – Part 1 and Microsoft Access for Office 365 – Part 2 or possess equivalent knowledge.
Candidates taking this course are database administrators or prospective database administrators who have experience working with Access for Microsoft 365 and need to learn advanced skills.
In this course, you will manage an Access database and add complex database features to improve its usability, efficiency, performance, and security. You will:
- Share data across applications.
- Use action, unmatched, and duplicate queries to manage data.
- Create complex reports and forms.
- Use macros to improve user interface design.
- Use VBA to extend database capabilities.
- Perform database management tasks such as backup, compacting, repairing, performance analysis, checking object dependencies, and documenting.
- Implement security strategies and distribute a database to multiple users.
Data Analysis and Visualization with Microsoft Excel
Technology and the data that it both collects and makes accessible is now interwoven with businesses and lives. The era of “big data” has exploded due to the rise of cloud computing, which provides an abundance of computational power and storage, enabling organizations of all sorts to capture and store data. Leveraging that data effectively can provide timely insights and competitive advantage.
Analysing data to find issues, insights, and opportunities is now a critical part of many job roles. Beyond the analysis, data analysts in all job roles must be able to effectively present and communicate their findings in visually compelling ways.
Microsoft Excel is designed for this purpose. Excel can connect to a wide range of data sources, perform robust data analysis, and create diverse and robust data-driven visualizations to show insights and trends, as well as create reports. These capabilities enable people who use Excel for data analysis to turn data into thoughtful action.
Course Code: MS-DAV
Course No: ELK91–157_rev1.1
Course Length: 3 Days
CertiPort Exam No: MO-500
This Course is Available for Virtual Online Training
To ensure success, you should have baseline skill using Excel worksheets, particularly in creating workbooks with formulas and functions. You can obtain this level of knowledge and skill by taking the following or any equivalent Logical Operations course:
- Microsoft Excel for Office 365™ (Desktop or Online): Part 1
This course is designed for students who already have foundational knowledge and skills in Excel and who wish to perform robust and advanced data and statistical analysis with Excel using PivotTables, use tools such as Power Pivot and the Analysis ToolPak to analyse data, and visualize data and insights using advanced visualizations in charts and dashboards in Excel.
In this course, you will analyse and visualize data using Excel and associated tools.
You will:
- Perform data analysis fundamentals.
- Visualize data with Excel.
- Analyse data with formulas and functions.
- Analyse data with PivotTables.
- Present visual insights with dashboards in Excel.
- Create geospatial visualizations with Excel.
- Perform statistical analysis.
- Get and transform data.
- Model and analyse data with Power Pivot.
- Present insights with reports.
Microsoft Excel: Introduction
Organizations the world over rely on information to make sound decisions regarding all manner of affairs. But with the amount of available data growing on a daily basis, the ability to make sense of all of that data is becoming more and more challenging. Fortunately, this is where the power of Microsoft Office Excel 2016 can help. Excel can help you organize, calculate, analyse, revise, update, and present your data in ways that will help the decision makers in your organization steer you in the right direction. It will also make these tasks much easier for you to accomplish, and in much less time, than if you used traditional pen-and-paper methods or non-specialized software.
Course Code: MS-EXC16-INT
Course No: OTF-EXC-INT_rev1.0
Course Length: 1 Day
CertiPort Exam No: 77-727 & 77-728
This Course is Available for Virtual Online Training
Read and write. The attendee should have a basic knowledge about Windows, e.g. to open, save and close files. The attendees must be able to work with a mouse/laptop touchpad.
This course is aimed at first time users of Microsoft Excel and serves as a foundation for Part 1 and 2.
After completing this course participants will have a Basic understanding of the Excel environment and be able to produce a basic Excel work sheet.
Microsoft Excel: Part 1
Organizations the world over rely on information to make sound decisions regarding all manner of affairs. But with the amount of available data growing daily, the ability to make sense of all of that data is becoming more and more challenging. Fortunately, this is where the power of Microsoft Excel can help.
Excel can help you organize, calculate, analyse, revise, update, and present your data in ways that will help the decision makers in your organization steer you in the right direction. It will also make these tasks much easier for you to accomplish, and in much less time, than if you used traditional pen-and-paper methods or non-specialized software. This course aims to provide you with a foundation for Excel knowledge and skills, which you can build upon to eventually become an expert in data manipulation.
NOTE: Most Office 365 users perform most of their daily tasks using the desktop version of the Office software, so that is the focus of this training. The course material will also enable you to access and effectively utilize many web-based resources provided with your Office 365 subscription. This includes brief coverage of key skills for using Excel Online and OneDrive. Helpful notes throughout the material alert you to cases where the online version of the application may function differently from the primary, desktop version.
Course Code: MS-EXC-P1
Course No: ELK91–136_rev1.1
Course Length: 2 Days
CertiPort Exam No: MO-200; MO-201
This Course is Available for Virtual Online Training
To ensure your success in this course, you should have end-user skills with any current version of Windows, including being able to start programs, switch between programs, locate saved files, close programs, and use a browser to access websites.
This course is intended for candidates who wish to gain the foundational understanding of Microsoft Excel for Office 365 that is necessary to create and work with electronic spreadsheets.
You will:
- Familiarize yourself with Excel’s layout, its various parts, its commands, and its terminology.
- Outline Excel’s abilities to calculate data quickly, efficiently, and accurately.
- Update worksheets without throwing away all the valuable work you’ve already done.
- Format a worksheet and organize your data.
- Print workbooks.
- Manage the overall structure of your workbooks.
Microsoft Excel: Part 2
Whether you need to crunch numbers for sales, inventory, information technology, human resources, or other organizational purposes and departments, the ability to get the right information to the right people at the right time can create a powerful competitive advantage. After all, the world runs on data more than ever before and that is a trend not likely to change, or even slow down, any time soon. But with so much data available and being created on a nearly constant basis, the ability to make sense of that data becomes more critical and challenging with every passing day. You already know how to get Microsoft Excel to perform simple calculations and how to modify your workbooks and worksheets to make them easier to read, interpret, and present to others. But Excel can do so much more. To gain a truly competitive edge, you need to be able to extract actionable organizational intelligence from your raw data. In other words, when you have questions about your data, you need to know how to get Excel to provide the answers for you. And that is exactly what this course aims to help you do.
This course builds upon the foundational knowledge presented in the Microsoft Excel for Office 365: Part 1 course and will help start you down the road to creating advanced workbooks and worksheets that can help deepen your understanding of organizational intelligence. The ability to analyse massive amounts of data, extract actionable information from it, and present that information to decision makers is at the foundation of a successful organization that can compete at a high level.
NOTE: Most Office 365 users perform most of their daily tasks using the desktop version of the Office software, so that is the focus of this training. The course material will also enable you to access and effectively utilize many web-based resources provided with your Office 365 subscription. This includes brief coverage of key skills for using Excel Online and OneDrive. Helpful notes throughout the material alert you to cases where the online version of the application may function differently from the primary, desktop version.
Course Code: MS-EXC-P2
Course No: ELK91–137_rev1.1
Course Length: 2 Days
CertiPort Exam No: MO-200; MO-201
This Course is Available for Virtual Online Training
To ensure your success in this course, you should have end-user skills with any current version of Windows, including being able to start programs, switch between programs, locate saved files, close programs, and use a browser to access websites. It is recommended that you have completed Microsoft Excel for Office 365 – Part 1 or possess equivalent knowledge.
This course is designed for candidates who already have foundational knowledge and skills in Excel and who wish to begin taking advantage of some of the higher-level functionality in Excel to analyse and present data.
Upon successful completion of this course, you will be able to leverage the power of data analysis and presentation in order to make informed, intelligent organizational decisions. You will:
- Work with functions.
- Work with lists.
- Analyse data.
- Visualize data with charts.
- Use PivotTables and PivotCharts.
Microsoft Excel: Part 3
Clearly, you use Microsoft Excel a lot in your role. Otherwise, you wouldn’t be taking this course. By now, you’re already familiar with Excel, its functions and formulas, a lot of its features and functionality, and its powerful data analysis tools. You are likely called upon to analyse and report on data frequently, work in collaboration with others to deliver actionable organizational intelligence and keep and maintain workbooks for all manner of purposes. At this level of use and collaboration, you have also likely encountered your fair share of issues and challenges. You’re too busy, though, to waste time scouring over workbooks to resolve issues or to perform repetitive, monotonous tasks. You need to know how to get Excel to do more for you so you can focus on what’s important: staying ahead of the competition. That’s exactly what this course aims to help you do.
This course builds upon the foundational and intermediate knowledge presented in the Microsoft Excel for Office 365: Part 1 and Microsoft Excel for Office 365: Part 2 courses to help you get the most of your Excel experience. The ability to collaborate with colleagues, automate complex or repetitive tasks, and use conditional logic to construct and apply elaborate formulas and functions will put the full power of Excel right at your fingertips. The more you learn about how to get Excel to do the hard work for you, the more you’ll be able to focus on getting the answers you need from the vast amounts of data your organization generates.
NOTE: Most Office 365 users perform most of their daily tasks using the desktop version of the Office software, so that is the focus of this training. The course material will also enable you to access and effectively utilize many web-based resources provided with your Office 365 subscription. This includes brief coverage of key skills for using Excel Online and OneDrive. Helpful notes throughout the material alert you to cases where the online version of the application may function differently from the primary, desktop version.
Course Code: MS-EXC-P3
Course No: ELK91–138_rev1.2
Course Length: 2 Days
CertiPort Exam No: MO-200; MO-201
This Course is Available for Virtual Online Training
To ensure success, candidates should have practical, real-world experience creating and analysing datasets using Excel. Specific tasks candidates should be able to perform include creating formulas and using Excel functions; creating, sorting, and filtering datasets and tables; presenting data by using basic charts; creating and working with PivotTables, slicers, and PivotCharts; and customizing the Excel environment. It is recommended that you have completed Microsoft Excel for Office 365 – Part 1 and Microsoft Excel for Office 365 – Part 2 or possess equivalent knowledge.
This course is intended for candidates who are experienced Excel users and have a desire or need to advance their skills in working with some of the more advanced Excel features. Candidates will likely need to troubleshoot large, complex workbooks, automate repetitive tasks, engage in collaborative partnerships involving workbook data, construct complex Excel functions, and use those functions to perform rigorous analysis of extensive, complex datasets.
Upon successful completion of this course, you will be able to perform advanced data analysis, collaborate on workbooks with other users, and automate workbook functionality. You will:
- Work with multiple worksheets and workbooks.
- Share and protect workbooks.
- Automate workbook functionality.
- Use LookUp functions and formula auditing.
- Forecast data.
- Create sparklines and map data.
Microsoft Office Program
This course covers overall topics of Microsoft Excel, Word, PowerPoint, Outlook and typing. It is a combination of the different parts courses of each application, and touches on subjects that are basic, as well as a bit more complicated concepts.
Course Code: MS-MOP
Course No: OTF-MOP_v1.2
Course Length: 5 Days
CertiPort Exam No: N/A
This Course is Available for Virtual Online Training
The student should have basic computer skills, e.g., working with the Windows interface, reading, and writing. It is ideal that the student has worked on the Microsoft applications before.
This course is for students who want an overall understanding of Microsoft Excel, Word, PowerPoint, Outlook and typing.
Microsoft Onenote
In our fast-paced digital world, the need to capture ideas, meeting notes, and to-do items is ever present. Microsoft’s OneNote app provides a way for you to efficiently create and collect your notes in an electronic notebook. This course will help you use OneNote notebooks to store a wide variety of content in an organized structure, access the content from anywhere, and share it with others. Additionally, learning how OneNote and other applications in the Microsoft 365 suite are integrated will increase your productivity.
Course Code: MS-1NOT
Course No: ELK91-174_rev1.0
Course Length: 1 Day
This Course is Available for Virtual Online Training
To ensure your success in this course, you should have end-user skills with any current version of Windows, including being able to start programs, switch between programs, locate saved files, close programs, and use a browser to access websites. Previous experience with OneNote is not required; however, having a basic understanding of the Microsoft 365 productivity suite would be beneficial.
This course is intended for people in a variety of roles and fields who have a basic understanding of Microsoft 365 and want to incorporate digital note taking and note collaboration by using Microsoft OneNote.
In this course, you will develop note-taking skills by creating, modifying, and managing OneNote notebooks that work with other Microsoft 365 applications. You will:
- Navigate and customize the OneNote environment and create your first notebook.
- Add and format various types of notes and note elements, including text, links, and drawing objects.
- Add images, video, audio, Excel spreadsheets, and other types of files to a notebook.
- Organize, categorize, and search notebook content.
- Finalize notebook content by checking spelling, printing copies, and password-protecting notebooks.
- Manage notebooks by exporting content and working with history and backups.
- Share notebooks using Outlook and collaborate with colleagues using OneDrive.
Microsoft Outlook: Part 1
Email has become one of the most widely used methods of communication, whether for personal or business communications. In most organizations, large or small, email is the preferred form of communicating information among employees. As email grows in popularity and use, most organizations have found the need to implement a corporate mail management system such as Microsoft Outlook to handle the messages and meeting invitations sent among employees.
In this course, you will use Outlook to send, receive, and manage email messages; manage your contact information; schedule appointments and meetings; create tasks and notes for yourself; and customize the Outlook interface to suit your working style.
This course is the first in a series of two Microsoft Outlook for Office 365 courses. It will provide you with the basic skills you need to start using Outlook to manage your email communications, contact information, calendar events, tasks, and notes.
NOTE: Most Office 365 users perform most of their daily tasks using the desktop version of the Office software, so that is the focus of this training. The course material will also enable you to access and effectively utilize many web-based resources provided with your Office 365 subscription. This includes brief coverage of key skills for using Excel Online and OneDrive. Helpful notes throughout the material alert you to cases where the online version of the application may function differently from the primary, desktop version.
Course Code: MS-OUT-P1
Course No: ELK91–139_rev1.1
Course Length: 2 Days
CertiPort Exam No: MO-400
This Course is Available for Virtual Online Training
To ensure your success in this course, you should have end-user skills with any current version of Windows, including being able to start programs, switch between programs, locate saved files, close programs, and use a browser to access websites.
This course is intended for those with a basic understanding of Microsoft Windows and who need to know how to use Outlook as an email client to manage their email communications, calendar events, contact information, and other communication tasks.
In this course, you will use Outlook to compose and handle your email communications and manage your calendar, contacts, and tasks. You will:
- Navigate Outlook to read and respond to email.
- Use the Address Book and format and spell check new messages.
- Attach files to and insert illustrations in messages.
- Customize read and response options.
- Use flags, categories, and folders to organize messages.
- Create and work with contacts.
- Create appointments and schedule meetings in the calendar.
- Create and work with tasks and other apps.
Microsoft Outlook: Part 2
Every day, millions of email messages are exchanged among people within and between organizations. Email has a ubiquitous presence in the lives of many, and it’s likely that email technologies will continue to evolve with the changing needs of workplaces. After all, email communication has not been replaced, or its growth slowed, as many predicted with the rise of social media and the widespread adoption of mobile technologies. Many organizations have implemented mail management systems that combine the back-end power of Microsoft Exchange Server and the front-end intuitive user interface of Microsoft Outlook.
In this course, you will customize command sets, configure mail accounts, set global options, perform advanced searches, apply filters to intercept mail and control spam, create rules to automate mail management tasks, work with calendars and contacts, manage tasks, preserve data with archives and data files, as well as share and delegate access to your Outlook items. In short, you’ll work with a wide range of features and options and, in so doing, understand why Outlook is a leading personal management system.
This course builds upon the foundational knowledge presented in the Microsoft Outlook for Office 365 – Part 1 course and will help you customize a communication system well-suited to your work style.
NOTE: Most Office 365 users perform most of their daily tasks using the desktop version of the Office software, so that is the focus of this training. The course material will also enable you to access and effectively utilize many web-based resources provided with your Office 365 subscription. This includes brief coverage of key skills for using Excel Online and OneDrive. Helpful notes throughout the material alert you to cases where the online version of the application may function differently from the primary, desktop version.
Course Code: MS-OUT-P2
Course No: ELK91–140_rev1.1
Course Length: 2 Days
CertiPort Exam No: MO-400
This Course is Available for Virtual Online Training
To ensure your success in this course, you should have end-user skills with any current version of Windows, including being able to start programs, switch between programs, locate saved files, close programs, and use a browser to access websites. It is recommended that you have completed Microsoft Outlook for Office 365 – Part 1 or possess equivalent knowledge.
This course is intended for those with a basic understanding of Microsoft Windows and who need to know how to use Outlook as an email client to manage their email communications, calendar events, contact information, and other communication tasks.
In this course, you will use Outlook’s advanced features to customize and manage your email communications, including using advanced features to organize emails; managing calendar settings and options; managing contact information; scheduling tasks; and managing Outlook archives and data file settings. You will:
- Insert objects in messages and modify properties and global options.
- Organize, search, and manage messages.
- Protect your mailbox and manage its size.
- Use rules and Quick Steps to automate message management.
- Work with advanced calendar settings.
- Import and forward contacts.
- Assign delegate permissions and share Outlook items with others.
- Archive and back up Outlook items using data files.
Microsoft PowerPoint: Part 1
How do you grab and maintain an audience’s focus when you’re asked to present important information? By being clear, organized, and engaging. And that is exactly what Microsoft PowerPoint can help you do.
Today’s audiences are tech savvy, accustomed to high-impact multimedia content, and stretched for time. By learning how to use the vast array of features and functionality contained within PowerPoint, you will gain the ability to organize your content, enhance it with high-impact visuals, and deliver it with a punch. In this course, you will use PowerPoint to begin creating engaging, dynamic multimedia presentations.
NOTE: Most Office 365 users perform most of their daily tasks using the desktop version of the Office software, so that is the focus of this training. The course material will also enable you to access and effectively utilize many web-based resources provided with your Office 365 subscription. This includes brief coverage of key skills for using Excel Online and OneDrive. Helpful notes throughout the material alert you to cases where the online version of the application may function differently from the primary, desktop version.
Course Code: MS-PWP-P1
Course No: ELK91–147_rev1.1
Course Length: 2 Days
CertiPort Exam No: MO-300
This Course is Available for Virtual Online Training
To ensure your success in this course, you should have end-user skills with any current version of Windows, including being able to start programs, switch between programs, locate saved files, close programs, and use a browser to access websites.
This course is intended for those with a basic understanding of Microsoft Windows and who wish to gain a foundational understanding of PowerPoint that is necessary to create and develop engaging multimedia presentations.
In this course, you will create and deliver an engaging PowerPoint presentation. You will:
- Identify the basic features and functions of PowerPoint.
- Develop a PowerPoint presentation.
- Perform text formatting.
- Add and arrange graphical elements.
- Modify graphical elements.
- Prepare to deliver your presentation.
Microsoft PowerPoint: Part 2
Meetings, instruction, training, pitches; these are all a part of our daily lives. We are often called upon to deliver presentations with little notice, at multiple venues, and with varying requirements. And some of these presentations include sensitive information that needs to be guarded. Given all the variables, it may seem an overwhelming task to deliver your content, on time, to all audiences, and to only those who need to see it. Oh, and by the way, you need to make it interesting, informative, and memorable. So, how do you do it? Without the help of a robust set of tools, it would be nearly impossible. But Microsoft PowerPoint provides you with a variety of such tools that can help you deliver content in nearly any situation, while saving time and effort. By taking advantage of these tools, you will be creating presentations that not only stand out from the crowd, but also don’t consume all your available time.
NOTE: Most Office 365 users perform most of their daily tasks using the desktop version of the Office software, so that is the focus of this training. The course material will also enable you to access and effectively utilize many web-based resources provided with your Office 365 subscription. This includes brief coverage of key skills for using Excel Online and OneDrive. Helpful notes throughout the material alert you to cases where the online version of the application may function differently from the primary, desktop version.
Course Code: MS-PWP-P2
Course No: ELK91–148_rev1.1
Course Length: 2 Days
CertiPort Exam No: MO-300
This Course is Available for Virtual Online Training
To ensure your success in this course, you should have end-user skills with any current version of Windows, including being able to start programs, switch between programs, locate saved files, close programs, and use a browser to access websites. It is recommended that you have completed Microsoft PowerPoint for Office 365 – Part 1 or possess equivalent knowledge.
This course is intended for those with a basic understanding of Microsoft Windows and who wish to take advantage of the application’s higher-level usability, security, collaboration, and distribution functionality.
In this course, you will use the advanced tools and features in PowerPoint to create and deliver engaging presentations. You will:
- Customize design templates.
- Add tables.
- Add charts.
- Work with media.
- Build advanced transitions and animations.
- Collaborate on a presentation.
- Customize the delivery of a presentation.
- Modify presentation navigation.
- Secure and distribute a presentation.
Microsoft Project: Part 1
Welcome to Microsoft Project 2019/2021/365 – Part 1. This course is designed to familiarize you with the basic features and functions of Microsoft Project so you can use it effectively and efficiently in a real-world environment.
This course covers the critical knowledge and skills a project manager needs to create a project plan with Project during the planning phase of a project. In other words, if your supervisor assigns you to lead a project, this course will enable you to draft a project plan with Project and share it with your supervisor (and others) for review and approval.
Note: This course is for anyone who has Project on the desktop, regardless of whether they purchased an “on-premises” edition or subscribed to a “cloud-based” (online) edition. Most project managers and project team members use the desktop application, so that is the main focus of this course. The main features of the online app are presented in an appendix.
This material will benefit users of any current version of Microsoft Office, and of the Microsoft Project desktop software. The classroom environment setup uses the Project 2019 desktop software.
Course Code: MS-PRJ-P1
Course No: ELK91-098_rev1.2
Course Length: 2 Days
CertiPort Exam No: N/A
This Course is Available for Virtual Online Training
To ensure your success in this course, you should have end-user skills with any current version of Windows, including being able to start programs, switch between programs, locate saved files, close programs, and use a browser to access websites. While you do not need to be an expert, some experience and competency with Microsoft Office applications, particularly Word and Excel, will be useful. Finally, having a foundational knowledge of project management concepts will help prepare you for working with Microsoft Project.
This course is designed for a person with an understanding of project management concepts, as well as general desktop computer skills, and who will be responsible for creating and maintaining project plans. This course will give you the fundamental understanding of Microsoft Project necessary to construct basic project plans.
In this course, you will be able to construct basic project plans using Microsoft Project. You will:
- Identify project management concepts and navigate Microsoft Project Professional.
- Create a new project plan.
- Add tasks to a project.
- Manage task relationships within a project.
- Manage project resources.
- Finalize a project plan.
Microsoft Project: Part 2
Welcome to Microsoft Project 2019/2021/365 – Part 1. This course is designed to familiarize you with the basic features and functions of Microsoft Project so you can use it effectively and efficiently in a real-world environment.
In Microsoft Project 2019/2021/365 – Part 1, you learned the basic features of Microsoft Project during the planning phase of a project. This course covers the advanced knowledge and skills a project manager needs to update a project plan in Project during the execution, monitoring, and controlling phases of a project. In other words, once your project plan is approved by the project sponsor, this course will enable you to manage the project so that it is completed on time, within budget, and according to scope.
Note: This course is for anyone who has Project on the desktop, regardless of whether they purchased an “on-premises” edition or subscribed to a “cloud-based” (online) edition. Most project managers and project team members use the desktop application, so that is the main focus of this course. The main features of the online app are presented in an appendix.
This material will benefit users of any current version of Microsoft Office, and of the Microsoft Project desktop software. The classroom environment setup uses the Project 2019 desktop software.
Course Code: MS-PRJ-P2
Course No: ELK91-099_rev1.2
Course Length: 2 Days
CertiPort Exam No: N/A
This Course is Available for Virtual Online Training
To ensure your success in this course, you should have basic project management knowledge and skills. Additionally, you should be able to create a new project plan, manage time in a project plan, manage tasks in a project plan, manage resources in a project plan, and share a project plan using Microsoft Project. It is recommended that you have completed Microsoft Project 2019/2021/365 – Part 1 or possess equivalent knowledge.
You should also have end-user skills with any current version of Windows, including being able to start programs, switch between programs, locate saved files, close programs, and use a browser to access websites. While you do not need to be an expert, some experience and competency with Microsoft Office applications, particularly Word and Excel, will be useful.
This course is designed for a person with an understanding of project management concepts and who is responsible for creating and maintaining project plans. Target students will be looking to acquire the advanced knowledge and skills needed to update a project plan in Microsoft Project during the execution, monitoring, and controlling phases of a project.
In this course, you will maintain project plans during the execution, monitoring, and controlling phases of a project. You will:
- Update a project plan.
- Generate project views to manage a project.
- Create project reports to share a project’s status.
- Reuse project plan information.
- Work with multiple projects.
Microsoft Publisher
Microsoft Publisher for Office 365 is a desktop publishing software application capable of producing greeting cards, certificates, newsletters, and other printed publications. Publisher includes a large collection of templates that provide a great way to start a new publication. Publisher offers a large selection of “building blocks” that can be dragged into your documents, helping you to create page elements such as calendars, newsletter sidebars, and borders. Publisher integrates online sharing and mail merge features, which are handy when you need to send publications to a list of customers, and it’s possible to export publications as HTML web pages or PDF documents. With a user-friendly interface, Publisher makes it easy to create and edit publications.
This course presents information and skills that are appropriate for users of the Office 2019 or Office 365 desktop applications. However, the instructional environment for the delivery of this course utilizes Office 365.
Course Code: MS-PUB365
Course No: ELK91–152_rev1.1
Course Length: 1 Day
This Course is Available for Virtual Online Training
To ensure your success in this course, you should have end-user skills with any current version of Windows, including being able to start programs, switch between programs, locate saved files, close programs, and use a browser to access websites.
This course is intended for persons in a variety of job roles such as publishing specialists, layout specialists, graphic designers, or any other knowledge workers who need to use Microsoft Office Publisher to create, lay out, edit, and share publications.
In this course, you will create, format, edit, and share publications. You will:
- Perform basic tasks in the Microsoft Publisher interface.
- Add content to a publication.
- Format text and paragraphs in a publication.
- Manage text in a publication.
- Work with graphics in a publication.
- Prepare a publication for printing and sharing.
Microsoft Visio: Part 1
From the earliest eras of human existence, visual images have been used to represent knowledge, data, and information. Beginning with the Palaeolithic cave paintings and continuing to today’s most complex computer networks, these images leverage the ability of the human brain to rapidly perceive patterns and trends from visual representations.
In today’s workplace, visual diagrams are an essential part of communication, from road maps to sales flows to process charts. Microsoft Visio provides you with an intuitive, customizable tool to easily create a professional-looking visual product by using its extensive gallery of shapes. By following the exercises in this course, you will create visually engaging diagrams, maps, and drawings, using graphical elements to make information easier to comprehend.
Course Code: MS-VIS-P1
Course No: ELK91-153_rev1.1
Course Length: 2 Days
This Course is Available for Virtual Online Training
To ensure your success in this course, you should have end-user skills with any current version of Windows, including being able to start programs, switch between programs, locate saved files, close programs, and use a browser to access websites.
It is recommended that you have completed Microsoft Excel for O365 – Part 1, Microsoft Access for O365 – Part 1 and Microsoft Project for 2019, 2021 & O365 – Part 1 or possess equivalent knowledge.
This course is designed for persons who are new to Visio and who will be using Visio to create basic workflows and perform end-to-end flowcharting.
In this course, you will design, modify, and manage basic diagrams. You will:
- Identify the basic elements of Visio and their use.
- Create a workflow diagram.
- Build organization charts.
- Design a floor plan.
- Build a cross-functional flowchart.
- Design a network diagram.
- Style a diagram.
Microsoft Visio: Part 2
Microsoft Visio stands out among similar applications because of its unique ability to draw a wide variety of diagrams, flowcharts, workflows, and organization structures—anything that can be represented by shapes connected by lines. Most importantly, these shapes can be rearranged and with corresponding lines remaining intact. Visio has improved over the years as features common among Microsoft Office applications have been added. Today, Visio is well integrated with other members of the Office family as well as Microsoft’s cloud-based services. This greatly enriches the sharing and publishing of Visio drawings.
In Microsoft Visio 2019/2021 – Part 1, you learned the basic skills needed to create and modify various Visio drawings. In this course, you will learn about more advanced features—making you a more efficient and effective Visio user.
Course Code: MS-VIS-P2
Course No: ELK91-072_rev0.95
Course Length: 2 Days
CertiPort Exam No’s: N/A
This Course is Available for Virtual Online Training
To ensure your success in this course, you should have the ability to create basic workflows and other common diagram types in Visio. It is recommended that you have completed Microsoft Visio 2019 & 2021– Part 1 or possess equivalent knowledge.
You should also have end-user skills with any current version of Windows, including being able to start programs, switch between programs, locate saved files, close programs, and use a browser to access websites.
It is also recommended that you have completed Microsoft Excel for O365 – Part 1, Microsoft Access for O365 – Part 1 and Microsoft Project for 2019, 2021 & O365 – Part 1 or possess equivalent knowledge.
The target student for this course is a graphic designer, subject matter specialist, or other knowledge worker with basic Microsoft Visio skills (such as creating basic workflows and other diagrams) who needs to use Visio to create complex graphics and illustrations (such as floor plans, custom maps, and scientific illustrations) that may be linked to external data sources and may be inserted into other Microsoft Office files.
In this course, you will examine advanced features to make you more efficient and effective. You will:
Design advanced plans and diagrams.
- Enhance the look of drawings.
- Create shapes, stencils, and templates.
- Connect drawings to external data.
- Leverage development tools.
- Share drawings.
Microsoft Word: Intro
Microsoft Word is a program designed for tasks such as writing letters, updating CV’s, creating newsletters, and editing other text-based documents. It is used to enter, edit, format, save, retrieve, and print documents. Microsoft Word is a powerful word processing program used, especially in everyday computer purposes. With all these advantages in learning and understanding more about Word, also comes the skills in using Word to its fullest potential. Basic tools will be learned in this course, introducing you to a world of using text in a formal, yet easy and manageable manner. Microsoft Word Introduction is the first course in a 4-part-series, introducing you to a program used mostly in everyday life.
Course Code: MS-WRD16-INT
Course No: OTF-WRD-INT_rev1.1
Course Length: 1 Day
CertiPort Exam No: 77-725
This Course is Available for Virtual Online Training
Read and write. Students should also be comfortable working in the Windows 10 environment and be able to use Windows 10 including to open, save and close files. The attendees must be able to work with a mouse/laptop touchpad.
This practical hands-on course is ideal for students who can read, write, use the computer keyboard and they must be able to open and save a document.
After completing this course students will have a Basic understanding of the Word environment.
Microsoft Word: Part 1
These days, most people take electronic word processing for granted. While we may still write out our grocery lists with pen and paper, we expect to use a computer to create most of our documents. It’s impossible to avoid word-processing software in many areas of the business world. Managers, lawyers, clerks, reporters, and editors rely on this software to do their jobs. Whether you are an executive secretary or a website designer, you’ll need to know the ins and outs of electronic word processing.
Microsoft Word is designed to help you move smoothly through the task of creating professional-looking documents. Its rich features and powerful tools can make your work easy, and even fun. In this course, you’ll learn how to use Word on the desktop to create and edit simple documents; format documents; add tables and lists; add design elements and layout options; and proof documents.
NOTE: Most Office 365 users perform most of their daily tasks using the desktop version of the Office software, so that is the focus of this training. The course material will also enable you to access and effectively utilize many web-based resources provided with your Office 365 subscription. This includes brief coverage of key skills for using Excel Online and OneDrive. Helpful notes throughout the material alert you to cases where the online version of the application may function differently from the primary, desktop version.
Course Code: MS-WRD-P1
Course No: ELK91–141_rev1.1
Course Length: 2 Days
CertiPort Exam No: MO-100; MO-101
This Course is Available for Virtual Online Training
To ensure your success in this course, you should have end-user skills with any current version of Windows, including being able to start programs, switch between programs, locate saved files, close programs, and use a browser to access websites.
This course is intended for those with a basic understanding of Microsoft Windows and who need to learn basic Word skills, such as creating, editing, and formatting documents; inserting simple tables and creating lists; and employing a variety of techniques for improving the appearance and accuracy of document content.
In this course, you will learn fundamental Word skills. You will:
- Navigate and perform common tasks in Word, such as opening, viewing, editing, saving, and printing documents, and configuring the application.
- Format text and paragraphs.
- Perform repetitive operations efficiently using tools such as Find and Replace, Format Painter, and Styles.
- Enhance lists by sorting, renumbering, and customizing list styles.
- Create and format tables.
- Insert graphic objects into a document, including symbols, special characters, illustrations, pictures, and clip art.
- Format the overall appearance of a page through page borders and colours, watermarks, headers and footers, and page layout.
- Use Word features to help identify and correct problems with spelling, grammar, readability, and accessibility.
Microsoft Word: Part 2
After you master the basics of using Microsoft Word for Office 365 such as creating, editing, and saving documents; navigating through a document; and printing, you’re ready to move on to tackling the more advanced features. These features enable you to create complex and professional documents with a consistent look and feel. They also enable you to automate tedious tasks such as preparing a letter to send to every customer of your organization.
Creating professional-looking documents can help you give your organization a competitive edge. Implementing time-saving features such as document templates and automated mailings helps your organization reduce expenses. Mastering these techniques will make you a valued employee in your organization.
NOTE: Most Office 365 users perform most of their daily tasks using the desktop version of the Office software, so that is the focus of this training. The course material will also enable you to access and effectively utilize many web-based resources provided with your Office 365 subscription. This includes brief coverage of key skills for using Excel Online and OneDrive. Helpful notes throughout the material alert you to cases where the online version of the application may function differently from the primary, desktop version.
Course Code: MS-WRD-P2
Course No: ELK91–142_rev1.1
Course Length: 2 Days
CertiPort Exam No: MO-100; MO-101
This Course is Available for Virtual Online Training
To ensure your success, you should have end-user skills with any current version of Windows, including being able to start and close applications, navigate basic file structures, manage files and folders, and access websites using a web browser. In addition, you should be able to navigate and perform common tasks in Word, such as opening, viewing, editing, and saving documents; formatting text and paragraphs; formatting the overall appearance of a page; and creating lists and tables.
It is recommended that you have completed Microsoft Word for Office 365 – Part 1 or possess equivalent knowledge.
This course is designed for candidates who wish to use Microsoft Word to create and modify complex documents and use tools that allow them to customize those documents.
In this course, you will learn fundamental Word skills. You will:
- Organize content using tables and charts.
- Customize formats using styles and themes.
- Insert content using Quick Parts.
- Use templates to automate document formatting.
- Control the flow of a document.
- Simplify and manage long documents.
- Use mail merge to create letters, envelopes, and labels.
Microsoft Word: Part 3
Microsoft Word for Office 365 enables you to do far more than simple word processing. Word includes advanced image manipulation tools, collaboration features, cross-referencing and linking tools, entry forms and data collection, security features, and tools to automate document production.
Being able to manipulate graphics and efficiently create, manage, revise, and distribute long documents and forms can help your organization create important and interesting documents. Implementing time-saving features that enable you to work well in a collaborative mode will benefit both you and your organization. Constructing document elements that ensure your readers have access to pertinent information at the click of a button, while at the same time protecting sensitive information, is another important skill. Mastering these skills and techniques will make you a valued employee in your organization.
NOTE: Most Office 365 users perform most of their daily tasks using the desktop version of the Office software, so that is the focus of this training. The course material will also enable you to access and effectively utilize many web-based resources provided with your Office 365 subscription. This includes brief coverage of key skills for using Excel Online and OneDrive. Helpful notes throughout the material alert you to cases where the online version of the application may function differently from the primary, desktop version.
Course Code: MS-WRD-P3
Course No: ELK91–143_rev1.1
Course Length: 2 Days
CertiPort Exam No: MO-100; MO-101
This Course is Available for Virtual Online Training
To ensure your success in this course, you should have end-user skills with any current version of Windows, including being able to start programs, switch between programs, locate saved files, close programs, and use a browser to access websites. In addition, you should be able to navigate and perform common tasks in Word, such as opening, viewing, editing, and saving documents; formatting text and paragraphs; formatting the overall appearance of a page; and creating lists and tables.
It is recommended that you have completed Microsoft Word for Office 365 – Part 1 and Microsoft Word for Office 365 – Part 2 or possess equivalent knowledge.
This course is intended for candidates who want to use more advanced functionalities in Microsoft Word, including image manipulation, collaboration, and revision tracking, cross-referencing, and linking, document security, forms, and process automation through macros.
In this course, you will explore advanced functionalities in Word. You will:
- Use images in a document.
- Create custom graphic elements.
- Collaborate on documents.
- Add reference marks and notes.
- Secure a document.
- Create and manipulate forms.
- Create macros to automate tasks.
INTRO TO COMPUTERS & MICROSOFT OFFICE
What is a computer? How does it work? How can Microsoft Word and Microsoft Excel help me? In this fast-growing world of computers and applications, it is easy to sometimes get behind on some of the foundation principles of technology. With this course, the basics of computers are handled: what is a computer, how does a computer work, the difference between hardware and software; windows essentials such as navigation, files and folders, WhatsApp for PC, and typing; and introduction to Microsoft Word and
Microsoft Excel.
Course Code: MS-INT-COM
Course No: OTF-OFF-BAS_rev3.0
Course Length: 3 Days
This course is NOT available for virtual online training. This course is an introductory computer course and covers fundamental concepts related to computer hardware, software, and basic digital literacy. The course requires a hands-on learning experience, as candidates will need to practice tasks like typing, navigating files, and using certain software. These technical challenges can be overwhelming in a virtual online environment, especially for candidates who have very little or no experience with computers.
The student should be able to read and write.
This course is aimed at students who have either no or little knowledge of computers and who wish to learn end-user skills with any current version of Windows, including being able to start programs, switch between programs, locate saved files, close programs, and use a browser to access websites.
In this course, you will:
- Get a basic understanding of computers and how they work
- Use navigation techniques
- Focus on keeping your hands at the correct position in using the keyboard
- Learn the basics of Microsoft Word
- Learn the basics of Microsoft Excel
- For the optional section, learn about emails
MICROSOFT OFFICE SPECIALIST (MOS) TRAINING PROGRAMME
WORD, EXCEL, & POWERPOINT - MICROSOFT 365 APPS
Modern organisations rely heavily on digital documents, data analysis, and professional presentations to communicate, make decisions, and operate efficiently. Microsoft Office remains the global standard for these tasks.
The Microsoft Office Specialist (MOS) Training Programme is designed to equip learners with practical, job-ready skills in Microsoft Word, Excel, and PowerPoint using Microsoft 365 Apps. The programme follows a structured, progressive learning path, starting with foundational skills and building toward advanced, exam-aligned competencies.
Learners complete a series of self-study eBooks at their own pace, reinforced by hands-on practice using GMetrix mock exams. The programme culminates in internationally recognised Microsoft Office Specialist (MOS) certification exams, written through Certiport.
The focus of this programme is on the desktop versions of Microsoft 365 Apps, as these are most commonly used in professional environments. Where relevant, differences between desktop and online versions are highlighted.
Course Code: MS-MOS-CERT
Programme Name:
Microsoft Office Specialist (MOS) Training Programme – Microsoft 365 Apps
Applications Covered:
- Microsoft Word 365
- Microsoft Excel 365
- Microsoft PowerPoint 365
Programme Delivery:
Self-study (eBooks) + Practical Practice (GMetrix) + Certification Exams (Certiport)
Learning Material:
8 Self-Study eBooks
- MS Excel – Part 1, Part 2, Part 3
- MS Word – Part 1, Part 2, Part 3
- MS PowerPoint – Part 1, Part 2
Certification Provider:
Certiport (Authorised Testing Centre)
To ensure success in this programme, learners should have:
- Basic end-user skills in Microsoft Windows
- Ability to start programs, switch between applications, and manage files
- Basic keyboard and mouse skills
- General computer literacy
No prior advanced Microsoft Office knowledge is assumed.
This programme is intended for:
- Individuals seeking internationally recognised Microsoft Office certification
- Administrative professionals, clerks, and office staff
- Students preparing for workplace readiness
- Business owners and professionals wanting to improve productivity
- Anyone who uses Microsoft Word, Excel, or PowerPoint as part of their daily work
No prior Microsoft certification is required.
Upon successful completion of this programme, learners will be able to:
- Create, format, and manage professional documents in Microsoft Word
- Analyse, calculate, and present data accurately using Microsoft Excel
- Design effective, professional presentations using Microsoft PowerPoint
- Apply productivity best practices across Microsoft 365 Apps
- Prepare confidently for MOS Associate and MOS Expert certification exams
- Demonstrate internationally recognised Microsoft Office proficiency
Phase 1: Self-Study (eBooks)
Learners complete eight structured eBooks at their own pace:
Microsoft Word
- Word Part 1 – Fundamentals
- Word Part 2 – Intermediate Features
- Word Part 3 – Advanced & Expert Preparation
Microsoft Excel
- Excel Part 1 – Fundamentals
- Excel Part 2 – Intermediate Data Handling
- Excel Part 3 – Advanced Analysis & Expert Preparation
Microsoft PowerPoint
- PowerPoint Part 1 – Fundamentals
- PowerPoint Part 2 – Advanced Presentations
Each eBook includes explanations, guided exercises, and practical tasks aligned to MOS exam objectives.
Phase 2: Practice & Mock Exams (GMetrix)
After completing the eBooks, learners practice using GMetrix, which provides:
- Training Mode with guided feedback
- Testing Mode that simulates real MOS exams
- Performance reports highlighting strengths and weaknesses
Phase 3: Certification Exams (Certiport)
Learners write official Microsoft Office Specialist (MOS) exams through Certiport at an authorised testing centre.
MOS Certification Levels:
- MOS Associate (Word, Excel, PowerPoint)
- MOS Expert (Word Expert and Excel Expert)
MOS exams are performance-based, requiring candidates to complete real tasks in the Microsoft applications rather than answering multiple-choice questions.
R15 000.00
(Price shown is an estimate and subject to change due to exchange rate fluctuations.)
Students may enrol for the full Microsoft Office Specialist (MOS) Training Programme upfront, or purchase each module individually. Each module focuses on a specific Microsoft Office application (Microsoft Word, Excel, and PowerPoint) and must be completed sequentially before progressing to the next module.
After completing all eight e-book modules, students are required to purchase and complete the GMetrix mock exams. Once these have been successfully completed, students may then purchase and attempt the official Microsoft Office Specialist certification exams.
Please contact us for an official quotation.