MS Excel - Advanced Level Training

MS Excel - Advanced Level Training

 

  • MS Excel Training 2016

    Sale Date Ended

    INR 2500
    Sold Out

Invite friends

Contact Us

Page Views : 52

About The Event

Working professionals from any function (Accounts, finance, process etc.),who work on large data and do extensive calculations, data analysis and prepare complex reports on regular, periodic basis.


Course Outline:Day 1:

CELL REFERENCING
NAMING RANGES
EXCEL FUNCTIONS
COPYING DATA
CONDITIONAL FORMATTING
USING AUTOFILTERS
USING ADVANCED FILTERS
WORKING WITH FILTERED DATA
CHARTING IN EXCEL
EMBEDDING AND LINKING OBJECTS
USING HYPERLINKS
IMPORTING DATA
IMPORTING TEXT FILES
USING MICROSOFT QUERY
REFRESHING DATA
GETTING VISUAL
PRACTICAL ASSIGNMENTS

Day 2:

ADVANCED EXCEL FORMULAS
USING DATA VALIDATION
AUDITING
LINKING & CONSOLIDATING DATA
WHAT-IF ANALYSIS
GOAL SEEK
SCENARIO MANAGERK
SOLVER
WORKING WITH PIVOT TABLES
PROTECTION AND SECURITY
MACROS
PRACTICAL ASSIGNMENTS



For More Details Visit Website @ :MS Office Training in Bangalore

Venue Map