When autocomplete results are available use up and down arrows to review and enter to select. Touch device users, explore by touch or with swipe gestures.
Watch free Excel tutorial videos, from basic to advanced.
Similar ideas popular now
Excel Dashboard Templates
Gantt Chart Templates
Excel For Beginners
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.
Microsoft Excel Formulas
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.
Life Hacks Computer
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.
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.
Learn Computer Coding
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.
Good Leadership Skills
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.
Excel Cheat Sheet
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
Marketing Planning Calendar
Content Marketing Calendar
How to Use Shrink to Fit in Excel so that dates and long text will display correctly instead of showing ######. By Vertex42.com
Microsoft Excel Lessons
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.
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.
Skills To Learn
Machine Learning Artificial Intelligence
Learn how to use Flash Fill in Excel to quickly and easily reformat data. Click to watch the video on YouTube.
Teaching Math Strategies
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.