Improve your use of Excel with our free tutorials...
Excel's Conditional Formatting
This is an excellent tool to highlight cells that you need to grab attention when a particular value is reached. Read more...
Microsoft Office 2007 Notes
Read our quick guide on deciding whether to upgrade and various notes on the changes in Excel 2007, more to come as time permits.
How to use Lists in Excel 2003
This is an extremely useful feature for working with data in Excel 2003. Quickly convert a table of data into a List and enhance data entry and manipulation. Read more...
Using the Camera tool
Excel's Camera tool gives you the ability to select a range of cells and make a live picture that you can place anywhere in your workbook. Since it makes a picture, it does not have to fit into worksheet row/columns, a great help in building dashboard type reports. Since it's a live picture, any changes to the source range are automatically updated in the picture. The Camera tool can significantly increase your Excel dashboard quality quickly and easily. More...
Changing the width of all columns in a worksheet
Everyone knows that if the data in a column is wider than the column itself some of the data will be hidden when viewed on screen. Most people know that if you select a single column and double-click on one of the column separators, the width will be auto-adjusted so that even the widest data can be seen.
But did you know there's a way of altering all the columns in your worksheet at once? Here's how.
Click to enlarge
Microsoft Excel – Recording Macros
This lesson assumes a comfortable level of experience with Microsoft Excel. Topics include recording, running and editing macros; absolute and relative referencing; assigning macros to keyboard shortcuts and command buttons and customizing the Excel toolbar. More...
Microsoft Excel: Pivot Tables
This is an intermediate to advanced lesson. Topics include data groupings, pivot tables, pivot charts, formatting Pivot tables, adding and removing data, multiple data forms, and sorting. More...
Why write clear and concise code?
When writing code it is often necessary to come back at a later date to edit the code. Without clear comments and sensibly named Variants his task becomes much harder. More....
Excel's Print Options and PageSetup
This tutorial assumes some experience with Excel. Topics include PrintPreview; printing selections; print areas; page orientation and scaling;
margins and centring; page breaks; headers and footers; printing titles; hiding rows and columns; inserting, deleting and renaming worksheets;
linking worksheets; editing and printing multiple worksheets; and linking workbooks. More...
Use Microsoft Excel’s “Paste Special"
Microsoft Excel has a PasteSpecial functions than can be far more useful than simply pasting values, formulas or formats, etc. It can be used to achieve results than some users think would require VBA or complicated formulas. In fact you could possibly call it Quick math. More....
Limit cell entry with Excel's data Validation Feature
Excel’s Data Validation feature is similar in many respects to the Conditional Formatting feature. This feature enables you to set up certain rules that dictate what you can enter into a cell, it is a very useful feature of Microsoft Excel. Data validation is a very useful feature of Microsoft Excel. More....
Save time with an Excel template
I have seen many questions recently on th Forums asking for code to copy a particular sheet to a new workbook so that the format, formulas etc, can be used in this new Workbook. This is totally unnecessary as you an easily create a template workbook. See how...
Note: all our examples are offered as is with no warranty. J & R Excel Solutions accept no responsibility for any loss arising from your use of them