In a data area, several cells are selected by highlighting in a different color. The example show cells that were manually selected, rather than using conditional formatting. However, if cells are shaded or have a different font color due to conditional formatting, this will work as well. These can easily be sorted to the top …
Category Archives: Excel
New to Analytics? — Start here
Think you are new to analytics? You may have a start. Most of us in business, and especially accounting are quite adept in Excel. This makes the tool a perfect place to start. You cannot use the largest data sets, but with new Excel tools such as PowerPivot, that is constantly increasing. Analyzing data in …
Excel Tip: Easily enter Absolute references
When entering formulas, use the F4 key to toggle between absolute and relative references. When typing the above example, after typing “A1”, press F4. Keep pressing F4 until the combination of absolute/relative references appears. Press F4 to make cell value Absolute For a refresher on the differences between Relative and Absolute references, go to: https://www.youtube.com/watch?v=7Gh-sRgV-DA
Excel Tip – Flash Fill
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. …
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 …
I Teach Accounting Information Systems 