Certified Microsoft Excel Expert (Level-2) Professional

This course will enable you to become an MS Excel Expert. In this course, you will learn the most important tools and techniques that can be used in creating a basic to an advanced effective dashboard.

image

BGMC Group

What you will learn

Upon successful completion of this course, participants will be able to:

Combine and Import invoice

How to use Excel formulas to add interactivity to your reports

How to analyze a data with Excel PivotTables and Pivot Charts

How to use Excel Power Query for data cleaning and transformation.

How to use Power Pivot to manage huge rows of data without breaking down

How to use DAX measures to speed up analysis

How to build responsiveness in your spreadsheet

How to build Pivot Table-based Hotel Management dashboards for easy interactivity

How to build non-standard Excel charts using smart techniques.

How to create a professional Hourly Production Stats dashboard from scratch.

Course content

Course Description

FAQ

image
  • £799 / one time