Microsoft Excel and GenAI

Learn how to make SharePoint online relevant to your team by using a sites functionality to help you share information and collaborate with your colleagues.

This course is intended for power users and IT professionals who are tasked with working within the SharePoint 2016 environment and conduct site collection and site administration. This course is for an on-premise SharePoint environment.

The course is appropriate for existing SharePoint on-premises administrators and new administrators to Office 365 who need to understand how to correctly setup SharePoint Online for their company. The course will also help SharePoint on-premise administrators understand the differences between SharePoint on-premises and SharePoint Online.

In this course, you will analyze and visualize data using Excel and associated tools.

This course teaches concepts by deep-dive on-hand exercises. Throughout the course, you will learn data wrangling with hands-on exercises and activities. You’ll find checklists, best practices, and critical points mentioned throughout the lessons, making things more interesting.

This course covers methods and practices for performing advanced data analytics at scale.

Master the skills to create polished, professional technical documents with advanced formatting techniques that enhance consistency, efficiency, and usability

This introductory and beyond level course is for technical users newer to Python who want to learn advanced data handling and transformation skills, using the latest tools and techniques. The course is approximately 50% hands-on to 50% lecture ratio, combining expert lecture, real-world demonstrations and group discussions with machine-based practical labs and exercises. Student machines are required.

Using Data Analysis Expressions to solve common business problems in Power BI

Use the advanced PivotTable functionality in Excel to analyze your raw data

Gain a solid understanding of Power Pivot to maximize your effectiveness when analyzing data

Put the full power of Excel right at your fingertips: collaborate, automate, and use conditional logic to construct and apply elaborate formulas and functions

Provides a foundation for Excel knowledge and skills

Start down the road to creating advanced workbooks and worksheets to help deepen understanding of organizational intelligence

This course introduces working with shared documents in the familiar Office 365 online apps—Word, PowerPoint®, and Excel®—as an alternative to installing the Microsoft® Office desktop applications. This course also introduces several productivity apps including Yammer™, Planner, and Delve® that can be used in combination by teams for communication and collaboration.

Builds upon the foundational knowledge presented in the Microsoft Outlook for Office 365/2019: Part 1 course and will help you customize a communication system well-suited to your work style

Use Outlook to compose and handle your email communications and to manage your calendar, contacts, and tasks.

This course is designed for professionals in a variety of job roles who are currently using desktop or web-based data management tools such as Microsoft® Excel® or SQL Server® reporting services to perform numerical or general data analysis. This course is also designed for professionals who want to pursue the Microsoft Power BI Data Analyst (Exam PL-300) certification.

This course is designed to familiarize you with some of the advanced features and functions of Microsoft Project so you can use it effectively and efficiently in a real-world environment

Use Microsoft Project effectively and efficiently in a real-world environment.

SharePoint 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

In this course, you will use generative AI tools to help you develop text and images that you can use in your word processor or desktop publishing application.

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.

You will learn fundamental Word skills

Tackle more advanced features of Word

Course Objectives: In this course, you will use a typical SharePoint team site to work collaboratively with other team members. You will: Launch a SharePoint site and navigate among the pages and resources provided by the site. Use SharePoint lists to track and view information. Use document libraries to store and organize documents. Find, share, and archive content stored in SharePoint. Author documents as a member of a SharePoint team site.

Course Objectives: In this course, you will use Microsoft Teams to communicate and collaborate with your colleagues. You will: Send messages to colleagues using Teams. Call and meet with people in Teams. Lead a meeting. Configure your Teams environment. Share files and app content. Create and configure Teams.

Learn to streamline your email workflow with practical Outlook tools, including folder management, rules, advanced inbox customization, and search techniques, to achieve better organization and productivity.

If you are someone with existing SQL or SQL Server knowledge (or someone highly versed in different data repositories), this is the Power BI course for you. This course covers the various methods and best practices that are in line with business and technical requirements for modeling, visualizing, and analyzing data with Power BI.

In this course, you will develop and deploy VBA modules to solve business problems.

In this course, you will use various Python tools to load, analyze, manipulate, and visualize business data.