Home Tags Video Tutorial

Tag: Video Tutorial

Excel Array Solution

Data Transformation – Excel Array Solution

0
In a recent Friday Challenge, I asked our readers to transform an varying text string into dates and values to determine averages.  Well although...
How-to Highlight Specific Horizontal Axis Labels in Excel Line Charts

How-to Highlight Specific Horizontal Axis Labels in Excel Line Charts

7
The Problem Recently a fan contacted me and asked how she change the horizontal axis could do the as follows: "I am trying to bold 5...
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...

Single Image Tree Goal Chart

How-to Make an Excel Single Image Goal Chart

2
Recently, a healthcare company employee contacted me about a chart he wanted to create.  The company that he works for is trying to save...

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...
Stacked Column Chart with 2 Axes

How-to Setup Your Excel Data for a Stacked Column Chart with a Secondary Axis

2
Many users have mixed reactions about this secondary axis overlap fix.  You can see the post here: Stop Excel From Overlapping the Columns When Moving...

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

5
Several years ago, I created an Excel workbook and I "Protected" a worksheet, but, I forgot the passcode the next day.  Try and try,...
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