The Chart Wizard brings you through the process of creating a chart by displaying a series of dialog boxes. [hidepost=1]Enter the data into the worksheet and highlight the range for which you want to make a chart including headers.Click the Chart Wizard icon on the standard toolbar to view the first Chart Wizard dialog box or choose Chart option from the...

Charts are pictorial representation of worksheet data and make it easy for users to make comparisons, patterns, and trends in data. Charts present worksheet data in graphical or pictorial form, which is easier to read and understand. For instance, rather than having to analyze several columns of worksheet numbers, you can see at a glance whether sales are...

Mathematical & Trigonometric FunctionsAbs() :This function is used to return the absolute value of a number. Syntax : Abs(number) Example : =Abs(A1) , Abs(-54) Result : 5 54 Sqrt() : This function is used to return the square root of a number. Syntax : Sqrt(number) Example : =Sqrt(A5) , Sqrt(D1*5) Result : 5 10 [hidepost=1] Round(): This function is used...

A cell in a worksheet is identified as C5, D8 etc. When a cell is referred to in a formula, this is called cell referencing. There are three types of referencing. [hidepost=1] Relative References When you create a formula, references to cells or ranges are usually based on their position relative to the cell that contains the formula. In the following example,...

You can use borders to make entries on your spreadsheet stand out. Accountants usually place a single underline above a final number and a double underline below. The following illustrates: [hidepost=1]Select the cell A1. Choose Format ? Cells from the menu. Choose the Border tab.Click on the single underline from the Style boxClick the top of the...

The general arrangement of data is known as formatting. The contents of selected cells can be formatted in different ways. The quick way to format the data is to use the format toolbar . Font and cell attributes can be added from shortcut buttons on the formatting tool bar. If this toolbar is not already visible on the screen, select View?Toolbars?Formatting...

You may open an existing file in MS Excel and edit the worksheet, copy or move data in the worksheet and again save it. [hidepost=1] Open an Existing File To open a file in MS Excel follow these steps:Click on File in the menu. Select Open option (When file is selected, there is a list of most recently saved files, if budget.xls is not there select Open...

By the end of this lesson, you should be able to open MS Excel and create a worksheet, select cell, enter data and save and edit the worksheet. Excel allows you to create spreadsheets much like paper ledgers that can perform automatic calculations. [hidepost=1] Starting MS ExcelClick on Start button. Click on Program. Click on Microsoft Office. Click on MS...

Before discussing a spreadsheet one should understand; What is a spreadsheet? A spreadsheet is simply a sheet of paper on which horizontal and vertical lines are drawn to generate a rectangular grid, similar to a mathematical notebook. Each blank square or block is for writing the number or text or data as required. [hidepost=1]A Rectangular Grid For Data...

On Day 10, I said that the information product is one of the best ways to make money online for multiple reasons. But, this inevitably means that you have to create an information product to sell. Next thoughts might include:What do I know that somebody would pay me for? Am I expected to create an entire info product? I don’t have time! I can’t...