Become Expert in Excel

No Reviews Yet


Course ID: 6152


Students Interested 0 (Seats Left 0)

No Reviews Yet

Date and Time

Not decided yet.

Deep Pandey picture
Deep Pandey


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


*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


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


*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


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


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


*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


*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


*Adding Subtotals to a List
*Nesting Subtotals
*Applying Advance Filters
*Adding Group & Outline Criteria to Ranges
*Using Data Validation

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


*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


Basic knowledge of computers

What you need to bring


Key Takeaways

*Working with Excel in a professional environment.
*Excel shortcuts
*Steps to reduce your time of routine work.
Coaching Notes


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


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 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 the OTP sent to your registered mobile number.

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 is India's largest network of most trusted tutors and institutes. Over 25 lakh students rely on, to fulfill their learning requirements across 1,000+ categories. Using, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 6.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more