loading......

Where do you need ?

location

Please select a Location.

Enquire

Submit your enquiry for Become Microsoft Excel Expert

Please enter valid question or comment

Please select a category

Please enter your name.

Please enter valid Phone Number

Please enter the Pin Code.

By submitting, you agree to our Terms of use and Privacy Policy

Connect With Shivkant

You have reached a limit!

We only allow 20 Tutor contacts under a category. Please send us an email at support@urbanpro.com for contacting more Tutors.

You Already have an UrbanPro Account

Please Login to continue

Please Enter valid Email or Phone Number

Please Enter your Password

Please Enter valid Password or OTP

Forgot Password? Resend OTP OTP Sent

Sorry, we were not able to find a user with that username and password.

We have sent you an OTP to your register email address and registered number. Please enter OTP as Password to continue

Further Information Received

Thank you for providing more information about your requirement. You will hear back soon from the trainer

Share

Become Microsoft Excel Expert

Become Microsoft Excel Expert

Sector 9 Noida, Noida

2 Reviews
0 Interested

About the Course


The training will cover all the aspects of Microsoft Excel for core MIS at corporate level.



Topics Covered

Overview of basic Excel skills
Basic Short Keys
Basic Functions
Worksheet Operations
Format Cells
Cell Operation
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 Group and 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
INDEX
IF
VLOOKUP – 1D
VLOOKUP – 2D
Reverse VLOOKUP
HLOOKUP
LARGE
SMALL
SUBTOTAL
SUMPRODUCT
OFFSET
NESTED FUNCTIONS

Name Manager
Defining Static and Dynamic 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 Dynamic list in validation

Charts in Excel
Elements of Charts
Major charts used in Excel
Creating Dynamic Charts

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
Creating Pivot Tables through Database Connections

Array Functions for quick conditional calculations

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

Summarizing data using Subtotal

Data Consolidation
Consolidation by categories
Consolidation using 3D Formulas

Analyzing data with What-If Analysis
Determine unknown with Goal Seek
Analyze data with Data Table
Enable decision making using Solver
View results with Scenario Manager

Use of Form controls for creating Dynamic Reports and Dashboards

Who should attend

Anyone who wants to be expert in Microsoft Excel

Pre-requisites

Should have basic understanding of Excel

What you need to bring

Notebook
Pen

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.

Develop Time saving Utilities.
Reviews

Recommendations & reviews from previous Customers:

Sanjay Kumar

"Excellent knowledge of MS Excel. Share various industry level examples which are very useful for me"

attended Become Microsoft Excel Expert


Pratap

"Excellent training skills and knowledge of MS Excel. Share various industry level examples which are very useful for me"

attended Become Microsoft Excel Expert


Questions and Comments

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

Comment ?

Questions Guidelines

  • Start your question with simple statements like "what", "when", "where", or "how".
  • Ensure your question or answer is not offensive or insensitive - it may be voted down or banned.
  • Please provide as much detail as possible as this will allow our members to better understand and respond to your question.
  • Take some time to categorize your question. This will greatly help other users find the question.


You can add upto 6 Images

Ask

Showing 1 to 3 of 3

Deepak 16/02/2014

I m a working professional in the field of quality and looking for trainer who can provide training for MS Excel with advance level. My main focus is to get trained in data analysis, statistical functions / tools, graphs, charts, pivot and MIS. Can u please provide me complete training details including fee structure, complete duration and training...  more » I m a working professional in the field of quality and looking for trainer who can provide training for MS Excel with advance level. My main focus is to get trained in data analysis, statistical functions / tools, graphs, charts, pivot and MIS.

Can u please provide me complete training details including fee structure, complete duration and training hours and location. «less

0 0

Answer

You can add upto 6 Images

K

Krishna 18/11/2013

I would like to know the time duration and the fee for learning Microsoft Excel together with the morning shift or weekend classes if available.

0 0

Answer

You can add upto 6 Images

U

girja shankar 15/11/2013

I want to learn Excel

0 0

Answer

You can add upto 6 Images


Recommendations & reviews from previous Customers:

Sanjay Kumar

"Excellent knowledge of MS Excel. Share various industry level examples which are very useful for me"

attended Become Microsoft Excel Expert


Pratap

"Excellent training skills and knowledge of MS Excel. Share various industry level examples which are very useful for me"

attended Become Microsoft Excel Expert


Date and Time

Not decided yet.

About the Trainer

Shivkant Pathak picture

Shivkant Pathak

Graduate from CCS Unitversity


7 Years industrial experience in core MIS.

Trained Executives, Managers, Students.

Awarded 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 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 a Solution for Human Resource to taken user inputs in email. The data received are automatically saved to central database.
Seats Left-

Students Interested 0

Course Id: 9124