Advanced Excel MIS VBA Access Course Training in Chandigarh Mohali

admin October 16, 2013 0 Comments

MIS Training Course in Chandigarh – Webtechlearning (ISO Certified Academy) is best institute for Advanced Excel MIS VBA Access Course Training in Chandigarh, Mohali and Panchkula.
Functioning skilled person connected to accounts, MBAs desire to learn Advanced Microsoft Excel, Access, VBA, Macro, Reporting and advanced commands to get familiar with Excel and also to develop desired reports from the data.
We provide also Online Training on Ms-Excel Training.

MIS Excel Training

100% Practical Training + Certification + Jobs

Call for free demo class: 09878375376


Course Name –
Advanced Excel Training, MIS Course, VBA MCROS, Acces
Course Duration –
30 days,
45 days,
industrial Training
Class Timing –
9am to 8pm, Year 2019 -2000, – 2 hours daily classes – early morning and late evening batches also available
Course Syllabus –
Basics and Professional Training, VBA Macros, Data Analyzing, Report Automation, Custom Formatting, Advance Formulas, Array Formula , MIS Reporting and all in excel , Learn Professional Trainer, Anyone who wish to make career in data analysis and MIS, Finance Professionals, Students from B.Com / Commercial Background, Administration Section, MIS Personals, VBA Programmer, Accounts Personal, Project Managers, Developers, Technical/ Test Leads, Program Managers, Project Managers, Research Workers, Freelancers, Data analysis departments.
Who can Learn –
10th, 12+, students, graduates, B Tech, MCA, Msc(IT), BCA, BE, Accountant, MBA ,any stream
Institute Locations
Punjab – Mohali, Chandigarh and Panchkula with near sector 34, 17, 15, 14,  kharar, zirakpur, derabassi, dhanas, new gaon, pgi sector 16, 22, 23, 24, 10, 11

webtechlearning chandigarh

Trainer & Teacher –
Surjeet Singh,
Mobile Contact-
Online Contact-
Institute  Address-
WebtechLearning  – ISO Certified Academy
SCO 54-55, 3rd Floor,
Sector 34/A Chandigarh, India,

MIS Course Syllabus:

Topics Covered

  • Creating a List
  • Using a Data Form
  • Adding Records Using a Data Form
  • Finding Records Using a Data Form
  • Deleting Records Using a Data Form
  • Sorting Records in a List
  • Using AutoFilter in a List
  • Learn Advance Excel & MIS Training with VBA Macros


  • Creating a Chart with the Chart Wizard
  • Moving a Chart
  • Resizing a Chart
  • Changing a Chart Type
  • Editing Chart Text
  • Modifying Chart Options
  • Formatting Category & Value Axis Data
  • Formatting a Data Series
  • Changing a Chart’s Source Data
  • Advance Excel and MIS Training


  • Using the Drawing Toolbar
  • Formatting Objects
  • Inserting WordArt
  • Inserting an Organization Chart
  • Modifying an Organization Chart


  • Web Page Preview
  • Converting Worksheets into Web Pages
  • Inserting Hyperlinks
  • Viewing & Editing Comments
  • Importing External Data into Excel
  • Importing Text Data into Excel
  • Importing Data from a Database
  • Exporting Data from Excel
  • Publishing Worksheets & Workbooks to the Web


  • Creating Custom Number Format
  • Using Conditional Formatting
  • Removing Conditional Formatting
  • Advanced Excel MIS VBA Access Course Training


  • Naming a range
  • Using a Named Range
  • Deleting a Named Range
  • Using the VLOOKUP Function
  • MIS and JOBS Preprations
  • Creating a Macro
  • Running a Macro
  • Editing a Macro
  • Advanced Excel MIS VBA Access Course Training
  • Adding a menu to the Menu Bar
  • Adding a Commands to a Menu
  • Adding Buttons to a Toolbar
  • Advanced Excel MIS VBA Access Course Training
  • Tracing Formula Precedents
  • Tracing Cell Dependents
  • Tracing & Fixing Errors
  • Creating a Pivot Table
  • Rearranging a Pivot Table
  • Filtering Pivot Table Data
  • Creating a Pivot Chart
  • MIS and JOBS Preprations


  • Adding Subtotals to a List
  • Nesting Subtotals
  • Applying Advance Filters
  • Adding Group & Outline Criteria to Ranges
  • Using Data Validation
  • Creating XML Web Queries
  • Using Goal Seek
  • Using Solver
  • Creating & Displaying Scenarios


  • Locking/Unlocking Cells in a worksheet
  • Protecting a Worksheet
  • Protecting a Workbook
  • Creating a Shared Workbook
  • Tracking Changes to a Workbook
  • Accepting & Rejecting Changes to a Workbook
  • Password Protecting a Workbook
  • Merging Workbooks
  • MIS and JOBS Preprations
  • Various MIS technique with the help of Excel VBA Programming
  • Get an overview of different Analytical Process
  • Data handling with the help of Access
  • Reporting and Formatting by different angles
  • Macro generation and application design
  • Writing customize queries as per the need
  • Fundamentals of data handling, MIS, EXCEL and Access.


Contact us for course details:

WebtechLearning – ISO Certified Academy
Sco 54-55, 3rd Floor, Sector 34-A,
Mobile: 9878375376

Leave a Reply

Your email address will not be published. Required fields are marked *