Microsoft Excel

An overview of how to use helpful Microsoft Excel functions (What-If Analysis, Pivot Tables, Text to Columns and Remove Duplicates).

Learn to save, print, find or select all with keyboard shortcuts in Microsoft's popular Excel and Word programs.

Open Financial Exchange (OFX) is a client-server system that enables direct communication between the client and the financial organization's server.

Excel has several little secrets that many occasional users are not aware. Learning these secrets can make you more productive and save you lots of time.

Microsoft Excel 2007 data forms make entering data into wide spreadsheets a simple matter of entering data into a fill-in-the-blanks form.

A group of one or more cells in Excel is called a "range". This article tells you the basics of how to name, identify, and select ranges in Excel.

Microsoft Excel worksheets can be very large, making navigation tedious and time consuming. Splitting the worksheet into panes can speed up this process and make it easier.

This is a guide to the most used keyboard shortcuts in Microsoft Excel. The keyboard shortcuts will help save you time when you are working on spread sheets and more in Microsoft Excel.

If you use Microsoft Excel but haven't yet mastered pivot tables, what are you waiting for? This one function is so simple to master and will change the way you work with Microsoft Excel.

This tutorial will show you how to automatically and manually align the data horizontally or vertically.

In this tutorial I will show you how to easily freeze panes horizontal and vertical. It is primarily used when you want some part of content (usually header) to freeze on the screen and all the underlying data to scroll.

This tutorial will show you how to protect and unprotect a Microsoft Excel worksheet.

This tutorial shows by example how to convert a CSV file to an XLS file using Microsoft Excel.

This article answer some of the most common questions when it comes to exporting to CSV.

This tutorial shows you how you can get and import data from a text file to a Microsoft Excel workshet.

This tutorial uses the Microsoft Excel external data functionality to get stock quotes from MSN Money.

This article lists the 10 most common string function along with a brief description and an example of how to use them in Microsoft Excel.

This article talks about one of the most common type of functions, the IF function. The concepts in this article applies to pretty much any programming language, but I will use Microsoft Excel as the example.

This is a description of functions in general when it comes to how they work and the parts that go into functions in Microsoft Excel.

This tutorial shows you, by example, how to create a chart in Microsoft Excel.

In Microsoft Excel, often you will want to compare two cells. The exact function does just that. This tutorial shows you how to properly use the exact function using an example.

This article lists the most common groups of functions for Microsoft Excel.

This tutorial shows you how to merge multiple cells into one large cell and provides an outline for it, so that it stands out.

This article shows you how to perform the five basic operations to a worksheet in Microsoft Excel.

Creating a calendar in Microsoft Excel is simple and easy. All you need is the program and a printer to print your calendar once you're finished.

When we are working on a spreadsheet in Microsoft Excel, we may find it necessary from time to time to protect or lock some of the cells or the whole spreadsheet.

Microsoft Excel is an incredibly popular and widely used piece of software. As such, there are tons of places to turn to if you find yourself in need of assistance with Microsoft Excel.

Microsoft's Excel application uses .XLS files- but how do they function?

A short tutorial explaining where and how to legally download Microsoft Excel.

Many people utilize spreadsheet programs such as Microsoft Excel on a daily basis. Many people also find this to be a tedious task. Employing a few simple keyboard shortcuts can make your work with Microsoft Excel more efficient and can make your life infinitely easier.