Just take a demo session then decide.

BASIC + ADVANCED EXCEL TRAINING

Course - 1. BASIC EXCEL TRAINING

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

•       Formatting Dates

•       Custom and Special Formats

•       Formatting Cells with Number formats, Font formats, Alignment, Borders, etc •

Mathematical Functions

•       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

Date and Time Functions

•       Today, Now

•       Day, Month, Year

•       Date, Date if, DateAdd

•       EOMonth, Weekday

Advanced Paste Special Techniques

•       Paste Formulas, Paste Formats

•       Paste Validations

•       Transpose Tables

New in Excel 2013 / 2016 & 365

•       New Charts – Tree map & Waterfall

•       Sunburst, Box and whisker Charts

•       Combo Charts – Secondary Axis

•       Adding Slicers Tool in Pivot & Tables

•       Using Power Map and Power View

•       Forecast Sheet

•       Sparklines -Line, Column & Win/ Loss

•       Using 3-D Map

•       New Controls in Pivot Table – Field, Items and Sets

•       Various Time Lines in Pivot Table

•       Auto complete a data range and list

•       Quick Analysis Tool

•       Smart Lookup and manage Store

Sorting and Filtering

•       Filtering on Text, Numbers & Colors

•       Sorting Options

•       Advanced Filters on 15-20 different criteria(s)

Printing Workbooks

•       Setting Up Print Area

•       Customizing Headers & Footers

•       Designing the structure of a template

•       Print Titles –Repeat Rows / Columns

Course 2. ADVANCED EXCEL TRAINING

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

Data Validation

•       Number, Date & Time Validation

•       Text and List Validation

•       Custom validations based on formula for a cell

•       Dynamic Dropdown List Creation using Data Validation – Dependency List

Lookup Functions

•       Vlookup / HLookup

•       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

•       Creating Simple Pivot Tables

•       Basic and Advanced Value Field Setting

•       Classic Pivot table

•       Choosing Field

•       Filtering PivotTables

•       Modifying PivotTable Data

•       Grouping based on numbers and Dates

•       Calculated Field & Calculated Items

•       Arrays Functions

•       What are the Array Formulas, Use of the Array Formulas?

•       Basic Examples of Arrays (Using ctrl+shift+enter).

•       Array with if, len and mid functions formulas.

•       Array with Lookup functions.

•       Advanced Use of formulas with Array.

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