Nov
28
2011

Excel 2010 – Ch:01:B – Introducing Excel 2010 - User Interface

Babu
Posted 3 years 21 days ago ago by Babu     
  • Currently 4.00/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5
  
 

Advanced Excel 2010 – Ch:01:B – Introducing Excel 2010 - User Interface

Before you can start using Excel, you must first start Excel. This brings the Excel window onto the Windows desktop, and you can then begin using the program. For all the tasks in this series, we assume that you have already installed Excel 2010 on your computer. We have used Windows 7 as the operating system for this tutorial.

Start Excel

Excel can be started in the same way as you would do any application.

  1. Click Start. The Start menu appears.
  2. Click All Programs. The App Programs menu appears.
  3. Click Microsoft Office. The Microsoft Office menu appears.
  4. Click Microsoft Excel 2010. The Microsoft Excel window appears on the desktop. 

While this is not the only way, but if it’s the first time and you don’t have any shortcuts created, then this would be the easiest approach.

If you find it taking too many steps or for some reason unable to find the Excel icon with the steps mentioned above, then you can try another approach:

  1. Click Start. The Start menu appears.
  2. At the bottom of the Start menu, you will find the search box. Just type in Excel, which will display all the programs that are available with the name containing Excel.
  3. Click Microsoft Excel 2010. The Microsoft Excel window appears on the desktop.

After you have used Excel a few times, it will automatically appear on the main Start menu under the most-used programs list. In such a case, you can click that icon to start the program without going through all the steps mentioned above. However, if you don’t use excel for long and if you are using other applications, there are chances that it may disappear from the most-used programs list.

To avoid the Excel icon disappearing from the list, you can pin it. You can either pin the Excel icon onto the Start menu or onto the Taskbar. To force the Excel icon onto the Start menu follow these steps:

  1. Perform Steps 1 to 3 as mentioned above
  2. Right-clicking the Microsoft Excel 2010 icon, and then clicking Pin to Start Menu, or click Pin to Taskbar to add the Excel icon to the taskbar.

This is what you see once you start Excel 2010. Microsoft Excel program begins with a new, blank workbook displayed ready for you to do what you set out to achieve.

Except for some set of tabs with a wide range of icons and buttons, the large portion of the window is covered with square boxes with white background. Here you go, this is Excel 2010 UI which you will be spending most part of your time in this tutorial and also in your daily life while using Excel.

Exploring Excel 2010 UI

For those users who have worked with Excel 2003 and earlier, you may find this interface a bit different with all those tabs at the top and missing menus that you might have got accustomed. This is because, starting with Excel 2007, the programs UI somewhat underwent a dramatic overhaul, which for veteran users might require some getting used to, while the beginners might be at ease since they are fresh and not in confused state as the veterans.

Before I start to take you a tour of Excel 2010 UI, let me give you a brief introduction about some of the common terms involved with Excel.

Excel documents are known as Workbooks. A single Workbook can store as many sheets as will fit into memory, and these sheets are stacked like the pages in a notebook.

Sheets can be either:

  • Worksheets: a normal Spreadsheet with rows and columns in a grid format.
  • Chart sheets: a special sheet that holds a single chart.

Worksheets are where you will spend most of your time on Excel. Each worksheet is made up of a grid of cells, with 1,048,576 rows and 16,384 columns. While Excel numbers rows starting with 1, it uses letters to columns which start with A. When Excel uses all the letters of the alphabet, it continues with AA, AB, and so on ending with XFD. So column 1 is A, column 26 is Z, column 27 is AA, column 52 is AZ, column 53 is BA, and so on. It ends with column 16384 which is XFD.

Rows are numbered from 1 to 1,048,576, and columns are labeled from A to XFD. The intersection of a row and a column is called a cell. In total, there are 17,179,869,184 cells — more than enough for just about any use. Cells have addresses, which are based on their row and column. The upper-left cell in a worksheet is called A1, and the cell down at the bottom right is called XFD1048576.


Leave Your Comments