Microsoft Office

This course is an immersive, hands-on training course designed to equip IT professionals, solution architects, and business technologists with the skills to design, build, and manage intelligent AI agents using Microsoft Copilot Studio.

By the end of this course, users should be comfortable with creating new sites in SharePoint, adding and configuring libraries and other site assets; configuring site settings, assigning permissions and access rights; and working with advanced site options. They should also be familiar with basic user tasks, such as accessing the site, using document libraries, and working with files.

By the end of this course, users should be comfortable with navigating the Microsoft Access interface, creating a new database from scratch, querying a database, generating reports, sharing data, and much more.

By the end of this course, users should be comfortable managing existing databases and completing light database development and management work. Users should also know how to find information about databases and use the validation techniques covered to ensure the integrity of the data that is collected.

Learn how to use formulas and advanced functions while creating workbooks.

Learn to create, format, enhance and print simple Excel spreadsheets.

Learn how to use Excel 2016 advanced PivotTable and PivotChart functionality to summarize, analyze and present large amounts of raw data.

Learn advance Excel skills.

This course is intended to help all novice computer users get up to speed with Excel quickly.

By the end of this course users should be comfortable in creating advanced formulas, analyzing data with functions, analyzing data using functions and PivotTables, working with tables, visualizing data with charts, working with graphical objects, and enhancing workbooks.

By the end of this course, users should be comfortable in both the online and desktop environments, using automating functions, analyzing and presenting data, auditing and error checking your work, working in multiple workbooks, and accessing and distributing data.

By the end of this course, users should be able to use OneDrive, Delve, and Planner in their day-to-day workflow. They should also be able to perform administrative tasks (such as managing users and groups within Office 365), manage domains, and use the Security & Compliance Center.