Corporate Training
InfoEdge is a pioneer in providing outstanding training in technical skills and soft skills. InfoEdge has high experience in conducting diversified training programs to various Corporate and Educational institutions. We has trained more than 10,000 candidates in various technologies since our inception.
Courses:
Advanced Excel 2007/2010 ( One Day 9:30 to 5:30 ) |
|
Program Overview: This 1 day program covers the overview of Advanced MS Excel and explains how to create MIS reporting using Pivot Table, Conditional Formatting, Custom Sorting, Advanced Filter, Advanced lookup function (Vlookup/Hlookup) Hyper & Data Linking, Group/Ungrouping, Subtotal, Data Analysis, VBA Macros using Ms Excel 2007/2010.
Course Contents:
- Data filters
AutoFilter and advanced filters
Sorting, Customize sorting, Subtotals
- Cell level validations
Specifying a valid range of values for a cell
Specifying a list of valid values for a cell
Specifying custom validations based on formula for a cell
- Using data tables for data analysis
Mastering PivotTables
Using external data sources
Multiple consolidation ranges
Customizing PivotTable layout
PivotTable advanced options
Pivot Charts
- Working with external data (Requires Microsoft Query)
Querying external databases
Saving, editing and reusing external data queries
Web queries
Importing text files in Excel
Refreshing data
- Using data forms for managing tabular data
Specifying criteria for a form
Searching with a form
- Workbook sharing
Tracking changes
Merging workbooks
Workbook and sheet protection
- Goal Seek
Scenario Manager,
Creating and editing scenarios,
Merging scenarios
- Understanding Macros, Recording Macros, Editing Macros, Assign Macros on command button
(Jump to list of courses) |
Microsoft Project MSP 2007 (Two days 9:30 to 5:30) |
Program Overview:
Following a structured Project Management Methodology is important for Project Success. It is also necessary to use an appropriate tool for planning and monitoring.
This 2 days program covers the overview of Project Management and explains how to manage projects using Microsoft Project Professional 2007. Microsoft Project assists Project Managers to do Scope Planning, assign resources, and prepare schedule, baseline, update progress, track and report. This training is imperative for all who need to plan, track and effectively communicate with stakeholders.
Course Contents:
1) Introduction to Project and Project Management
2) Introduction to Microsoft Project Professional 2007
3) Understand how to manage Projects effectively using MSP Professional
4) Understand how to List and Organize Tasks
5) Understand how to Create and modify calendars
5) Understand resource listing and assigning resources
7) Understand how to baseline project, update progress information
8) Understand the impact of scope, time, cost changes
9) Formatting Project Details, Views and Reports / Customization
10) Interface with Other Office Applications, Working with Multiple Projects
11) Sharing Resources across Project.
(Jump to list of courses)
|
Excel Macro programming with VBA (Two days 9:30 to 5:30) |
Program Overview:
This 2 days program covers the VBA Fundamental, Excel Object,User Form. It is about recording, writing, modifying and testing macros in the Visual Basic Editor.
Course Contents:
- Understanding Concept of Macros
What are Macros
How Macros help us to increase the Productivity
- Functions
What is Function and Subroutine
Writing Functions using VBA Editor
Calling function in other workbook
- Recording Macros
Recording and running macro
Storing macro in different books
Creating buttons and assigning macro to it
Creating My Menu
- The Visual Basic Editor
Editing macros using VBA Editor
Understanding the project explorer
Exploring windows properties
Modifying code in code window
Debugging code
- 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
- Excel Object Model
Working with objects properties, events and methods
Application objects
Workbook objects, Worksheet objects and Range objects
Charts objects
Pivot table objects
- User Forms
Creating forms
Form events
Creating custom menus and toolbars
Creating Add-ins
(Jump to list of courses) |
| Training Timing: |
9:30 am to 5:30 pm |
| Sufficient Enrolment Required: |
InfoEdge Solutions reserves the right to postpone any program due to insufficient number of enrolments. |
| Compulsory Registration: |
Please note that you need to register for these programs at least 2 days prior to the start date of the training. |
| Infrastructure: |
We shall provide the entire infrastructure for the training. Study material/CD/Textbook as applicable would be provided. |
| Corporate Batches: |
We also conduct the above programs as Corporate Batches at Client locations' or at our Training Center. |
| Contact Us: |
Phone : +91-11-2652 2493 Fax: +91-11-4182 9284 Email: training@InfoEdgeSolutions.com
URL: www.InfoEdgeSolutions.com |
|
| |
| |