What is Data Analysis

Introduction of Microsoft Excel

Data Analysis with Excel

Concatenate

Len ()

Days ()

Networkdays

Sumifs()

Averageifs()

Countsifs()

Counta()

Vlookup()

Hlookup()

If ()

Iferror()

Find/Search

Left/Right

Rank()

Advanced Analysis:

Ranges and Tables

Data Cleaning: Text Functions, Dates and Times

Conditional Formatting

Sorting and Filtering

Subtotals with Ranges

PivotTables

Data Visualization

Data Validation

Working with Multiple Worksheets

Formula Auditing

What-if Analysis