compare excel columns

What are some of the lesser known but useful Excel functions/tricks?

Useful Excel Functions

 

Definition:

Useful excel functions – An often-overlooked method of increasing productivity when working in an Excel model is to use Excel shortcuts or shortcut keys. These shortcut keys perform major functions that, when used instead of clicking in the toolbar, dramatically increase efficiency in speed. Useful Excel Functions & Tricks 2018.

Uses:

Microsoft Excel is a spreadsheet program used to store and retrieve numerical data in a grid format of columns and rows. Excel is ideal for entering, calculating and analyzing company data such as sales figures, sales taxes or commissions.

Introduction:

Taking a cue from the answer in Saito’s link ...

Continue Reading →

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 →