Microsoft Office Productivity Tools

Microsoft Office Access: 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 Office Access: Part 1

Data is everywhere. Most job roles today involve some form of data management. Virtually everyone is affected in some way by the need to manage data. A relational database application such as Microsoft 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 Office Access: 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 Office Excel: Dashboards

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: Data Analysis and Visualization

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 Office Excel: Data Analysis with PivotTables

Advances in technology have made it possible to store ever-increasing amounts of data. Being able to harness the power of advanced PivotTable features and create PivotCharts will help you to gain a competitive edge.

Microsoft Office Excel: Data Analysis with PowerPivot

This course will empower you to analyze large amounts of data quickly using Power Pivot in Microsoft Excel.

Microsoft Office Excel: 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: Part 2

This course builds upon the foundational knowledge presented in the Microsoft Office Excel: 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: Part 3

Microsoft Office Excel: VBA

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 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 Office OneNote

Mastering Microsoft Outlook - Working Smarter

Audience: Professionals seeking to optimize their time and task management using Outlook

Microsoft Office Outlook: 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 Office Outlook: Part 1

Microsoft Office Forms

Microsoft Forms seamlessly integrates with other applications like Excel, SharePoint, and OneDrive. This integration facilitates data storage, sharing, and collaboration.

Microsoft Planner and Forms

In this course, you will learn to effectively organize tasks and gather data using Microsoft Planner and Microsoft Forms.

Mastering Microsoft PowerPoint – Working Smarter

By the end of the course, professionals will be equipped to deliver presentations that inform, persuade, and inspire.

Microsoft Office PowerPoint: 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 provides you with all these tools that can help you.