Office User

Data is everywhere. Most professional roles today involve some form of data management. Practically everyone is somehow concerned with the need to manage data. A relational database application such as Microsoft Access can help you and your organization with this task. This course is the first part of a series of three courses that cover the skills necessary to perform database design and development in Access.

This Microsoft 365 Access training focuses on designing and building an Access database—viewing, navigating, searching, and entering data in a database, as well as designing relational databases and creating simple tables, queries, forms, and reports.

Your training and experience using Microsoft Access have enabled you to acquire basic database management skills, such as creating tables, designing forms and reports, and creating queries. In this course, you will deepen your knowledge of relational database design, promote quality user contributions, improve database efficiency, ensure data integrity, and implement advanced features in tables, queries, forms, and reports. Expanding your Access knowledge will result in a robust and functional database for your users.

This Microsoft 365 Access training is the second part of a three-course series covering the skills necessary for database design and development in Microsoft Access.

This course focuses on optimizing an Access database, including performance optimization, data normalization, data validation, usability, and advanced queries, forms, and reports.

You’ve covered many of the basic functions of Microsoft Access, and now you’re ready to learn advanced Access features such as database management, advanced form design, packaging a database, encrypting a database, preparing a database for multiple-user access, and more. Knowledge of these features separate database professionals from the casual database users or occasional designers.

This course is the third part of a three-course series that covers the skills needed to perform basic database design and development in Microsoft Access.

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.

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.

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.

You already know how to get Microsoft Office 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.

This course 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.

By now, you’re already familiar with Microsoft 365 Excel, its functions and formulas, a lot of its features and functionality, and its powerful data analysis tools. You are likely called upon to analyze and report on data frequently, work in collaboration with others to deliver actionable organizational intelligence, and keep and maintain workbooks for all manner of purposes. At this level of use and collaboration, you have also likely encountered your fair share of issues and challenges. You’re too busy, though, to waste time scouring over workbooks to resolve issues or to perform repetitive, monotonous tasks. You need to know how to get Excel to do more for you so you can focus on what’s really important: staying ahead of the competition. That’s exactly what this course aims to help you do.

This course 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.

These days, most people take electronic word processing for granted. While we may still write out our grocery lists with pen and paper, we expect to use a computer to create the majority of our documents. It’s impossible to avoid word-processing software in many areas of the business world. Managers, lawyers, clerks, reporters, and editors rely on this software to do their jobs. Whether you are an executive secretary or a website designer, you’ll need to know the ins and outs of electronic word processing.

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

After mastering the basics of using Microsoft 365 Word, such as creating, modifying, and saving documents, navigating within a document, and printing, you are ready to move on to more advanced features.

In this Microsoft 365 Word training, you will learn features that allow you to create complex and professional documents with a consistent appearance. They also enable you to automate tedious tasks such as preparing a letter to send to each client of your organization.

Creating professional-looking documents can help give your organization a competitive advantage. Implementing time-saving features, such as document templates and automated mailings, helps your organization reduce costs. Mastering these techniques will make you a valuable employee in your organization.

Microsoft Word for Microsoft 365 enables you to do far more than simple word processing. Word includes advanced image manipulation tools, collaboration features, cross-referencing and linking tools, entry forms and data collection, security features, and tools to automate document production.

Being able to manipulate graphics and efficiently create, manage, revise, and distribute long documents and forms can help your organization create important and interesting documents. Implementing time-saving features that enable you to work well in a collaborative mode will benefit both you and your organization. Constructing document elements that ensure your readers have access to pertinent information at the click of a button, while at the same time protecting sensitive information, is another important skill. Mastering these skills and techniques will make you a valued employee in your organization.

In this Microsoft 365 Outlook training, you will use Outlook to send, receive, and manage email messages; manage your contacts; schedule appointments and meetings; create tasks and notes for yourself; and customize the Outlook interface to suit your working style. This course is the first in a series of two Microsoft Outlook courses for Microsoft 365. It will provide you with the basic skills you need to start using Outlook to manage your email communications, contact information, calendar events, tasks, and notes.

In this course, you will customize command sets, configure mail accounts, set global options, perform advanced searches, apply filters to intercept mail and control spam, create rules to automate mail management tasks, work with calendars and contacts, manage tasks, preserve data with archives and data files, as well as share and delegate access to your Outlook items. In short, you’ll work with a wide range of features and options and, in so doing, understand why Outlook is a leading personal management system.

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 365 PowerPoint can help you do.

Today’s audiences are tech savvy, accustomed to high-impact multimedia content, and stretched for time. By learning how to use the vast array of features and functionality contained within PowerPoint, you will gain the ability to organize your content, enhance it with high-impact visuals, and deliver it with a punch. In this course, you will use PowerPoint to begin creating engaging, dynamic multimedia presentations.

We are often called upon to deliver presentations with little notice, at multiple venues, and with varying requirements. And, some of these presentations include sensitive information that needs to be guarded. Given all the variables, it may seem an overwhelming task to deliver your content, on time, to all audiences, and to only those who need to see it. Oh, and by the way, you need to make it interesting, informative, and memorable. So, how do you do it? Without the help of a robust set of tools, it would be nearly impossible.

Microsoft PowerPoint provides you with a variety of such tools that can help you deliver content in nearly any situation, while saving time and effort. By taking advantage of these tools, you will be creating presentations that not only stand out from the crowd, but also don’t consume all of your available time.