Push the limits of what Excel can do in Excel Advanced User, a hands-on course designed for experienced users who want to solve real-world problems with confidence and precision. Building on skills from our Novice and Business User classes, this advanced training explores powerful tools like auditing and error-handling, macros, and data import/export. You'll learn how to automate repetitive tasks with recorded macros, troubleshoot complex formulas, and cleanly move data between Excel and other platforms. We'll also explore array formulas, date and text functions, and what-if analysis to model and test business scenarios. Whether you're optimizing reports, preparing data for other systems, or building smarter workflows, this course gives you the skills to make Excel your ultimate productivity partner.

Take your Excel skills to the next level with Excel Business User, a dynamic and practical class built for professionals who want to work smarter—not harder—with data. This hands-on course builds on the fundamentals taught in Excel for the Novice and dives into advanced tools that help you manage, analyze, and present complex business data with confidence. You’ll work with PivotTables, custom formulas, data validation, and conditional formatting to uncover insights and streamline reporting. Learn how to organize large workbooks, create interactive tables, apply powerful presentation features, and collaborate effectively with others. If you’re ready to make Excel work for you, this engaging, real-world-focused class is the perfect next step.

Take your Excel skills to the next level with Excel Business User, a dynamic and practical class built for professionals who want to work smarter—not harder—with data. This hands-on course builds on the fundamentals taught in Excel for the Novice and dives into advanced tools that help you manage, analyze, and present complex business data with confidence. You’ll work with PivotTables, custom formulas, data validation, and conditional formatting to uncover insights and streamline reporting. Learn how to organize large workbooks, create interactive tables, apply powerful presentation features, and collaborate effectively with others. If you’re ready to make Excel work for you, this engaging, real-world-focused class is the perfect next step.

Learners who complete this program will receive a 50% discount voucher to take the PL-900 Certification Exam.

Business analysis is a field that is becoming increasingly important in many different industries. As organizations become more data-driven, the need for skilled analysts who can help them make sense of this data is growing. Jobs related to Business Analysis are projected to increase by 14% from 2018 to 2028. That is 9% higher than the average growth rate for all occupations.¹

The role of a business analyst is crucial in guiding organizations through data-driven decision-making. They analyze, interpret, and document business processes and data, providing insights to shape strategic decisions.

This Microsoft Professional Certificate prepares you for an entry-level role in this dynamic field, offering a unique blend of technical and strategic skills vital in today's market. As industry leaders in technology and business solutions, Microsoft offers unparalleled training in business analysis.

The curriculum combines videos, assessments, and hands-on activities, offering a practical understanding of these concepts in a business context.

When you graduate, you’ll have tangible examples to talk about in job interviews and you’ll also be prepared to take the Microsoft PL-900 Certification Exam.

^{1 Iacolino, T. (2023, March 21). Exploring the Top Industries Embracing Business Analysis Professionals. IIBA}

Applied Learning Project

This program has been uniquely mapped to key job skills required in business analyst roles. In each course, you’ll be able to consolidate what you have learned by completing a hands-on project that simulates real-world business analysis scenarios. You’ll also complete a final capstone project where you’ll work through the process of solving a fictional business problem as a business analyst. The project will include practicing on:

• A real-world scenario focused on investigation, stakeholder management, business process improvement, forming a business case, requirements engineering, project delivery and monitoring, and solution validation.

To round off your learning, you’ll take a mock exam that has been set up in a similar style to the industry-recognized Microsoft Exam PL-900: Microsoft Power Platform Fundamentals.