This course delivers an instructor-led product showcase for Microsoft Power Automate from start to finish in an engaging and practical way. Power Automate is a diverse product, turning business processes into automated, consistent and visual workPower Automates. Power Automate is designed to interweave the various products in Office 365 as well as connect to other on-premises and web-based solutions. This course will give you the confidence to select the right actions and workPower Automate logic for your business workPower Automates.

This three-day instructor-led 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 teach you all about tables in Access. You will learn how to work with tables, understand various field types, create, and modify table relationships, and how to import and link external data.

This course gives you an introduction to forms in Access. Learn how to create forms and subforms, navigate through forms, understand various views, and use the design and layout view.

This course is designed to provide a detailed look at queries in Access. Students will learn how to create different query types, joins, and criteria to extract specific data from their database.

This course focuses on introducing all aspects of Access to the new user. Learn how to create databases, understand, and work with tables, use queries, forms, and reports.

Focuses on the design and construction of an Access database —viewing, navigating, searching, and entering data in a database, as well as basic relational database design and creating simple tables, queries, forms, and reports.

In this course, you will expand your knowledge of relational database design; promote quality input from users; improve database efficiency and promote data integrity; and implement advanced features in tables, queries, forms, and reports. Extending your knowledge of Access will result in a robust, functional database for your users. Focuses on optimization of an Access database, including optimizing performance and normalizing data; data validation; usability; and advanced queries, forms, and reports.

This course focuses on setting up Access reports. You will learn how to create and modify reports, the various report sections, how assorted report controls function and best practices to print or export a report.

This course explores what a database administrator should know regarding their database. Learn how to bring external data into Access. Explore how data normalization can optimize your database organization with the table analyzer wizard. Make your database easier to use with navigation forms and startup options. Understand important database utilities that need to be run periodically. Export Access data in different formats.

This session introduces Macros and how to use them. Automate repetitive tasks and gain more control over how you work with data. Create and run macros and with coding in Visual Basic for Applications (VBA).

The focus of this session is on using advanced LOOKUP functions in a variety of different ways to quickly find answers within a dataset. The course will also introduce a variety of useful functions regarding formula and error management. Lookup functions are one of the most frequently used advanced features in Excel, and this course will expand your knowledge of their power.