Chart
Create Dynamic Excel Chart Conditional Labels and Callouts
Learn this SIMPLE executive dashboard chart trick for conditional labels and callouts so you can QUICKLY identify individual data points.
EXPLORE THE LIBRARY
Video Tutorial category
How-To
Alternate Ways to Select Large and Non-Contiguous Ranges in Excel
Learn how to use alternate techniques to select very large ranges in Excel and also another way to select non-contiguous ranges.
Bar Chart
How-to Create a Stacked and Unstacked Column Chart in Excel
Stacked and Unstacked Column Chart in Excel Excel is awesome because, even when a certain chart type is not a standard option, there may be a way that you can create the type of chart that y
Chart
How-to Create a Dynamic Excel Chart of Last 3 Months Data Without Offset
Chart of Last 3 Months If you wanted to create a dynamic Excel chart of last 3 months of your data but didn’t know how to use or didn’t want to use the Excel Offset Function, then check out
Chart
How-to Copy a Chart and Change the Data Series Range References
Learn several techniquest to Copy a Chart and modify the copy of the chart to change the data series range references to a new area in your worksheet.
Challenge
Friday Challenge Answer – Find Unique Values from CSV List
Here is how you can quickly solve the most recent Friday Challenge: Find Unique Values from CSV List Before we begin, I am going to show you how to do this with some standard Excel features
Chart
How-To Copy an Excel Chart on Same Worksheet with a New Data Reference
This quick tutorial will show you how-to copy an Excel Chart on Same Worksheet such that it uses a new data reference instead of the original reference.
Averageif
How-to AverageIF Excluding Zeros Across Excel Worksheet Tabs
A quick tutorial that teaches how to create an AverageIF Formula that will exclude Zero (0) and blank values when averaging across many Excel Worksheet Tabs
Challenge
How-to Easily Sum Across Excel Worksheet Tabs (Plus Friday Challenge)
Learn How you can Quickly and Easily Sum Across Excel Worksheets for the same Cells for every Excel Worksheets or Spreadsheet Tab
Chart
A Better Format For Excel Chart Secondary Axis Columns Overlap with 3 Series
Facebook Twitter Pinterest WhatsApp Linkedin Learn a better charting format when your Excel Chart Secondary Axis Columns Overlap with 3 data series. The Problem I didn’t love the last chart