Tag: Excel
Excel Fun Day – Something Fun and Useful That You May Not Know About
Hi All,
Peter reminded me of a really cool option that you have in Excel.
You may have never known about it. But it is fun...
How-to Make a Pass Fail Chart in Excel
Last week, I posed a Friday Challenge that was posted in a Q&A for Excel. Here it is:
*****************************************************************
Plotting a line graph to track build...
Friday Challenge – Pass Fail Chart in an Excel Spreadsheet
Hi all and thanks for your patience. I think we are all better now and the hack has been fixed. (Fingers Crossed)
I will get...
How-to Split Up Email Address Text with Excel Formulas – Part 2
In my previous Friday Challenge, Tracey wanted to know how to split up email address text in Excel. The sample text that Tracey wanted...
Friday Challenge – Splitting Up Email Address Text with Excel Formulas
Alright, this challenge was posted by a fan in on my Youtube Channel. It was posted for this video: “Splitting Cell Text and Numbers...
How-to Concatenate Excel Column or Row Data Using Google Docs
Yesterday I demonstrated how to find and replace a hard return in an Excel spreadsheet. I presented the last topic before this one so...
How-to Find and Replace a Hard Return in an Excel Spreadsheet
In a previous post, I showed you how to add a hard return within an Excel worksheet cell. You can check out that post...
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-best/
And don’t forget to vote...
Friday Excel Challenge Submissions–Which Chart Solution One Do You Like Best?
Sorry for the late posting. I was in Atlanta all week working on a new project and going out with the client at night,...
Dynamically Change Excel Bubble Chart Colors
In last week’s Challenge, I posted a question from an Excel User Forum that asked the following:
“I've used Excel 2010 to create a bubble...