The online office suite office.live.com is available right now to anyone who wants to use it. One of the apps available within the suite is Excel Web App. It’s watered down compared to the full-installed Excel or OpenOffice.org Calc, however it does get the job done as long as you know the basics. Something which would otherwise be unknown unless you see...

For most of us, Excel is one of those programs where you use 10% of the functionality and only even know of 50% of it. Regardless of whether or not you fall into this category, an brief article you might want to take a look at is “Hidden gems in Excel 2007“. This points out and walks you through 3 functions which most of us would probably find very...

If you do data analysis in Excel, you are probably well aware with the myraid number of chart selections available to make your data graphical. If ever need help determining which one might be the best option, check out the Chart Advisor add-on for Excel. Ever struggled to find just the right chart for your data? Chart Advisor was created as a concept test to...

Excel is, without a doubt, the most versatile productivity tool available. It can do everything from number crunching to graphs and charts as well as intricate form layouts. One of the most practical everyday uses for this functionality is keeping track of your personal finances. If you have found a program dedicated to this functionality, such as Quicken or...

Over the past month or so, I have covered several different software packages for managing your personal and/or small business finances, so today I will provide some a resource to perhaps the most popular tool of all, Excel. On Microsoft Office Online, you can find lots of Excel Templates for managing budgets. Scrolling through the selections, everything from...

The distinguishing feature of a spreadsheet program such as Excel is that it allows you to create mathematical formulas and execute functions. Microsoft Excel has a set of prewritten formulas called Functions. A function is a small assignment that is performed to produce a result that can be reliably used without caring as to how the function works or how it was...

Click the file below to see the sample spreadsheet. [hidepost=1] Download spreadsheet example [/hidepost]

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...