One of the hardest Excel features to master is charts and graphs, which aren't always so user-friendly.That "Select Data Source" dialogue box is so sensitive that it could drive you crazy!Select Data …
Excel for Healthcare Preview: Intro to Data Visualization
Healthcare produces massive amounts of data. Use data visualization to make meaning of it all. This is an introduction to some of the most powerful data visualization principles I've learned as a …
Continue Reading about Excel for Healthcare Preview: Intro to Data Visualization →
Excel Tip: Add Some Color to Your Chart!
One topic that I'm covering in my course on Excel for healthcare is data visualization and charts in Excel. I'm trying to cover just the basics, but finding it hard to do -- there's so much to learn …
Continue Reading about Excel Tip: Add Some Color to Your Chart! →
Conditional Formatting Across Columns
Update: After getting clarification from the reader I developed the attached model. It was bit trickier than I thought at first and I am feeling a little under the weather tonight so have not gone …
Continue Reading about Conditional Formatting Across Columns →
Chandoo Blew My Mind: Here’s How
Purna Duggirala is known to Excel users worldwide as Chandoo. His site,Chandoo.org, is my go-to Excel resource. Chandoo has a variety of Excel media from blog posts and videos to full online …
30 Seconds Spent Better: Resume Visualization
One of the first things job-seekers will hear is that a recruiter is only going to spend about 30 seconds reading your resume. This seems overstated. With the average job posting getting dozens of …
Continue Reading about 30 Seconds Spent Better: Resume Visualization →