Signup as a Tutor

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

# MS Office Excel

No Reviews Yet

South Extn., Delhi

Course ID: 13470

South Extn., Delhi

Students Interested 0 (Seats Left 0)

No Reviews Yet

Class Outline
1. Creating a Microsoft Excel Workbook
A. Starting Microsoft Excel
B. Creating a Workbook
C. Saving a Workbook
D. The Status Bar
F. Closing a Workbook
2. The Ribbon
. Tabs
A. Groups
B. Commands
3. The Backstage View (The File Menu)
. Introduction to the Backstage View
A. Opening a Workbook
B. New Workbooks and Excel Templates
C. Printing Worksheets
D. Getting Help
B. Adding Ribbon Commands or Groups
C. Placement
5. Entering Data in Microsoft Excel Worksheets
. Entering Text
A. Using AutoComplete
B. Entering Numbers and Dates
C. Using the Fill Handle
6. Formatting Microsoft Excel Worksheets
. Selecting Ranges of Cells
A. The Font Group
B. The Alignment Group
C. The Number Group
7. Using Formulas in Microsoft Excel
. Math Operators and the Order of Operations
A. Entering Formulas
B. AutoSum (and Other Common Auto-Formulas)
C. Copying Formulas and Functions
D. Relative and Absolute Cell References
8. Working with Rows and Columns
. Inserting Rows and Columns
A. Deleting Rows and Columns
B. Setting Row Height and Column Width
C. Hiding and Unhiding Rows and Columns
D. Freezing Panes
9. Editing Worksheets
. Find
A. Find and Replace
B. Using the Clipboard
10. Finalizing Microsoft Excel Worksheets
. Setting Margins
A. Setting Page Orientation
B. Setting the Print Area
C. Print Scaling (Fit Sheet on One Page)
. Using Named Ranges in Formulas
A. Naming a Single Cell
B. Naming a Range of Cells
C. Naming Multiple Single Cells Quickly
D. Using Formulas That Span Multiple Worksheets
E. Using the IF Function
F. Using the PMT Function
G. Using the VLOOKUP Function
H. Using the HLOOKUP Function
I. Using the CONCATENATE Function
J. Using the PROPER Function
K. Using the LEFT and RIGHT Functions
L. Using Date Functions
12. Working with Lists
. Converting a List to a Table
A. Removing Duplicates from a List
B. Sorting Data in a List
C. Filtering Data in a List
D. Adding Subtotals to a List
E. Grouping and Ungrouping Data in a List
13. Working with Illustrations
. Working with Clip Art
A. Using Shapes
B. Working with SmartArt
. Inserting Charts
A. Editing Charts
. Applying Conditional Formatting
A. Working with Styles
B. Applying Styles to Tables
C. Applying Styles to Cells
16. Using Pivot Tables
. Creating Pivot Tables
B. Inserting a Pivot Table
C. Inserting Slicers
D. Inserting Pivot Charts
E. More Pivot Table Functionality
17. Auditing Worksheets
. Tracing Precedents
A. Tracing Dependents
B. Showing Formulas
18. Data Tools
. Converting Text to Columns
A. Data Validation
B. Consolidating Data
C. Goal Seek
19. Working with Others
. Protecting Worksheets and Workbooks
C. Password Protecting Ranges in a Worksheet
D. Tracking Changes
E. Accepting or Rejecting Changes
20. Recording and Using Macros
. Recording Macros
A. Running Macros
B. Editing Macros
21. Random Useful Items
. Sparklines
A. Inserting Sparklines
B. Customizing Sparklines
C. Importing and Exporting Files
D. Importing Text Files
E. Exporting Worksheet Data to Microsoft Word
F. Exporting Excel Charts to Microsoft Word

## Topics Covered

Class Outline
1. Creating a Microsoft Excel Workbook
A. Starting Microsoft Excel
B. Creating a Workbook
C. Saving a Workbook
D. The Status Bar
F. Closing a Workbook
2. The Ribbon
. Tabs
A. Groups
B. Commands
3. The Backstage View (The File Menu)
. Introduction to the Backstage View
A. Opening a Workbook
B. New Workbooks and Excel Templates
C. Printing Worksheets
D. Getting Help
B. Adding Ribbon Commands or Groups
C. Placement
5. Entering Data in Microsoft Excel Worksheets
. Entering Text
A. Using AutoComplete
B. Entering Numbers and Dates
C. Using the Fill Handle
6. Formatting Microsoft Excel Worksheets
. Selecting Ranges of Cells
A. The Font Group
B. The Alignment Group
C. The Number Group
7. Using Formulas in Microsoft Excel
. Math Operators and the Order of Operations
A. Entering Formulas
B. AutoSum (and Other Common Auto-Formulas)
C. Copying Formulas and Functions
D. Relative and Absolute Cell References
8. Working with Rows and Columns
. Inserting Rows and Columns
A. Deleting Rows and Columns
B. Setting Row Height and Column Width
C. Hiding and Unhiding Rows and Columns
D. Freezing Panes
9. Editing Worksheets
. Find
A. Find and Replace
B. Using the Clipboard
10. Finalizing Microsoft Excel Worksheets
. Setting Margins
A. Setting Page Orientation
B. Setting the Print Area
C. Print Scaling (Fit Sheet on One Page)
. Using Named Ranges in Formulas
A. Naming a Single Cell
B. Naming a Range of Cells
C. Naming Multiple Single Cells Quickly
D. Using Formulas That Span Multiple Worksheets
E. Using the IF Function
F. Using the PMT Function
G. Using the VLOOKUP Function
H. Using the HLOOKUP Function
I. Using the CONCATENATE Function
J. Using the PROPER Function
K. Using the LEFT and RIGHT Functions
L. Using Date Functions
12. Working with Lists
. Converting a List to a Table
A. Removing Duplicates from a List
B. Sorting Data in a List
C. Filtering Data in a List
D. Adding Subtotals to a List
E. Grouping and Ungrouping Data in a List
13. Working with Illustrations
. Working with Clip Art
A. Using Shapes
B. Working with SmartArt
. Inserting Charts
A. Editing Charts
. Applying Conditional Formatting
A. Working with Styles
B. Applying Styles to Tables
C. Applying Styles to Cells
16. Using Pivot Tables
. Creating Pivot Tables
B. Inserting a Pivot Table
C. Inserting Slicers
D. Inserting Pivot Charts
E. More Pivot Table Functionality
17. Auditing Worksheets
. Tracing Precedents
A. Tracing Dependents
B. Showing Formulas
18. Data Tools
. Converting Text to Columns
A. Data Validation
B. Consolidating Data
C. Goal Seek
19. Working with Others
. Protecting Worksheets and Workbooks
C. Password Protecting Ranges in a Worksheet
D. Tracking Changes
E. Accepting or Rejecting Changes
20. Recording and Using Macros
. Recording Macros
A. Running Macros
B. Editing Macros
21. Random Useful Items
. Sparklines
A. Inserting Sparklines
B. Customizing Sparklines
C. Importing and Exporting Files
D. Importing Text Files
E. Exporting Worksheet Data to Microsoft Word
F. Exporting Excel Charts to Microsoft Word

## Who should attend

Anyone can attend.

## Pre-requisites

Basic Knowledge of Computer.

## What you need to bring

Note book and Pen Only

MS Office
MS Excel
MS PPT
MS Access

Not decided yet.

## Students also enrolled in these Courses

Avg Rating

0 Reviews

0 Students

2 Courses

Tanya

Having 5 + Years of experience in same field as a corporate trainer as well as online and retail trainer.

## Reviews

No reviews currently Be the First to Review

## Discussions

Students Interested 0 (Seats Left 0)

Post your requirement and let us connect you with best possible matches for Microsoft Excel Training classes Post your requirement now

Enquire

Submit your enquiry for MS Office Excel

Please enter valid question or comment

Connect With Indohora Galaxy

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 Enter valid Email or Phone Number