Search Results

Practice a lot of useful Excel techniques by setting up a fun game. You can create a mosaic puzzle in Excel with the help of the RANDBETWEEN function and features such as conditional formatting, custom number formatting, Excel backgrounds, row and column hiding and resizing, and Form Controls.

With this complete Excel Gantt chart, you can professionally present your project timeline. It includes task completion, planned timeline versus actual view in one single chart.

Use this Excel formula to sum cell values based on cell color. The formula is an Excel VBA function. Copy and paste the code in your files so you can sum values based on background cell color.

Quickly learn how to use PowerPoint’s Slide Zoom feature to make more exciting and dynamic PowerPoint presentations. Take a look at this “before” and “after” slide presentation. What a difference a small feature can make!

It’s easy to lock and unlock individual cells in Excel. You can protect specific worksheets but leave some cells unlocked. You can even leave cells unlocked based on their color!

Choosing the right Chart animation in PowerPoint is the secret to a professional presentation. In this quick tutorial find out how to link your Excel chart to PowerPoint and how to animate the graph to support your story.

Learn how you can use the new Excel dynamic arrays functions to filter all records between two dates. We’ll use the new Filter function together with Sort and Unique functions.

Learn how to create an Excel Data Entry From without any macros or VBA. This is the easiest data input form you have ever created in Excel.

How can you use wildcards in Excel’s IF Function – with this method you can easily check for a partial text match. It’s a clever method to get the IF function to check if the cell value contains a word.

Taking advantage of Excel’s custom number formatting is a must for any advanced Excel user. Learn some easy and useful tricks when it comes to custom formatting.

Use this Excel formula (NO VBA, NO Macros) to convert numbers to words. Download the workbook and copy and paste to your own files. I show you how easily you can adjust the formula to fit your needs.

Here’s an Excel Hack that shows an unusual but simple method to change horizontal data to vertical. The advantage of this hack is it’s dynamic so if you add more values to the horizontal data it will reflect in the vertical one.