Online Session on Microsoft Excel Intermediate to Advanced level on Sunday 11-Mar-2018 from 10:30 AM to 12:30 PM.

Advanced Excel (Intermediate to Advanced Level) Webinar - Info2Excel

 

  • Early Bird

    Sale Date Ended

    INR 300
    Sold Out
  • Early Bird-Group

    Group of 3 members

    Sale Date Ended

    INR 750
    Sold Out
  • Regular

    Sale Date Ended

    INR 400
    Sold Out
  • Regular-Group

    Group of 3 members

    Sale Date Ended

    INR 900
    Sold Out

Invite friends

Contact Us

Page Views : 135

About The Event

 

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

More Events From Same Organizer

Similar Category Events