Quantcast
Home Tags Tips and Tricks

Tag: Tips and Tricks

Learn SumProduct and SumIF Excel Functions

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

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...
Final Pivot Table Data Format

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

How-to Fix Security Links Warnings in an Excel Spreadsheet

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

How-to Add a Hard Return to an Excel Concatenate Formula

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

How-to Group and Categorize Excel Chart Legend Entries

2
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...
Unprotect Worksheet Buttons

How-to Unprotect an Excel Worksheet If You Forgot the Passcode

9
Several years ago, I created an Excel workbook and I "Protected" a worksheet, but, I forgot the passcode the next day.  Try and try,...
Network Data Usage Excel Chart

How-to Visualize 17000 Data Points of Upload and Download Times

0
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...
Final Stacked Column Pivot Chart with a Grand Total Line

How-to Add a Grand Total Line on an Excel Stacked Column Pivot Chart

8
Today I answer a viewer question. "How do I add a cumulative grand total amount as a line above a stacked column pivot chart...
Want to Receive the Next Post?
Join My Newsletter
Subscribe
Give it a try, you can unsubscribe anytime.
Privacy Policy
Close
Subscribe Now!   (Privacy Policy)
SUBSCRIBE

Stay Connected!

Get the latest post emailed straight to your inbox!
SUBSCRIBE
close-link