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. ...
Excel Shortcut: Copy Formulas and/or Formatting to Multiple Sheets at Once – How to Identify Highest Sales For Each Country
I was just going through some handy shortcuts in Excel and thought I'd toss this on my website for all of you. You can select multiple sheets/tabs at once in a workbook and apply a formula/formatting to a cell and have it be applied to all sheets. You can...
Using Excel Vlookup With Shapes and Data Validation: Building a Dynamic Salesman Dashboard (Part 2)
Before I get started, I had a reader mention that in versions 2007 and greater you can use Excel Tables to build dynamic data validation list which is definitely another great way of handling a validation list in Excel. For the purpose of...
Excel Data Validation List: Building a Dynamic Salesman Dashboard (Part 1)
Over the next couple of weeks, I will be building a dynamic salesman dashboard that allows the user to interact with the spreadsheet to get the information that they need. This post will first focus on building a data validation list that will immediately make...
Excel Shortcuts: Build A Quick Weekday Date List in Excel
Now that the holiday season is over (almost 2 weeks ago now) I've finally got myself back into a routine and I wanted to start off the year with a quick tip for those of you looking on how to build a list of weekday dates for your planning purposes and to get the...