Have to stand up to hurry on the most recent options in Excel? Wrestling with an previous model of Phrase? Trying to get extra out of Home windows 10? Computerworld’s cheat sheets are easy-to-use guides that can assist you navigate Microsoft’s core productiveness apps.
Here is a one-stop useful resource the place you’ll find in-depth tales on a number of generations of Phrase, Excel, PowerPoint, and Outlook for Home windows, specializing in what’s new in every main launch. We have additionally received guides for Microsoft Groups, SharePoint, OneNote, Planner, and Home windows itself.
Microsoft’s subscription-based workplace suite, known as Workplace 365 or Microsoft 365 relying in your model, is frequently up to date with new options, and its newest non-subscription workplace suite is Workplace 2019. We’re engaged on publishing new cheat sheets to cowl these merchandise, however we’re keen to wager that many corporations and people will keep on older variations of the standalone software program for a while to return. We have you lined right here.
Home windows 10 and Workplace 365
Home windows 10 cheat sheet
The perfect working system that is come alongside from Microsoft in a very long time, Home windows 10 is frequently enhancing 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 Home windows 10. (Present for the Home windows 10 October 2020 Replace, model 20H2.)
Phrase for Workplace 365 cheat sheet
Study to make use of the most effective options launched in Microsoft Phrase for Workplace 365 in Home windows since 2015. This story covers all of the options launched in Phrase 2016 and 2019, plus a number of extra unique to Workplace 365 subscribers. We additionally embrace helpful keyboard shortcuts, plus there is a quick-reference information to the Ribbon in Phrase for Workplace 365 for downloading and printing.
Excel for Workplace 365 cheat sheet
Study all of the options launched in Excel 2016 and 2019, plus a number of extra unique to Workplace 365 subscribers. You may additionally discover helpful keyboard shortcuts and a quick-reference information to the Ribbon in Excel for Workplace 365 you could obtain and print.
Coming quickly: Cheat sheets protecting PowerPoint and Outlook for Workplace 365. Within the meantime, see our Workplace 2016 and 2019 cheat sheets under.
Microsoft OneDrive cheat sheet
When you’ve got Home windows 10, you will have OneDrive. Right here’s how you can again up, sync and share recordsdata in OneDrive and OneDrive for Enterprise.
Microsoft OneNote cheat sheet
A part of Microsoft’s Workplace suite and constructed into Home windows 10, OneNote is a strong note-taking app that can also be accessible as a free standalone product. Right here’s how you can stand up and operating with OneNote for Home windows 10. As soon as you’ve got mastered the fundamentals, try 5 energy consumer suggestions for Microsoft OneNote.
Microsoft Groups cheat sheet
Microsoft’s reply to Slack, Groups gives group messaging, voice and video calls, and helpful integrations with different Workplace 365 apps. Here is how you can get arrange in Groups and discover your manner round. Able to go to the following degree with Groups? See 8 Microsoft Groups suggestions and tips.
SharePoint On-line cheat sheet
Learn to discover your manner round SharePoint On-line (the Workplace 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 On-line.
Microsoft Planner cheat sheet
Planner offers Workplace 365/Microsoft 365 customers a built-in task-management device that small groups can use to trace plans, duties, and progress. Right here’s our information to utilizing Planner by itself and inside Microsoft Groups.
Microsoft Movement: A newbie’s information
Movement (not too long ago renamed Energy Automate) allows you to create automated workflows throughout apps and companies that ship notifications, ask for and provide approvals, and deal with rote duties routinely — with no coding required. Learn to get began with this highly effective device.
Microsoft Phrase for Android (and iOS) cheat sheet
Phrase isn’t only for the desktop anymore. Right here’s your information to creating, enhancing, and collaborating on paperwork in Microsoft’s Phrase cellular app.
Workplace 2016 and 2019
Phrase 2016 and 2019 cheat sheet
Learn to use Phrase’s reside collaborative enhancing options, Inform Me and Good Lookup, and the brand new Translator pane in Phrase 2019. Additionally included is an inventory of helpful keyboard shortcuts for Phrase 2016 and 2019. Should you simply wish to know the place to search out varied instructions on the Ribbon, obtain our Phrase 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 sorts launched in Excel 2016 and Excel 2019 for Home windows, in addition to how you can use a number of spectacular new knowledge evaluation instruments. We have additionally received an inventory of helpful keyboard shortcuts in Excel, in addition to the Excel 2016 and 2019 Ribbon fast reference.
PowerPoint 2016 and 2019 cheat sheet
Like Phrase and Excel, PowerPoint 2016 and PowerPoint 2019 for Home windows provide Inform Me, Good Lookup, reside collaborative enhancing and a slew of latest chart sorts. We cowl all that plus some helpful options launched in PowerPoint 2019 — to not point out our checklist of keyboard shortcuts for PowerPoint and the PowerPoint 2016 and 2019 Ribbon fast reference.
Outlook 2016 cheat sheet
Outlook 2016 for Home windows has been enhanced with Good Lookup, Inform Me, and options that can assist you discover recordsdata you wish to connect and preserve a tidy inbox. And do not miss our checklist of keyboard shortcuts for Outlook 2016 and the Outlook 2016 Ribbon fast reference.
Workplace 2013
Phrase 2013 cheat sheet
Among the many main options launched in Phrase 2013 are a Begin display, a Design tab, Learn Mode, and OneDrive sync. Our information covers how you can use all of them and gives helpful keyboard shortcuts for Phrase 2013. There’s additionally a Phrase 2013 Ribbon fast reference.
SharePoint 2013 cheat sheet
Study the fundamentals of navigating and utilizing a SharePoint web site, the place to go to search out a few of the customization choices, and 5 superior SharePoint 2013 suggestions.
Workplace 2010
Outlook 2010 cheat sheet
The Ribbon was solely half-present in Outlook 2007, however in Outlook 2010 it is ubiquitous. Different notable modifications embrace Dialog View to group e mail messages, Schedule View for scheduling conferences, and an enhanced search perform. We present you how you can use all of them, present some helpful keyboard shortcuts for Outlook 2010 and element the place previous Outlook 2003 instructions are positioned in Outlook 2010.
PowerPoint 2010 cheat sheet
Learn to use PowerPoint 2010’s new multimedia enhancing instruments, sharing choices and different helpful options. As normal, we have keyboard shortcuts for PowerPoint 2010 and a information to discovering previous PowerPoint 2003 instructions on the PowerPoint 2010 Ribbon.
Excel 2010 cheat sheet
Excel 2010 introduces Sparklines, Slicers, and different enhancements to PivotTables and PivotCharts. Learn how to make use of these, together with keyboard shortcuts for Excel 2010 and our fast reference for locating your favourite instructions on the Excel 2010 Ribbon.
Phrase 2010 cheat sheet
Learn to use Phrase 2010’s new Navigation pane, picture enhancing instruments, textual content results and different new options. Additionally see the checklist of helpful keyboard shortcuts for Phrase 2010 and our Phrase 2010 Ribbon fast reference charts.
SharePoint 2010 cheat sheet
In contrast to earlier variations of SharePoint, SharePoint 2010 relies on the Ribbon interface. Here is how you can discover your manner round and get began with a SharePoint web site. Additionally see 5 suggestions for working with SharePoint 2010 for extra superior strategies.
Home windows 8
Home windows 8 cheat sheet
Not many individuals are nonetheless utilizing this nightmare of an working system, which radically overhauled the basic Home windows interface in an try and make it extra like a cellular OS. However simply in case, here is assist discovering your manner round.