Need to stand up to hurry on the newest options in Excel? Wrestling with an outdated model of Word? Looking to get extra out of Windows 10? Computerworld’s cheat sheets are easy-to-use guides that will help you navigate Microsoft’s core productiveness apps.
Here’s a one-stop useful resource the place you could find in-depth tales on a number of generations of Word, Excel, PowerLevel, and Outlook for Windows, specializing in what’s new in every main launch. We’ve additionally received guides for SharePoint, OneNote, Microsoft Teams and Windows itself.
Microsoft’s subscription-based workplace suite, known as Office 365 or Microsoft 365 relying in your model, is frequently up to date with new options, and its newest non-subscription workplace suite is Office 2019. We’re engaged on publishing new cheat sheets to cowl these merchandise, however we’re prepared to guess that many corporations and people will keep on older variations of the standalone software program for a while to come back. We’ve received you lined right here.
Windows 10 and Office 365
Windows 10 cheat sheet
The finest working system that is come alongside from Microsoft in a very long time, Windows 10 is frequently bettering with main characteristic updates each spring and fall. Get to know the interface and key options, and do not miss our downloadable checklist of helpful gestures and shortcuts for Windows 10. (Current for the Windows 10 November 2019 Update, model 1909.)
Word for Office 365 cheat sheet
Learn to make use of the very best options launched in Microsoft Word for Office 365 in Windows since 2015. This story covers all of the options launched in Word 2016 and 2019, plus a number of extra unique to Office 365 subscribers. We additionally embody helpful keyboard shortcuts, plus there is a quick-reference information to the Ribbon in Word for Office 365 for downloading and printing.
Excel for Office 365 cheat sheet
Learn about all of the options launched in Excel 2016 and 2019, plus a number of extra unique to Office 365 subscribers. You’ll additionally discover helpful keyboard shortcuts and a quick-reference information to the Ribbon in Excel for Office 365 you can obtain and print.
Coming quickly: Cheat sheets protecting PowerLevel and Outlook for Office 365. In the meantime, see our Office 2016 and 2019 cheat sheets under.
Microsoft OneDrive cheat sheet
If you could have Windows 10, you could have OneDrive. Here’s the best way to again up, sync and share information in OneDrive and OneDrive for Business.
Microsoft OneNote cheat sheet
Part of Microsoft’s Office suite and constructed into Windows 10, OneNote is a strong note-taking app that can also be obtainable as a free standalone product. Here’s the best way to stand up and operating with OneNote for Windows 10. Once you’ve got mastered the fundamentals, try 5 energy consumer suggestions for Microsoft OneNote.
Microsoft Teams cheat sheet
Microsoft’s reply to Slack, Teams gives group messaging, voice and video calls, and helpful integrations with different Office 365 apps. Here’s the best way to get arrange in Teams and discover your manner round. Ready to go to the following stage with Teams? See 8 Microsoft Teams suggestions and tips.
SharePoint Online cheat sheet
Learn the best way to discover your manner round SharePoint Online (the Office 365 model of SharePoint), create websites, share and handle paperwork, work with calendars, combine with Outlook and extra. Then transcend the fundamentals in 5 suggestions for working with SharePoint Online.
Microsoft Flow: A newbie’s information
Flow (not too long ago renamed Power Automate) permits you to create automated workflows throughout apps and providers that ship notifications, ask for and provide approvals, and deal with rote duties robotically — with no coding required. Learn the best way to get began with this highly effective instrument.
Microsoft Word for Android (and iOS) cheat sheet
Word isn’t only for the desktop anymore. Here’s your information to creating, modifying, and collaborating on paperwork in Microsoft’s Word cellular app.
Office 2016 and 2019
Word 2016 and 2019 cheat sheet
Learn the best way to use Word’s stay collaborative modifying options, Tell Me and Smart Lookup, and the brand new Translator pane in Word 2019. Also included is an inventory of helpful keyboard shortcuts for Word 2016 and 2019. If you simply wish to know the place to seek out varied instructions on the Ribbon, obtain our Word 2016 and 2019 Ribbon fast reference.
Excel 2016 and 2019 cheat sheet
Now up to date for Excel 2019, our information covers a number of helpful chart varieties launched in Excel 2016 and Excel 2019 for Windows, in addition to the best way to use a number of spectacular new information evaluation instruments. We’ve additionally received an inventory of helpful keyboard shortcuts in Excel, in addition to the Excel 2016 and 2019 Ribbon fast reference.
PowerLevel 2016 and 2019 cheat sheet
Like Word and Excel, PowerLevel 2016 and PowerLevel 2019 for Windows provide Tell Me, Smart Lookup, stay collaborative modifying and a slew of recent chart varieties. We cowl all that plus some helpful options launched in PowerLevel 2019 — to not point out our checklist of keyboard shortcuts for PowerLevel and the PowerLevel 2016 and 2019 Ribbon fast reference.
Outlook 2016 cheat sheet
Outlook 2016 for Windows has been enhanced with Smart Lookup, Tell Me, and options that will help you discover information you wish to connect and hold a tidy inbox. And do not miss our checklist of keyboard shortcuts for Outlook 2016 and the Outlook 2016 Ribbon fast reference.
Office 2013
Word 2013 cheat sheet
Among the most important options launched in Word 2013 are a Start display screen, a Design tab, Read Mode, and OneDrive sync. Our information covers the best way to use all of them and gives helpful keyboard shortcuts for Word 2013. There’s additionally a Word 2013 Ribbon fast reference.
SharePoint 2013 cheat sheet
Learn the fundamentals of navigating and utilizing a SharePoint website, the place to go to seek out a number of the customization choices, and 5 superior SharePoint 2013 suggestions.
Office 2010
Outlook 2010 cheat sheet
The Ribbon was solely half-present in Outlook 2007, however in Outlook 2010 it is ubiquitous. Other notable modifications embody Conversation View to group e-mail messages, Schedule View for scheduling conferences, and an enhanced search operate. We present you the best way to use all of them, present some helpful keyboard shortcuts for Outlook 2010 and element the place outdated Outlook 2003 instructions are situated in Outlook 2010.
PowerLevel 2010 cheat sheet
Learn the best way to use PowerLevel 2010’s new multimedia modifying instruments, sharing choices and different helpful options. As regular, we have keyboard shortcuts for PowerLevel 2010 and a information to discovering outdated PowerLevel 2003 instructions on the PowerLevel 2010 Ribbon.
Excel 2010 cheat sheet
Excel 2010 introduces Sparklines, Slicers, and different enhancements to PivotTables and PivotCharts. Find out the best way to use these, together with keyboard shortcuts for Excel 2010 and our fast reference for locating your favourite instructions on the Excel 2010 Ribbon.
Word 2010 cheat sheet
Learn the best way to use Word 2010’s new Navigation pane, picture modifying instruments, textual content results and different new options. Also see the checklist of helpful keyboard shortcuts for Word 2010 and our Word 2010 Ribbon fast reference charts.
SharePoint 2010 cheat sheet
Unlike earlier variations of SharePoint, SharePoint 2010 is predicated on the Ribbon interface. Here’s the best way to discover your manner round and get began with a SharePoint website. Also see 5 suggestions for working with SharePoint 2010 for extra superior methods.
Windows 8
Windows 8 cheat sheet
Not many individuals are nonetheless utilizing this nightmare of an working system, which radically overhauled the basic Windows interface in an try and make it extra like a cellular OS. But simply in case, here is assist discovering your manner round.
Copyright © 2020 IDG Communications, Inc.