Microsoft Excel is without a doubt the best spreadsheet program on the market and the one most used by businesses, students and individuals. Excel allows you to store data, dates and numeric values. You can create formulas, charts and graphs to help you analyze your data better. Microsoft has built in many shortcuts to make it easier for those using Excel to perform basic functions. The more shortcuts you learn, the faster and easier it is to maximize your use of Microsoft Excel.
These really useful Excel tricks and tips can increase your productivity and save you time.
1 - Repetitive Operations
Repeat Last Action F4 or Ctrl + Y
Life is full of repetition and most of the time not only is that boring but we are not always consistent. Using function key F4 (When the mode indicator = READY) will repeat the last action with most operations in Excel. You can go on to use it indefinitely.
So if that row you just inserted that wasn’t enough – press F4
That complex cell formatting in the Format Cells dialog box that you need to repeat – press F4
Excel Tricks Tips and More Goodies
This article contains 5 extra Excel Tricks Tips and more sage advice on using Microsoft Excel.
5 - Driving your Computer – Shortcuts (Excel Tricks Tips)
During our training courses it is very apparent that Delegates all have their preferred methods of driving their computer and I find it interesting just how committed Delegates are to their particular method. I am very impressed with those who have taken to learning keyboard shortcuts and use them without even giving them a second thought. However, I thought I would just review your options and you can decide for yourself how you might not only improve your speed but also your accuracy whilst remaining comfortable with your method mix.