Conditional Formatting

Logical Functions: (IF, IFS, COUNTIF, COUNTIFS, SUMIF, SUMIFS, AVERAGEIF, AVERAGEIFS, AND, OR)

Creating tables and Design Sort

Sort, Filters and Slicers

Graph Representations

Creating PivotTables for summarizing data.

Grouping data, filtering data, creating calculated fields in PivotTables.

Creating bar, column, line, and pie charts.

Slicers with multiple charts

PRODUCT, CEIL, FLOOR, ROUND, ABS, SIN, COS, LEN, UPPER, LOWER, LEFT, RIGHT, SEARCH, CONCATENATE, EXACT, PROPER

DATE, YEAR, MONTH, DAY, DAY360, TEXT, EDATE, DATEDIF, TODAY, TIME, HOUR, MINUTE, SECOND, NOW

VLOOKUP, HLOOKUP, XLOOKUP, MATCH, INDEX

VLOOKUP, HLOOKUP, XLOOKUP, MATCH, INDEX with multiple sheets

Text to Columns

Remove Duplicates

FILTER

Data Validations and Dropdown List

Use of Flash Fill

Goal seek and data table

Forecast sheet

Group and ungroup data

Apply the subtotal

Header and Footer

Freeze Row and Column

Basic use of MACRO

Designing Interactive Dashboards with Charts & Graphs

Conditional Formatting & Data Validation for Better Data Insights

Using Slicers & Timeline Filters for Reports

Importing & Exporting Data from Databases & Web Sources

Working with Google Sheets

Protecting & Securing Excel Files (Data Protection & Encryption)

Keyboard Shortcuts for Faster Workflows

Dynamic Charts & Interactive Forms

Excel Best Practices & Error Handling