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
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 @ : http://www.margonline.com/
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 @ : http://www.margonline.com/