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)

₹ 3,000

No Reviews Yet

Date and Time

Not decided yet.

Ravi Kumar

Microsoft Office Specialist Excel Expert-2010

About Ravi Kumar

I am a Certified Microsoft Office Specialist- Excel Expert 2010. I conduct Excel workshops. I have my own Excel website "www.excelsage.org " 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 "worklogics@gmail.com".
No reviews currently Be the First to Review

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:
Formulas
• References, Using $
• COUNTIF
• SUMIF
• IF, Nested IF, CHOOSE
• VLOOKUP, Adv VLOOKUP
• MATCH
• INDEX
• OFFSET
• SUMPRODUCT
• ROWS, COLUMNS
• SUMIFS, COUNTIFS
• IFERROR, ISERROR
• SMALL, LARGE
• Text Formulas
• Formula Debugging
Formatting
• 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
Charting
• Choosing correct chart
• Various charts in Excel
• Chart formatting Options
• Chart templates
• Dynamic charts
Tables
• 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.

Pre-requisites

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

Reviews

No reviews currently Be the First to Review

Gallery (4)

Discussions

Students Interested 1 (Seats Left 0)

₹ 3,000

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

Enquire

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.

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