Advanced Excel MIS VBA Access Course Training in Chandigarh Mohali
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
Table of Contents
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 |
|
Trainer & Teacher –
|
Surjeet Singh,
|
|
Mobile Contact-
|
+91- 9878375376
|
|
Online Contact-
|
info@webtechlearning.com,
|
|
Institute Address-
|
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
WORKING WITH CHARTS
- 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
WORKING WITH GRAPHICS
- Using the Drawing Toolbar
- Formatting Objects
- Inserting WordArt
- Inserting an Organization Chart
- Modifying an Organization Chart
WORKGROUP COLLABORATION
- Web Page Preview
- Converting Worksheets into Web Pages
- Inserting Hyperlinks
- Viewing & Editing Comments
- IMPORTING & EXPORTING DATA
- 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
FORMATTING NUMBERS
- Creating Custom Number Format
- Using Conditional Formatting
- Removing Conditional Formatting
- Advanced Excel MIS VBA Access Course Training
WORKING WITH RANGES
- Naming a range
- Using a Named Range
- Deleting a Named Range
- Using the VLOOKUP Function
- MIS and JOBS Preprations
- CUSTOMIZING EXCEL
- 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
- DATA ANALTSIS TOOLS
- 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
SUMMARIZING DATA
- Adding Subtotals to a List
- Nesting Subtotals
- Applying Advance Filters
- Adding Group & Outline Criteria to Ranges
- Using Data Validation
- Creating XML Web Queries
- WHAT–IF DATA ANALYSIS
- Using Goal Seek
- Using Solver
- Creating & Displaying Scenarios
WORKGROUP COLLABORATIONS
- 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,
Chandigarh
Mobile: 9878375376
info@webtechlearning.com
