Excel Sparklines: Merge Sparkline Cells For Quick and Easy Charts

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 make large charts that represent your data. (more…)

Excel Custom Number Formatting: Turn your values into K (Thousands)

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 and you’ll be right on your way.  If you have any questions, feel free to leave a comment. (more…)

Excel Shortcut: Using Alt + Shift + Right Arrow To Group Your Pivot Table Fields

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.  Thanks for checking the website out as always!

Cheers to the weekend.

Pivot Table Grouping

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 also check out the formula I used in this example.  I used the index formula nested with the max formula to identify the highest sales value by product category.  This formula translates over automatically to each country tab.  Have a look for yourself.

 

APPLY_TO_MULTIPLE_SHEETS

 

If you have any questions feel free to drop a line in the comments.