Getting Started with Excel

Starting Excel with the Start Menu
1) Click on Start Button
2) Select All Programs
3) Select Microsoft Office
4) Click on Microsoft Excel 2010

Starting Excel by Using Run Option
1) Click on Start Button
2) Select Run (a dialog box will appear)
3) Type Excel
4) Enter
This will launch the Microsoft Excel 2010 application and you will see the
following excel window.

There are 5 important areas in the screen

  1. Quick Access Toolbar:
    This is a place where all the important tools can be placed. When you start
    Excel for the very first time, it has only 3 icons (Save, Undo, and Redo). But you can add any feature of Excel to to Quick Access Toolbar so that you can easily access it from anywhere (hence the name).
  2. Ribbon:
    Ribbon is like an expanded menu. It depicts all the features of Excel in easy to
    understand form. Since Excel has 1000s of features, they are grouped in to
    several ribbons. The most important ribbons are ‚Äď Home, Insert, Formulas, and Page Layout & Data.
  3. Formula Bar:
    This is where any calculations or formulas you write will appear. You will
    understand the relevance of it once you start building formulas.
  4. Spreadsheet Grid:
    This is where all your numbers, data, charts & drawings will go. Each Excel file
    can contain several sheets. But the spreadsheet grid shows few rows & columns
    of active spreadsheet. To see more rows or columns you can use the scroll bars
    to the left or at bottom. If you want to access other sheets, just click on the
    sheet name (or use the shortcut CTRL+Page Up or CTRL+Page Down).
  5. Status bar:
    This tells us what is going on with Excel at any time. You can tell if Excel is
    busy calculating a formula, creating a pivot report or recording a macro by just looking at the status bar. The status bar also shows quick summaries of
    selected cells (count, sum, average, minimum or maximum values). You can
    change this by right clicking on it and choosing which summaries to show.

The Ribbon
Understanding the Ribbon is a great way to help understand the changes
between Microsoft 2003 to Microsoft 2007/2010. The ribbon holds all of the
information in previous versions of Microsoft Office in a more visual stream line
manner through a series of tabs that include an immense variety of program
features.
Home Tab
This is the most used tab; it incorporates all text and cell formatting features
such as font and paragraph changes. The Home Tab also includes basic
spreadsheet formatting elements such as text wrap, merging cells and cell style


Insert Tab
This tab allows you to insert a variety of items into a document from
pictures, clip art, and headers and footers.

Leave a Reply