The spreadsheet designing within MS Excel is an art that will not be handy until you have gone through a dedicated training program. Quick access of procedure sums, setting maximum & minimum ranges, chart preparation. The customized training on Advance Excel, VBA and MIS is designed in such a way that the people from the relevant field can have insight about the tools and techniques to develop a customizable MIS system.
since Advanced Excel classes in Gurgaon are conducted on weekends it become more and more convinient for working persons to join this course. Industry experienced corporate trainer takes up classes in small group to teach various advanced functions of advanced excel techniques, small size batch gives individual attention to each participant. during MS Excel Training
Day 1: Introduction
Different File extensions
All Keyboard shortcuts
Data types and properties
Create, delete and update new templates
Day 2: Basics of Advanced Excel additional Formatting
Define Name
Paste special
Conditional formatting
Basic functions
Day 3: Advanced formulas and linking
Advanced formulas like Database, time, date, number, mathematical logical
etc.
Creating links
Errors and error types
Day 4: Sorting & Filtering
Multilevel sorting
Custom sorting
Filtering
Day 5: Goal Seek, Scenarios, Grouping and Subtotals
Creating, using, and ,editing scenarios
Concept of Goal seek and using it
Grouping large data by different criteria
Adding subtotals to grouped data
Day 6: Lists, Charts & Data validation
Creating menu and sub menus by using list
Advanced & Dynamic chart properties
Applying data validation and generating error message
Day 7: Pivot & Data from other sources functions
Report generation and extraction
Applying logic and functions
Generating charts my using extracted results
Importing exporting data from other sources and extensions
Day 8: Security & Macro Basics s of Macro and using it
Cell protections
Hiding Data and formulas
Sheet protection
Workbook protection and sharing
Basics of Macro and using it
Bit of automation by using macros
Day 9: Practice Session 1
Working with more than 1 lacs of entries in one sheet
Extracting reports
Data analysis
Day 10: Doubt clearing session
Overall revision 1
Day 11: Practice Session 2
Working with more than 2 lacs of entries in many sheets but linked