loading......

coming soon

Coming Soon

We are in process of building the inventory of good professionals in this category

Got it!

Where do you need ?

location

Please select a Location.

Enquire

Submit your enquiry for MS Office Excel

Please enter valid question or comment

Please enter your name.

Please enter valid email

Please enter valid Phone Number

Please enter the Pin Code.

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

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

Share

course photo

MS Office Excel

South Extn., Delhi

No Reviews Yet
0 Interested

About the Course


Class Outline
1. Creating a Microsoft Excel Workbook
A. Starting Microsoft Excel
B. Creating a Workbook
C. Saving a Workbook
D. The Status Bar
E. Adding and Deleting Worksheets
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
E. Adding Your Name to Microsoft Excel
4. The Quick Access Toolbar
. Adding Common Commands
A. Adding Additional Commands with the Customize Dialog Box
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)
D. Headers and Footers
11. Advanced Formulas
. 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
14. Visualizing Your Data
. Inserting Charts
A. Editing Charts
15. Advanced Formatting
. Applying Conditional Formatting
A. Working with Styles
B. Applying Styles to Tables
C. Applying Styles to Cells
16. Using Pivot Tables
. Creating Pivot Tables
A. Preparing Your Data
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
A. Password Protecting a Workbook
B. Password Protecting a Worksheet
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
C. Adding Macros to the Quick Access Toolbar
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
E. Adding and Deleting Worksheets
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
E. Adding Your Name to Microsoft Excel
4. The Quick Access Toolbar
. Adding Common Commands
A. Adding Additional Commands with the Customize Dialog Box
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)
D. Headers and Footers
11. Advanced Formulas
. 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
14. Visualizing Your Data
. Inserting Charts
A. Editing Charts
15. Advanced Formatting
. Applying Conditional Formatting
A. Working with Styles
B. Applying Styles to Tables
C. Applying Styles to Cells
16. Using Pivot Tables
. Creating Pivot Tables
A. Preparing Your Data
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
A. Password Protecting a Workbook
B. Password Protecting a Worksheet
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
C. Adding Macros to the Quick Access Toolbar
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

Key Takeaways

MS Office
MS Excel
MS PPT
MS Access
Reviews
There are no Reviews yet. Be the First to Review
Questions and Comments

Thousands of experts Tutors, Trainers & other Professionals are available to answer your questions

Comment ?

Questions Guidelines

  • Start your question with simple statements like "what", "when", "where", or "how".
  • Ensure your question or answer is not offensive or insensitive - it may be voted down or banned.
  • Please provide as much detail as possible as this will allow our members to better understand and respond to your question.
  • Take some time to categorize your question. This will greatly help other users find the question.


You can add upto 6 Images

Ask


There are no Reviews yet. Be the First to Review

Date and Time

Not decided yet.

About the Trainer

Tanya

Post Graduate


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

Students Interested 0

Course Id: 13470