Applied Excel for Workplace Workflow, Reporting, and Data Management

E

100

This function calculates the mean of a group of numbers.

AVERAGE

200

This function counts cells containing numbers.

COUNT

300

This function counts all non-empty cells.

COUNTA

X

100

A graphical representation used to visualize data trends.

Chart

200

Information gained from analyzing data.

Insights

300

This helps organizations make informed decisions based on data.

Data Analysis

C

100

This feature displays only records that meet specific criteria.

Filtering

200

Sorting from Z to A is also known as this order.

Descending Order

300

This type of filter allows users to focus on specific records in a dataset.

Data Filter

L

100

A visual interface that displays key metrics and reports in one view.

Dashboard

200

Interactive controls used to filter dashboard data.

Slicers

300

This dashboard component measures performance.

KPI (Key Performance Indicator)