Advanced Excel Training ( CLASSROOM / ONLINE )

Demystify some of the most complex business relevant areas of Microsoft Excel.

Become an Expert and learn to use Excel like a pro with this Advanced Excel Training.

These days, any managerial or analyst role requires that you work with data. Excel remains one of the most powerful and easy to use tools when it comes to crunching data. Learning Excel in a proper, structured way can not only help you save time, but it will also help you to become better at your job responsibilities and can give you time to focus on things and people that matter.

Microsoft Excel just might be the greatest piece of software ever developed.

So while there are a lot of basic tricks that you have to know, there are also a few tricks that will set you head and shoulders above the competition.

If you want to dazzle your bosses and beat your rivals, this training is a must for you !!!

Course Module

  • a) Excel Conditional Formatting Options
    b) Simple Conditional Formatting 
    c) Highlight Cells Rules
    d) Clear Rules
    e) Top/Bottom Rules
    f) Color Cells Based on Cell Value
    g) Find Duplicate Data in Excel with Conditional Formatting

  • a) Data Field

    b) Column Labels

    c) Row Labels

    d) Summation values

    e) Change Summary Calculation

    f)Update (refresh) data in a PivotTable

    g) Freeze Panes

  • a) Create a Chart
    b) Change Chart Type
    c) Switch Row/Column
    d) Chart Title
    e) Data Labels
    f) Move or resize a chart

  • a) Text Filter (And, Or)

    b) Text (  Concatenate, Len, Lower, Proper, Substitute, Trim, Upper)

    c) Date & Time(Now, Today)

    d) MIS Functions = Lookup & Reference (Vlookup, Hlookup, Rows, Columns)

    e) Auto Filter, Custom Auto Filter

    f) Logical ( IF,NESTED IF )

    g) Absolute & Relative referencing, Excel Mathematical function: SUM, AVERAGE, MIN, MAX ,ROUND, ROUNDUP, ROUNDDOWN, SUBTOTAL, AUTOSUM

  • a) Handling Formula Errors

    b) Data Validation

    c) Insert Comment

    d) Macros

    e) Goal Seek

    f) Sheet Protection

    g) To Remove Duplicates

    h) Alt Short Cut Keys


Add on Benefits


Choose Your Direction

Advanced Excel Training

Master Yourself into Advanced Excel and

Take your Career to new heights

Phone: +91 - 7975642525
Empower, Bangalore, Karnataka, India