What you are going to Learn in this MS Excel course?

Click Here for Free Stock Management Excel Sheet

Understanding Excel Interface – 1

Topics covered in this Microsoft Excel Lecture
• How to open Microsoft Excel?
• What is the office button in Microsoft Excel?
• What is the Quick Access Tool bar?
• How to save an Excel document?
• What is the Tab Bar in Excel?
• What is the Ribbon in Excel?
• What is the Interface of Excel?
• What is the Box Name?
• What is the Formula Bar?

Format painter, clipboard, boarder, gridlines, cell formatting – 3

You will find following answers in this Microsoft excel Lecture.
• How to use copy in Excel?
• How to use Cut in Excel?
• How to use Paste in Excel?
• What is the Clipboard in Excel?
• How to use bold, italic and Underline in Excel?
• How to use Font Style and Font Size in Excel?
• How to change row height in Excel?
• How to change Column width in Excel?
• How to use Border in Excel?
• How to use Alignment in Excel?
• How to use Merge Cells in Excel?
• What is the wrap text in Excel?

Number group, general, number, currency, accounting, date format – 4

You will find following answers in this Microsoft excel Lecture.
• How to use General Format in Excel?
• How to use Number Format in Excel?
• How to use Currency format in Excel?
• How to use Accounting Format in Excel?
• How to use Short Date Format in Excel?
• How to use Long Date Format in Excel?
• How to use Time Format in Excel?
• How to use Percentage Format in Excel?
• How to use Fraction Format in Excel?
• How to use Scientific Format in Excel?
• How to use Text Format in Excel?
• How to use Custom Format in Excel?
• How to use Format Cells Dialog box in Excel?
• How to use Decimal points in Excel?
• How to use Symbol in Excel?

Conditional formatting with different criteria’s – 5

You will find following answers in this Microsoft excel Lecture.
• What is the Conditional Formatting in Excel?
• How to use Highlight Cell Rules in Conditional Formatting in Excel?
• How to use Greater than in Highlight Cell Rules in Conditional Formatting in Excel?
• How to use Less Than in Highlight Cell Rules in Conditional Formatting in Excel?
• How to use Between in Highlight Cell Rules in Conditional Formatting in Excel?
• How to use Equal to in Highlight Cell Rules in Conditional Formatting in Excel?
• How to use Text that Contains in Highlight Cell Rules in Conditional Formatting in Excel?
• How to use A Date Occurring in Highlight Cell Rules in Conditional Formatting in Excel?
• How to use Duplicate Values in Highlight Cell Rules in Conditional Formatting in Excel?
• How to use Clear Rules in Conditional Formatting in Excel?
• What is the Manage Rules in Conditional Formatting in Excel?

Conditional formatting with different criteria’s, data bars etc – 6

You will find following answers in this Microsoft excel Lecture.
• How to use Top/Bottom Rules in Conditional Formatting in Excel?
• How to use Data Bars in Conditional Formatting in Excel?
• How to use Color Scales in Conditional Formatting in Excel?
• How to use Icon Sets in Conditional Formatting in Excel?
• How to use New Rule in Conditional Formatting in Excel?

Conditional formatting managing rules, above and below average etc – 7

You will find following answers in this Microsoft excel Lecture.
• How to use Top/Bottom Rules in Conditional Formatting in Excel?
• How to use Top 10 Items in Top/Bottom Rules in Conditional Formatting in Excel?
• How to use Top 10% in Top/Bottom Rules in Conditional Formatting in Excel?
• How to use Bottom 10 Items in Top/Bottom Rules in Conditional Formatting in Excel?
• How to use Bottom 10% in Top/Bottom Rules in Conditional Formatting in Excel?
• How to use Above Average in Top/Bottom Rules in Conditional Formatting in Excel?
• How to use Below Average in Top/Bottom Rules in Conditional Formatting in Excel?

Cell group, insert cell, insert rows and sheet – 9

You will find following answers in this Microsoft excel Lecture.
• How to Insert a cell in Excel?
• How to Insert a row in Excel?
• How to Insert a Column in Excel?
• How to Insert a Sheet in Excel?
• How to Delete a cell in Excel?
• How to Delete a sheet row in Excel?
• How to Delete a sheet Column in Excel?
• How to use row height in Excel?
• How to use AutoFit row height in Excel?
• How to use Column Width in Excel?
• How to use AutoFit Column Width in Excel?
• How to use row, column and sheet Hide and Unhide in Excel?
• How to use Rename Sheet in Excel?