Spreadsheets

If you use Excel 2007 a lot, you may have noticed when you work with a large file, Excel sometimes creates automatic backups of the file you are working with. These files often save themselves to...

Microsoft Excel lets you create, calculate and organize data. You can create tables, charts and records quickly using the inbuilt tools that come with Excel or create your own. As your data grows,...

Creating combo boxes in Microsoft Excel is quite simple if you know how. A combo box is a drop-down list from which one of many items can be selected. You can create a combo box in your Excel...

Many offices use Microsoft Excel to create thorough spreadsheets containing extensive data and demonstrative charts that display information at a glance. If you have never used MS Excel, you might...

If you've ever worked with a worksheet in excel that had a super huge number of rows, you know how hard to navigate it can become when you delete some of those rows. Excel still views those rows...

Anyone who has ever used excel to handle large amounts of data knows how frustrating it can be to manually look for and remove duplicate entries. With Excel 2007 Microsoft has made it easy to...

A box plot is a hybrid of a line chart and a bar chart, which lets you graph several ranges of numbers using the same axes. It is a useful tool for illustrating survey results, demographic trends...

Lotus 1-2-3 is part of the SmartSuite office suite and can be used as an alternative to other numerical spreadsheet software such as Microsoft Excel. Spreadsheets created by Lotus 1-2-3 are given...

Keeping track of your Grades is an important step in succeeding in school. The easiest and most efficient method is to use Microsoft Excel to do the work for you!

A spreadsheet is a computerized table consisting of individual cells arranged into rows and columns. Information can easily be entered into, modified at, and deleted from the cells. Though in...

Microsoft Excel is a spreadsheet program used to analyze financial data. It also has charting, database and programming capabilities through its many menus, toolbars and palettes.

An organizational chart shows the hierarchy of a company or a project. Each level in the hierarchy is represented by a row of boxes. The levels are stacked one on top of the other like a pyramid....

You have a list of data in a single column in Excel, and would like to rearrange the data randomly. This can be done easily with the use of the RAND() function.

Microsoft Excel is spreadsheet software used for everything from basic calculations to complex computations. One of the features of Excel is its built-in formulas. One of the complex calculations...

As the industry standard for spreadsheet software, Microsoft Excel comes with many advantages to the new user or the user transitioning from another spreadsheet package. Over several decades,...

Pie charts are an easy way to display percentile information at a glance. Microsoft Excel makes it simple to create a pie chart in just a few steps. You input the data into an Excel worksheet and...

Along with all of the high-quality, professional-looking documents, spreadsheets and presentations you can create with Apple’s iWork ’09 suite of programs, you can also share them with a click of...

How do I create a Pivot Table in Microsoft Excel? Not only do many Excel users shy away from creating Pivot Tables, they’re not even sure what their purpose is. If you’re one of those people,...

Let's say you an a Microsoft Excel spreadsheet where you are inputting the daily temperatures. What you want is the daily average of those values for the current month. Sure you could sum up all...

You created a graph or chart in Excel, but it is blocking important worksheet data you need to work with. Your options are to resize the chart so it does not block data or move the chart out of...

You can format your Excel cells one at a time or a range at a time in the same way or with different looks. Instead of spending all this time formatting, Excel has already done some of the work...

Spreadsheets are a great way to keep track of data. Most spreadsheet programs contain formula options to meet the needs of most users. A formula is the manner in which a spreadsheet performs a...

Microsoft Excel is a computer application that allows you to do basic spreadsheet and math functions. With this tool, you can create balance sheets, standard input forms, databases, reports, or...

Microsoft Office Excel is a popular software program that is part of the Microsoft Office Suite. Excel is used to create spreadsheets, charts, databases and more, offering the familiar toolbar to...

The spreadsheet program Microsoft Excel has become so popular among businesses that many list proficiency as a job requirement when hiring for any accounting or administrative position. Excel...

You can easily paste an Excel chart or an area of a spreadsheet into a Word document or other file. However, there are times when you need to present the entire worksheet or workbook, but also...

To stop computer desktop icons from moving, right click on the desktop, select the option to auto arrange and align the icons in a grid, and check the icons to be included in the option. Keep a...

Restore deleted files from a memory card by downloading a program called "Restoration," inserting the memory card into the computer, launching "Restoration" and selecting the drive and file to...

If you've ever used the VLOOKUP function in Microsoft Excel to find an exact match, then you've probably encountered at least one occasion where you received #N/A. You may have wanted something...

Excel is a good Office application to use if you want your files to include visual aids. You can make charts, graphs and pivot tables in Excel to show (rather than tell) the information you want...

That college paper needs to get finished, but you don't have a computer with Microsft Excel installed. Being a broke college student, you cannot afford to go out and purchase a copy right now....

Excel macros are a special feature in Microsoft Excel that allow you to perform common tasks automatically. They work by "recording" your keystrokes, mouse movements and settings during a given...

Creating an Excel chart or graph is an essential tool that everyone needs to know if they are to present the bottom line in a graphical format. Hey lets face it numbers get attention but a picture...

It is always smart to password protect your Microsoft excel spreadsheets especially when there are too many cooks in the kitchen. The last thing you want is a user on the network tampering with a...

If you have large spreadsheets that might span hundreds of columns or rows, Excel has built in functionality that allows you to name specific cells and then you can jump to them. This process is...

Through a macro, you can record a sequence of keystrokes or mouse clicks that once saved, can be used in other Excel workbooks on the same computer by pressing a combination of two or three keys. ...

In Microsoft Excel, you have a list of individuals’ names that includes first and last name, but may also include a middle name, initials, or even a hyphenated name. You want to extract just...

Microsoft Excel has built in functionality where you can multiple all of the values in a row and return that value into a cell. Here is how it is done.

An Excel spreadsheet is a fantastic way to provide information to other users. However, you might not think of them as aesthetically appealing or terribly exciting. One way to spruce up your...

When using a spreadsheet application like Microsoft Excel, finding individual pieces of data can be daunting, especially if a workbook contains enormous amounts of information. Programmers foresaw...

Microsoft Excel is great for making detailed spreadsheets, producing informative charts and even constructing small databases. However, you can use Excel to create something instructional and fun....

The pivot table was originally created to help users recognize data patterns in order to effectively analyze that data. You can create a pivot table to sort, sum and count data in a spreadsheet....

Excel has a built in function that allows you to calculate the average of multiple cells. This function works whether you are average 2 cells or 2000. Here is how it is done.

If you want to change the font of the entire worksheet, or the size of the font or a variety of other things to do all at once a good way to do this is to highlight the entire worksheet at one...

There is a way to copy and paste contents of one cell to another in Microsoft Excel without having to actually copy and paste it. Here is how you do it.

Microsoft Excel makes it easy to make a graph. All you need to do is supply the data for the graph and then let Microsoft Excel create the graph for you. Microsoft Excel provides several graph...

Microsoft Excel is part of the Microsoft Office Suite. A powerful tool, it is mostly used for spreadsheet functions, and is superb for charts, tables and anything else you can think of when it...

Creating a time sheet with Microsoft Excel is simple to do. The beauty is that you can modify or beautify the time sheet as you see fit. By adding a few columns and a time calculating formula you...

You can use Excel to track information for accounts. If you are running a small business and only need to keep track of simple accounting, then Excel might meet your accounting needs. You can set...

By showing formulas in Excel, you can quickly check for inaccuracies and make the changes needed. It can also help you find the cells that contain certain formulas, as well as track the data.