-
Categories
Top Posts
- How to format dates that are over 1 year old to turn red in Excel using conditional formatting.
- How to Format Dates In Excel That Are Over One Year Old To Turn Red, Yellow If Eleven Months Ago, And Green If Between One and Ten Months Ago
- Access Input Mask Cheat Sheet
- How to Use Excel Traffic Lights with Conditional Formatting Dates
- Shrink to Fit Word Document on One Page
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
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.
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.
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
Steve Chase Docs