Access - Part 2

In this course, learners will discover how to apply generative AI to streamline daily tasks, enhance decision-making, and drive meaningful business outcomes. Learners will understand how to use Microsoft 365 Copilot and its functionalities to improve their productivity. The course focuses on real-world use cases—no coding required—making it ideal for those who want to confidently integrate AI into their work.

In this course, learners will explore how to lead AI transformation across their organization. They’ll learn practical strategies to identify high-impact AI opportunities, align investments with business goals, and champion responsible AI practices. The course emphasizes real-world applications and strategic decision-making—no technical expertise required—making it ideal for senior leaders who want to confidently drive AI adoption and innovation.

Professionals using advanced query design techniques complete complex data retrieval tasks up to 40% faster and with greater accuracy than those relying only on basic tools. The Microsoft Access Training – Access Part 2 course equips you with the advanced features, queries, reports, and relational design practices, that make this level of efficiency possible. In this course, you will expand your knowledge of relational database design, promote quality input from users, and learn how to improve database efficiency while strengthening data integrity. You’ll also implement advanced features in tables, queries, forms, and reports, giving you the ability to build databases that are more reliable, usable, and scalable. The training focuses on optimization of Access databases, including performance tuning, normalizing data, applying data validation rules, and improving usability.

Organizations that rely on instinct often miss key opportunities. The ones that trust their data? They win more customers, keep them longer, and earn more in the process. In fact, data-driven organizations are 23 times more likely to acquire customers, six times more likely to retain them, and 19 times more likely to be profitable. This course shows you how to use Microsoft Excel to make sense of data and communicate it clearly. You’ll learn how to organize, clean, and analyze datasets, build dashboards that update with a click, and present insights using tools like PivotTables, Power Pivot, and geospatial charts. For professionals responsible for reporting, forecasting, or decision support, this training delivers practical, real-world skills you can apply right away.

Being able to harness the power of PivotTable features & create PivotCharts will help students gain an edge. Not only will students be able to summarize data to analyze, but they can organize the data in a way that can be meaningfully presented to others.

Excel provides Power Pivot to help students organize, manipulate, and report on their data in the best way possible. In this course, students gain a solid understanding of Power Pivot to maximize their effectiveness when analyzing data.

Ready to start building your Excel skills from the ground up? This beginner Excel training course provides the foundation you need to grow your knowledge and become an expert in data manipulation over time. You'll learn how to create and format worksheets, perform basic calculation operations, work with charts and tables, and organize data efficiently. This course also covers Microsoft Office Specialist Program exam objectives to help you prepare for the Excel Associate (Office 365 and Office 2019): Exam MO-200 and Excel Expert (Office 365 and Office 2019): Exam MO-201. Master the basics—and open the door to more advanced skills in data analysis, reporting, data visualization, and spreadsheet management.

Ready to go beyond the basics? Our Intermediate Excel Training course is perfect for professionals who want to turn raw data into clear insights using Microsoft Excel. Whether you're managing projects, tracking budgets, or building reports, this course gives you the tools to work smarter—not harder. You’ll dive into features like advanced functions, data analysis tools, PivotTables, and charting—all designed to help you confidently modify spreadsheets and workbooks to support better decision-making. With over 60% of employers saying Excel skills are in high demand, this training is a smart step in growing your career. This course builds on the foundational knowledge from Excel – Part 1 and takes your skills to the next level. It aligns with Microsoft Office Specialist exam objectives, helping you prepare for the Excel Associate (MO-200) and Excel Expert (MO-201) certifications. You'll learn how to build and modify advanced workbooks that streamline processes and enhance data insights in your organization.

Ready to take your spreadsheet skills to the next level? This Advanced Excel Training course is designed for professionals who want to work smarter—not harder—with Microsoft Excel. You’ll build upon the foundational and intermediate knowledge from Microsoft Excel – Part 1 and Microsoft Excel – Part 2, helping you get the most out of your Excel experience. Learn to collaborate more effectively with colleagues, automate complex or repetitive tasks, and use conditional logic to create powerful formulas and functions. The more you master Excel’s advanced tools, the more you can shift your focus from manual work to extracting the insights your organization needs from its vast amounts of data. From building dynamic dashboards to forecasting trends, this course unlocks the full potential of Excel at your fingertips.

In This Course, students will analyze Excel data, create PivotTables, Pivot Charts as well as Analyzing Pivot Tables.

Dive deep into the world of Microsoft Copilot and how it can maximize your efficiency when using Microsoft Excel. Participants will delve into the advanced features of Microsoft Copilot, learning how to streamline their workflow and optimize their use of Microsoft Excel. Through hands-on exercises and expert-led instruction, attendees will gain practical experience and confidence in leveraging Microsoft Copilot to its fullest potential.

Dive deep into the world of Microsoft Copilot and how it can maximize your efficiency when using Microsoft Outlook. Participants will delve into the advanced features of Microsoft Copilot, learning how to streamline their workflow and optimize their use of Microsoft Outlook. Through hands-on exercises and expert-led instruction, attendees will gain practical experience and confidence in leveraging Microsoft Copilot to its fullest potential.

Dive deep into the world of Microsoft Copilot and how it can maximize your efficiency when using Microsoft PowerPoint. Participants will delve into the advanced features of Microsoft Copilot, learning how to streamline their workflow and optimize their use of Microsoft PowerPoint. Through hands-on exercises and expert-led instruction, attendees will gain practical experience and confidence in leveraging Microsoft Copilot to its fullest potential.

Dive deep into the world of Microsoft Copilot and how it can maximize your efficiency when using Microsoft Teams. Participants will delve into the advanced features of Microsoft Copilot, learning how to streamline their workflow and optimize their use of Microsoft Teams. Through hands-on exercises and expert-led instruction, attendees will gain practical experience and confidence in leveraging Microsoft Copilot to its fullest potential.

Dive deep into the world of Microsoft Copilot and how it can maximize your efficiency when using Microsoft Word. Participants will delve into the advanced features of Microsoft Copilot, learning how to streamline their workflow and optimize their use of Microsoft Word. Through hands-on exercises and expert-led instruction, attendees will gain practical experience and confidence in leveraging Microsoft Copilot to its fullest potential.

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® Office Publisher is an application capable of producing greeting cards, certificates, newsletters, and other printed publications. Publisher includes a large collection of templates that provide a great way to start a new publication.

In this course, students will learn how to create, configure, and manage a SharePoint team site so that your team or organization can share information and collaborate effectively. This course is for an on-premise SharePoint environment.

MS-4018: Draft, analyze, and present with Microsoft 365 Copilot directs users to learn common prompt flows in Microsoft 365 apps including PowerPoint, Word, Excel, Teams, and Outlook. It also introduces Microsoft 365 Copilot Chat and discusses the difference between work and web grounded data.

MS-4019: Transform your everyday business processes with agents examines Microsoft prebuilt agents and agents for the everyday business user in Microsoft 365 Copilot. Hands-on lab exercises help students learn how to create agents in both Microsoft 365 Copilot Chat and SharePoint.

Understand what Microsoft 365 Copilot Chat is and how it can help you in your daily work. Learn how to access Copilot Chat experiences and write prompts.

This course provides a way for students to create and collect their notes. This course will introduce students to using OneNote notebooks to store a variety of content in an organized way, access the content from anywhere, and also share it.

Discover the powerful mail merge feature from Outlook to quickly build customized emails, labels, and letters. Create and set up data files from scratch or connect to names in Excel or Outlook.

Explore how to quickly locate email messages. Learn to use advanced efficiency features of Outlook.

In this course, you will use Outlook to send, receive, and manage email messages, manage your contact information, schedule appointments and meetings, create tasks and notes for yourself, and customize the Outlook interface to suit your working style. This course covers the Microsoft Office Specialist Program exam objectives to help you prepare for the Outlook Associate (Office 365 and Office 2019): Exam MO-400 certification exam.

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. This course builds upon the foundational knowledge presented in the Microsoft Outlook - Part 1 course and will help you customize a communication system well-suited to your work style. This course covers Microsoft Office Specialist Program exam objectives to help you prepare for the Outlook Associate (Office 365 and Office 2019): Exam MO-400.

Want to give your presentations more power and polish? This PowerPoint training course is your perfect starting point. Designed as a beginner-friendly Part 1 introduction, this one-day, instructor-led class teaches you how to use PowerPoint to create and deliver professional, visually engaging slides. Through real-world scenarios and hands-on practice, you’ll learn to build a strong PowerPoint presentation using built-in templates, formatted text, graphics, transitions, and animations. You’ll also get familiar with PowerPoint for the Web, OneDrive, and the essentials of working in Microsoft PowerPoint as part of your Microsoft Office subscription.

Meetings, instruction, training, pitches; these are all a part of our daily lives. 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. But 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. This course covers Microsoft Office Specialist Program exam objectives to help you prepare for the PowerPoint Associate (Office 365 and Office 2019): Exam MO-300.

VBA (Visual Basic for Applications) enables you to enhance and extend the capabilities of Microsoft® Excel® and other applications in the Microsoft® Office 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 involving the collection, processing, analysis, and visualization of data. This course will give you a good foundation for understanding, creating, and using VBA in your own Excel workbooks, show you how to work with data across different applications, and how to package the macros and functions you create so you can back them up, move them to other computers, and share them with other users

Drowning in spreadsheets, missed deadlines, and scope creep? Time to take control. This hands-on course introduces the essential tools and features of Microsoft Project. You’ll learn to create structured project plans, link tasks, manage schedules, and allocate resources. Designed for beginners, this training provides a strong foundation for delivering well-organized, trackable plans that can be reviewed and approved by key stakeholders.

How do you keep your project on track once the plan is approved? This course teaches you to manage and adjust Microsoft Project plans during the execution, monitoring, and controlling phases. With 70% of projects failing to meet scope, schedule, or cost goals, the ability to revise timelines, update task progress, and produce real-time reports is essential. You’ll gain the practical skills needed to navigate changes, reuse planning assets, and coordinate across multiple projects.

Microsoft® SharePoint®, in conjunction with the Microsoft 365™ productivity and office automation suite, provides tools to create and manage a corporate intranet, facilitate content sharing and collaboration, and enable users to create, access, store, and track documents and data in a central location. Users who already have experience as SharePoint site members and owners may be ready to move on to more advanced site-building tasks such as using custom site templates, custom themes, applying advanced permissions settings, improving security, and preparing sites to support governance and compliance. Advanced site builders may be ready to undertake more advanced site management tasks, working in conjunction with their SharePoint Administrator to create and use custom site templates, term sets and metadata, manage information governance and compliance, and get deeper into SharePoint security configuration. This course focuses on these advanced site-building and administration tasks.

Over 200 million users rely on Microsoft 365 and SharePoint—but most don’t take full advantage of its capabilities. This hands-on training gives you the skills to navigate and use SharePoint Online efficiently, helping you manage team resources, collaborate effectively, and streamline daily workflows. In this SharePoint basics training, you'll learn to manage documents, create and customize lists, search for content, and work in team sites. You'll also explore simple automation using Power Automate, all within the modern Microsoft SharePoint interface. Designed for non-technical professionals, this course equips you to confidently use SharePoint in a Microsoft 365 environment to support team collaboration, resource sharing, and task coordination.

Nearly 80% of Fortune 500 companies rely on Microsoft 365 and SharePoint to power their intranet and collaboration. Beyond storing documents, SharePoint connects sites, streamlines content management, and integrates apps that enhance productivity. The SharePoint – Site Owner with Power Platform (Modern Experience) course builds on basic SharePoint usage to teach you how to plan and manage a multi-site intranet. You will explore hub sites, advanced list management, validation rules, and integration with Power Apps to create custom user experiences. This training helps experienced site users step into a site owner role, enabling them to unify navigation, manage content efficiently, and extend SharePoint functionality with Power Platform tools.

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® provides you with an intuitive, customizable tool to easily create a professional-looking visual product by using its extensive gallery of shapes. By following the exercises in this course, you will create visually engaging diagrams, maps, and drawings, using graphical elements to make information easier to comprehend.

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. Most importantly, these shapes can be rearranged and with corresponding lines remaining intact. Visio has improved over the years as features common among Microsoft® Office applications have been added. 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. In Microsoft Visio - Part 1, you learned the basic skills needed to create and modify various Visio drawings. In Microsoft Visio - Part 2, you will learn about more advanced features—making you a more efficient and effective Visio user.

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. This course covers Microsoft Office Specialist Program exam objectives to help you prepare for the Word Associate (Office 365 and Office 2019): Exam MO-100 and Word Expert (Office 365 and Office 2019): Exam MO-101 certification exams.

Creating professional-looking documents can help you give your organization a competitive edge. Implementing time-saving features such as document templates and automated mailings helps your organization reduce expenses. Mastering these techniques will make you a valued employee in your organization. This course covers Microsoft Office Specialist Program exam objectives to help you prepare for the Word Associate (Office 365 and Office 2019): Exam MO-100 and Word Expert (Office 365 and Office 2019): Exam MO-101 certification exams.

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. 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 This course covers Microsoft Office Specialist Program exam objectives to help you prepare for the Word Associate (Office 365 and Office 2019): Exam MO-100 and Word Expert (Office 365 and Office 2019): Exam MO-101 certification exams.