Advanced Excel Training , MIS Course & Corporate Excel Training Institute in Delhi

Key Information

Advanced Excel Training

IPA has developed advanced excel module to help managers understand various complex issues related to advanced excel. MIS course designed by IPA guarantees the value addtions in terms of and development of managers and other employees of the organisation. Hence MBA CA's CS and othe working people can come and solve their problem in few days learning, since classes in delhi 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 and techniques, small size batch gives individual attention to each participant. during

Significance

IPA institute offers MIS Course for freshers as well as experience persons, MIS - Management Information System experts are required for every sector of the economy as well for every industry, there are various reports and informations that Management of an organisation looks for, managers are required to prepare those rpeports using various functions and formulas available in spreadsheets however many times managers do feel lack of knowledge and understanding how to use commands. Most of the topics mentioned are covered under this course has however excel has huge potential and the learning process is limitless and it takes years of practice to have full fledge mastering on the subject. IPA fulfill this gap by offering quality learning program

Corporate Advanced Excel Training

IPA do conduct Corporate training in Advance Excel & VBA since Business managers often need to take decisions that can affect the business for example detail of sales with distributor network , while it is not possible to use complex formulas by hand that immediately generate report with accuracy and efficiency, hence routine task of feeding inputs and obtaining suggestion/ reports as output with the help of computer application like MS Excel spread sheet is very common these days. In any MIS environment standard reports are generated by advanced function of Ms Excel , for comparing actual performance with original budget, hence user can learn all these advanced functions of Excel under the expert guidance of coporate trainer who has spend alomst more than a decade in resolving practical problems reltaed to various MIS reports, hence it is advisable to HR manager to pursue their employees to join Corporate Training program which mainly deals with advanced Ms Excel and its applicability, during this program main focus remains on how to prepare various MIS reports with maximum use of formulas and functions, for more detail kindly download the brochure

  • Various MIS technique in Advanced Excel VBA Programming
  • Get an overview of Analytical Process
  • Data handling in MIS Reports
  • Reporting and Formatting
  • Fundamentals of data handling, MIS, EXCEL

Important Features of Training at IPA Institue:-

IPA is best Excel classes Training Institute in Delhi with the following features:-

  • Lowest Fee
  • Full Course covering every advanced topics
  • Experienced Corporate Trainer
  • Fully Aircondition class rooms
  • Small batch size of 3 to 4 students
  • Individual attention
  • Standard study material
  • Free Excel Templates

Course Detail

Advanced Excel Training Module and Flow :

Day One

  • Introduction and Basic Overview
  • Working with Workbook and Worksheets
  • Formatting Cells
  • Customized formatting of Cells
  • Cell References (Absolute, Relative & Mixed)
  • Shortcut Keys
  • Other Features (Paste Special and finding and replacing data etc.)

Day Two

  • Text Formulas (CONCATENATE, UPPER, LOWER, PROPER, DATE, MOD, MODE, TODAY, NOW)
  • Inserting Comments
  • Use of Go to Feature
  • Use of “&” to Join data in different cells
  • Logical formula (IF function and its use)
  • Conditional Formatting and its Use in different scenarios

Day Three

  • Logical Complex Formulas (IF, OR, AND &  IFERROR)
  • Use of Nested IF formula with examples
  • Other Text Formulas (TEXT, CLEAN, TRIM, Len,  T, COUNT, COUNTA, COUNTBLANK, COUNTIF, SUBTOTAL)
  • Defining Cell Range & Name Manager

Day Fou

  • Applying Autofilter
  • Use of Advanced Filter
  • Displaying Unique Record by using Advanced Filter
  • Freezing and Unfreezing Panes
  • Linking of Worksheets & Workbooks
  • Open websites, existing files etc by Inserting Hyperlink
  • More useful formulas (RIGHT, LEFT, LEN, FIND, SUMIF & SUMPRODUCT)
  • Formatting Data as Table

Day Five

  • Financial Formulas (PMT, PV, DISC, DB, IRR, NPV etc.)
  • Text to Column to fetch data
  • Lookup & Reference cell Formulas (CELL, ADDRESS, ROW, COLUMN, LOOKUP, VLOOKUP, HLOOKUP, MATCH, OFFSET, SUMPRODUCT, INDEX, CHOOSE, INDIRECT etc.)
  • Data Validation and its use in different scenarios

Day Six

  • Understanding the Page layout of the workbook (Orientation, Print preview, Page Break etc.)
  • Consolidate the data range from multiple sources.
  • What if Analysis (Goal Seek, Scenario Manager and Data Table)
  • Protecting worksheet and workbook
  • Customized Protection of worksheet
  • Sharing Workbook
  • Track and Highlight Changes
  • Encrypting Document

Day Seven

  • Understanding & Preparing Dashboards.
  • Group and Ungroup Data
  • Formula Auditing (Trace Precedents/Dependents, Error Checking, Show/Evaluate Formula, Watch Window)
  • Applying Subtotal to a Data Source
  • Export and Import Data from (Different Sources like Access, Web, Text, CSV etc.)

Day Eight

  • Understanding Macros
  • Recording new Macros
  • Understanding the use of Form Controls
  • Inserting User form / Module using VBA
  • Creating own formulas using VBA
  • Protecting and working on VBA projects

Who Can Join ?

  • Students after 12thGraudates
  • MBA (Finance, HR, Marketing)
  • Engineers
  • Chartered Accountants
  • Managers (working with small and large companies)
  • Working professionals
  • MIS Executives
  • MIS Personals
  • Accounts Personal
  • Project Managers
  • Research Workers
  • Freelancers

Brochure

Batch Timing

Course Duration: 30 Hrs (2 Months)

Batch Duration

  • Weekend (3 Hours)

Timing

  • Weekend(Sundays)
  • One is to One Coaching also available on Daily basis

Back to Top