Excel Introduction

• An overview of the screen, navigation and basic spreadsheet concepts
• Various selection techniques
• Shortcut Keys

Customizing Excel

• Customizing the Ribbon
• Using and Customizing AutoCorrect
• Changing Excel’s Default Options

Using Basic Functions

• • Using Functions – Sum, Average, Max,Min, Count, Counta
• Absolute, Mixed and Relative Referencing

Formatting and Proofing

• Currency Format
• format painter
• format dates
• custom special formats
• Formatting Cells with Number formats, Font formats, Alignment, Borders, etc
• Basic conditional formatting

Mathematical FunctionsS 

• SumIf, SumIfs CountIf, CountIfs AverageIf, AverageIfs, Nested IF, IFERROR Statement, AND, OR, NOT

Protecting Excel

• File Level Protection
• Workbook, Worksheet Protection

Text Functions

• Upper, Lower, Proper
• Left, Mid, Right
• Trim, Len, Exact
• Concatenate • Find, Substitute

Sorting and Filtering

• Filtering on Text, Numbers & Colors
• Sorting Options
• Advanced Filters on 15-20 different criteria(s)

What If Analysis

• Goal Seek
• Scenario Analysis
• Data Tables (PMT Function)
• Solver Tool

Logical Functions

• If Function
• How to Fix Errors – if error
• Nested If
• Complex if and or functions

Lookup Functions

• Index and Match
• Creating Smooth User Interface Using Lookup
• Nested VLookup
• Reverse Lookup using Choose Function
• Worksheet linking using Indirect
• Vlookup with Helper Column

Pivot Tables

• Basic and Advanced Value Field Setting
• Classic Pivot table
• Choosing Field
• Filtering PivotTables
• Modifying PivotTable Data

Charts and slicers

• Various Charts i.e. Bar Charts / Pie Charts / Line Charts
• Using SLICERS, Filter data with Slicers
• Manage Primary and Secondary Axis

Excel Dashboard

• Planning a Dashboard
• Adding Tables and Charts to Dashboard
• Adding Dynamic Contents to Dashboard

VBA Macro

Introduction to VBA

• What Is VBA?
• What Can You Do with VBA?
• Recording a Macro
• Procedure and functions in VBA

Variables in VBA

• What is Variables?
• Using Non-Declared Variables
• Variable Data Types
• Using Const variables

Message Box and Input box Functions

• Customizing Msgboxes and Inputbox
• Reading Cell Values into Messages
• Various Button Groups in VBA

If and select statements

• Simple If Statements
• The Elseif Statements
• Defining select case statements

Looping in VBA

• Introduction to Loops and its Types
• The Basic Do and For Loop
• Exiting from a Loop
• Advanced Loop Examples