Advanced Excel

Advanced Excel

Our Training Institute offers Advanced Excel training course for the students and professional to learn more advanced features of Excel. The topics covered in Advanced Excel Training include latest and best real-time examples that are aimed to help students in getting the right job so after the completion of Training. We offer the best advanced excel training workshop in Bangalore and training with us would give you an edge over others at office or in interviews.

1. Introduction to Advanced Excel

    • 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 comments