Advanced Excel (Intermediate to Advanced Level) Webinar - Info2Excel

Microsoft Excel (Intermediate to Advanced Level) Webinar - Info2Excel

About The Event :

Info2Excel invites you to Webinar/Training on MS Excel.

When: Sunday, March 11, 2018

Time: 10:30 AM IST

Where: Online Webinar

Trainer: Mouzzam Ali

Agenda /Advanced Excel Contents :

Introduction to MS Excel

• Introduction to MS Excel, Quick Review on MS Excel Options, Ribbon, Worksheets and Toolbar

Working with Formulas/Functions

• Lookup and Reference Functions: VLOOKUP, HLOOKUP, TRANSPOSE etc.
• Logical Function: IF / ELSE, AND, OR, NOT, TRUE, NESTED IF/ELSE etc.
• Math Functions: ROUND, CEILING, FLOOR, MOD, SUMIF, SUMIFS etc.
• Statistical Functions: AVERAGE, AVERAGEA, COUNT, COUNTA, COUNTBLANK, MAX, MAXA, MIN, MINA etc.
• Text Functions: LEFT, RIGHT, TEXT, TRIM, MID, LOWER, UPPER, PROPER, REPLACE, FIND, SEARCH, SUBSTITUTE, TRIM, TRUNC, CONCATENATE etc.
• Date and Time Functions

References or Links 

• Relative
• Absolute
• Mixed Reference

 Data Validations

• Restricting the user to enter valid data
• Remove duplicates
• Using Nested Functions

Data Sorting and Filtering

• Sorting Data
• Using Filters to Sort Data

Pivot Tables 

• Creating Pivot Tables
• Using Pivot Table Options

 Pivot Charts 

• Creating Pivot Charts and their Usage

Macros 

• Introduction to VBA Macro
• Recording Macro