The main purpose of this course is to give participants the ability to add analysis capabilities to Excel® spreadsheets. It also provides participants with a foundation to learn about more advanced data analytics with Excel or Power BI®.
This course provides participants with the knowledge and skills to analyse data with Power BI®.
The main purpose of the course is to give participants the ability to add BI techniques to Excel® data analysis. The course goes beyond the capabilities of tables and charts and uses Pivot Charts, the Excel Data Model, and Power BI®.
This course will teach participants how to use PowerPivot to access data sources, create relationships, use the PowerPivot DAX expressions and generate and format reports. They will also explore how PowerPivot workbooks can be integrated with SharePoint®.
This course explores all the end user features of SharePoint® 2010 including all out of the box lists and sites. Learn to use the new ribbon effectively to manage list items and explore the new Office integration features and tools.
This course explores advanced topics of working with SharePoint® 2010 sites. Topics include SharePoint® Server site definitions (Business Intelligence, Search Center, etc.), in-depth coverage of Workflows, My Sites and Social Computing, Site Administration, Site Customization and Site Collection Administration.
This course is designed for the site owner/”power user” of a SharePoint® site who needs to know how to create sites and lists, manage user access and customize lists and pages. This class uses the SharePoint® Server 2010 version of SharePoint®. While it is of equal value for users of SharePoint® Foundation, it does include a few features not found in Foundation.
This course provides participants with the knowledge and skills to write basic Microsoft® Excel® lookup formulas as well as in-depth nesting of advanced array and reference functions. The course will also show that certain functions exist and what they look like but will show the diversity and usefulness of those functions. This is a very hands-on approach with constant examples, practices and problem-solving provided to the participants.
This class is designed for SharePoint® team members who need to know how to use the team collaboration and document management features of a Microsoft® SharePoint® 2010 Team Site.
This course teaches participants the fundamentals of managing SharePoint® 2013 sites.
This course is for end users working in a Microsoft® SharePoint 2013 environment. The course teaches SharePoint® basics such as working with lists and libraries as well as basic page customizations.
This course will provide a deeper, narrowly-focused training on the important and popular skills needed to be an administrator for SharePoint® site collections and sites. This course is also designed to complement skills such as SharePoint deployment or farm administration skills and tasks, which are required for IT professionals to manage SharePoint 2013, taught in other Microsoft Official Courseware.
This course teaches participants how to manage the team collaboration, document management and social features of Microsoft SharePoint 2013. NOTE: This course is an excellent prerequisite for IT Professionals who work as SharePoint Server Administrators and would like to attend the 20331: Core Solutions of Microsoft SharePoint Server 2013 course.
This course is intended for individuals who are interested in expanding their knowledge base and technical skills about Microsoft® Project. The course begins with the basic concepts and leads students through all the functions they’ll need to plan and manage a small to medium-size project, including how to level resources and capture both cost and schedule progress.
This course begins with project management basics and follows with a complete examination of project creation, management, troubleshooting and closure. Finally, sharing project progress and the options available will be discussed.
This course is designed for information workers who are using or will use Office 365®. It will provide participants with the knowledge and skills to efficiently use Office 365 on a day-to-day basis. The course is designed with real world scenarios in mind. Participants will learn how to use Outlook® Online, Skype® for Business, OneDrive® for Business, SharePoint® Online, and OneNote®. At the end of this course, participants will be able to effectively navigate Office 365 and make use of all of the features of Office 365.
This course is designed to introduce participants to the SQL Business Intelligence Semantic Model (BISM) Tabular model, data modelling, and DAX.
This course teaches participants how to combine the functionality of Power View, PowerPivot, Power Query, and Power BI® into graphs, charts, KPIs, reports, and other visualizations for use in their business.
This course is designed for participants new to working with Microsoft® Word in Windows®. Participants will learn to create, edit, format, and print Microsoft Word documents.
In this course, participants will learn advanced formatting, use Microsoft® Word 2016 drawing tools, create and manage tables, and work with column layouts.
In this course, participants will learn advanced techniques, such as working with tables of contents, footnotes, and endnotes, adding comments, tracking changes, comparing and combining documents, creating envelopes and labels, using Mail Merge, and protecting Microsoft® Word documents.
In this course, participants will spend time getting comfortable with the Project 2016 user interface, including project views and the ribbon. They will also learn to enter, organize, and link tasks, work with resources, create basic reports, and create projects independently. The course allows time to practice fundamental basic skills essential for efficient use of this program.
This course takes an in-depth approach to key features of Project 2016 including task entry and linking, resource and resource management, and examining and updating projects. Participants will learn to efficiently manage projects, create master projects and sub-projects, create and customize visual reports, work with resource pools, and learn about costing.
This course teaches participants to manage a schedule but NOT manage cost within Microsoft® Project. By focusing only on the SCHEDULING capabilities of Project, this course dramatically simplifies this powerful application.
This course teaches participants the basics of SharePoint® such as working with sites, lists and libraries, basic page customizations as well as managing the different permissions of SharePoint.
This course is intended for individuals who are interested in expanding their knowledge base and technical skills about Microsoft® Project. The course begins with the basic concepts and leads students through all the functions they’ll need to plan and manage a small to medium-size project, including how to level resources and capture both cost and schedule progress.
This course delivers the complete site owner story engagingly and practically. This will ensure that participants have the confidence to plan and create new sites or manage their existing sites in SharePoint® Online. The goal is to teach participants how to make SharePoint Online relevant to their team using a site’s functionality to help them share information and collaborate with their colleagues. During the class, participants will also learn best practices and ‘what not to do’ as they watch live, interactive demonstrations and put theory into practice with hands-on exercises in SharePoint Online.
This course delivers the complete site owner story engagingly and practically. This will ensure participants have the confidence to plan and create new sites or manage their existing sites. The goal is to teach participants how to make SharePoint® relevant to their team using a site’s functionality to help them share information and collaborate with their colleagues. During the class, participants will also learn best practices and ‘what not to do’ as they watch live, interactive demonstrations and put theory into practice with hands-on exercises.
This course will provide a deeper, narrowly-focused training on the important and popular skills needed to do SharePoint® site collection and site administration with SharePoint 2016 deployed on-premise, in Office 365® (SharePoint Online) or a hybrid deployment (on-premise connected to Office 365). This course is also designed to complement skills learned in other Microsoft courses, which focus on overall SharePoint 2016 server administration and deployment as well as overall Office 365 management such as either 20339-1: Planning and Administering SharePoint 2016, 20339-2: Advanced Technologies of SharePoint 2016 or 20347: Enabling and Managing Office 365.
This course will introduce participants to the SharePoint® Online Administration in Office 365®. It will explain and demonstrate the configuration options for SharePoint Online. The course is appropriate for. The course will also help participants understand the differences between SharePoint on-premises and SharePoint Online.
This course is designed to teach participants an overview of the roles and responsibilities of a SharePoint® Site Owner. They will learn how to add and configure sites and subsites, create and configure libraries and lists, create and customize columns, as well as create and manage content types. Participants will also learn the basics of permissions and how to manage the various permission levels, create and modify site pages, and work with web parts and app parts.
This course is an abbreviated version of the complete SharePoint® End-User course, 55199. In this course, participants will learn about the SharePoint basics such as working with sites, lists and libraries.
Microsoft® SharePoint® 2016 provides a business collaboration platform that streamlines document management, simplifies access to information, and provides the ability to deploy solutions quickly and securely. In this course, participants will gain a comprehensive overview of the SharePoint 2016 on-premise and SharePoint online platform. They will learn to create, manage, and customize SharePoint 2016 to the requirements of their organization.
This course is for end-users and site owners/managers new to working in a SharePoint® environment in Office 365®. The course teaches participants SharePoint basics such as working with lists and libraries, basic page customization, working with forms and managing site permissions and users.
This course teaches participants SharePoint® in Office 365® basics such as working with lists and libraries, basic page customization and managing site permissions and users.
This course is an abbreviated version of the complete course 55255: SharePoint® for Office 365® End-User. In this course, participants will learn about the SharePoint basics such as working with sites, lists and libraries.
This course delivers an instructor-led breakdown of Microsoft® PowerApps®. Participants will be taught how to design, test and publish new apps that work with a variety of data sources. The course will take them through a selection of well-crafted lessons to help them build new applications for their business.
This course delivers an engaging and practical product showcase of Microsoft® Flow from start to finish. Flow is a diverse product, turning business processes into automated, consistent and visual workflows. Flow is designed to interweave the various products in Office 365® as well as connect to other on-premises and web-based solutions. This course will give participants the confidence to select the right actions and workflow logic for their business workflows.
This course delivers a walkthrough of the various options for branding SharePoint® Online Sites. SharePoint Online has some non-code options to add logo’s, corporate colour schemes and conditional formatting on Apps. There are also options to add in coded customisations. This course will give participants guidance on how to use the non-code options available with practical labs to practice these methods. The course will also give participants guidance on the code options and advise where to look for the resources to do this. NOTE: The course will not cover how to write the code for the non-standard customisations.
This course is designed to help power users and end-users make the most of the Microsoft® Office 365® apps. It will teach participants how to collaborate across the business and understand when to use which of the Office 365 apps. This will help maximize your business adoption of Office 365 which is also known as Microsoft 365®.
This course delivers the complete site owner story from start to finish engagingly and practically. This will ensure that participants have the confidence to plan and create new sites or manage their existing sites. Their goal is to learn how to make SharePoint® relevant to their team by using a site’s functionality to help them share information and collaborate with their colleagues. During the class, participants will also learn best practices and ‘what not to do’ as they watch live, interactive demonstrations and put theory into practice with hands-on exercises.
In this course, participants will spend time getting comfortable with the Microsoft® Project 2019 or Project 365 user interface, including project views and the ribbon. They will learn to enter, organize, and link tasks, work with resources, create basic reports, and create projects independently. The course also allows time to practise fundamental basic skills essential for efficient use of this program.
This course takes an in-depth approach to key features of Microsoft® Project 2019 or Project 365. These features include task entry and linking, resource and resource management, and examining and updating projects. Participants will learn to efficiently manage projects, create master projects and sub-projects, create and customize visual reports, work with resource pools, and analyze project costs.
This course teaches participants the SharePoint® basics such as working with lists and libraries, basic page customization, working with forms and managing site permissions and users.
In this course, participants will learn the fundamentals of managing SharePoint® sites by creating custom workflows using SharePoint Designer 2013, using Metadata Navigation, using Information Management Policies, etc.
This course is an abbreviated version of the complete SharePoint® End-User course, 55293. In this course, participants will learn about the SharePoint basics such as working with sites, lists and libraries.
This course is designed to teach participants an overview of the roles and responsibilities of a SharePoint® Site Owner. They will learn how to add and configure sites and subsites, create and configure libraries and lists, create and customize columns, as well as create and manage content types. Participants will also learn the basics of permissions and how to manage the various permission levels, create and modify site pages, and work with web parts and app parts.
Microsoft Teams® is a full collaboration platform and offers facilities for peer-to-peer collaboration as well as full team collaboration. This course will give guidance on how to use the tools for chat, file sharing, meetings, and calls. The course will also give direction on best practices for sharing files with external parties and show how to access other services available in the tenant directly from within Teams.
In this course, participants will learn about SharePoint® Online Administration. SharePoint Online is part of Microsoft 365 and underpins all the file experiences in Microsoft 365™.
This course will provide insight into the development techniques and approaches that can be applied to solutions built on the Microsoft® Power Platform®. Participants will learn the necessary skills to extend, integrate and implement Power Platform solutions. Participants will also learn about the Application Lifecycle Management (ALM) frameworks available to help support and maintain Power Platform implementations, including the Microsoft Power Platform Build Tools for Azure® DevOps and the PowerApps® Center of Excellence (CoE).
This course will take participants on a journey from the concepts of a Microsoft® Power BI® project right through to the end result in an engaging and structured format. Participants will get hands-on with a wealth of data to practise the techniques taught in this course.
This course teaches participants the knowledge and skills required to transform business requirements in support of data-driven decisions. They will learn to do so by mining and manipulating data, applying basic statistical methods, and analysing complex data sets while adhering to governance and quality standards throughout the entire data lifecycle. In addition, this course will help prepare participants to take the certification exam. Also, this course may earn participants a Credly Badge.
This course builds on the foundational knowledge of the Microsoft® Office 365® online apps. It introduces the desktop, online and mobile versions of the Microsoft Teams™ application to participants. Participants will learn how to collaborate on shared files and conduct online meetings.
Participants will connect to a database to extract data and present it as a report using Crystal Reports® 2011.
Participants will create complex reports using Crystal Reports® tools.
Organizations use reporting tools to access data sources and generate customized reports. Crystal Reports® 2016 enhances report building and report processing techniques with a variety of features that add value to a presentation. In this course, participants will create a basic report by connecting to a database and modifying the report's presentation.
In this course, participants will create complex reports and data sources using the tools in Crystal Reports® 2016. They will not only create more sophisticated reports including subreports, cross-tabs and running totals but will also increase the speed and efficiency of their reports by using SQL queries.
Information is critical to making sound business decisions. Data presented without any formatting or structure holds little or no meaning for interpretation. Thus, organizations use reporting tools to access data sources and generate customized reports. In this course, participants will create a basic report using Crystal Reports® 2020 by connecting to a database and modifying the report's presentation.
Until now, you have used Crystal Reports® 2020 to build and modify reports. You want to use the advanced functionality of Crystal Reports to generate reports in the format you desire. In this course, participants will create complex reports and data sources using the tools in Crystal Reports 2020. They will create more sophisticated reports including subreports and cross-tabs but also increase the speed and efficiency of their reports by using SQL queries. By creating subreports, cross-tabs, and running totals, they will turn raw data into meaningful customized reports that will help their business run more smoothly. Participants will also learn to use tools that can increase the speed with which data is retrieved and thus eliminate any performance issues they may be faced with.
This course will discuss the various methods and best practices that are in line with business and technical requirements for modelling, visualizing, and analysing data with Microsoft® Power BI®. The course will also show participants how to access and process data from a range of data sources including both relational and non-relational data. This course will also explore how to implement proper security standards and policies across the Power BI spectrum including datasets and groups. The course will also discuss how to manage and deploy reports and dashboards for sharing and content distribution. Finally, this course will show participants how to build paginated reports within the Power BI service and publish them to a workspace for inclusion within Power BI.
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. This course will show participants how to use Excel to connect to a wide range of data sources, perform robust data analysis, and create diverse and robust data-backed visualizations to show insights and trends, and create reports. At the end of this course, these capabilities will enable participants to turn data into thoughtful action.
This course provides participants with a thorough introduction to using Linux™ from the command line. All the essential shell and basic operating system commands are taught, enabling participants to start utilising the power of the Linux operating system.
Cloud computing enables an organization to increase capacity or add capabilities on the fly, without necessarily requiring considerable investment in infrastructure, new personnel, or software. With a carefully planned migration to cloud services, organizations can provide themselves with greater flexibility, additional capability, and potential cost savings. Google is one of the major players among cloud vendors, offering a wide variety of cloud services. In this course, participants will learn the capabilities of Google's cloud offerings and will identify a process for migrating their current systems, data, and users to them.
Learn how to effectively use Canva to design graphics for your business. This course will not only teach participants how to use Canva but will help them develop a brand identity for their business or organization.
This comprehensive course offers foundational knowledge in graphic design principles, tools, and techniques essential for creating impactful artwork. Participants will explore design history, key elements of design, and gain proficiency in Adobe Illustrator while covering topics such as colour theory, typography, and the creative process. They will develop hands-on skills in shape creation, artwork enhancement, and preparing designs for various media. By blending theoretical knowledge with practical application, the course equips participants to produce high-quality designs and develop a portfolio that prepares them for further studies or careers in graphic design.
This course provides practical training in creating professional graphic designs. The areas covered include principles and elements of design, colour theory, working with text, working with cameras and scanners, exporting files and the different file types. The course is an important step towards furthering studies in the field of Computer Graphics.
This course is an introduction to Microsoft 365® cloud-based tools and can be used as an orientation to the full suite. Using the Microsoft 365 suite of productivity apps, users can easily communicate and collaborate through Microsoft Outlook® mail and Teams® messaging and meeting functionality. Additionally, the Microsoft® SharePoint® team site provides a central storage location for accessing and modifying shared documents. This course introduces working with shared documents in the familiar Microsoft 365 web apps—Word, PowerPoint®, and Excel®—as an alternative to installing the Microsoft Office desktop applications.
This course builds on your foundational knowledge of the Microsoft® 365 core apps and takes a deeper look at some of the productivity apps beyond Microsoft Word, Excel®, and PowerPoint®. Knowing that productivity often begins with assembling the right people, this course starts with the Teams® app that is used to collaborate on shared files and conduct online meetings. The connection between Planner and Teams is established to keep the group's work on schedule. The Forms app is introduced as a tool for collecting information that can be used to help determine your next course of action.
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® for Office 365™can help participants and their 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.
In this course, participants will expand their knowledge of relational database design. They will learn how to promote quality input from users; improve database efficiency and promote data integrity; and implement advanced features in tables, queries, forms, and reports. Extending their knowledge of Microsoft® Access® for Office 365™ will result in a robust, functional database for their users.
Once participants have covered many of the basic functions of Microsoft® Access® for Office 365™, they are ready to learn advanced Access features. In this course, features such as database management, advanced form design, packaging a database, encrypting a database, preparing a database for multiple-user access, and more will be covered. Knowledge of these features separate database professionals from casual database users or occasional designers.
Microsoft® Excel® for Office 365™ can help participants organize, calculate, analyse, revise, update, and present their data in ways that will steer their decision-makers in the right direction. With this specialized software these tasks are made much easier for participants to accomplish, and in much less time as well. This course aims to provide participants with a foundation in Excel knowledge and skills. Eventually, they can build upon that foundation and become an expert in data manipulation.
This course builds upon the foundational knowledge presented in the course, Microsoft® Excel® for Office 365™ (Desktop or Online): Part 1. It will help participants in creating advanced workbooks and worksheets that can help deepen their understanding of organizational intelligence. This course also aims to help participants extract actionable organizational intelligence from their raw data. Participants will be shown how to analyse massive amounts of data, extract actionable information from it, and present that information.
This course builds upon the foundational and intermediate knowledge presented in the courses, Microsoft® Excel® for Office 365™ (Desktop or Online): Part 1 and Part 2. 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 their fingertips. This course aims to help participants to get Excel to do more for them so they can focus on what is important: staying ahead of the competition.
With the tremendous amount of available data, the ability to make sense of it continues to be an ongoing challenge. You already know how to use Excel to perform simple calculations and modify worksheets to make them easier to read, interpret, and present to others. But Excel can do so much more. This course introduces the basics of data analysis and how to use Excel to create informative dashboards. This allows participants to be able to extract actionable organizational intelligence from their raw data and present it in a visually compelling format that enables decision-makers to view key trends and gain insights. Note: This course builds upon the foundational knowledge presented in the Microsoft® Excel® for Office 365™ (Desktop or Online): Part 1 course and introduces the basics of data analysis and how to use Excel to create informative dashboards.
With the tremendous amount of available data, the ability to make sense of it continues to be an ongoing challenge. This course introduces the basics of data analysis and how to use Microsoft® Excel® to create informative dashboards. This allows participants to be able to extract actionable organizational intelligence from their raw data and present it in a visually compelling format that enables decision-makers to view key trends and gain insights.
Participants will learn how to use Microsoft® InfoPath® 2010/2013 to gather and share information by creating and implementing XML-based forms.
A relational database application such as Microsoft® Office Access® 2010 can help you and your organization collect and manage large amounts of data. Access is a versatile tool. You can use it as a personal data management tool (for your use alone), or you can use it as a construction set to develop applications for an entire department or organization. In this course, participants will learn how to use Access 2010 to manage their data, including creating a new database, constructing tables, designing forms and reports, and creating queries to join, filter, and sort data.
Your training and experience using Microsoft® Access® 2010 has given you basic database management skills such as creating tables, designing forms and reports, and building queries. In this course, participants will expand their knowledge of relational database design, write advanced queries, structure existing data, share data across applications, and customize reports. Extending your knowledge of Microsoft Access 2010 will result in a robust, functional database for your users.
You've covered many of the basic functions of Microsoft® Office Access® and now you're ready to learn advanced Access features such as database management, advanced form design, packaging a database, encrypting a database, preparing a database for multi-user access, and more. Knowledge of these features separate database professionals from casual database users or occasional designers. This course, adds on to the knowledge and skills participants have gained previously and, rounds out their Access education and provides them with marketable job skills.
This course will teach participants how to exchange data with other applications, automate business processes by using VBA code, and secure and share databases.
A relational database application such as Microsoft® Office Access® 2013 can help you and your organization collect and manage large amounts of data. Access is a versatile tool. You can use it as a personal data management tool (for your use alone), or you can use it as a construction set to develop applications for an entire department or organization. In this course, participants will learn how to use Access 2013 to manage their data, including creating a new database; constructing tables; designing forms and reports; and creating queries to join, filter, and sort data.
Your training and experience using Microsoft® Access® 2013 has given you basic database management skills such as creating tables, designing forms and reports, and building queries. In this course, participants will expand their knowledge of relational database design, write advanced queries, structure existing data, share data across applications, and customize reports. Extending your knowledge of Microsoft Access 2013 will result in a robust, functional database for your users.
You've covered many of the basic functions of Microsoft® Office Access® and now you're ready to learn advanced Access features such as database management, advanced form design, packaging a database, encrypting a database, preparing a database for multi-user access, and more. Knowledge of these features separate database professionals from casual database users or occasional designers. This training, added to that which participants have gained from the previous two levels or experience, rounds out their Access education and provides them with marketable job skills.
A relational database application such as Microsoft Office Access 2016 can help attendees and their organizations collect and manage large amounts of data. Access is a versatile tool. Attendees can use it as a personal data management tool (for their use alone), or they can use it as a construction set to develop applications for an entire department or organization. In this course, attendees will use Access 2016 to manage data, including creating a new database; constructing tables; designing forms and reports; and creating queries to join, filter, and sort data.
In this course, attendees will expand their knowledge of relational database design, write advanced queries, structure existing data, validate data entered into a database, and customize reports. Extending your knowledge of Microsoft Access 2016 will result in a robust, functional database for your users.
In this course, attendees will learn advanced Access features such as database management, advanced form design, packaging a database, encrypting a database, preparing a database for multi-user access, and more. Knowledge of these features separate database professionals from the casual database users or occasional designers. Today's training will round out attendees’ Access education and provides them with marketable job skills.
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® Office Access® can help you and your organization with this task. This course focuses on the design and construction of an Access database which entails viewing, navigating, searching, and entering data in a database, as well as basic relational database design and creating simple tables, queries, forms, and reports. NOTE: This course is the first part of a three-course series that covers the skills needed to perform database design and development in Access 2019.
Previous training and experience using Microsoft® Office Access® should have given participants basic database management skills, such as creating tables, designing forms and reports, and building queries. In this course, they will expand their 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 their knowledge of Access will result in a robust, functional database for their users. This course focuses on the optimization of an Access database, including optimizing performance and normalizing data, data validation, usability, and advanced queries, forms, and reports. NOTE: This course is the second part of a three-course series that covers the skills needed to perform database design and development in Access 2019.
Participants have covered many of the basic functions of Microsoft® Office Access®, and now they 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 casual database users or occasional designers. NOTE: This course is the third part of a three-course series that covers the skills needed to perform database design and development in Access 2019.
This course will focus on the design and construction of an Microsoft® Office Access® database. Therefore, participants will learn how to view, navigate, search, and enter data in a database. They will also learn basic relational database design and create simple tables, queries, forms, and reports.
Your training and experience using Microsoft® Office Access® have given you basic database management skills. In this course, participants will expand their knowledge of relational database design. They will learn to promote quality input from users, improve database efficiency and promote data integrity, and implement advanced features in tables, queries, forms, and reports. At the end of this course, participants will be able to create a robust, functional database for their users.
Microsoft® Excel® has the power to help persons organize, calculate, analyze, revise, update, and present their data in ways that will help the decision-makers in their organization to steer the company in the right direction. To do this, first, one needs to know exactly how to ask Excel the questions that need to be answered, which questions to ask and how to interpret the answers Excel gives. Beyond that, this course aims to provide participants with the foundational knowledge and skills necessary to make data easier to read, interpret, and present to others.
The ability to analyze massive amounts of raw data, extract actionable intelligence from it, and present that information to decision-makers is the cornerstone of a successful organization that can compete at a high level. Microsoft® Excel® enables knowledgeable users to excel in these tasks. This is exactly what this course aims to help participants with. It also builds upon the foundational knowledge presented in the previous level course as well as help participants start down the road to creating advanced workbooks and worksheets that can help deepen their organizational intelligence.
This course aims to help participants use Microsoft® Excel® to do more for them. There is no wasting time scouring over workbooks to resolve issues or performing repetitive, monotonous tasks. They can focus on what is important: staying ahead of the competition. This course builds off of the foundational and intermediate knowledge presented in the previous two-level courses so that participants can get the most out of their 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 their fingertips. The more participants learn about how to use Excel to do the hard work for them, the more they'll be able to focus on getting the answers they need from the vast amounts of data their organization generates.
Excel® can help you organize, calculate, analyze, revise, update, and present your data in ways that will help the decision-makers in your organization steer you in the right direction. Of course, knowing exactly how to ask Excel the questions that you need answered, which questions you can even ask, and how to interpret the answers Excel gives is necessary before you can even begin to embark on the journey ahead. This course aims to provide you with the foundational Excel knowledge and skills necessary to begin that journey.
This course builds upon the foundational knowledge presented in the Microsoft® Office Excel® 2013: 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 analyze 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 is able to compete at a high level.
This course builds off of the foundational and intermediate knowledge presented in the Microsoft® Office Excel® 2013: Part 1 and 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.
This course builds upon the foundational knowledge presented in either of the Microsoft® Office Excel® 2016: Part 1 (Desktop/Office 365™) courses. It will help participants start down the road to creating advanced workbooks and worksheets that they can use to create dashboards. The ability to analyse massive amounts of data, extract actionable intelligence from it, and present that information to decision-makers is the cornerstone of driving a successful organization that can compete at a high level.
This course aims to provide attendees with a foundation for Excel knowledge and skills, which they can build upon to eventually become an expert in data manipulation. Excel can help persons organize, calculate, analyse, revise, update, and present their data in ways that will help the decision makers to steer the organization in the right direction.
This course builds upon the foundational knowledge presented in the Microsoft Office Excel 2016: Part 1 course. It will help start participants down the road to creating advanced workbooks and worksheets that can help deepen their understanding of organizational intelligence. Persons need to be able to extract actionable organizational intelligence from their raw data. The ability to analyze 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 is able to compete at a high level.
This course builds off of the foundation and intermediate knowledge presented in the Microsoft Office Excel 2016: Part 1 and Part 2 courses to help you get the most out 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.
Microsoft® Office Excel® can help persons organize, calculate, analyze, revise, update, and present their data in ways that will help the decision makers in their organization steer them in the right direction. It will also make these tasks much easier for persons to accomplish, and in much less time, than if they had used traditional pen-and-paper methods or non-specialized software. This course aims to provide participants with a foundation for Excel knowledge and skills, which they can build upon to eventually become an expert in data manipulation.
This course builds upon the foundational knowledge presented in the Microsoft® Office Excel® 2019: Part 1 course. It will also help participants start down the road to creating advanced workbooks and worksheets that can help deepen their 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 is able to compete at a high level.
This course builds upon the foundational and intermediate knowledge presented in the previous two level courses to help attendees get the most of their 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.
This course aims to provide participants with a foundation in Microsoft® Office® Excel 2021 knowledge and skills. Participants can eventually build upon them to become an expert in data manipulation.
This course builds upon the foundational knowledge presented in the Microsoft® Office Excel® 2021: Part 1 course. It will help start participants down the road to creating advanced workbooks and worksheets that can help deepen their understanding of organizational intelligence. This course will teach participants to analyse massive amounts of data, extract actionable information from it, and present that information to decision-makers. At the end of this course, participants will be able to use Excel to provide the answers to any questions they may have about their data.
This course builds upon the foundational and intermediate knowledge presented in the Microsoft® Office Excel® 2021: Part 1 and Microsoft® Office Excel® 2021: Part 2 courses to help participants maximise their Excel experience. This course aims to teach participants how to collaborate with colleagues, automate complex or repetitive tasks, and use conditional logic and dynamic arrays to construct and apply elaborate formulas and functions. This knowledge will put the full power of Excel right at their fingertips. At the end of this course, participants will know how to use Excel to do more for them so that they can focus on getting the answers needed from the vast amounts of data their organization generates.
This course is designed to familiarise existing users of Microsoft® Excel® in the building of dashboards that can be used to create compelling Excel reports. It provides participants with in-depth coverage of the necessary individual functions and tools. It will walk attendees through the most effective ways to present and report data as well as cover the fundamental knowledge and skills needed to create dashboards and interactive controls. Through this training, participants will go from reporting data with simple tables full of dull numbers to presenting key information using high-impact, meaningful reports and dashboards that will wow management both visually and substantively.
Advances in technology have made it possible to store ever increasing amounts of data. Along with this, the need to analyse that data and gain actionable insight is greater than ever. You already have experience working with Excel® and creating basic PivotTables to summarize data. But, Excel® is capable of doing much more. Being able to harness the power of advanced PivotTable features and create PivotCharts will help you to gain a competitive edge. You will not only be able to summarize data for you to analyse, but also organize the data in a way that can be meaningfully presented to others. This leads to data-driven business decisions that have a better chance of success for everyone involved.
We are now living in the age of big data. Data is being collected all the time and for increasingly detailed transactions. This can lead to an overwhelming amount of data, which brings about a need for people who can analyse large amounts of data quickly. Fortunately, Excel® provides Power Pivot to help users organize, manipulate, and report on their data in the best way possible. Since a tool is only as good as the person using it, it is important to gain a solid understanding of Power Pivot to maximize your effectiveness when analysing data.
This course will help participants learn about the advanced features of Microsoft® Excel® to attain proficiency as an Excel power user.
This course is designed to give experienced Excel® users proficiency in creating procedures that run in response to specific events, working with control structures, developing user forms to accept or display data, validating the data entry in user forms, and debugging and handling errors in code whether in Microsoft® Office Excel® 2010, 2013 or 2016.
This course is intended for advanced professionals who need to automate spreadsheet tasks using Visual Basic for Applications (VBA) in Microsoft® Office Excel® 2010/2013/2016/2019.
You will use Microsoft® Outlook® to compose and send emails, schedule appointments and meetings, manage contact information, schedule tasks, and create notes.
You will customize the Microsoft® Outlook®environment, calendar, and mail messages, and will also track, share, assign, and quickly locate various Outlook items.
In this course, you will explore the Microsoft® Outlook® interface and when you are familiar with it, you will use Outlook to manage all aspects of email communications; use the Outlook calendar to manage appointments and meetings; use Outlook's People workspace to manage your contact information; create Tasks and Notes for yourself in Outlook; and customize the Outlook interface to serve your own personal needs.
In this course, participants will explore the advanced features provided with the Microsoft® Outlook® interface, such as advanced message, calendar, and contacts management. They will use the Tasks and Journal workspaces provided in the application to manage tasks assigned to them and others and to record interactions they will have with their colleagues. Lastly, participants will also share their workspaces with other users and use Outlook data files to save and back up their important information.
In this course, participants will learn to use Microsoft® Outlook®. They will learn the basic skills needed to start using Outlook to manage their e-mail communications, contact information, calendar events, tasks, and notes. It will also teach participants to customize the Outlook interface to suit their working style. This course is the first in a series of two Outlook courses.
In this course, participants will customize command sets, configure e-mail accounts, set global options, and perform advanced searches. They will also learn how to apply filters to intercept mail and control spam, create rules to automate many management tasks as well as work with calendars and contacts. Lastly, participants will manage tasks, protect data with archiving and data files, and share and delegate access to their workspaces. In short, participants will work with a wide range of features and options and, in so doing, understand why Microsoft® Outlook® is a leading personal management system.
In this course, participants will use Microsoft® Outlook® to send, receive, and manage e-mail messages. They will also learn to manage their contact information, schedule appointments and meetings, and create tasks and notes for themselves. Participants will also customize the Outlook interface to suit their working style. This course is the first in a series of two Outlook 2019 courses. It will provide participants with the basic skills needed to start using Outlook to manage their e-mail communications, contact information, calendar events, tasks, and notes.
In this course, participants 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 their Outlook items. In short, participants will 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® Office Outlook® 2019: Part 1 course and will help participants customize a communication system well-suited to their work style.
In this course, participants will use Microsoft® Office Outlook® to send, receive, and manage e-mail messages. participants will also learn to manage their contact information, schedule appointments and meeting. Lastly, they will also learn to create tasks and notes for themselves and customize the Outlook interface to suit their working style.
In this course, participants 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 their Outlook items. In short, they will work with a wide range of features and options and, in so doing, understand why Microsoft® Office Outlook® is a leading personal management system.
Participants will explore the Microsoft® PowerPoint® environment and create a presentation. They will format text on slides to enhance clarity. To enhance the visual appeal, participants will also add graphical objects to a presentation and modify them. Thirdly, they will also add tables and charts to a presentation to present data in a structured form. Then, participants will finalize a presentation to deliver it.
This course teaches participants how to enhance their presentations by using features that will transform it into a powerful means of communication. They will customize the Microsoft® PowerPoint® interface to suit their requirements and use features to create dynamic and visually appealing presentations. Participants will then finalize a presentation and secure it to authenticate its validity.
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 Microsoft® PowerPoint® 2013, participants will gain the ability to organize their content, enhance it with high-impact visuals, and deliver it with a punch. In this course, participants will use PowerPoint 2013 to begin creating engaging, dynamic multimedia presentations.
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 these variables, a robust set of tools such as Microsoft® PowerPoint® 2013 is needed. It provides the user with a variety of tools that can help them deliver content in nearly any situation while saving time and effort. In this course, participants will be shown how to take advantage of these tools to create interesting, informative, and memorable presentations that will deliver their content, on time, to all audiences, and to only those who need to see it.
When persons are asked to present important information so that the audience's focus is grabbed and maintained, Microsoft Office PowerPoint 2016 is the tool to use. Gone are the days of flip charts or drawing on a whiteboard to illustrate your point. 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 2016, participants will gain the ability to organize their content, enhance it with high-impact visuals, and deliver it with a punch. In this course, participants will use PowerPoint 2016 to begin creating engaging, dynamic multimedia presentations.
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? By using Microsoft Office PowerPoint 2016 robust set of tools which 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.
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 Microsoft® PowerPoint® 2019, participants will gain the ability to organize their content, enhance it with high-impact visuals, and deliver it with a punch. In this course, participants will use PowerPoint 2019 to begin creating engaging, dynamic multimedia presentations.
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 these variables, a robust set of tools such as Microsoft® Office PowerPoint® 2019 is needed. It provides the user with a variety of tools that can help them deliver content in nearly any situation while saving time and effort. In this course, participants will be shown how to take advantage of these tools to create interesting, informative, and memorable presentations that will deliver their content, on time, to all audiences, and to only those who need to see it.
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 Microsoft® Office PowerPoint® 2021, participants will gain the ability to organize their content, enhance it with high-impact visuals, and deliver it with a punch. In this course, participants will use PowerPoint to begin creating engaging, dynamic multimedia presentations.
Microsoft® PowerPoint® 2021 is needed. It provides the user with a variety of tools that can help them deliver content in any situation while saving time and effort. In this course, participants will be shown how to take advantage of these tools to create interesting, informative, and memorable presentations that will deliver their content, on time, to all audiences, and to only those who need to see it.
Microsoft® Office Publisher 2010 is a desktop publishing software program that comes with the Microsoft Office suite. While Microsoft Word is a word processing program, Microsoft Office Publisher is used for page layout and design. Participants can use Publisher to create brochures, flyers, menus, business cards, certificates, and any number of things that you want to design for either use on the computer or to print — personally or by a commercial printer. In this course, participants will create, format, edit, and distribute publications.
Microsoft® Office Publisher is a desktop publishing software application capable of producing greeting cards, certificates, newsletters, and other printed publications. 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 mail merge features, which is 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. In this course, participants will create, format, edit, and distribute publications.
Microsoft® Office Publisher 2016 is a desktop publishing software application capable of producing greeting cards, certificates, newsletters, and other printed publications. The software includes a large collection of templates that provide a great way to start a new publication. It 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 is 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. In this course, participants will create, format, edit, and distribute publications.
Microsoft® Office Publisher 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 is designed for students who wish to learn the basic operations of the Microsoft® Word to perform their day-to-day responsibilities, and who want to use the application to be more productive in their work. It provides the fundamental knowledge and techniques needed to advance to using more complex Word features such as protecting your documents and usage of ligatures.
This course is designed for persons who are able to create and modify standard business documents in Microsoft® Word 2010 but need to know how to create or modify complex business documents and customized Word efficiency tools. It also aims to assist persons preparing for the Microsoft Office Specialist exams for Microsoft Word 2010.
This course is designed for persons who want to gain skills necessary to manage lengthy documents, collaborate with others, and secure documents using Microsoft® Word 2010.
Microsoft® Word 2013 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, participants will learn how to use Word 2013 to create and edit simple documents; format documents; add tables and lists; add design elements and layout options; and proof documents.
Microsoft® Word can be used to create complex documents that are nearly as complicated as those created using a desktop publishing application. Using Word, you can control how the text flows between paragraphs and pages, you can link a story on page one to the rest of the story later in the document, and you can add graphics and specify how the text and graphic appear together on the page.
Microsoft® Word 2013 enables participants to do more than simple word processing. It can be used to collaborate on complicated documents and manage how the documents are accessed and distributed. Advanced features of Word 2013 enable participants to revise, manage, and secure theirr business documents.
Microsoft® Word 2016 is designed to help persons 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, participants will learn how to use Word 2016 to create and edit simple documents; format documents; add tables and lists; add design elements and layout options; and proof documents.
After you master the basics of using Microsoft® Word 2016, you're ready to move on to tackling the more advanced features. These features enable persons 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. This course will introduce participants to these advanced features as well as help them master the techniques for implementing them.
Microsoft® Word 2016 enables you to do far more than simple word processing. This 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.
Microsoft® Word 2019 is designed to help persons move smoothly through the task of creating professional-looking documents. Its rich features and powerful tools can make work easy, and even fun. In this course, participants will learn how to use Word 2019 to create and edit simple documents; format documents; add tables and lists; add design elements and layout options; and proof documents.
After the basics of creating, editing, and printing Microsoft® Word documents have been mastered, it is time to move on to tackling the more advanced features. In this course, participants will work with features such as formats, styles, and templates to create professional documents with a consistent look and feel. They will also add visual interest to their documents using the tables and charts features. Then, participants will learn about Quick Parts and templates to provide efficiency and consistency when adding content as well as learn how long complex documents can be simplified and managed in Master Documents. Finally, participants will use the mail merge feature to automate sending individual letters to customers. Participants should note that mastering these techniques will help make them a valued employee in your organization.
Microsoft® Word 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.
In this course, participants will learn how to use Microsoft® Word 2021. They will learn to create and edit simple documents, format documents, add tables and lists, add design elements and layout options, and proof documents.
After the basics of creating, editing, and printing Microsoft® Word documents have been mastered, it is time to move on to tackling the more advanced features. In this course, participants will work with features such as formats, styles, and templates to create professional documents with a consistent look and feel. They will also learn to add visual interest to their documents by using the tables and charts features. Then, participants will learn about Quick Parts and templates to provide efficiency and consistency when adding content as well as learn how long complex documents can be simplified and managed in Master Documents. Finally, they will use the mail merge feature to automate sending individual letters to customers.
Microsoft® Word 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. This course will teach participants image manipulation, collaboration, and revision tracking, cross-referencing, and linking, document security, forms, and process automation through macros.
Microsoft® OneDrive® for Business (formerly SkyDrive Pro) is an amazing cloud storage service that apart from storing, sharing, collaborating and syncing files, also allows users to create their own documents through Office Online. Office Online is the web-based version of some of the Microsoft Office suite of applications such as Word, Excel®, PowerPoint® and OneNote®. In this course, participants will learn how to use both the online web interface and the Desktop sync client. Participants will also learn how to store documents, pictures and other files safely and access them from any device connected to the Internet, including their phones and/or tablets.
In this fast-paced digital world, there is an ever-present need to capture ideas, meeting notes, and to-do items. This course provides a way for participants to efficiently create and collect their notes in an electronic notebook. It will introduce them to using Microsoft® OneNote® notebooks to store a wide variety of content in an organized structure, access the content from anywhere, and also share it with others.
In this course, participants will learn to use Microsoft® Outlook® for Office 365™. They will learn to send, receive, and manage email messages; manage their contact information; schedule appointments and meetings; create tasks and notes for themselves, and customize the Outlook interface to suit their working style.
In this course, participants 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 their Outlook items. In short, participants will work with a wide range of features and options and, in so doing, understand why Microsoft® Outlook® for Office 365™ is a leading personal management system.
Data scientists, or any professional, use the creation of data-backed visualizations to explore, analyze, and report insights and trends from data. Microsoft® Power BI® software is designed for this purpose. Power BI was built to connect to a wide range of data sources and allows users to quickly create visualizations of connected data to gain insights, show trends, and create reports. Its data connection capabilities and visualization features go far beyond those that can be found in spreadsheets, allowing users to create compelling and interactive worksheets, dashboards, and stories that bring data to life and turn data into thoughtful action. This course teaches attendees how to use Power BI to leverage (“big”) data effectively so that it provides timely insights and competitive advantage.
Data scientists, or any professional, use the creation of data-backed visualizations to explore, analyze, and report insights and trends from data. Microsoft® Power BI® software is designed for this purpose. Power BI was built to connect to a wide range of data sources and allows users to quickly create visualizations of connected data to gain insights, show trends, and create reports. Its data connection capabilities and visualization features go far beyond those that can be found in spreadsheets, allowing users to create compelling and interactive worksheets, dashboards, and stories that bring data to life and turn data into thoughtful action. This course teaches attendees how to use Power BI to leverage (“big”) data effectively so that it provides timely insights and competitive advantage.
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 Microsoft® PowerPoint® for Office 365™, participants will gain the ability to organize their content, enhance it with high-impact visuals, and deliver it with a punch. In this course, participants will use PowerPoint to begin creating engaging, dynamic multimedia presentations.
Microsoft® PowerPoint® for Office 365™ 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, participants will be creating presentations that not only stand out from the crowd but also do not consume all their available time.
Participants will create and manage a project schedule using Microsoft® Project 2010.
Participants will manage and customize project plans during the implementation stage of a project.
This course is designed to familiarise you with the basic features and functions of Microsoft® Project Professional 2013 so that you can use it effectively and efficiently in a real-world environment. It covers the critical knowledge and skills a project manager needs to create a project plan with Project 2013 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 2013 and share it with your supervisor (and others) for review and approval.
This course is designed to familiarise you with the advanced features and functions of Microsoft® Project Professional 2013 so that you can use it effectively and efficiently in a real-world environment. It covers the advanced knowledge and skills a project manager needs to update a project plan in Project 2013 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. Each lesson in this course is built around the executing, monitoring, and controlling tasks that can be accomplished using the advanced commands found on one of these Project 2013 tabs: PROJECT, TASK, VIEW, or REPORT. This will enable you to become a "power user" and leverage the full potential of the application.
Welcome to Microsoft® Project 2016: Part 1. This course is designed to familiarize you with the basic features and functions of Microsoft Project Professional 2016 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 2016 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 2016 and share it with your supervisor (and others) for review and approval.
Welcome to Microsoft® Project 2016: Part 2. This course is designed to familiarize you with the advanced features and functions of Microsoft Project Professional 2016 so that you can use it effectively and efficiently in a real-world environment. In Microsoft Project 2016: Part 1, you learned the basic features of Microsoft Project 2016 during the planning phase of a project. Microsoft Project 2016: Part 2 covers the advanced knowledge and skills a project manager needs to update a project plan in Project 2016 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.
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. It covers the critical knowledge and skills a project manager needs to create a project plan Project during the planning phase of a project. In other words, if you are assigned to lead a project, this course will enable you to draft a project plan with Project and share it with your superior (and others) for review and approval. This course will give you the fundamental understanding of Microsoft Project necessary to construct basic project plans.
This course is designed to familiarize you with some of the advanced features and functions of Microsoft Project so you can use it effectively and efficiently in a real-world environment. In Microsoft® Project® 2019 (On-Premise or Online Editions): 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 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.
This course is designed to familiarize participants with the basic features and functions of Microsoft® Project so they can use it effectively and efficiently in a real-world environment. The 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, this course will enable participants to draft a project plan with Project and share it with their supervisor (and others) for review and approval, if they are assigned to lead a project.
This course covers the advanced knowledge and skills a project manager needs to update a project plan in Microsoft® Project during the execution, monitoring, and controlling phases of a project. In other words, once the project plan is approved by the project sponsor, this course will enable participants to manage the project so that it is completed on time, within budget, and according to scope.
In this course, participants will learn how to create, configure, and manage a Microsoft® SharePoint® site so that their team or organization can collaborate effectively, manage the flow of digital information, meet governance and compliance needs, and create rich websites for their organization's needs.
In this course, participants will learn how to create, configure, and manage Microsoft® SharePoint®sites so that their team or organization can share information and collaborate effectively.
In this course, participants will learn about and use Microsoft® SharePoint®to access, store, share, and collaborate with information and documents.
This course is designed to help participants master Microsoft® Teams®, the key communications tool in the suite of Microsoft 365® productivity apps. Participants will learn to use Teams to have a quick chat with a colleague or individual, participate in a virtual meeting, make an online call, share files and resources, and collaborate with persons. They will learn how to use the Microsoft Teams app across the three versions: desktop, web, and or mobile app. On completion of this course, participants will be able to easily work in any version of the software and be able to take advantage of connecting through Teams wherever their work takes them.
Attendees will learn how to design and manage basic diagrams, workflow, and flowcharts.
Attendees will learn how to create custom elements and a custom template, represent external data as a drawing, and share their work with others.
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, participants will create visually engaging diagrams, maps, and drawings, using graphical elements to make information easier to comprehend.
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 with corresponding lines remaining intact. Microsoft® Visio® has improved over the years as features common to Microsoft® Office applications have been added. Today, Microsoft® 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 this course, participants will learn about more advanced features—making them a more efficient and effective Visio® user.
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 that easily creates professional-looking visual products by using its extensive gallery of shapes. By following the exercises in this course, participants will create visually engaging diagrams, maps, and drawings, using graphical elements to make information easier to comprehend.
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 the corresponding lines remain intact. Microsoft 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 this course, participants will learn about more advanced features—making participants more efficient and effective Visio users.
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. In this course, participants will create visually engaging diagrams, maps, and drawings, using graphical elements to make information easier to comprehend.
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. In this course, participants will learn about more advanced features—making them more efficient and effective Visio users. They will learn to create complex graphics and illustrations such as floor plans, custom maps, and scientific illustrations. They will also learn to link these illustrations to external data sources and insert them into other Microsoft Office files.
Microsoft® Word for Office 365™ 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, participants will 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.
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.
This course will focus on managing the database and supporting complex database designs. Participants will learn to import and export data, use action queries to manage data, create complex forms and reports, macros and VBA, and tools and strategies to manage, distribute, and secure a database. NOTE: Knowledge of these features separates database professionals from casual database users or occasional designers
Microsoft® Word for Office 365™ enables participants to do far more than simple word processing. 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
The business climate has changed. People want to communicate without collaborative barriers. Businesses want solutions that are both cost-effective and flexible. Organizations start to configure hybrid environments and migrate content to the cloud as the solution. In this course, participants will learn how to deploy and configure the SharePoint® Server 2019, designed to meet the demands of modern workstyles. They will also learn how to configure and manage various SharePoint service applications to prepare for a hybrid deployment. Then, participants will learn how to plan and implement SharePoint hybrid scenarios that provide seamless users’ experience. Eventually, they will learn how to design the content migration process and available resources and tools to use while migrating content to SharePoint and OneDrive® in Microsoft® 365.
This course will discuss the various methods and best practices that are in line with business and technical requirements for modelling, visualizing, and analysing data with Microsoft® Power BI®. The course will also show how to access and process data from a range of data sources including both relational and non-relational data. This course will also explore how to implement proper security standards and policies across the Power BI spectrum including datasets and groups. Lastly, the course will also discuss how to manage and deploy reports and dashboards for sharing and content distribution.
VBA (Visual Basic for Applications) enables you to enhance and extend the capabilities of Microsoft® Excel® and other applications in the Microsoft Office application suite. You can use VBA to perform tasks that would be difficult or impossible to do using only worksheet functions, and you can automate a wide range of tasks involving the collection, processing, analysis, and visualization of data. This course will give participants a good foundation for understanding, creating, and using VBA in their own Excel workbooks. It will also show them how to work with data across different applications, and how to package the macros and functions they create so they can be backed up, move them to other computers, and share them with other users.
The office productivity apps that comprise Google G Suite supports both real-time and asynchronous collaboration. In this course, participants will learn about the features and functionalities of the apps included in most G Suite editions—Gmail™, Google Drive™, Google Docs™, Google Slides™, Google Drawings™, Google Sheets™, Google Forms™, Google Hangouts™, Google Calendar™, and Google Sites™—and work within their respective environments. Participants will also learn how to create, manage, store, and share various types of files for personal or professional use in the Google G Suite environment.
You already know how to get 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 is capable of doing 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's exactly what this course aims to help you do.
VBA (Visual Basic for Applications) enables you to enhance and extend the capabilities of Microsoft® Excel® and other applications in the Microsoft Office application suite. This course will give participants a good foundation for understanding, creating, and using VBA in their own Excel workbooks. Participants will learn how to use the macro recorder effectively, as well as how to write their own VBA code from scratch. They will use the tools built into Excel to explore and learn VBA's capabilities and to optimize and debug their code.
This course will help participants become more confident and productive Zoom users. Participants will partake in, host and record Zoom meetings, use Zoom productivity tools such as share screen, annotation, polling, breakout rooms and contacts, and apply Zoom security and personalization.