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
/category/how-to/page/9/
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
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.
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.
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 – Create a Percentage (%) and Value Label within 100% Stacked Chart?
Friday Excel Challenge. Analyst question in Excel. Try and recreate it in an Excel Spreadsheet. Come back on Monday to see the solution.
Chart
Multi-Column Stacked Chart – How would you do it? – How I did it.
Step-by-Step Tutorial This is my solution to this week's Excel challenge. Learn how to put category names in a stacked column chart for your Excel Dashboard
Excel Dashboard
How-to Create a Scroll Bar in Excel to Make Your Dashboard Dynamic
Learn how to use a scroll bar to dynamically change the data in the Excel dashboard chart.
Bar Chart
How-to Make a Tenant Timeline Excel Dashboard Chart
How to make an Excel dashboard chart that shows when a lease ends for a tenant.