About this course:

The main reason for the course is to enable understudies to add investigation capacities to Excel spreadsheets and to give understudies an establishment to learn further developed information examination with Excel or Power BI.

Course Objective:

• Create an Excel report
• Create Hierarchies
• Filtering Excel Data
• Formatting Excel Data
• Create excel Charts
• Create a pivot table and pivot chart
• Explain pivot tables and how to create them.
• Define the various elements of a pivot chart.
• Edit pivot tables and pivot charts.
• Explain what Excel Data tables are.
• Sort, filter, and validate data.
• Summarize data.
• Format summarized data.
• Create an Excel table
• Create a dashboard and analyze data
• Describe the dashboard.
• Filter data using a slicer.
• Add calculated columns to a dashboard.
• Find anomalies.
• Create a model of Excel data and connect to external data
• Explain an Excel Data Model and how to use it.
• Import External Data and use it.
• Link out to external data.

Audience:

This course is designed for any individual who needs to take the information analysis innovations in Excel beyond formulas and include further developed capacities, for example, hierarchies, dashboards, and connections.

Prerequisite:

Prior to attending this course, understudies must have:

Fundamental information on the MS Windows operating framework and its main usefulness.

Propelled working information on Excel spreadsheets including formulas.