Microsoft Project 2019/2021: Part 2

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

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

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

A toolbox of best practices to transform key processes and design organizations of the future. The material is geared to the ASQ exam (asq.org).

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

Expand basic database management skills

Learn advanced Access features

Tackle more advanced features of Word

Analyze business data, visualize insights, and share those insights across the enterprise

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

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

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

Create presentations that not only stand out from the crowd, but also don't consume all of your available time

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

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 perform advanced data visualization and data blending with Tableau.

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

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

This course will prepare you to use the most common basic features of Adobe Photoshop.

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.

This course is for individuals who are new to Adobe Acrobat Pro DC, but need to create and share PDF files and PDF portfolios.

This course is designed for Project Managers and/or Project Support Personnel who wish to learn industry best-practices and apply a more formal, standards-based approach to their projects. The content of this class directly aligns with the Project Management Body of Knowledge (PMBOK) and will prepare attendees who are seeking to obtain the (PMI)® Project Management Professional (PMP)® certification.

The Microsoft Power Platform helps organizations optimize their operations by simplifying, automating and transforming business tasks and processes.

Upon successful completion of this course, you will be able to use Adobe Illustrator CC to create illustrations that include graphics and text.

In this course, you will use Adobe® InDesign® to create and deliver professional looking printed and interactive documents.

Students will benefit from this course by understanding the foundational principles of project management, improving their project management skills, utilizing tools and techniques to effectively manage projects, gaining a common project management language to improve communication, and learning frameworks to identify, manage, and mitigate risk. Concepts learned in this course are immediately applicable to ongoing projects.

Work with formatting options such as styles and section breaks to automate and troubleshoot document content including table of contents, list of figures, and more.

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.

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.

In this course, you will understand and use Agile core terms, explain key Agile concepts and their importance in achieving agility, identify, engage, and leverage key stakeholders in an Agile environment, apply common Agile tools and techniques, embrace and advocate for an Agile mindset to benefit from an Agile approach, select the best practices for a project and apply them appropriately to benefit the project and organization.

In this course, you will draw complex illustrations, enhance artwork by using painting tools, customize colors and swatches, format type. Enhance the appearance of artwork, prepare content for deployment, and set up project requirements.

Upon successful completion of this course, you will be able to use Adobe InDesign CC to create and deliver professional looking printed and interactive documents.

In this course, you will use generative AI to assist you as you work with spreadsheets.

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