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 Become Expert in Excel

Please enter valid question or comment

Please enter your name.

Please enter valid email

Please enter valid Phone Number

Please enter the Pin Code.

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

Connect With Deep

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

course photo

Become Expert in Excel

Delhi

No Reviews Yet
0 Interested

About the Course


Today in every IT Industry, MS Excel plays a very crucial part. Either you are a Manager, Team Lead or working in Reporting Team. You must have good working knowledge of MS Excel.

In our class we will not only teach you the theory of Excel but also give its practical example and each student will get a chance to work over on the spot scenario.

At the end of the course you will be provided with the coaching notes too.

Topics Covered

Topics Covered
*Creating a List
*Using a Data Form
*Adding Records Using a Data Form
*Finding Records Using a Data Form
*Deleting Records Using a Data Form
*Sorting Records in a List
*Using AutoFilter in a List

WORKING WITH CHARTS

*Creating a Chart with the Chart Wizard
*Moving a Chart
*Resizing a Chart
*Changing a Chart Type
*Editing Chart Text
*Modifying Chart Options
*Formatting Category & Value Axis Data
*Formatting a Data Series
*Changing a Chart’s Source Data

WORKING WITH GRAPHICS

*Using the Drawing Toolbar
*Formatting Objects
*Inserting WordArt
*Inserting an Organization Chart
*Modifying an Organization Chart
WORKGROUP COLLABORATION
*Web Page Preview
*Converting Worksheets into Web Pages
*Inserting Hyperlinks
*Viewing & Editing Comments

IMPORTING & EXPORTING DATA

*Importing External Data into Excel
*Importing Text Data into Excel
*Importing Data from a Database
*Exporting Data from Excel
*Publishing Worksheets & Workbooks to the Web

FORMATTING NUMBERS

*Creating Custom Number Format
*Using Conditional Formatting
*Removing Conditional Formatting

WORKING WITH RANGES

*Naming a range
*Using a Named Range
*Deleting a Named Range
*Using the VLOOKUP Function

CUSTOMIZING EXCEL

*Creating a Macro
*Running a Macro
*Editing a Macro
*Adding a menu to the Menu Bar
*Adding a Commands to a Menu
*Adding Buttons to a Toolbar

DATA ANALTSIS TOOLS

*Tracing Formula Precedents
*Tracing Cell Dependents
*Tracing & Fixing Errors
*Creating a Pivot Table
*Rearranging a Pivot Table
*Filtering Pivot Table Data
*Creating a Pivot Chart

SUMMARIZING DATA

*Adding Subtotals to a List
*Nesting Subtotals
*Applying Advance Filters
*Adding Group & Outline Criteria to Ranges
*Using Data Validation
WHAT–IF DATA ANALYSIS

*Using Goal Seek
*Using Solver
*Creating & Displaying Scenarios

WORKGROUP COLLABORATIONS

*Locking/Unlocking Cells in a worksheet
*Protecting a Worksheet
*Protecting a Workbook
*Creating a Shared Workbook
*Tracking Changes to a Workbook
*Accepting & Rejecting Changes to a Workbook
*Password Protecting a Workbook
*Merging Workbooks

Who should attend

Managers, Team Leads, Students and all interested candidates can attend

Pre-requisites

Basic knowledge of computers

What you need to bring

NA

Key Takeaways

*Working with Excel in a professional environment.
*Excel shortcuts
*Steps to reduce your time of routine work.
Coaching Notes
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

Showing 1 to 1 of 1
P

Pradeep 17/05/2013

I need excel training - let me please know the course fee and duration of the course. How long, mode of payments and do you accept installments or else

Pradeep

0 0

Answer

You can add upto 6 Images


There are no Reviews yet. Be the First to Review

Date and Time

Not decided yet.

About the Trainer

Deep Pandey picture

Deep Pandey

B.TECH


Personality Development and Training Big Data, Hadoop, Cassandra, Excel from past 5 years in various MNCs including TCS, Accenture, HCL etc
Seats Left-

Students Interested 0

Course Id: 6152