CHANDIGARH NO.1 - Web Education Academy - Admissions on 1st come 1st basis - Lowest Fee, Learn Unlimited! - Book a Free Demo Class
for Course Inquiry?
Call Now!

09878375376

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

100% Practical Training + Certification + Jobs

Call for free demo class: 09878375376

istqb_course_in_chandigarh

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-
info@webtechlearning.com,
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

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.

html-css-trainingi-in-chd

Contact us for course details:

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

Mobile: 9878375376
info@webtechlearning.com

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