Signup as a Tutor

As a tutor you can connect with more than a million students and grow your network.

Share

Mastering Microsoft Excel - New Year Offer

Mastering Microsoft Excel - New Year Offer

Vasundhara, Delhi

4,000

1 Reviews
5 Interested

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.


Highlights:

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

AND
OR
NOT
COUNT
COUNTA
COUNTBLANK
COUNTIF
MAX
MIN
UPPER
LOWER
PROPER
RIGHT
LEFT
MID
POWER
SUM
SUMIF
AVERAGE
EXACT
CONCATENATE
LEN
NETWORKDAYS
IS FUNCTIONS
MATCH
IF
VLOOKUP – 1D
VLOOKUP – 2D
HLOOKUP
SUBTOTAL
SUMPRODUCT
NESTED FUNCTIONS

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.

Pre-requisites

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.
Content
Reviews

Recommendations & reviews from previous Customers:

Vibhor Rawat

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

attended Mastering Microsoft Excel - New Year Offer


Questions and Comments

Thousands of experts Tutors, Trainers & other Professionals are available to answer your questions


Recommendations & reviews from previous Customers:

Vibhor Rawat

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

attended Mastering Microsoft Excel - New Year Offer


cash back100% Money Back Guarentee

About the Trainer

Vivekananda Sinha picture

Vivekananda Sinha

Certified Microsoft Office Specialist


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.

Course Id: 7460