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
Table of Contents
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 | ||
|
||
| 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, |
