Microsoft Applications

Microsoft Access 2019/2021 - Part 2

In this course, you will expand your knowledge of relational database design,promote quality input from users, improve database efficiency, promote data integrity, implement advanced features in tables, queries, forms, and reports. 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/2021.

Microsoft Access 2019/2021 - Part 1

Data is everywhere. Most job roles today involve some form of data management. Virtually everyone is affected in some way by the need to manage data. A relational database application such as Microsoft Office Access can help you and your organization with this task. This course is the first part of a three-course series that covers the skills needed to perform database design and development in Access.

Microsoft Access 2019/2021 - Part 3

This course is the third part of a three-course series that covers the skills needed to perform basic database design and development in Access 2019/2021. This course focuses on managing the database and supporting complex database designs, including import and export of data; using action queries to manage data; creating complex forms and reports; macros and Visual Basic for Applications (VBA); and tools and strategies to manage, distribute, and secure a database.

Creating Accessible Excel Spreadsheets

The objective of this course is to immerse students into accessibility issues and how to create easy to read and accessible Excel spreadsheets.

VBA with Microsoft Excel (v1.2)

VBA (Visual Basic for Applications) enables you to enhance and extend the capabilities of Microsoft Excel and other applications in the Microsoft 365 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 so they can be performed faster, more consistently, and with less effort than performing them manually. This course will give you a good foundation for understanding, creating, and using VBA in your own Excel workbooks. You will learn how to use the macro recorder effectively, as well as how to write your own VBA code from scratch. You will use tools built into Excel to explore and learn VBA's capabilities and to optimize and debug your code.

Microsoft Office Excel 2019/2021 Part 3

This course builds upon the foundational and intermediate knowledge presented in the Microsoft Office Excel 2019: Part 1 and Microsoft Office Excel 2019: 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.

Microsoft Office Excel 2019/2021 Part 2

This course builds upon the foundational knowledge presented in the Microsoft Office Excel 2019/21: 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.

Microsoft Office Excel 2019/2021 Part 1

This course aims to provide you with a foundation for Excel knowledge and skills, which you can build upon to eventually become an expert in data manipulation. 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. It will also make these tasks much easier for you to accomplish, and in much less time, than if you used traditional pen-and-paper methods or non-specialized software.

Microsoft Excel for Office 365 or Office 2019: Dashboards [v1.1]

Today's world runs on data more than ever before and that's a trend not likely to change, or even slow down, any time soon. 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 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, and present it in a visually compelling format that enables decision makers to view key trends and gain insights. And that's exactly what this course aims to help you do.

Microsoft Excel for Office 365 - Data Analysis with PowerPivot (v1.1)

Microsoft Excel for Office 365 - Data Analysis with PivotTables (v1.1)

Advances in technology have made it possible to store ever-increasing amounts of data. Along with this, the need to analyze data and gain actionable insight is greater than ever. You already have experience working with Microsoft 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.

Microsoft Excel 2016/2019 - Data Analysis with Power Pivot

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 analyze large amounts of data quickly. Fortunately, Excel provides Power Pivot to help you organize, manipulate, and report on your 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 analyzing data.

Microsoft Excel 2016/2019 - Data Analysis with PivotTables

Advances in technology have made it possible to store ever-increasing amounts of data. Along with this, the need to analyze that data and gain actionable insight is greater than ever. Participants 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 participants gain a competitive edge. Participants will not only be able to summarize data to analyze, 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 for success for everyone involved.

Data Analysis and Visualization with Microsoft Excel [v1.1]

Technology and the data that it both collects and makes accessible is now interwoven with businesses and lives. The era of "big data" has exploded due to the rise of cloud computing, which provides an abundance of computational power and storage, enabling organizations of all sorts to capture and store data. Leveraging that data effectively can provide timely insights and competitive advantage. Analyzing data to find issues, insights, and opportunities is now a critical part of many job roles. Beyond the analysis, data analysts in all job roles must be able to effectively present and communicate their findings in visually compelling ways. Microsoft Excel is designed for this purpose. Excel can connect to a wide range of data sources, perform robust data analysis, and create diverse and robust data-driven visualizations to show insights and trends, as well as create reports. These capabilities enable people who use Excel for data analysis to turn data into thoughtful action.

Microsoft Windows 11: Using Windows 11

Whether you're new to computers or have used them in the past, this class will help you become more comfortable using Windows 11 by familiarizing you with the Windows 11 user interface and its basic capabilities. In this course, you will explore Windows 11 and learn how to work with locally installed apps and cloud-based apps, browse the Internet, and manage basic Windows 11 settings.

Microsoft OneNote for the Desktop

Microsoft Outlook 2019/2021: Part 1

Microsoft Outlook 2019/2021: Part 2

In this course, you will customize command sets, configure mail accounts, set global options, perform advanced searches, apply filters to intercept mail and control spam, create rules to automate mail management tasks, work with calendars and contacts, manage tasks, preserve data with archives and data files, as well as share and delegate access to your Outlook items.

Introduction to DAX for Power BI

Welcome to Introduction to DAX for Power BI. This two-day instructor-led course is intended for business users who have been using Power BI and want to use DAX to create custom calculations in their data models. In this class, you will be introduced to using Data Analysis Expressions (DAX), which is the expression language that is used to create custom calculations in the Power BI Data model. The course covers some of the theoretical underpinnings of the data model and the DAX language, but the emphasis is on using DAX to solve common business problems. You will learn how to write your own calculated columns, measures, and tables, how to visualize the way Power BI computes DAX calculations, and how to troubleshoot custom code.

Power BI for Data-driven Decision Makers

As data acquisition, access, analysis, and reporting are interwoven with our businesses and lives, more and more data is collected about business and personal activities. This abundance of data and the computing power to analyze it has increased the use of data analysis and data visualization across a broad range of job roles. Decision makers of all types, including managers and executives, must interact with, interpret, and develop reports based on data and analysis provided to them. Microsoft Power BI software is designed for data analysis and the creation of visualizations. Data analysts prepare data, perform initial analysis, and create visualizations that are then passed to business data decision makers. These decision makers can use Power BI's tools to explore the data, perform further analysis to find new insights, make decisions, and create customized reports to share their findings.

Power BI Dashboard in a Day

A one-day, hands-on workshop for business analysts that covers the full capabilities of Power BI.

Microsoft Power BI: Data Analysis Professional (Second Edition) (v1.3)

Creating data-backed visualizations is key for data scientists, or any professional, to explore, analyze, and report insights and trends from data. Power BI was built to connect to a wide range of data sources, and it enables users to quickly create visualizations of connected data to gain insights, show trends, and create reports. Power BI's data connection capabilities and visualization features go far beyond those that can be found in spreadsheets, enabling users to create compelling and interactive work

Microsoft Power BI: Data Analysis Practitioner (Second Edition) (v1.3)

Creating data-backed visualizations is key for data scientists, or any professional, 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 it enables users to quickly create visualizations of connected data to gain insights, show trends, and create reports. Power BI's data connection capabilities and visualization features go far beyond those that can be found in spreadsheet.

Creating Accessible PowerPoint Presentations

This one-day course will take students into detailed feature of PowerPoint to insure accessible presentations. Attendees will work with some advanced tools and include narration and subtitling for both visually impaired and hearing-impaired audiences.

Microsoft Office PowerPoint 2019/2021: Part 2

Meetings, instruction, training, and pitches are all part of our daily lives. We are often called upon to deliver presentations with little notice, at multiple venues, and with varying requirements. 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. Microsoft PowerPoint 2021 provides you with all these tools that can help you.

Microsoft Office PowerPoint 2019/2021: Part 1

How do you grab and maintain an audience's focus when you're asked to present important information? By being clear, organized, and engaging. And, that is exactly what Microsoft Office PowerPoint 2021 can help you do. Today's audiences are tech savvy, accustomed to high-impact multimedia content, and stretched for time. By learning how to use the vast array of features and functionality contained within PowerPoint 2021, you will gain the ability to organize your content, enhance it with high-impact visuals.

55301 Mastering Microsoft Project 2019

This course is intended for those interested in expanding their knowledge base and technical skills about Microsoft Project. Starting with the basic concept, you will gain hands-on experience with all the functions needed to plan and manage a small to medium-size project, including how to level resources and capture both cost and schedule progress.

Microsoft 365 for the Web (with Teams, SharePoint, and OneDrive) v3.0

This course is an introduction to Microsoft 365 in a cloud-based environment. Using the Microsoft 365 suite of productivity apps online, users can easily communicate and collaborate through Microsoft Teams messaging and meeting functionality and Outlook email. When you create a team, the Microsoft SharePoint team site provides a central storage location for accessing and modifying shared documents. Each user also receives individual document storage through OneDrive for Business. Teams can provide a central hub for working with shared documents in the familiar apps?Word, PowerPoint, and Excel?as an alternative to installing the Microsoft 365 Desktop applications.

Microsoft Access 2019/2021 - Part 1

Data is everywhere. Most job roles today involve some form of data management. Virtually everyone is affected in some way by the need to manage data. A relational database application such as Microsoft Office Access can help you and your organization with this task. This course is the first part of a three-course series that covers the skills needed to perform database design and development in Access.

Microsoft Access 2019/2021 - Part 2

In this course, you will expand your knowledge of relational database design,promote quality input from users, improve database efficiency, promote data integrity, implement advanced features in tables, queries, forms, and reports. 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/2021.

Microsoft Access 2019/2021 - Part 3

This course is the third part of a three-course series that covers the skills needed to perform basic database design and development in Access 2019/2021. This course focuses on managing the database and supporting complex database designs, including import and export of data; using action queries to manage data; creating complex forms and reports; macros and Visual Basic for Applications (VBA); and tools and strategies to manage, distribute, and secure a database.

Microsoft Excel 2016/2019 - Data Analysis with PivotTables

Advances in technology have made it possible to store ever-increasing amounts of data. Along with this, the need to analyze that data and gain actionable insight is greater than ever. Participants 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 participants gain a competitive edge. Participants will not only be able to summarize data to analyze, 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 for success for everyone involved.

Microsoft Excel 2016/2019 - Data Analysis with Power Pivot

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 analyze large amounts of data quickly. Fortunately, Excel provides Power Pivot to help you organize, manipulate, and report on your 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 analyzing data.

Microsoft Excel for Office 365 - Data Analysis with PivotTables (v1.1)

Advances in technology have made it possible to store ever-increasing amounts of data. Along with this, the need to analyze data and gain actionable insight is greater than ever. You already have experience working with Microsoft 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.

Microsoft Excel for Office 365 - Data Analysis with PowerPivot (v1.1)

Microsoft Excel for Office 365 or Office 2019: Dashboards [v1.1]

Today's world runs on data more than ever before and that's a trend not likely to change, or even slow down, any time soon. 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 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, and present it in a visually compelling format that enables decision makers to view key trends and gain insights. And that's exactly what this course aims to help you do.

Microsoft Office Excel 2019/2021 Part 1

This course aims to provide you with a foundation for Excel knowledge and skills, which you can build upon to eventually become an expert in data manipulation. 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. It will also make these tasks much easier for you to accomplish, and in much less time, than if you used traditional pen-and-paper methods or non-specialized software.

Microsoft Office Excel 2019/2021 Part 2

This course builds upon the foundational knowledge presented in the Microsoft Office Excel 2019/21: 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.

Microsoft Office Excel 2019/2021 Part 3

This course builds upon the foundational and intermediate knowledge presented in the Microsoft Office Excel 2019: Part 1 and Microsoft Office Excel 2019: 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.

Microsoft Office PowerPoint 2019/2021: Part 1

How do you grab and maintain an audience's focus when you're asked to present important information? By being clear, organized, and engaging. And, that is exactly what Microsoft Office PowerPoint 2021 can help you do. Today's audiences are tech savvy, accustomed to high-impact multimedia content, and stretched for time. By learning how to use the vast array of features and functionality contained within PowerPoint 2021, you will gain the ability to organize your content, enhance it with high-impact visuals.

Microsoft Office PowerPoint 2019/2021: Part 2

Meetings, instruction, training, and pitches are all part of our daily lives. We are often called upon to deliver presentations with little notice, at multiple venues, and with varying requirements. 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. Microsoft PowerPoint 2021 provides you with all these tools that can help you.

Microsoft Office Word 2019/2021: Part 1

Microsoft Word 2021 is designed to help you move smoothly through the task of creating professional-looking documents. Its rich features and powerful tools can make your work easy, and even fun. In this course, you'll learn how to use Word 2021 to create and edit simple documents; format documents; add tables and lists; add design elements and layout options; and proof documents.

Microsoft Office Word 2019/2021: Part 2

In this course, you will work with features such as formats, styles, and templates to create professional documents with a consistent look and feel. You will add visual interest to your documents by using the tables and charts features. Quick Parts and templates provide efficiency and consistency when adding content, and long complex documents can be simplified and managed in Master Documents. Finally, you will use the mail merge feature to automate sending individual letters to customers.

Microsoft Office Word 2019/2021: Part 3

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.

Microsoft OneNote for the Desktop

Microsoft Outlook 2019/2021: Part 1

Microsoft Outlook 2019/2021: Part 2

In this course, you will customize command sets, configure mail accounts, set global options, perform advanced searches, apply filters to intercept mail and control spam, create rules to automate mail management tasks, work with calendars and contacts, manage tasks, preserve data with archives and data files, as well as share and delegate access to your Outlook items.

Microsoft Power BI: Data Analysis Practitioner (Second Edition) (v1.3)

Creating data-backed visualizations is key for data scientists, or any professional, 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 it enables users to quickly create visualizations of connected data to gain insights, show trends, and create reports. Power BI's data connection capabilities and visualization features go far beyond those that can be found in spreadsheet.

Microsoft Power BI: Data Analysis Professional (Second Edition) (v1.3)

Creating data-backed visualizations is key for data scientists, or any professional, to explore, analyze, and report insights and trends from data. Power BI was built to connect to a wide range of data sources, and it enables users to quickly create visualizations of connected data to gain insights, show trends, and create reports. Power BI's data connection capabilities and visualization features go far beyond those that can be found in spreadsheets, enabling users to create compelling and interactive work

Microsoft Project 2016 - Part 1

This course is designed to familiarize students with the basic features and functions of Microsoft Project Professional 2016 so they can use it effectively and efficiently in a real-world environment.

Microsoft Project 2016 - Part 2

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.

Microsoft Project 2019/2021: Part 1

Welcome to Microsoft Project 2019/2021: Part 1. This course is designed to familiarize you with the basic features and functions of Microsoft Project so you can use it effectively and efficiently in a real-world environment. This course covers the critical knowledge and skills a project manager needs to create a project plan with Project during the planning phase of a project. In other words, if your supervisor assigns you to lead a project, this course will enable you to draft a project plan with Project and share it with your supervisor (and others) for review and approval.

Microsoft Project 2019/2021: Part 2

This course covers the advanced knowledge and skills a project manager needs to update a project plan in Project during the execution, monitoring, and controlling phases of a project. In other words, once your project plan is approved by the project sponsor, this course will enable you to manage the project so that it is completed on time, within budget, and according to scope.

Microsoft Publisher for Office 2019/2021

Microsoft Publisher for Office 365 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 online sharing and mail merge features, which are handy when you need to send publications.

Microsoft Teams for Business Users

This course is designed to help you master Microsoft Teams, the key communications tool in the suite of Microsoft 365 productivity apps. Microsoft Teams enables individuals and organizations to chat, share ideas, collaborate on files, and essentially, work together. You can use Teams to have a quick chat with a colleague, participate in a virtual meeting, make an online call, and share files and resources. The Microsoft Teams app is available in three versions: a desktop app, a web app, and a mobile app. Once you are familiar with the Teams desktop app, you can easily transfer that knowledge and work in the web and mobile apps to take advantage of connecting through Teams wherever your work takes you.

Microsoft Visio 2019/2021 - Part 1

From the earliest eras of human existence, visual images have been used to represent knowledge, data, and information. Beginning with the Paleolithic cave paintings and continuing to today's most complex computer networks, these images leverage the ability of the human brain to rapidly perceive patterns and trends from visual representations. In today's workplace, visual diagrams are an essential part of communication, from road maps to sales flows to process charts.

Microsoft Visio 2019/2021 - Part 2

Microsoft Visio stands out among similar applications because of its unique ability to draw a wide variety of diagrams, flowcharts, workflows, and organization structures anything that can be represented by shapes connected by lines. Today, Visio is well integrated with other members of the Office family as well as Microsoft's cloud-based services. This greatly enriches the sharing and publishing of Visio drawings.

Microsoft Windows 11: Using Windows 11

Whether you're new to computers or have used them in the past, this class will help you become more comfortable using Windows 11 by familiarizing you with the Windows 11 user interface and its basic capabilities. In this course, you will explore Windows 11 and learn how to work with locally installed apps and cloud-based apps, browse the Internet, and manage basic Windows 11 settings.

Getting the Most from Your Documents and Presentations with GenAI

Generative Artificial Intelligence (GenAI) tools like ChatGPT, Copilot, Gemini™, and Claude have revolutionized the way business users approach their work. These tools enhance productivity by speeding up tasks and offering creative solutions.

Getting the Most from Your Spreadsheets with GenAI

No matter what spreadsheet software you use, what the data is about, or how it's structured, you can use freely available generative AI tools to enhance your productivity and help you find solutions to problems that can guide crucial business decisions.