Quantcast
Home Tags Tips and Tricks

Tag: Tips and Tricks

Learn SumProduct and SumIF Excel Functions

Advanced Excel Summation Skills Using SUMIFS and SUMPRODUCT

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

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

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

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

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

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

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

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

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

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