Basic EXCEL Techniques
These best five (5) articles give shortcuts to working in your spreadsheet more easily by the use of headings, copying formulas and sorting.
PRE-QUIZ: Basic Excel
Nothing is more frustrating that having so much data in a spreadsheet that you can’t see the names at the head of the columns and rows. Use this technique to have this key information stay at the top and side, regardless of where you are.
You create a formula in one column. Instead of retyping it in all the cells below, use this quick trick to make copying a formular a breeze.
No matter what spreadsheet your start with, you’re going to want to make the columns a different size. The same may be true of the rows. You can use this method to get exactly what you want in seconds.
If you’re not careful, when you want to sort data by a column or a row, you can disorient all the data instead of keeping everything together. The trick you learn in this article will prevent that disaster.
Sometimes spreadsheets get very large. When you want to highlight all of your data, you need to find the very last cell. This technique will help you do that quickly.
POST-QUIZ: Basic Excel