Mastering Microsoft Excel - New Year Offer

1 Reviews

Vasundhara, Delhi

Course ID: 7460

Vasundhara, Delhi

1 Reviews

Date and Time

Not decided yet.

Vivekananda Sinha picture
Vivekananda Sinha

Certified Microsoft Office Specialist

8 Years of Experience

About Vivekananda Sinha

8 Years industrial experience in core MIS.

Trained Executives, Engineers, Managers, Students.

Received MICROSOFT OFFICE SPECIALIST title from Microsoft Corporation.

Awarded several times as Best Trainer at corporate level for receiving excellent feedback for trainings on Advance Excel, Statistical Analysis using Excel, VBA Macros and Microsoft Productivity Tools.

Developed Global Content Repository System, a 20,000 USD project developed in VBA for an IT company in South America. Received excellent customer feedback for the application.

Been as a Project Guide on Construction Site Layout Planning System, a VBA project initiated by group of Civil Engineers of Indian Institute of Technology, New Delhi. This project emphasizes on the planning of different facilities of a site in an optimized way. This is a generic-algorithm based model for site layout planning.

Developed and Implemented Utilities for Excel, a multi functionality tool that helped in saving lots of time for the Excel users. It covers the functionalities such as Sending Mails, Format Cells, Workbook Management, Workbook Library, Text Operations, Arithmetic Operations, Color Themes and Printing.

Developed various Consolidation Tools using VBA that helped in the reduction of 99% of the time taken in manual consolidation of Reports. It proved great at the time of Yearly Baseline Analysis.

Developed and Implemented Awareness Evaluation System, a VBA project to check the skills of the internal employees in different domains. This project includes SQL Server 2005 for storing questions, scores, user information and other details of the application. Login is based on windows Authentication.

Developed a Solution for Human Resource to taken user inputs in email. The data received are automatically saved to central database.

Developed Document Management System Plug-In for Microsoft Excel. This is a VBA Application that facilitates the users, to have documents easily available without wasting their time and efforts in searching them in the drive.

Vibhor Rawat

Attended Mastering Microsoft Excel - New Year Offer

One day Training session on Expertising Excel is a great learning experience. This training is beneficial for all those who are working in corporates. I attended this training and learnt many things that can be used in our routine tasks. Waiting for VBA Session to commnece.

About the Course

Will cover the entire Microsoft Excel that is required in the Industry. It is a fully practical based training. Beneficial for career oriented people.


Lunch Included
Training Video to be provided for the complete training
Training Materials (In DVD)
Discount Voucher Rs. 500 to be provided for future trainings
Notepad and Pen to be provided at venue

Payment Terms:

50% to be paid at the time of Registration.
50% to be paid by 11-May-2013.
Non Refundable.
Payment Mode: Cash only.

Content of Training Materials:

Training Presentation.
Solved samples discussed during the training.
Excel learning videos.
Excel eBooks
VBA Programming in Excel eBooks
Demo applications created in excel.

Topics Covered

Overview of basic Excel skills
Basic Short Keys
Worksheet Operations
Cell Operation
Format Cells
Freeze Panes
Techniques of Paste Special
Protect Worksheets & Workbooks

Time Saving Utilities
Format Painter
Text to Columns with fixed and delimited parameters
Data Sorting using custom list
Summarizing data using Auto Outline

Concept of Cell Referencing
Relative Referencing
Absolute Referencing
Mixed Referencing

Important Functions in Excel


Name Manager
Defining List using names
Use of Names in Advance Reports

Conditional Formatting
Conditional Formatting using Formulas & cell values
Highlighting Duplicates
Calculation based Conditional Formatting

Data Validation
Different Data validation in Excel
Using list in validation

Charts in Excel
Elements of Charts
Major charts used in Excel

Pivot Table
Pivot Table creating Methods
Rearranging a Pivot Table
Filtering Pivot Table Data
Performing Custom Calculation
Creating Dynamic Dashboards using pivot charts and Slicer
Consolidating Data from external source or multiple files in less than a minute

Array Functions for quick conditional calculations

Data Filter
Normal Data Filter
Advance Filter
Calculation based filter
Filter using wild cards

Summarizing data using Subtotal

Analyzing data with What-If Analysis
Determine unknown with Goal Seek
Analyze data with Data Table

Sparklines for Data trends

Error handling Tips and Tricks

Who should attend

MS Office Specialist, BPO Executives, MIS Personals, Accounts Personal, HR Personal, Quality Analyst Software Engineers, Project Managers, Developers, Test Leads, Program Managers, Project Managers, Research Workers, Freelancers, Data analysis departments, , Students, others who what to get an excellent growth in corporate.


Basic understanding of Microsoft Excel.

What you need to bring

Learning Mindset."

Key Takeaways

Understanding importance of Management Information System at corporate environment.

Perform Data Analysis on key performance indicators to drive performance and operational excellence to exceed the goals.

Proactively monitor Performance Dashboards to determine key areas of focus and to identify root causes and potential corrective Actions.

Develop and provide Trend Data and Analysis on key performance indicators as required.

Track, monitor and report out on all Service Delivery and Quality Improvement Plans.

Prepare Annual Reports in less than a minute.

Analyze data and enhance Decision Making to generate new business opportunities.

Analyze Trends and increase the accuracy of forecasting.

Reviews (1) See all Reviews


Vibhor Rawat

Attended Mastering Microsoft Excel - New Year Offer

One day Training session on Expertising Excel is a great learning experience. This training is beneficial...


Post your requirement and let us connect you with best possible matches for Microsoft Excel Training classes Post your requirement now is India's largest network of most trusted tutors and institutes. Over 25 lakh students rely on, to fulfill their learning requirements across 1,000+ categories. Using, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 6.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more