How would you like to MASTER graphic design by next week?
Click here to find out how
Featured Photoshop templates - professional ready to use designs for your next project
View all templates
Excel Move Tutorials
Macro to Remove Blank Rows
Great Microsoft Excel tutorial showing you how to create a macro to remove blank rows. Genius!
Pivot Tables in Excel
Pivot tables are one of the most versatile and powerful tools available in Excel. They allow you to display data in a table format with multiple filters, and the ability to easily add or remove rows and columns.
Managing Worksheet Windows
This tutorial covers ways you can use worksheet windows to compare data, copy and move it between different regions of the same (or different) worksheets, and even move it from one workbook file to another.
Excel Editing Settings
This technique begins by covering how and when to change the direction in which the cell pointer moves when you press Enter and then gives you the lowdown on why you might want to disable the AutoComplete feature.
Refining Excel Worksheet
This tutorial describes how to move, delete, and rename worksheets, as well as protect them from being edited or altered.
Use Replace to Remove Unwanted Characters
Using this tutorial, you can spare yourself the trouble of removing them by hand.
Split Panes in Excel 2007
Split panes in Excel 2007 so you can put your Excel worksheet into multiple windows that allow you to move quickly between groups of data.
Move or Copy a Worksheet in Excel 2007
You can move a worksheet to another location in your workbook or copy a worksheet to become a new worksheet in the same Excel 2007 workbook.
Enter Data in Excel 2007
Enter data in Excel 2007 with ease so you can quickly move around the Excel workspace as you enter data.
By the end of this module, learners should be able to: Specify a print area Preview a page Insert and remove page breaks Print a worksheet or workbook
Removing #DIV/0! errors from your spreadsheets
Shows how to remove #DIV/0! errors from your spreadsheets permanently using the AssumeIT macros
TRIM Function in Excel
Using the TRIM function to remove unnecessary spaces in cells i.e. only have a single space between words and no spaces before or after the text
Automatically Move The Cell Pointer In A Direction After Entering a Number
You can have the cell pointer move in any direction after using Enter by changing this setting on the Edit tab of the Options menu.
OFFSET in Excel
Offset allows you to refer to cells above, below, left or right of a reference cell. Very useful for cash flow forecasts where the receipt or payment of money can move between periods.
TRANSPOSE in Excel
Two methods to quickly and easily move information from row format into a column format, or a column into a row.