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

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

Date and Time

Not decided yet.

About the Trainer

Deep Pandey picture

Avg Rating

Reviews

Students

Courses

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

Reviews

No reviews currently

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

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 25 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, 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 UrbanPro.com. 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