# Tips and Tricks

### Stop Excel Overlapping Columns on Second Axis for 3 Series

8
We have learned how to Stop Excel Overlapping Columns in a few posts on the site.  A reader had a follow-up question that I...

### Calculating Hours Difference of Time in Excel Spreadsheets

6
When working with Time in Microsoft Excel you may have noticed that there is a problem when you subtract certain numbers.  Excel gives you...

### Advanced Excel Summation Skills – Using ARRAY Formulas to Check for Multiple Criteria

0
In this post, I will show you another Excel summation technique that you can use to evaluate criteria and then sum the data based on that...

### Advanced Excel Summation Skills Using SUMIFS and SUMPRODUCT

0
In this post, I will show you 2 other techniques that you can use to evaluate criteria and then create a sum of data...

### Advanced Excel Summation Techniques Using Pivot Table

0
There are many ways to Sum data in Excel.  But when you have lots and lots of data, then you will want to learn...

### How-to Find a Wild Card or Question Mark or Asterisk or Tilde in Excel

2
Lots of users use Excel for lists or you may receive reports from other people or systems and sometimes those files contain Wild Cards...

### How-to Convert an Existing Excel Data Set to a Pivot Table Format

10
In previous posts, I have espoused the virtues of the Pivot Tables in Excel and that you should always think in terms of a...

0
If you have the yellow bar show up at the top of your Excel Spreadsheet "! Security Warning - Automatic update of links has...

### How-to Make an Excel Stacked Column Pivot Chart with a Secondary Axis

0
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...

0
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...
Want to Receive the Next Post?