Signup as a Tutor

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

Expertising Microsoft Excel

No Reviews Yet

Hari Nagar, Delhi

Course ID: 12715

Hari Nagar, Delhi

Students Interested 0 (Seats Left 0)

₹ 5,500

No Reviews Yet

Date and Time

Not decided yet.

Vinay Nagpal picture
Vinay Nagpal

Post Graduate

5 Years of Experience

About Vinay Nagpal

8 Years industrial experience in core MIS and Data Analytics and working as a Manager in a MNC and handling the Analytics team
No reviews currently Be the First to Review

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

No reviews currently Be the First to Review

Discussions

Students Interested 0 (Seats Left 0)

₹ 5,500

Post your requirement and let us connect you with best possible matches for Microsoft Excel Training classes Post your requirement now
₹ 5,500 Enquire

Enquire

Submit your enquiry for Expertising Microsoft Excel

Please enter valid question or comment

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