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 →