Email
How-to Split Up Email Address Text with Excel Formulas – Part 2
Learn how to create dynamic Excel formulas using text functions to breakup or split an email address into First Name, Middle Name, Last Name and Domain Name.
EXPLORE THE LIBRARY
Excel Dashboard Templates Home
Challenge
Friday Challenge Answer Part 1: Splitting Up Email Address Text
How-to Splitting Up Email Address Text with Excel Formulas using text to columns
Challenge
Friday Challenge – Splitting Up Email Address Text with Excel Formulas
How to separate names from email addresses using formulas in Excel spreadsheets
Concatenate
How-to Concatenate Excel Column or Row Data Using Google Docs
How to use Google Docs to Concatenate a range in Excel without the using a formula. Best for lots of data to concatenate or when you want to do it quickly.
Find and Replace
How-to Find and Replace a Hard Return in an Excel Spreadsheet
Find or find and replace a hard return in excel workbook
Challenge
Thanks for the Friday Chart Challenge Submissions – Vote in the Poll!
I had some AMAZING submissions for the last Friday Excel Chart Challenge. Check out the post and file downloads here: Friday-excel-challenge-submissionswhich-chart-solution-one-do-you-like-b
Challenge
Friday Excel Challenge Submissions–Which Chart Solution One Do You Like Best?
Friday Submissions to How would you make this Excel Dashboard Design?
Bubble Chart
Dynamically Change Excel Bubble Chart Colors
This tutorial will show you how to conditionally format bubble colors in an Excel chart using the NA() function.
Excel tutorial
Friday Challenge – Conditionally Control Excel Bubble Chart Colors
Hi All, Sorry this is a little late. But better late then never . Here is this week’s Friday Challenge (on Sunday. I will post my results on Tuesday to give you more time): The challenge i
Connect Line Data Points
How-to Show Gaps in a Line Chart When Using the Excel NA() Function
Learn how to have gaps in a line chart when using the NA function in an Excel Formula
Chart
How-to Eliminate Statistical Outliers in an Excel Line Chart
Learn how to create a dynamic Excel chart where you can hide outliers in a Line chart or Line graph. Free Excel Template download file
Challenge
Friday Challenge – Eliminating outliers in and Excel Chart
how to make an excel chart that ignores outliers when plotted in a line chart. Do this without manually deleting the data points.