Excel Tutorials

Watch free Excel tutorial videos, from basic to advanced.
·
14 Pins
 3y
Collection by
Conditional Formatting is Volatile
This fire in Excel flickers whenever the display refreshes, demonstrating the concept that Conditional Formatting in Excel is volatile. Visit Vertex42.com to download the example file.
Use the Date Picker in Google Sheets
The Date Picker is #3 in my list of things Google Sheets does better than Excel. Wish Excel had a built-in date picker? If so, visit Vertex42.com to find out how to vote for Excel features.
Insert an Image in a Cell in Google Sheets
You can Insert an Image in a Cell in Google Sheets and automatically resizes to fit the cell. This is a great technique for customizing calendars. Download calendar templates from Vertex42.com.
Insert a Checkbox in Google Sheets
Learn how to easily insert a Checkbox in Google Sheets and then use conditional formatting to cross out the task when you check the box. Visit Vertex42.com to download this Simple Action Item Tracker template.
How to Move Rows in Excel
Here is a quick trick to easily Move a Row in Excel. Hold down Shift as you click-and-drag on the edge of the row selection. You can move one or more rows this way. This example uses the Content Calendar Template from Vertex42.com.
Change the Theme in Excel
You can change theme colors and fonts easily by going to Page Layout > Themes. Most templates from Vertex42.com, like this calendar template, are designed to allow you to change theme colors and fonts.
How to Quickly Copy a Worksheet in Excel
Quick shortcut to copy a worksheet in Excel, from Vertex42.com. Hold CTRL as you click-and-drag the worksheet tab. The Zero-Based Budget Worksheet is used as an example in this video. Visit the link to download the budget worksheet.
How to Make a Drop Down List in Excel. By Vertex42.com Microsoft Software, Excel Calendar, Learning Microsoft
TikTok · Vertex42.com
How to Make a Drop Down List in Excel. By Vertex42.com
How to Use Shrink to Fit in Excel so that dates and long text will display correctly instead of showing ######. By Vertex42.com Apps, Admin, Content Marketing Calendar, Marketing Plan
TikTok · Vertex42.com
How to Use Shrink to Fit in Excel so that dates and long text will display correctly instead of showing ######. By Vertex42.com
How to Group Rows in Excel and collapse and hide groups of rows. By Vertex42.com. Hardware, Microsoft Excel Lessons, Marketing Planning Calendar
TikTok · Vertex42.com
How to Group Rows in Excel and collapse and hide groups of rows. By Vertex42.com.
The Windows key + period(.) shortcut works in Excel, Google Sheets, and most other applications!! (but only on Windows 10) Click on the pin to watch the video for more methods. Windows, Google, Keyboard Shortcuts, Method
✔ How to Insert a Check Mark (Tick Symbol) in Excel
The Windows key + period(.) shortcut works in Excel, Google Sheets, and most other applications!! (but only on Windows 10) Click on the pin to watch the video for more methods.
Use the Shrink to Fit option in Excel when you want dates, text, and numbers to fit in cells without widening columns or changing fonts. Watch the video. Fonts, Computer Tips, Text, Computer Help, It Works, Numbers, Dating
Use the Shrink to Fit option in Excel when you want dates, text, and numbers to fit in cells without widening columns or changing fonts. Watch the video.
Learn how to use Flash Fill in Excel to quickly and easily reformat data. Click to watch the video on YouTube. Ideas, Youtube, Reading, Machine Learning Artificial Intelligence, Machine Learning
How to Use Flash Fill in Excel
Learn how to use Flash Fill in Excel to quickly and easily reformat data. Click to watch the video on YouTube.
Learn the VLOOKUP function and INDEX MATCH formulas in Excel. These formulas will also work in Google Sheets. The video shows how these lookup formulas are used within a working purchase order template. Microsoft Word, Purchase Order
How to Use VLOOKUP in Excel
Learn the VLOOKUP function and INDEX MATCH formulas in Excel. These formulas will also work in Google Sheets. The video shows how these lookup formulas are used within a working purchase order template.