CHANDIGARH NO.1 - Web Education Academy - Admissions on 1st come 1st basis - Lowest Fee, Learn Unlimited! - Book a Free Demo Class
More information?
Lets' talk


Advanced Excel MIS VBA Access Course Training in Chandigarh Mohali

advanced Excel Training in Chandigarh
Webtechlearning 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.

100% Practical Training + Certification + Jobs


Course Name –

Advanced Excel Training, MIS Course, VBA MCROS, Acces

Course Duration –
30 days, 45 days, 6 month,  industrial Training
Class Timing –
7am to 9pm, Year 2013 -2014,
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 Location –
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,
Telephone Contact-
+91-9915337448, 9878 375376
Online Contact-,
Institute  Address-

SCO 54-55, 3rd Floor, Sector 34/A Chandigarh, India,

Courses Details:

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:

Mobile: 9915337448, 9878375376

Top Search: > > > >

WebtechLearning - Web Education Academy

ISO 9001:2008 Certified Academy

Professional Training + with Live Projects + Certifications+ Job

Call for query:  +91 9878 375 376, +91 9915 337 448 , Skype: webtechlearning

Book My Free Demo Class Now!

Note: you can meet your trainer, get demo class before joining the Course.

Webtech LearningTM partner's companies