Signup as a Tutor

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

Become Expert in Excel

No Reviews Yet

Delhi

Course ID: 6152

Delhi

Students Interested 0 (Seats Left 0)

No Reviews Yet

Date and Time

Not decided yet.

Deep Pandey picture
Deep Pandey

B.TECH

9 Years of Experience

About Deep Pandey

Personality Development and Training Big Data, Hadoop, Cassandra, Excel from past 5 years in various MNCs including TCS, Accenture, HCL etc
No reviews currently Be the First to Review

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

No reviews currently Be the First to Review

Students Interested 0 (Seats Left 0)

Post your requirement and let us connect you with best possible matches for Computer Software Classes Post your requirement now
Enquire

Enquire

Submit your enquiry for Become Expert in Excel

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