Category Archives: Videos

How to Use the IF Function and the VLOOKUP Function Together In Excel

The Vlookup function is an awesome function. It looks up information in a table where you have defined the lookup value in the left-most column of the table. In this video I share how to use it with an IF … Continue reading

Posted in Excel, Videos | Tagged | 2 Comments

How to Use the People Graph in Excel

The People Graph is an Excel 2013/2016 Add-In which makes graphic style charts. Find this command in the Add-Ins group of the Insert tab. Below is a video demonstration.  

Posted in Excel, Videos | Tagged | Leave a comment

Automatically Update the Date and Time Stamp for Access Modified Records

Posted in Access, Videos | Tagged | Leave a comment

Understanding Visio’s Glue to Shape vs Glue to Connection Point

In this post, I am going to explain how to connect Visio shapes. You can connect to the shape or to its connection point.  

Posted in Videos, Visio | Tagged | Leave a comment

Format Red Cells if the Date is Older than One Year in Excel [Video]

In this video, I will demo how to format rows with red formatting if the date has been more than a year old. I will use the DATEDIF function to work within the conditional formatting rules.      

Posted in Excel, Videos | Leave a comment

Create a PivotTable in Excel [Video]

In this video, I will demo how to create an Excel PivotTable. This PivotTable will have Slicers and Timeline filters as well as a PivotTable chart.  

Posted in Excel, Videos | Leave a comment

A Special Trick to Select All Cells within the Find Box [Video]

This video will share with you how to search for cells within Excel’s find command and then select all the contents simultaneously. In the video, I show you how to delete all rows that contain the same value. I use … Continue reading

Posted in Excel, Videos | Leave a comment

Using the DATEDIF Function in Excel for Conditional Formatting Expired Training Dates [Video]

Posted in Excel, Videos | Tagged | 7 Comments

My Top 6 Excel Time Saving Tricks

Posted in Excel, Videos | 3 Comments

Making an Excel PivotTable, Slicers, and TimeScale Dashboard from the Reds 2016 Schedule [Video]

Posted in Excel, Videos | Leave a comment