Charting Survey Results in Excel

Charting Survey Results in Excel (Visualize Employee Satisfaction results) This post spotlights a practical way to visualize survey results in Excel, particularly surveys that follow a “like/hurt” format.  Surveys, like employee surveys, that provide a range of choices between “Strongly Disagree” to

Excel shortcut keys you SHOULD know!

Excel shortcut keys you SHOULD know! This post‘s topic is one the most requested topics for the site. SHORTCUTS!!!! These are keyboard shortcuts that EVERY Excel user needs to know, practice, and commit to muscle memory. From the beginning Excel user to

Have You Tried These PowerPoint Presentation Tips?

Have You Tried These PowerPoint Presentation Tips? This post is a bit of a departure from the norm.  Instead of discussing some lifechanging Excel feature, let’s talk about delivering better presentations. I want to share three tips that helped me create more

Highlight Max & Min Values in an Excel Line Chart

Highlight Max & Min Values in an Excel Line Chart (Conditional Formatting in Charts) Is it possible to call attention to the highest and lowest values in a line chart dynamically?  Can we color or accent these values in the line chart

Learning Excel Custom Number Formatting

Learning Custom Number Formatting – One of Excel’s Magical Mystery Tours Typing data in Excel can have the same result as typing a letter on a typewriter – what you see is what you get – commonly referred to as “WYSIWYG”. Unlike

Better Excel Presentations: Increase Font Size of Formula Bar

Better Excel Presentations: Increase Font Size of Formula Bar Imagine the following scenario:  You’re in the audience of a presentation and the speaker is displaying a spreadsheet on a television or projector screen.  The screen is full of facts, figures, and formulas.