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...
Find And Replace from a List of Multiple Emails in Excel without VBA
Find And Replace from a List of Multiple Emails in Excel without VBA
I had a recent request from a friend who needed to Find...
Excel Line Charts Using a Date Axis
Not sure if you knew this or not, but Excel is amazing!
The makers of Microsoft Excel even went so far as to make sure...
How-to Show Text in an Excel Chart Data Table (Part 1)
Yesterday, I showed you how you can use the new label options in Excel 2013 to help Kevin with his engineering chart. But we...
How-to Create a Step Chart in Excel with 3 Quick Steps
Here is the first and easiest answer to the challenge on posted on Friday.
In case you missed it, you can check it out and...
How-to Make a Basic Gantt Chart in an Excel Chart in 7 Easy Steps
Project Managers and Executives love Gantt Charts. They also love Microsoft Excel, Charts and Graphs. So it is a natural to consider how you...
How-to Create a Time Data Series Step Chart in Excel
In our recent Friday challenge, we were asked by Anna how can we make our popular Excel Step Chart work for data that is...
How-to Select Data Series in an Excel Chart when they are Un-selectable?
When I first learned to make Excel charts, I was taught to select the chart and then select the data series with my mouse. ...
Tips and Tricks – Longer Legend Color Bars in Excel Charts
Here is a real quick tip that you may want to learn when using Excel. This tutorial will help you apply this technique to...
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...