10 Best Cheat Sheets to Help You Master Microsoft Office
Microsoft Office continues to be the most popular office suite used by businesses and individuals around the world. These Word, Excel, PowerPoint, and OneNote cheat sheets can help you be more productive and save time using these programs.
10. Useful techniques and capabilities of Excel
Excel contains many functions that ninjas should know , but for clarity, save or download one or all of these cheat sheets: 8 great tools to make you an Excel expert (including ways to merge cells, use VLOOKUP and conditional formatting), Excel tricks that will impress your boss (includes flash fill, pivot tables, and search for targets) and 8 Excel shortcuts (including select the entire spreadsheet, resize columns in just two clicks, and insert the current date). They may sound the same, but offer different tips and tricks. There are so many of them in Excel!
9. See the “Side by side Excel for PC and Mac keyboard shortcuts” section.
Keyboard shortcuts in Excel are similar to PCs and Macs, but not always. Some are very different between the two OSs, while others are for Windows only. Side-by-side comparison can help if you are moving between two operating systems.
8. Popular Office shortcuts
New Horizons offers this printable PDF that describes commonly used keyboard shortcuts for Word, Excel, Outlook, and PowerPoint. If you fold the paper along the lines and glue the edges together, you have a pyramid that can be placed in front of the keyboard for ease of use. (This option is best for those new to Office.)
7. Quick References on Keyboard Shortcuts in Excel
Microsoft offers three reference sheets for Excel , including Ctrl key combinations, function key combinations, and miscellaneous keyboard shortcuts. While these are for Excel 2010, they should apply to other versions of Excel as well.
6. Keyboard Sequences for PowerPoint
You may be familiar with PowerPoint keyboard shortcuts, but some tasks in PowerPoint require key sequences — pressing two buttons together and then a third. As we discussed earlier , Indezine offers a complete list of these powerful funnels for PowerPoint 2016 and earlier, which you can check out here . There is also a printable version of the e-book for 2013 and earlier.
5. Keyboard shortcuts in Office for Mac
I couldn’t find Office for Mac cheat sheets, but I did find this Help PDF, which is chock full of keyboard shortcuts for Office on Mac, a concern of Dean Pierer of OS X Keyboard Shortcuts . They should help with any version of Office on Mac.
4. All Word keyboard shortcuts
Microsoft Word has over 200 keyboard shortcuts. If you want to see them all in one place, you can use a macro in Word to create a list, or simply download our PDF or Word version .
3. Quick Reference Guides from CustomGuide
CustomGuide offers tons of free cheat sheets for Microsoft Office , including Access and Office 2011 for Mac. This can be a treasure trove of Office cheat sheets .
2. Microsoft Quick Reference Guides
Microsoft offers its own cheat sheets or quick reference guides for its Office suite, which you can view online or download as PDFs. These are for Office 2016. MSDN also has a collection of quick start guides for 2013 .
1.20 most common keyboard shortcuts everyone should know
This is not the case for Microsoft Office, but most of these common keyboard shortcuts can be used in Office as well as other programs, so they are worth remembering. Here’s our cheat sheet from our guide to using ninja-like keyboard shortcuts .