ADVANCED EXCEL TRAINING

    20 Shortcut keys

    Formatting (Applying borders, Colors and Font styles)

    Conversion of Formats (Number, Text, Date etc)

    Merging and Wrapping the text

    Conditional formatting

    Formula based conditional formatting

    Format as Table

    Insert/delete row and column, Sheets

    Row height & column width

EXCEL FUNCTIONS

    IF and Nested if (Multiple if conditions)

    HLOOKUP,VLOOKUP, INDEX, MATCH, MID, FIND, REPLACE

    Date Functions(TODAY,WEEKDA,NOW),

    LEN,REPT

    Min/Max, Count/CountA/CountBlank/CountIf/

    Average/AverageA/AverageIf/

    Sum/SumIf

    Round/RoundUp/RoundDown

    Freeze Panes- Three ways

NAMING RANGES

    Defining a Range Name

    Using a Range Name in a Formula

    Moving to a Named Range

CHARTING IN EXCEL

    Charts & graph – Chart properties

USING DATA VALIDATION

    Setting data validation

    Creating the Input Message

    Displaying an Input Message

    Creating the Error Alert

    Displaying an Error Alert

    Creating List

 WORKING WITH PIVOT TABLES

    Creating Custom Formats

    Explaining the Grouping Options

    Adding Formulas to a Pivot Table

    Changing a Calculation in a Pivot Table

    Replicating a Pivot Table

    Counting with a Pivot Table

    Using Pivot Charts

 AUDITING

    Displaying all formulas within a worksheet

    Adding comments

    Displaying comments

    Removing comments

    Editing commen