Excel Advance Course Module

Module 1: Introduction To Excel
What is excel?

Types of Object in excel.

Understand rows and columns in excel.

Excel reference addressing.

 Discuss different types of TABS in excel (File/Home/Insert/Design/Page

Layout/References /Review/View/Developer)

Module 2: File Tab
Info

New

Open

Save As

Share

Account

Option

Module 3: Home Tab
Clipboard (Paste / Cut /Copy/ Format Painter)

Font

Alignment

Number

Styles

Cells

Editing

Module 4: Insert Tab
Tables

Charts

Sparkline

Filters

Links

Text

Module 5: Page Layout
Page Setup

Sheet Option

Arrange

Module 6: Formulas
Basic Function( Average, AverageA, Sum, Sumif, Sumifs, Count, Countif, Countifs)

Logical Function( AND, OR, NOT )
VLOOKUP

HLOOKUP

Pivot Table

Define Names

Formula Auditing

Module 7: Data
Get External Data

 Connections

Sort & Filter

Data Tools

Module 8: Review
 Comments

Changes

Module 9: View
Workbook View

Show

Window

Module 10: Pivot Table
Group

Filter

Data

Action

Calculation

Pivot Chart

Layout

PivotTable Style Option

Module 11 : Excel Macro
Introduction To Macro

How to add Developer TAB

Macro Controls

Inserts Buttons

View Design Mode

View Code Mode

View Properties

• Explanation of Different M-VBA TABS and its usages.

Clear (All, Format, Comments, Hyperlink, Content, Insert, delete, color)