In a few steps I will show you how to sort data in MS Excel tables. One of the most used features of MS Excel is, without any doubt, the sort feature.

MS Excel can be used for many things one of which is creating a cloze test with automated scoring. Unfortunately that can be pretty hard for those who have no understanding of Visual Basic.

Quite often it is necessary to work with extremely big tables, which contain many rows. A common inconvenience when working with such tables is that when we scroll down we cannot see the title of each column.

Sometimes when working with Excel spreadsheets and making calculations we often get nasty results like 3.

Sometimes when using MS Excel it is quite helpful to be able to copy a table as an image. Whether because it is easier to upload on our website or it is easier to embed in our presentation, we use that.

Quite often when working with MS Excel we enter a great amount of data just to realize that it will be actually better to switch rows and columns.

The default color scheme of MS Office 2007 (as in MS Office 2010) is blue. If you are not a big fan of blue there are other color schemes from which you can choose.

In this tutorial we will guide you how to use a drop-down lists in MS Excel 2007. Drop-down lists in your worksheet provide a quick and easy way to ensure that erroneous data is not entered in a cell.

In this tutorial we will explain how to protect whole Excel sheets or parts of them by making them read-only or restricting the types of changes that can be done to them.

Sometimes we need to hide the formulas in our Excel worksheet to give it a cleaner and more professional look or to simply hide your calculations.

Creating and using macros in MS Excel 2007 When using MS Excel you can often find yourself doing series of tasks repeatedly in a worksheet.

The MS Excel add-in Solver is a feature that makes creating financial models in a spreadsheet quite easy.

In the Chart Options window, you have an opportunity to enter a Title for the Chart (Titles) and provide labels for the X-axis and the Z-axis (percentage).

In this tutorial I will demonstrate how you can create a simple Pivot table. For those who are new to Excel i will explain what is basically the idea of Pivot tables in MS Excel.

In this tutorial we will show you how to create easily a useful table in MS Excel. MS Excel is really nice application, but it happens to have some annoying problems with displaying data in the spreadsheets.