Introduction to Microsoft Excel

Introduction to Microsoft Excel
                     

         
                        (Introduction and setting of MS Excel)              

In this lecture, I will cover the following topics.

   

      1-    What is Excel?

      2-    Understanding and customize

       Main menu (Quick access toolbar, Tabs and Ribbons)

      3-    Main interface of the MS Excel.

      4-    Customize the Excel environment.

1- What is MS Excel?

Microsoft Excel is spreadsheet software, is used to record and analyse numerical data. It is a collection of columns and rows that form a table. Alphabetical letters are assigned to columns and numbers are assigned to rows. The intersection point of a column and a row is called a cell. The address of a cell is given by the letter representing the column and the number representing a row.

2- Understanding the main menu.

The Quick Access Toolbar contains a set of commands that are independent of the tab on the ribbon. We can move the Quick Access Toolbar from top to below to the ribbon, and we can add or remove buttons that represent commands on the Quick Access Toolbar.

Click on the arrow just right to the quick access toolbar as mentioned.we can add or remove menu items by clicking on the arrow, a drop-down menu will open. Here we can select required menu items and unselect menu items that we do not want to appear on the toolbar. selected items will be shown on Quick Access Toolbar. 

If we click on More Commands the following window will appear and can further customize the Quick Access Toolbar by adding more menu items as desired.

Here we can add more commands to the Quick Access Toolbar from left box .

Customize Ribbons.

Go to file tab in main menu and then click on options the following box will appear  select customize Ribbon as shown below.here we can add more tabs and costomize ribbon as desired.

From this excel options box, we can customize whole excel options as given in left-most box in the above figure. i.e General, Formulas Proofing, save, Language, Advance etc.

3-Main  interface of excel spread sheet.

                                                     
                                                                    Download Exercise