Home Tips and Tricks

Tips and Tricks

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...
Sum Across Excel Worksheets Tabs

How-to Easily Sum Across Excel Worksheet Tabs (Plus Friday Challenge)

1
Sum Excel Worksheets Technique Why haven't I known about this simple Excel technique before now? Maybe you were aware how you can easily Sum Excel Worksheets...

How-to Make a Beer Mug Goal Chart as an Excel Dashboard Component

26
Time for some beer and Excel.  Last month I saw that a User was wondering how to make Beer Mug Goal Chart for their...

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

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

Friday Challenge Answer – Create a Percentage (%) and Value Label within 100% Stacked...

12
Last week I posted a Friday Excel Challenge!.  Fun times.  How did you do?  Spoiler alert, if you don’t know how to create this...

How-to Make an Excel Vertical Likert Line Chart with Categories

26
In the Mr. Excel forums there was a question raised on how can you create a Likert Chart or Graph using Excel.  The person...

How-to Make a Basic Gantt Chart in an Excel Chart in 7 Easy Steps

6
Project Managers and Executives love Gantt Charts.  They also love Microsoft Excel, Charts and Graphs.  So it is a natural to consider how you...

Replace Numbers with Text for Excel Radar Chart Axis Values

Replace Numbers with Text in Excel Radar Chart Axis Values

6
Replace Numbers with Text in Excel Radar Chart Axis Values This is a cool Excel Trick that I just created based on a user request...

Friday Challenge Answer – Find Unique Values from CSV List

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

How-to Draw a Straight Line with Excel Shapes

2
Have you ever tried to draw a straight line in Excel only to get frustrated? It can be so Frustrating :) to be off by...
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