A Global Look at The Workbook

Now that certain features of Ribbon Interface (such as tabbed pages, contextual tabs and dialog launcher) have been explained, let’s take a global look at Excel’s workbook.

A workbook (as previously explained here) actually is an Excel file that contains many objects with their specific functions (Fig. 1).

Continue reading

Ribbon Interface: Dialog Launcher

One important change in Ribbon that doesn’t seem to be too obvious is the presence of dialog launcher. Ribbon interface with all those tab pages may provide user with all necessary commands for regular activities, such as formatting text in bold, changing lettercase, and so on. But there are also moments when specific, yet detailed commands need to be applied. This used to be handled through menu-driven interface – usually by the Format menu – but since the advent of Ribbon Interface all those instructions are “hidden” inside dialog launcher.

Continue reading

Ribbon Interface: Contextual Tab and Toolbar

Despite of the tabbed pages, Ribbon Interface also brings contextual tab and toolbar. These two improvements would provide a user with specific tasks when certain objects (such as Picture, Word Arts, Text Box, etc) in the worksheet are activated or highlighted.

Continue reading

Ribbon Interface: The Tabs

Compared to earlier versions with their menu-driven interface, Excel 2007 has a very different look-and-feel user interface, called Ribbon. Ribbon is actually a series of tabbed pages, each relates to a different activity type. For an example, if a user clicked the Insert tab, then he/she will be presented with an activity “group” pertaining to inserting and modifying an object. These tabs are probably the first thing that a user notices upon opening Excel.

Continue reading

Starting and Quitting Excel

This tutorial will basically explain how to start an Excel session and quit it. Just keep in mind that “Excel” here refers to Microsoft Excel 2007. I would like to assume that Excel had been installed on your computer, be it on your laptop or desktop PC, with a typical or standard configuration. No additional setup. I’d safely assume that you run Excel under Windows Vista or Windows 7 environment.¬†UV2HACYCKDZB

Continue reading

Color Bands to Resistance Value Converter with HLOOKUP


This blog entry is submitted to VLOOKUP Week

Converting color bands to the equivalent resistance value is a good example of how table lookup function can be employed. Anyone can pick a separate color for every band through a drop-down list (built from data validation facility) and Excel matches color selected to the reference table, counts and displays the resistance value. As a visual aid of the band and the corresponding color, a table containing both information should be used.

Continue reading

A Glimpse At Microsoft Excel

Microsoft Excel (or simply, “Excel”) is a spreadsheet application built by Microsoft, which is a part of Microsoft Office (or “Office”) application.¬†Initially called Multiplan in 1982, there are various versions of Microsoft Excel running in Windows platform. Among them are:

Continue reading

The Right Place to Start Learning Microsoft Excel

%d bloggers like this: