Advanced Excel (Intermediate to Advanced Level) Online Training on 27-May-2018 - Info2Excel

Microsoft Excel (Intermediate to Advanced Level) Online Hands-On Training - Info2Excel

Who Can Attend :

Anyone with basic knowledge or understanding of Excel, Working Professionals who want to enhance their Excel Skills.

About The Event

Info2Excel invites you to Webinar /Training on MS Excel.

When: Sunday, May 27^th, 2018

Time: 10:00 AM IST

Where: Online Webinar

Trainer: Mouzzam Ali

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, Match and Index.
• Logical Function: IF / ELSE, AND, OR, NOT, NESTED IF/ELSE.
• Math Functions: ROUND, TRUNC, CEILING, FLOOR, MOD, SUM, SUMIF, SUMIFS.
• Statistical Functions: AVERAGE, COUNT, COUNTA, COUNTBLANK, MAX, MIN.
• Text Functions: LEFT, RIGHT, TRIM, MID, LOWER, UPPER, PROPER, REPLACE, FIND, CONCATENATE, SEARCH, SUBSTITUTE.
• Date and Time Functions

References or Links:

• Relative Reference.
• Absolute Reference / Locking the Cells.
• Mixed Reference

Data Validations & Data Cleansing

• Restricting the user to enter valid data
• Remove duplicates
• Using Nested Functions ( Function inside a function )
• Formatting & Splitting Data into Multiple Columns.

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 Macro
• Recording a Macro.
• Running a recorded Macro with different data.