Spreadsheets are awesome and we want to help everybody learn how to use them. Vertex42 has been creating and providing professional spreadsheet templates since 2003. Our YouTube channel provides demos and tutorials to help you use the templates. We are also creating tutorials to help you use both Excel and Google Sheets better.


Vertex42

Rebekah Oster shows a very simple VBA trick to get the Date Picker in Excel (an add-in created by Vertex42) to show, hide, and move around as you click on dates in your worksheet. This will only work within the worksheet where you have added the VBA code, but for something like a check register, log, or other type of transaction-oriented sheet, this is very cool!

1 month ago | [YT] | 3

Vertex42

This video (How to Make a Gantt Chart) is the start of what I hope will be an awesome new video series. This particular video shows how I created the essential elements of the "Simple Gantt Chart" that you can find either on my website or by going to File > New within Excel and searching for "gantt chart"


Download the Template Here:
www.vertex42.com/ExcelTemplates/simple-gantt-chart…

Learn Excel shortcuts, tips, tricks, and features while watching us create useful templates. I will likely do quite a bit with gantt charts because they are useful for demonstrating a lot of different Excel features and formulas.

5 years ago | [YT] | 35