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! 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
Change CASE of text in Excel (3 ways including NO Formulas) How do we change the case of text in Excel to normalize our data or to fix casing errors? Changing lower case text to upper case text, upper case text to
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 (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 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
Excel RANK without Skipping Numbers (Top 3 Report with Duplicates) Let's look at Excel’s ranked function. How can you rank your values in descending or ascending order and how can you rank duplicate values without skipping numbers in the sequence?es.
3 Methods to Unhide All Sheets in Excel (& how to hide) How can you unhide all Excel sheets at once? Hiding many worksheets at once is easy in Excel. Click on a sheet, hold down the control or the shift key,
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.
Calculate Percentages the Right Way in Excel (% Change & Amount after % increase) Let’s look at calculating percentages. Seem simple enough, but there may be few tricks we can use to ensure everything works smoothly and displays properly. We will not