Advanced Excel MIS VBA Access Course Training in Chandigarh Mohali

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.

Advanced Excel MIS VBA Access Course Training in Chandigarh Mohali

Institute Chandigarh is the best institute for Advanced Excel MIS VBA Access Course Training in Chandigarh, Mohali, and Panchkula.

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 and MIS Training with VBA Macros

WORKING WITH VARIOUS ASPECTS:

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

WORKGROUP COLLABORATIONS

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.
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 Preparations

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 and Editing Comments
IMPORTING and EXPORTING DATA
Importing External Data into Excel
Text Data into Excel
Importing Data from a Database
Exporting Data from Excel
Publishing Worksheets and 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 Preparations
CUSTOMIZING EXCEL
Creating a Macro
Running a Macro
Advanced Excel MIS VBA Access Course Training
Tracing and Fixing Errors
Adding a menu to the Menu Bar
Adding a Commands to a Menu
Editing a Macro
Adding Buttons to a Toolbar
Advanced Excel MIS VBA Access Course Training
DATA ANALYSIS TOOLS
Tracing Formula Precedents
Tracing Cell Dependents
Creating a Pivot Table
Rearranging a Pivot Table
Filtering Pivot Table Data
Creating a Pivot Chart
MIS and JOBS Preparations

SUMMARIZING DATA

Adding Subtotals to a List
Nesting Subtotals
Applying Advance Filters
Adding Group and Outline Criteria to Ranges
Using Data Validation
Creating XML Web Queries
WHAT–IF DATA ANALYSIS
Using Goal Seek
Using Solver
Creating and Displaying Scenarios