MIS Training in Chandigarh

MIS Training in Chandigarh – WebtechLearning (ISO Certified Academy) provide the best MIS training in Chandigarh. Its 100% practical training with live project. This course will help to write macros in Excel using programming language Visual Basic Application (VBA).
Recorded macro can edited to customize it to fulfill our requirement and one can directly go for coding to accomplish the required tasks. One can write his own functions and procedures, design forms and working with add-ins.

MIS Training Course

100% Practical Training + Certification + Jobs

Call Now for details: 09878375376

Microsoft Excel for Windows is a powerful electronics spreadsheet application that can be used for managing, analyzing and presenting data in graphical manner.

Course Features

	Excel has three components that perform in three different manners: 1. The Spreadsheet. 2. The Data sheet. 3. The Chart. Create formulas on worksheets. It’s easy and fast. Enhanced formatting and layout features help you get the printed report or online form with the look you want. You can quickly find the information you need and create automatic subtotals of your data. Increased capacity, high-end formatting options, and a mapping feature give you powerful ways to analyze your data visually. Explore the power of the Internet from your familiar Microsoft Excel spreadsheet. When you want to analyze data from outside Microsoft Excel, there’s no need to retype. In a few keystrokes, you can bring the data right onto your worksheet.

Application

~ ~	Excel is used for preparing Company profiles in the form of Charts and Graphs. Excel stores the accounting spreadsheets in Electronic form.

Module 1: Getting Started

~ ~ ~ ~	Understanding the Excel screen Navigating in a spreadsheet Understanding worksheets, columns, rows and cells Saving, opening, and closing workbooks

Module 2: Formatting a Spreadsheet

~ ~ ~ ~ ~ ~ ~	Changing column widths and row heights Changing alignment of cells Undoing and redoing actions Formatting numbers Clearing formats Applying borders to cells Merging cells

Module 3: Formulas and Functions

~ ~ ~ ~ ~ ~ ~ ~	Entering formulas Copying data and formulas Using AutoSum Understanding functions Using simple aggregate functions (Sum, Count, Average, Min, Max) Copying formulas Applying conditions in a formula (The IF function) Working with ranges

Module 4: Editing Features

~ ~ ~ ~	Using cut , copy, and paste operations Using paste special with values Selection techniques Navigation techniques

Module 5: Working with Large Worksheets

~ ~ ~	Freezing and unfreezing panes Splitting windows Inserting page breaks for printing

Module 6: Working with Charts

~ ~ ~ ~	Creating charts using Chart Wizard Creating different types of charts Including titles and values in charts Formatting of charts

Module 7: Previewing and Printing

~ ~ ~ ~ ~	Previewing worksheets Page setup Printing of worksheets in multiple pages Repeating rows and columns for multiple pages Printing multiple worksheets

Module 8: Simple Database Operations

~ ~ ~	Sorting tables Filtering data with auto filter Referring data from other worksheets

Module 1: Understanding Security Levels

~ ~	Why security Security levels and its meaning

Module 2: Functions

~ ~ ~	What is Function and Subroutine Writing Functions using VBA Editor Calling function in other workbook

Module 3: Recording Macros

~ ~ ~ ~	Recording and running macro Storing macro in different books Creating buttons and assigning macro to it Creating My Menu

Module 4: The Visual Basic Editor

~ ~ ~ ~ ~	Editing macros using VBA Editor Understanding the project explorer Exploring windows properties Modifying code in code window Debugging code

Module 5: Programming Fundamentals

~ ~ ~ ~ ~ ~ ~ ~	Variables, data types and constants Arrays Object Variables Conditional structures (If â€¦. Then, Select Case) Logical Operators Looping constructs (For loops, Do loops, whileâ€¦ Wend) Built-in functions Creating Subroutines

Module 6: Excel Object Model

~ ~ ~ ~ ~	Working with objects â€“ properties, events and methods Application objects Workbook objects, Worksheet objects and Range objects Charts objects Pivot table objects

Module 7: User Forms

~ ~ ~ ~	Creating forms Form events Creating custom menus and toolbars Creating Add-ins

Module 8: Working with other applications

~	Working Word, PowerPoint and other applications.

Database Design with My SQL Why use a Relational Database?

Blasted Anomalies
~ ~ ~	The update anomaly The delete anomaly The insert anomaly

Normalization
~ ~ ~	First normal form Second normal form Third normal form

Types of Relationships
~ ~ ~	The one-to-many relationship The one-to-one relationship The many-to-many relationship

Advanced Database Concepts
~ ~ ~	Referential integrity Transactions Stored procedures

The Structured query Language for Creating and Altering Tables

Essential Definitions
~ ~	Null Values Indexes

The create database Statement

The use database Statement

The create table Statement

Column Types
~ ~ ~	String column types Numeric column types Date and time types

Creating Indexes

Table Types
~ ~ ~	MyISAM InnoDB Tables Berkeley DB Heap

The alter table Statement
~ ~ ~ ~ ~ ~	Changing a table name Adding columns Dropping columns Adding indexes Dropping indexes Changing column definitions

Using the show Command
~ ~ ~ ~ ~ ~	show databases show tables show columns show index show table status show create table

GUI Tools for Manipulating MySQL Tables and Data
~	Using phpMyAdmin

The Structured Query Language for Inserting, Editing, and Selecting Data
~ ~ ~ ~	The insert Statement The update Statement The delete Statement The replace Statement

The Basic select Statement
~ ~ ~ ~	The Where clause order by limit group by and aggregate functions

Joining Tables
~ ~ ~ ~ ~ ~	The two-table join (equi-join) The multi-table join The outer join The self join Unions Correlated subqueries

Course Name –	Advanced Excel Training MIS Course
Course Duration –	30 days, 45 days, 6 month, industrial Training
Class Timing –	7am to 9pm, Year 2013 -2014,
Course Syllabus –	MIS Basics and Professional Training, MIS Reporting and all in excel , MIS Course
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

Trainer & Teacher –	Surjeet Singh,
Telephone Contact-	+91 – 9878375376
Online Contact-	info@webtechlearning.com,
Institute Address-	WebtechLearning – Web Education Academy Chandigarh SCO 54-55, 3rd Floor, Sector 34/A Chandigarh, India,

MIS Training Course

For queries, feedback & assistance

Online Support

9:00AM - 7:00PM

For Admissions & Career Counselling

Call Back Request

Company

Careers

Resources

Refer & Earn

Diploma Courses

Job Oriented Courses

Programming Courses

Corporate Training Courses