Spreadsheet Tips

Quick Tips for Excel and Google Sheets.

14 Pins

·4y

Convert Excel to PDF

Watch the video by Vertex42 to learn how to convert Excel files to PDFs.

This article lists my current most-wanted list, with links to the official Microsoft site for making and voting on Excel suggestions. Microsoft does see the suggestions that receive sufficient votes, so your vote counts! Area Formula, Data Validation, Scroll Bar, Budget Categories, Page Setup, Personal Mission, Gantt Chart, Computer Tips, Ms Office

Vote on Feature Suggestions for Excel

This article lists my current most-wanted list, with links to the official Microsoft site for making and voting on Excel suggestions. Microsoft does see the suggestions that receive sufficient votes, so your vote counts!

a blue and white poster with the words vlookup on it

Computer Commands

Gifts For Managers

Excel Training

Purchase Order Template

Order Template

Teaching Math Strategies

Office Tips

Computer Hacks

College Algebra

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.

a keyboard sitting on top of a table next to a sheet of paper that says excel keyboard shortcut bingo

Excel Keyboard Shortcut Bingo!

A fun way to learn new keyboard shortcuts. Download this free spreadsheet from Vertex42.com.

two yellow smiley faces are shown in the form of a checkbook with text that reads,'go to view and uncheck gridlines weekly time card '

100+ Excel Tips

To create a clean looking form with a spreadsheet, remember to hide the gridlines. Visit Vertex42 for spreadsheet tips and templates.

how to use flash fill in google sheets? - click on the image below for more information

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.

the right - click on everything page is displayed in this screenshote screen shot

Keyboard

Office Hacks

Financial Calculators

Microsoft Office

100+ Excel Tips

Contextual menus pop up when you right-click on something and contain unique options. You can learn a lot by right-clicking on stuff. When there is no right mouse button ... Phone: Tap-and-hold (long press); Trackpad: Two-finger click; Mac: Ctrl+click

a cell phone screen with text on it and an arrow pointing to the left side

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.

an image of the internet interface for windows and macosk, with text below it

Microsoft Excel Formulas

✔ 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.