Here’s your Monday Excel tip to help you become an Excel whiz! Excel 2013 has a great new Flash Fill feature gives you the ability to take a part of the data entered into one column of a worksheet table and enter just that data in a new table column using only a few keystrokes. …
Tag Archives: Excel Tip
Excel Tip – Keyboard shortcuts
The fastest Excel users have one thing in common They rarely use the mouse. Most all actions in Excel can be done with a keyboard shortcut. Here are some of my favorites: CTRL + HOME — Go to Cell A1 CTRL + END — Goes to the last cell used. CTRL+SHIFT + right arrow then down arrow …
Excel Tip: Quick Fill Down
Excel is THE tool for accountants. There is rarely a day that will go by without using Excel. Each Monday, this blog will post a time saving tip that is helpful. Enjoy the first tip! In larger spreadsheets, I used to spend lots of time dragging the cursor down a column to extend a formula …
I Teach Accounting Information Systems 