Check here frequently for the latest FREE tips for MS Excel.
7 keys to avoid spreadsheet hell
Seven Keys to Avoiding Spreadsheet Hell – Ignore the Sixth and You’ll Be Eternally Sorry
Microsoft Excel is a powerful and widely used tool, but it can also be easily misused.
Here are 7 tips that are sure to make your Excel experience more efficient and enjoyable.
1. Referencing Cells Using the ‘$’ Symbol
The ‘$’ sign is essential when writing formulas. It allows you to lock a row or column, so when you copy the cells down, the referenced cell remains the same.
Tip: Select an address in the formula and use the F4 key to add or remove the ‘$’ symbol.