Data Analysis with Excel

What is Excel?

Understanding the Interface

Creating and Saving a Workbook:

QUIZ

Typing in Cells

Copying, Cutting, and Pasting:

Basic Formatting (Font, Color, Borders)

Sorting a data

Filtering a data

Using Tables

Addition, Subtraction, Multiplication, Division

Using the SUM and AVERAGE Functions

Basic Function Syntax

IF Statements

Nested IF Statements

COUNT, COUNTA, COUNTIF, SUMIF

Introduction to Cell Referencing

Creating Basic Charts (Bar, Line, Pie)

Formatting Charts

What Is a PivotTable

Creating and Using a Basic PivotTable

Using a PivotChart (Visualization)

Introduction to VLOOKUP 1

Introduction to HLOOKUP

Conditional Formatting