Search Results

In this Excel VBA & macros tutorial, you will learn how to create a ListBox that contains the names of the worksheets. You can select multiple names and then print the sheets as one print job instead of separate ones.

Learn how to quickly transform boring bullet points into text that your audience pays attention to. You’ll also learn how to create professional transitions and animations with the new morph feature. And guess what? You can now morph between two different objects. It’s really smooth. Check it out.

What’s an effective way to visualize survey results in Excel? Specially results of an employee satisfaction survey? In this tutorial, you’ll find an impressive way to chart survey results in Excel. It’s not as difficult as you think.

Are you using all of these 20 Excel keyboard shortcuts in your daily work? They range from data navigation to auto sum, inserting the date and time and even moving rows of data and dropping them between other rows.

Learn 3 ways to quickly change the case of text in Excel. For example, change lower case to upper case or vice versa – or clean up text to proper case. We use formulas, as well as non-formula techniques to get his done. You’ll also find a list of free Fonts you can install.

Have you been presenting hand-outs instead of slides? What makes a good slide presentation? In this tutorial I share 3 actionable tips you can apply to your next PowerPoint presentation.

Can you conditionally format an Excel line chart to highlight the maximum and minimum values? Can you do it in a dynamic way? You can. You just need to use this simple trick.

Learn all about Excel’s custom formatting – what is the rule for the custom formatting dialog box? How can you use it to hide zero values and much more.

Learn about Excel’s Rank and Rank.EQ functions. How can you rank values without skipping numbers in between and how to create a top 3 report with duplicates.

Learn how to quickly hide and unhide all worksheets in at once. Hiding sheets in Excel is easy, but unhiding all sheets is not as simple. I show you 3 methods to unhide Excel tabs. Pick the one you like most.

Would like to increase the font size of the text inside the Excel formula bar? You’ve probably noticed that zooming in to the cells doesn’t increase the text size inside the formula bar. In this short article I show you a quick way to get this done.

Learn how to calculate percentage change correctly. In addition, find out how to calculate end value when there is a percentage increase or decrease.