Book Online Tickets for Advanced Excel (Intermediate to Advanced, Hyderabad. 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&nb

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

 

Invite friends

Contact Us

Page Views : 247

About The Event

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 27th, 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.