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 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 course will show participants how to work with Microsoft® Project Server 2013. Participants will also create and manage projects and schedules, resources, tasks and timesheets with Project Web App. As well as create and configure Business Intelligence for customized project reporting and how-to backup and restore and troubleshoot Project Server 2013.
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 will show participants how to develop applications using the various APIs available in Project Server including Project Server Interface (PSI), .NET Client-Side Object Model, JavaScript Object Model and REST. In addition, participants will learn how to extend on-premise Project Server installs via web parts, local and remote event handlers, Apps via the new App Model and workflows.
This course provides participants with the knowledge and skills necessary to effectively manage projects using Microsoft® Project Server 2010.
This course is intended for project team member or project managers who build an easy-to-maintain and reusable work schedule for team members and partners. Managing task status and evaluate the work schedule in terms of time, man-hours, tasks, budgets on demand. Also would like to improve effective project team communication and collaboration.
The goal of this three-day instructor-led course is to provide students with the knowledge and skills necessary to effectively plan, deploy and manage Microsoft® Project Server 2010.
The goal of this course is to provide participants with the knowledge and skills necessary to effectively plan, deploy and administer Microsoft® Project Server 2013.
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 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 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 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®.
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.
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.
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 advanced methods of Social Media Management. They will learn about strategy and paid advertising techniques, and how to master the various social media platforms. At the end of the course, participants will be able to monetize their business profiles.
In this course, participants will identify the principles of effective leadership and practical strategies to apply on the job to improve their performance as a leader within their workgroup or organization.
This course will teach participants a logistics approach to inventory management – from the warehouse through the distribution system, from the supplier to the customer. The course outlines objectives and performance measures pertaining to customer service, inventory investment, and operational efficiency. Factors affecting inventory are fully discussed while warehouse environments are fully explored, including types and objectives, packaging, material handling, and costs involved.
This course teaches participants the basics of Social Media Management. They will learn how to identify their target markets, clarify which platforms their audience uses and tailor their message to fit their needs. At the end of this course, participants will be able to manage their own personal or business profiles.
Whether or not your title is "Business Analyst", business analysis (BA) work is expected from project managers, quality assurance professionals, and pretty much everyone in the organization. It is a complex and broad discipline! This course outlines the critical tasks included in the business analysis profession, along with definitions and examples of the various requirements types. It will also cover key analysis techniques for eliciting, analyzing and presenting requirements.
This certification is the world’s first and only certification in privacy programme management. Earning the CIPM indicates that the participants know how to make a privacy programme work for their organisation. In this course, participants will learn how to create a company vision, structure their privacy team, develop and implement a privacy framework and communicate with stakeholders. They will also get insights on performance measurement and the privacy programme operational lifecycle.
Data privacy regulations worldwide require privacy protections to be built into products and services. This course will provide participants with the knowledge to recognize privacy threats and skills to apply technical strategies to mitigate privacy risk throughout the software and systems development lifecycles. This course is also beneficial for participants who plan to certify or want to deepen their privacy knowledge. And, in the ever-changing privacy environment, as new legislation such as the GDPR and the CCPA comes along, participants will be fully prepared.
This course is designed to help acquaint you with the art of communicating. You will learn to understand the importance of interpersonal skills in becoming a leader, be able to convey believability by keeping verbal, vocal, and visual communications consistent, practice the nine behavioural skills of interpersonal communication, and change your habits to improve interpersonal effectiveness. This content is applicable whether you are currently in a leadership role or hope to be a leader in the future.
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.
Project managers are always under severe pressure to complete projects on time and within budget. However, most projects fail to meet these demands and as a result, many projects are terminated early. Successful project management requires knowledge and experience. This course is designed to provide participants with the skills needed to be a successful project manager in today's rapidly changing world. Thus, participants will apply recognized practices of project management and understand a project’s life cycle, roles, and skills necessary to effectively initiate, plan, execute, monitor, control and close a project. Additionally, this course can be a significant part of a participants’ preparation for the CompTIA® Project+ certification exam. The skills and knowledge participants gain in this course will help them avoid making costly mistakes and increase their competitive edge in the project management profession.
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.
As a customer service representative, you are expected to manage customer interactions in the best way possible. The expectations of both your company and your customers hinge on your ability to provide the right service in the right way. In this course, participants will explore the background and techniques of customer interactions.
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.
Though businesses increasingly rely on technology, technological skills alone do not guarantee success in the workplace. You must still develop your ideas, express them clearly, and persuade others of their viability. This course offers effective strategies to sharpen your writing skills by structuring your ideas logically, exercising diplomacy in letters and reports, and shaping your arguments.
To be successful in the workplace, you must be able to effectively communicate and cooperate with co-workers and external people. With this course, participants will be able to negotiate successfully, develop active listening, and form a healthy culture of constructive criticism.
The world of business is increasingly becoming centred about the interaction of different teams, both within and outside the organization. The success of a team within a company is often directly linked to the ability of a manager to lead and manage the team effectively. In order to perform the job well, the manager must understand the different roles of everyone involved in the team, and be trained in developing the capabilities of all team members and addressing issues as soon as they surface. This course will help you gain an understanding of the basic fundamentals of becoming an effective manager for your team.
The ability to deliver presentations is vital to achieving advancement for yourself and your ideas. Few life skills will contribute to your success as much as presentation skills. Without a dynamic and coherent presentation, even stellar ideas can fail to convince your audience. In this course, participants will learn to organize their ideas to create coherent and convincing oral presentations. They will also learn to utilize available visual aids and use public-speaking techniques to strengthen their delivery.
Effective time managers enjoy the satisfaction of directing their talents and energy towards productive, goal-centred activities. In this course, participants will learn effective time management and organizational skills. This will allow them to also use their time and energy efficiently, focusing their efforts on the activities that will help them reach their short- and long-term professional and personal goals.
It was once believed that intelligence was the metric that would determine a person's success in the workplace. Intelligence matters because it contributes to your ability to do your job. Though, intelligence is not the best indicator of whether you will succeed. Your ability to understand and manage your own emotions, and get along well with others, has at least as much impact on your performance and effectiveness as intelligence. In this course, participants will explore strategies to increase the awareness of one’s emotions, develop the ability to manage one’s emotions, and improve their social skills.
Motivation has a profound effect on employees' productivity and performance. An organization improves its likelihood of success by maintaining a motivated workforce. As a leader within your organization, you share the responsibility of motivating your employees. This course will help participants cultivate the skills necessary to motivate their employees and give them essential performance-management skills.
This course is essential to maintaining a successful and productive work environment. The course will teach participants how to identify and assess ethical dilemmas. It will also help them formulate the best strategies for addressing these dilemmas, whether they are facing issues about relationships, discipline, safety, or performance.
In this course, participants will apply important principles and skills they can use as a customer service professional. In addition to providing basic customer service, participants will also learn important principles and skills they can use to solve difficult and challenging customer interactions, encourage further sales, and take on leadership responsibilities.
In this course, participants will learn how to deal with difficult employees. Participants will learn about the characteristics and sources of difficult behaviour. They will also learn effective techniques to prevent difficult behaviour and effective communication methods. Participants will also learn how to examine the workplace culture, how to lead employees through culture changes as well as tips for fostering a positive work environment, addressing negativity, and inspiring employee innovation.
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.
You learned the rules of grammar in school, but now you would like to refresh and refine your grammar usage for your professional life. You need to articulate your ideas clearly and succinctly in written communications and present yourself in a professional manner. In this course, you will review the rules of grammar, identify common grammar errors, and refine your business writing style
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.
Participants will learn critical leadership skills so that they are able to step forward with confidence as a leader in their organization. They will develop practical, necessary skills such as managing their time well, communicating effectively, and delegating work to others. Participants will also learn what great leaders know: how to hire the right people, how to facilitate productive meetings and handle conflict among team members, and how to coach people to give their best job performance.
In this course, participants will learn about organizational leadership and its role in guiding the organization toward vision fulfilment.
An organization improves its likelihood of success by effectively managing conflict. As a leader within your organization, you share that responsibility. This course will help participants cultivate the skills necessary to help manage conflict and ultimately to decrease the presence of conflict in the workplace.
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.
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.
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.
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.
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.
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.
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
This course covers three central elements of Microsoft® 365 enterprise administration – Microsoft 365 security management, Microsoft 365 compliance management, and Microsoft 365 device management. Participants will learn about Microsoft 365 Security Management, which includes topics such as how to manage security metrics, how to enable Azure® AD Identity Protection, how to configure Microsoft 365 security services and user Microsoft 365 Threat Intelligence. They will then learn about Microsoft 365 Compliance Management, which includes topics such as data retention and data loss prevention solutions in Microsoft 365, archiving and retention in Microsoft 365, implementing and managing data governance, and managing search and investigations. Lastly, this course will conclude with introducing participants to the world of Microsoft 365 device management – from establishing Microsoft Intune to enrolling devices to Intune, monitoring the devices, and controlling what users can do from the enrolled devices by using conditional access policies.
New managers want to be able to step forward and assume their new responsibilities with confidence. They want to be able to lead the individuals on their team effectively by conducting ongoing performance appraisals; delivering helpful and instructive feedback, training, and coaching; and designing and implementing performance standards. New managers also want to develop talent within their team by employing effective performance-management strategies on the job. This course will give new managers essential performance-management skills.
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.
In this course, participants will learn the practical skills you need to be an effective leader in your organization. Leadership enhances the skills employees at all levels need to be truly successful. When you learn practical leadership skills, you'll have the ability to motivate, coach, communicate with, and teach employees in such a way that they are more effective in their jobs and, as a result, you become more effective in your job.
This course is designed to equip public sector workers with the necessary knowledge and skills to effectively utilize AI tools, with a specific focus on ChatGPT, in their day-to-day tasks. Participants will gain hands-on experience in leveraging these tools to enhance productivity, streamline workflows, and improve decision-making processes. Through practical examples and interactive exercises, participants will also learn how to harness the power of AI tools while ensuring ethical considerations and data privacy.
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.
At this point in a participant’s professional development, they are ready to take on the responsibility for managing projects. Participants can manage a project by developing a solid understanding of the fundamentals of project management and its underlying structure and elements, including project phases, project life cycles, stakeholders, and areas of expertise. These, coupled with the ability to identify the project management processes that are recognized industry-wide as good practice, will help them to apply effective project management techniques to improve the efficiency of their projects and ensure their success. In this course, participants will identify effective project management practices and their related processes.
This course is designed to help participants understand the basics of preventing sexual harassment at work and handling complaints when they do occur. This course will also help participants to recognize actions that would be considered sexual harassment under most laws, as well as learn how to set up procedures to deal with sexual harassment complaints.
This Course will equip participants with the skills required to immediately start setting priorities, controlling budget and reporting on project results. It will help participants to better define and understand Project Management; Project Lifecycles and Stakeholders; Project Process Groups and Initiating a Project; Project Planning and how these are applied in the real world. In this course, participants will also be exposed to other critical areas such as Risk Management, Quality Management and Procurement Management. They will also get hands-on experience in the use of Microsoft Project software.
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.