Comprehensive Excel

Objective : To learn the different (basic & advanced) functionalities available in MS Excel comprehensively
Suitability : Entry level executives / Executives & Officers at supervisory or middle management level
Prior excel background : Atleast 3-6 months of working experience on excel is required
Duration : 20 Hours or 3 Days
Functionalities covered
Basics of excel
  • calculator
  • cell formatting
  • navigating shortcuts
  • moving/copying sheets to other workbooks
  • different formats of saving excel file
  • copy - paste/paste special
  • Fill and Fill handle

Exploring and editing the data
  • Autofilters
  • Sort
  • Find/Replace
  • Freeze panes
  • text to columns
  • comments
  • Printing a page - some neat techniques

Functions
  • vlookup and hlookup
  • if, and, or
  • round, roundup, rounddown
  • sumif and sumifs
  • countif and countifs
  • averageif and averageifs
  • concatenate and trim
Charts
  • Basic Charts
  • Pivot Charts

Data management, validation and protection
  • Pivot tables
  • Conditional formatting
  • data validation
  • formula auditing
  • calculation options
  • protecting cell, worksheet and workbook
  • concatenate and trim
Introduction to Macros
  • Recording a macro
  • Editing macros in VBA window
  • Running macros