Downloads of the Follow Along and Exercise files
Free Excel Tips and Tricks
Excel Tips and Tricks
A free course covering 11 useful tips and tricks for anyone using Excel in the business world. Covers ways to see multiple spreadsheets or sheets at the same time, navigating quicker, writing reports in MS Excel and more.
Most people quickly learn to hide rows and columns in Excel. However, this has a risk and a safer way to achieve the same thing is to rather include the convenient plus and minus signs to the left. This also allows you to create nested groupings which can make your spreadsheet look like there is a drill down capability.
If you have lots of sheets in a spreadsheet, it is sometimes easier to view them in portrait style instead of scrolling through the entire list of sheet names.
You may find it useful to learn some of the quick ways to get around your spreadsheet. Whether you use your mouse/ trackpad or the arrow keys, by combining them with CTRL and SHIFT you can do things faster.
Quick ways to enter the current date and/ or time into a spreadsheet cell.
Learn how to customise Excel to generate quick answers.
How to put your most used buttons in a convenient place that is easy to access.
Create paragraphs within an Excel cell (including adding bullet points)
Quick data entry in Excel so that when you click ENTER it jumps back to the start of the next row.
Quick data entry in Excel part 2
Drill down into Excel formula to see resultant numbers
When working on spreadsheets, you often need to work on different parts of the spreadsheet at the same time.
In this lesson you will learn about:
- Freezing the panes
- Splitting the screen so you can see row 10 while looking at row 1000
- Watching key cells as you move around your spreadsheet
- See two (or more) spreadsheet workbooks next to each other
- See two sheets WITHIN the same spreadsheet at the same time
Next Steps and Excel Training Coupons