Getting Started

Course Overview

Introduction to Excel

Basic Overview Of Excel
Basic Options and Data Formatting
Cell Referencing & Addressing
Copy and Fil
Worksheet Customization
Worksheet Views
Drop-down List

Logics & Functions

IF and Nested IF
Logical Functions
Text Functions
Date Functions
Creating Formulas
Calculation Formulas
Count Function
Statistical Functions
Mathematical Functions
Lookup & Vlookup Function

Digging Deeper into Excel

Privacy and Protection
Hyperlinks
Page Layout
Sorting and Filtering
Conditional Formatting
Data Validation

Tables and Charts

Understanding Tables
Getting Familiar with Charts

Macros

Introduction to Macros
Conditional Formatting using Macros