Excel – Productivity Tips Free Download
2 Likes Comment

Excel - Productivity Tips 1

Excel – Productivity Tips   Free Tutorial Download

1. Shortcuts

Let’s start with keyboard shortcuts. It’s one of the single best investments of time you can make to further your spreadsheet skills. It’s all about reducing your reliance on the mouse and instead harnessing the awesome efficiency of navigating spreadsheets from the keyboard.

Try these for starters:

  • Quickly move around your data ranges by holding the Ctrl key (or Cmd key on a Mac) and the Left or Right or Up or Down Arrow keys. Hold down Ctrl (or Cmd) key and the Shift key with your left hand and the Left or Right or Up or Down Arrow keys.
  • Move quickly between your worksheets by holding down the Ctrl key and Page Up or Page Down.
  • Toggle between absolute and relative cell references using F4.
  • Quickly jump into a cell to edit the contents, by pressing the F2 key.
  • Highlight a whole row by holding down the Shift key and hitting Spacebar. Similarly, highlight a whole column by holding down the Ctrl key and hitting Spacebar.

Find more in the official Microsoft Excel documents for Windows or Mac.

2. Format Painter

Chances are you’ll want to re-apply format options again and again in your worksheets, for example when you’re preparing reports that need to look consistent. There’s a slow way and a quick way to do this. The slow way is to just repeat your steps each time, selecting fonts, sizes, shading, borders etc. to match.

 

Download  Excel – Productivity Tips Free

Go to Download Tutorials Page

Password : freetuts.download

How to bypass Google Drive download limit for shared files


You might like

About the Author: minhtri

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.