Excel Sparklines: Merge Sparkline Cells For Quick and Easy Charts
I know, I know. I am starting to get lazy and I haven't really done any full length posts but these image posts will at least give you some quick pointers. That being said this is just another visual lesson on how you can use Excel Sparklines with the merging tool to...
Excel Shortcut: Use the Alt Key as Your All in One Shortcut Key
Alright so the Alt key may not allow you to access everything that Excel has to offer but pretty darn close. You'll see below that you can use the Alt Excel Shortcut key to quickly access any of the functionality that is available in the ribbon. Which Excel...
Excel Custom Number Formatting: Turn your values into K (Thousands)
Happy Monday everyone! This is another very quick post about how you can use some of Excel's awesome functionality. In this post I want to show how to use Excel custom number formatting to format a range of numbers into thousands (k). Simply follow the steps below...
Excel Camera Tool: How to Use the Camera Tool To Build Excel Dashboard Worksheets
I decided to do another short post to save you some time. This image/post takes a look at how to setup the camera tool and then how you can use it on a separate worksheet to begin the setup of a new dashboard. The Excel Camera Tool allows you to take an image of a...
Excel Shortcuts: Use Alt + = to Automatically Sum Cells
This is just another quick and simple shortcut that you can use to make your life a little bit easier. Use Alt + = to automatically add/sum a range of cells.
Excel Shortcut: Using Alt + Shift + Right Arrow To Group Your Pivot Table Fields
This is just another quick little image/post that shows how powerful Excel shortcuts can be. If you have the time, please leave some of your favorite keyboard shortcuts in the comments - I'd love to hear them. If you have any specific to pivot tables even better. ...