Signup as a Tutor

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

Microsoft Excel training

No Reviews Yet

APHB Colony, Hyderabad

Course ID: 4393

APHB Colony, Hyderabad

Students Interested 1 (Seats Left 0)

No Reviews Yet

About the Course

Basic and Advanced Excel courses are tailor made mainly for the needs of BPO Employees, MBA Students and Excel Enthusiasts.

Topics Covered

Basic Excel Course contains the following:

• Creating a Microsoft Excel Workbook
• Starting Microsoft Excel
• Creating a Workbook
• Saving a Workbook
• The Status Bar
• Adding and Deleting Worksheets
• Closing a Workbook
• The Ribbon
• Tabs
• Groups
• Commands
• The Backstage View (The File Menu)
• Introduction to the Backstage View
• Opening a Workbook
• New Workbooks and Excel Templates
• Printing Worksheets
• Getting Help
• Adding Your Name to Microsoft Excel
• The Quick Access Toolbar
• Adding Common Commands
• Adding Additional Commands with the Customize Dialog Box
• Adding Ribbon Commands or Groups
• Placement
Entering Data in Microsoft Excel Worksheets
• Entering Text
• Using Auto Complete
• Entering Numbers and Dates
• Using the Fill Handle
• Formatting Microsoft Excel Worksheets
• Selecting Ranges of Cells
• The Font Group
• The Alignment Group
• The Number Group
• Using Formulas in Microsoft Excel
• Math Operators and the Order of Operations
• Entering Formulas
• Auto Sum (and Other Common Auto-Formulas)
• Copying Formulas and Functions
• Relative and Absolute Cell References
• Working with Rows and Columns
• Inserting Rows and Columns
• Deleting Rows and Columns
• Setting Row Height and Column Width
• Hiding and Un-hiding Rows and Columns
• Freezing Panes
• Editing Worksheets
• Find
• Find and Replace
• Using the Clipboard
• Finalizing Microsoft Excel Worksheets
• Setting Margins
• Setting Page Orientation
• Setting the Print Area
• Print Scaling (Fit Sheet on One Page)
• Headers and Footers

Conditional Formatting
• Applying Conditional Formatting
• Working with Styles
• Applying Styles to Tables
• Applying Styles to Cells

Working with Lists
• Converting a List to a Table
• Removing Duplicates from a List
• Sorting Data in a List
• Filtering Data in a List
• Adding Subtotals to a List
• Grouping and Ungrouping Data in a List

Visualizing Your Data
• Inserting Charts
• Editing Charts

• Data Validation
• Pivot Tables

Advanced Excel contains some Basic course contents and the following:
• References, Using $
• IF, Nested IF, CHOOSE
• Text Formulas
• Formula Debugging
• Paste Special
• Format Painter
• Custom Cell Formats
• Date / Time Formatting
• Table Formats
• Formatting Best Practices
• Freezing Rows, Splits
• Formatting for Print
Conditional Formatting
• Intro to Conditional Formatting
• Formulas in Conditional Formatting
• Using Data bars, Icons, Color Scales
• Advanced Conditional Formatting thru Examples
• Removing Conditional Formatting, Cleaning
• Choosing correct chart
• Various charts in Excel
• Chart formatting Options
• Chart templates
• Dynamic charts
• Excel 2007 Tables –Intro
• Benefits of using tables
• Table formatting
• Table formulas
• Table –named ranges
Pivot Tables
• What is a Pivot and why use one?
• Creating Pivots
• Summarizing data
• Calculated Fields, Calculated Items
• Grouping Data
• Pivot Table Tips
• Pivot Charts –Intro
Data Filters
• Data Filters
• Sorting
• Data Validation
• Error Messages, Invalid Data
• Advanced Filters
• Filters in Tables, Pivots
Importing Data
• Text to Columns
• Importing Text Files
• Importing Web Data
• Importing MS Access Data
Advanced Formulas
• Named Ranges, What are they and why use them?
• Formula Audit
• Array Formulas –Intro
• Calculation Modes and uses
• Formula Errors and What to do?
Form Controls, Macros
• Developer Toolbar / Ribbon
• What are Form Controls?
• Using Scroll-bar Control
• Using Check boxes
• What is a Macro?

Who should attend

Anybody who want to use Excel in an efficient way and get more done by it.


Familiarity with Computers and Basic Computer knowledge especially Microsoft Windows Operating System.

What you need to bring

The students who have laptops can bring them for their hands on working.

Key Takeaways

At the end of the course, the student will be confident in using the following Excel features:

From Basic Course:

1. Excel features covered in Basic training
2. Basic Excel formulas i.e. Vlookup, H lookup
3. Conditional Formatting,
4. Basic Charting,
5. Basic Pivot tables
6. Data Filters
7. Sorting
8. Data Validation

From Advanced Course
Users will be confident in using the following:

1. Advanced functions
2. Interactive Charts
3. Advanced formulas
4. What-if Analysis
5. Scenario Manager
6. Interactive Pivot Charts
and many more Advanced Excel functionalities

Date and Time

Not decided yet.

Gallery (4)

About the Trainer

5 Avg Rating

5 Reviews

5 Students

3 Courses

Ravi Kumar

Microsoft Office Specialist Excel Expert-2010

I am a Certified Microsoft Office Specialist- Excel Expert 2010. I conduct Excel workshops. I have my own Excel website " " on which I share Excel tips &tricks . We have an active forum where you can post Excel queries and get instant tips. For Excel classes and workshops, please contact me on +91 98668 60188 or "".


No reviews currently Be the First to Review


Students Interested 1 (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 Microsoft Excel training

Please enter valid question or comment

Please select a category

Please enter your name.

Please enter valid Phone Number

Please enter the Pin Code.

Please check the fields again.

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

Connect With Excel Sage

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