Need to get up to speed on the latest features in Excel 2016? Wrestling with an old version of Word? Looking to get more out of Windows 10? Computerworld’s cheat sheets are easy-to-use guides to help you navigate Microsoft’s core productivity apps.
Here’s a one-stop resource where you can find in-depth stories on several generations of Word, Excel, PowerPoint, and Outlook for Windows, focusing on what’s new in each major release. We’ve also got guides for SharePoint, OneNote, Microsoft Teams and Windows itself.
Microsoft’s subscription-based office suite, Office 365, is continually updated with new features, and the company recently released Office 2019, its latest non-subscription office suite. We’ll be publishing new cheat sheets to cover those products, but we’re willing to bet that many companies and individuals will stay on older versions of the standalone software for some time to come. We’ve got you covered here.
Windows 10 and Office 365
Windows 10 cheat sheet
The best operating system that’s come along from Microsoft in a long time, Windows 10 is continually improving with major feature updates every spring and fall. Get to know the interface and key features, and don’t miss our downloadable list of handy gestures and shortcuts for Windows 10. (Current for the Windows 10 May 2019 Update, version 1903.)
Word for Office 365 cheat sheet
Learn to use the best features introduced in Microsoft Word for Office 365 in Windows since 2015. This story covers all the features introduced in Word 2016 and 2019, plus several more exclusive to Office 365 subscribers. We also include useful keyboard shortcuts, plus there’s a quick-reference guide to the Ribbon in Word for Office 365 for downloading and printing.
Excel for Office 365 cheat sheet
Learn about all the features introduced in Excel 2016 and 2019, plus several more exclusive to Office 365 subscribers. You’ll also find useful keyboard shortcuts and a quick-reference guide to the Ribbon in Excel for Office 365 that you can download and print.
Coming soon: Cheat sheets covering PowerPoint and Outlook for Office 365. In the meantime, see our Office 2016 and 2019 cheat sheets below.
Microsoft OneDrive cheat sheet
If you have Windows 10, you have OneDrive. Here’s how to back up, sync and share files in OneDrive and OneDrive for Business.
Microsoft OneNote cheat sheet
Part of Microsoft’s Office suite and built into Windows 10, OneNote is a robust note-taking app that is also available as a free standalone product. Here’s how to get up and running with OneNote for Windows 10. Once you’ve mastered the basics, check out 5 power user tips for Microsoft OneNote.
Microsoft Teams cheat sheet
Microsoft’s answer to Slack, Teams provides group messaging, voice and video calls, and useful integrations with other Office 365 apps. Here’s how to get set up in Teams and find your way around. Ready to go to the next level with Teams? See 8 Microsoft Teams tips and tricks.
SharePoint Online cheat sheet
Learn how to find your way around SharePoint Online (the Office 365 version of SharePoint), create sites, share and manage documents, work with calendars, integrate with Outlook and more. Then go beyond the basics in 5 tips for working with SharePoint Online.
Office 2016 and Office 2019
Word 2016 and 2019 cheat sheet
Learn how to use Word’s live collaborative editing features, Tell Me and Smart Lookup, and the new Translator pane in Word 2019. Also included is a list of handy keyboard shortcuts for Word 2016 and 2019. If you just want to know where to find various commands on the Ribbon, download our Word 2016 and 2019 Ribbon quick reference.
Excel 2016 and 2019 cheat sheet
Now updated for Excel 2019, our guide covers several useful chart types introduced in Excel 2016 and Excel 2019 for Windows, as well as how to use several impressive new data analysis tools. We’ve also got a list of handy keyboard shortcuts in Excel, as well as the Excel 2016 and 2019 Ribbon quick reference.
PowerPoint 2016 cheat sheet
Like Word and Excel, PowerPoint 2016 for Windows gets Tell Me, Smart Lookup, real-time collaborative editing and six new chart types. We cover all that plus several handy features for Office 365 subscribers — not to mention our list of keyboard shortcuts for PowerPoint 2016 and the PowerPoint 2016 Ribbon quick reference.
Outlook 2016 cheat sheet
Outlook 2016 for Windows has been enhanced with Smart Lookup, Tell Me, and features to help you find files you want to attach and keep a tidy inbox. And don’t miss our list of keyboard shortcuts for Outlook 2016 and the Outlook 2016 Ribbon quick reference.
Office 2013
Word 2013 cheat sheet
Among the major features introduced in Word 2013 are a Start screen, a Design tab, Read Mode, and OneDrive sync. Our guide covers how to use them all and provides handy keyboard shortcuts for Word 2013. There’s also a Word 2013 Ribbon quick reference.
SharePoint 2013 cheat sheet
Learn the basics of navigating and using a SharePoint site, where to go to find some of the customization options, and 5 advanced SharePoint 2013 tips.
Office 2010
Outlook 2010 cheat sheet
The Ribbon was only half-present in Outlook 2007, but in Outlook 2010 it’s ubiquitous. Other notable changes include Conversation View to group email messages, Schedule View for scheduling meetings, and an enhanced search function. We show you how to use them all, provide some handy keyboard shortcuts for Outlook 2010 and detail where old Outlook 2003 commands are located in Outlook 2010.
PowerPoint 2010 cheat sheet
Learn how to use PowerPoint 2010’s new multimedia editing tools, sharing options and other handy features. As usual, we’ve got keyboard shortcuts for PowerPoint 2010 and a guide to finding old PowerPoint 2003 commands on the PowerPoint 2010 Ribbon.
Excel 2010 cheat sheet
Excel 2010 introduces Sparklines, Slicers, and other enhancements to PivotTables and PivotCharts. Find out how to use those, along with keyboard shortcuts for Excel 2010 and our quick reference for finding your favorite commands on the Excel 2010 Ribbon.
Word 2010 cheat sheet
Learn how to use Word 2010’s new Navigation pane, image editing tools, text effects and other new features. Also see the list of handy keyboard shortcuts for Word 2010 and our Word 2010 Ribbon quick reference charts.
SharePoint 2010 cheat sheet
Unlike earlier versions of SharePoint, SharePoint 2010 is based on the Ribbon interface. Here’s how to find your way around and get started with a SharePoint site. Also see 5 tips for working with SharePoint 2010 for more advanced techniques.
Windows 8
Windows 8 cheat sheet
Not many people are still using this nightmare of an operating system, which radically overhauled the classic Windows interface in an attempt to make it more like a mobile OS. But just in case, here’s help finding your way around.
Copyright © 2019 IDG Communications, Inc.