loading......

coming soon

Coming Soon

We are in process of building the inventory of good professionals in this category

Got it!

Where do you need ?

location

Please select a Location.

Enquire

Submit your enquiry for Expertising Microsoft Excel

Please enter valid question or comment

Please enter your name.

Please enter valid email

Please enter valid 10 digit Phone Number

Note: Please enter the phone number that you will be calling from.

Please enter the Pin Code.

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

Connect With Vinay

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

Expertising Microsoft Excel

Expertising Microsoft Excel

Hari Nagar, Delhi

5,500

No Reviews Yet
0 Interested

About the Course


This is an industry based course, will teach the Microsoft Excel which is being used in doing analysis and preparing advance MIS reports in the Industry.
It is a fully practical based training and beneficial for career oriented people.

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

Who should attend

MS Office Specialist, MIS Personals, VBA Programmer, Accounts Personal, Project Managers, Developers, Technical/ Test Leads, Program Managers, Project Managers, Research Workers, Freelancers, Data analysis departments, HR Managers, Students

Pre-requisites

Basic understanding of Microsoft 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.

Develop Automated Dashboard.

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
There are no Reviews yet. Be the First to Review
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


There are no Reviews yet. Be the First to Review

Date and Time

Not decided yet.

About the Trainer

Vinay Nagpal picture

Vinay Nagpal

Post Graduate


8 Years industrial experience in core MIS and Data Analytics and working as a Manager in a MNC and handling the Analytics team
Seats Left-

Students Interested 0

Course Id: 12715