Search Results

Learn how to use OneNote effectively so you can get the most out of it. OneNote is a great tool to stay organized, but it has a lot of hidden features. Read the article to find out what these are.

Create an Excel report with the top values and categories. Sort them by ranking and also handle duplicated (tied) values. Get it done fast with Excel new dynamic array Sort & Filter formulas.

It’s one thing to have to sit through a boring presentation. It’s quite another to give a boring presentation. The solution is a simple roadmap. Discover how you can add road-maps to your presentations.

This Excel topic is not talked about often: Excel Cell Modes. Once you know which mode you’re in: Ready, Enter, Point or Edit, it will be easier to decide whether to use the arrow keys or switch your mode first.

Learn to create a simple searchable drop-down list in Excel on multiple rows. Searchable lists make it much easier to find an item from a large data validation list.

A progress bar is a great addition for Excel macros that take long to run. It gives your project a more professional touch. It’s also quite easy to add. You can create your progress bar once and reuse it in your Excel VBA projects.

Speed up your analysis in Excel with the Analyze Data button. It creates helpful reports for you using artificial intelligence.

Uncover Windows 10 most useful features in this summarized article. Some of these are what I consider hidden features of Windows 10. Super simple to use BUT not easy to find!

Create multiple dependent drop-down lists in Excel that you can copy to every row. You’ll also learn how to exclude the blank cells on the bottom to make sure each list is restricted to the number of categories available.

Create an automatically sorted Excel bar chart that ALSO lets you hide and show categories based on a flag in the cell. It’s super easy with Excel dynamic arrays.

Find out a secret workaround that takes care of the problem of blank cells in the middle of your data range when you’re trying to quickly navigate to the end of the range with the help of shortcuts. It can get really frustrating, especially in a long range with lots of blanks. But there is a way – several, in fact. Next time you come across this issue, you will be fully equipped.

Check out this Excel formula hack to count text cells only. This mysterious syntax excludes blank cells, numbers and also cells with formulas that result in an empty string.