Excel is the lifeline of every business hence adequate knowledge of excel is indispensable for working efficiently and increasing the productivity.
The broad contents of our basic and advanced excel course:

Introduction to MS Excel

  • Understanding the screen of excel
    Ribbon & various tabs on ribbon
    Formulae bar
    Reducing the use of mouse
    Cell freezing & referencing
    Basic shortcuts

    Navigation shortcuts , Insert/Delete, Hide/Unhide Row/ Column, Hide/Unhide Ribbon , Edit Mode, Repeat last action, Save as, Instant charting, Hide/Unhide gridlines & Group/Ungroup Rows/Columns

    Cell formatting with custom formatting
    Sorting/ Filtering the data with advanced filters
    Conditional formatting
    Protect/Unprotect worksheet/workbook

Exploring Excel Functions

  • Mathematical functions

    ABS, MOD, SOR, PI, SUM, SUBTOTAL, SUMPRODUCT, SUMIF, ROUND, MROUND, FACT

    Statistical functions

    AVERAGE, AVERAGEA, AVERAGEIF, COUNTIF, COUNTIFS, MAX, MIN, MEDIAN

    Financial functions

    PMT, PPMT, IPMT, FV, PV, NPV, XNPV, IRR, XIRR

    Logical functions

    IF, OR, AND, NOT, FALSE/TRUE

     

Exploring Excel Functions (Contd)

  • Lookups & Reference functions

    CHOOSE, INDIRECT, TRANSPOSE, OFFSET, INDEX, MATCH, LOOKUP, VLOOKUP, HLOOKUP, VLOOKUP+MATCH, INDEX+MATCH

    Text functions

    FIND, REPLACE, LEFT, RIGHT, MID, LEN, LOWER, UPPER, PROPER, TRIM, TEXT

    Date & Information functions

    DATE, DAY, MONTH, YEAR, TODAY, DAYS360, YEARFRAC, EDATE, EOMONTH

Call Now
Directions