What are some cool Microsoft Excel tricks?

Without a doubt, your #1 priority should be to learn how to go mouse-free.

You increase your speed 3–5X when you get rid of the mouse. The best way to start learning this is to:

  1. Hit the ALT key – you’ll see letters and number shows up all over the menu, that’s how you navigate from now on
  2. Print out a page of Keyboard Shortcuts (search keyboard shortcuts on google images) and tape it to your computer

Getting comfortable using Excel ...

Continue Reading →

What are some great Excel power user hacks and tips?

These should make you both faster and more accurate in Excel. Doing things quickly is great, but learning how to avoid bugging your model – and to fix it when it happens – is equally important.

(Apologies for low-res screenshots here – I’m using some fairly shoddy technology! – but the images should still illustrate the points.)

1. Master shortcuts – download and install Keyrocket.
This application is free, and will inform you of what shortcuts you could be using as it observes you ...

Continue Reading →

What is the method to collapse or expand rows & columns in excel sheet?

What is the method to collapse or expand rows & columns in excel sheet?

The simple method to collapse or expand rows & columns in excel sheet are as follows:

Here is a quick step-by-step example to show you how.

Here are the basic steps:

  • First, you have to group the row/column selection
  • THEN, you can collapse or expand that group

Here is how you group rows or columns and then expand/collapse the group:

  • First, you need to group the columns/rows.

 

  • To group the ...
Continue Reading →

How can I automatically duplicate data from Excel sheet to another?

How can I automatically duplicate data from Excel sheet to another?

To automatically duplicate data from Excel sheet to another. The simplest thing you can do is add formulas that refer to the cells in sheet 1 containing the information you want to replicate. So a simple =Sheet1!A1 should be enough. Repeat for as many cells as necessary across the row and copy down as required. Like that every time you add a new record the information is replicated/linked ...

Continue Reading →