In this post, I will show you 2 other techniques that you can use to evaluate criteria and then create a sum of data based on that criteria in Excel. Two posts ago, we showed presented with
Lots of users use Excel for lists or you may receive reports from other people or systems and sometimes those files contain Wild Cards or Tilde’s. If you are trying to Find or Find & Replac
In previous posts, I have espoused the virtues of the Pivot Tables in Excel and that you should always think in terms of a database programmer when you create your data layouts. If you miss
If you have the yellow bar show up at the top of your Excel Spreadsheet “! Security Warning – Automatic update of links has been disabled ‘Enable Content'” But you don’t know why you have th
In this previous post: Stopping Excel Pivot Chart Columns from Overlapping When Moving Data Series to the Second Axis I had a fan question – How can you do this same type of Pivot Chart but
Like most Excel users, one of the first formulas that you ever learned to master was the Concatenate Function. But how do you add other controls like a Hard Return or a Tab to your Concatena
If you have a chart with Legends, then you should check out this tutorial. Recently when working on a solution for a fan, I noticed that it was not clear on my Stacked Column Chart which ser
Several years ago, I created an Excel workbook and I “Protected” a worksheet, but, I forgot the passcode the next day. Try and try, I couldn’t remember the password. Therefore, I could nev
In the last Friday Challenge, I presented you with 17,000+ data points representing 2 days of network data usage. With so many data points, it may be best to visualize the data to see what i
Today I answer a viewer question. “How do I add a cumulative grand total amount as a line above a stacked column pivot chart in Excel?” Well there are a few tips and tricks to create this t