Free Excel Tips and Tricks

or log in to view this course.

Some free tips and tricks on using Excel in the business world

Adrian
Course By

Adrian

Miricle Solutions was started in 2003 when Adrian Miric left KPMG to set up a consultancy focused on the safe and efficient use of excel in the corporate world. With this is mind the company has strived to provide the ultimate solution to all excel needs.

Lessons

Create a drill down experience in Excel

Length: 2 minutesComplexity: Easy

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.

Group Ungroup Rows Columns

Show sheet names vertically

Length: 2 minutesComplexity: Easy

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.

Selecting sheets

Fastest way to navigate through cells

Length: 2 minutesComplexity: Easy

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.

Date stamp a cell

Length: 2 minutesComplexity: Easy

Quick ways to enter the current date and/ or time into a spreadsheet cell.

Date Time Stamp

Quick data entry in Excel

Length: 2 minutesComplexity: Easy

Quick data entry in Excel so that when you click ENTER it jumps back to the start of the next row.

Working with multiple worksheets and workbooks

Length: 11 minutesComplexity: Easy

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

Split Screens