Uncategorized
No Friday Challenge – I was hacked :(
Hi All, Thanks for your patience, but if you visited my site in the last 36 hours, you may have noticed that I was hacked 🙁 But all is better (I hope) and we are up and running again! Not fu
EXPLORE THE LIBRARY
admin
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.
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