Have to stand up to hurry on the newest options in Excel? Wrestling with an previous model of Phrase? Discovering your means round Home windows 11 or seeking 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.

Right here’s a one-stop useful resource the place yow will discover 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’ve additionally received guides for Microsoft Groups, SharePoint, OneDrive, 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, so we periodically replace the cheat sheets for the “365” variations of Phrase, Excel, PowerPoint, and Outlook. However we’re prepared to wager that many firms and people will keep on older variations of the non-subscription software program (Workplace 2016, for instance) for a while to return, so we’ve received cheat sheets for a number of generations of these merchandise as effectively.

[ Related: Office 2021 vs. Microsoft 365: How to choose ]

Home windows 10 and 11

Home windows 11 cheat sheet

To an incredible extent, Home windows 11 appears and works like Home windows 10, however there are a number of minor variations that take some getting used to. We cowl all of the necessary modifications right here, together with new three- and four-finger gestures for touchscreen customers in our lists of shortcuts and gestures for Home windows 11.

Home windows 10 cheat sheet

Home windows 10 is frequently enhancing with main function updates each spring and fall. Get to know the interface and key options, and don’t miss our downloadable checklist of useful gestures and shortcuts for Home windows 10. (Present for the Home windows 10 October 2020 Replace, model 20H2.)

Microsoft OneDrive cheat sheet

When you’ve got Home windows 10 or 11, you’ve OneDrive. Right here’s the best way to again up, sync and share information in OneDrive and OneDrive for Enterprise.

Microsoft OneNote cheat sheet

A part of Microsoft’s Workplace suite and constructed into Home windows 10 and 11, OneNote is a strong note-taking app that can be accessible as a free standalone product. Right here’s the best way to stand up and operating with OneNote.

Extra suggestions for Home windows 10 and 11

  • How you can deal with Home windows 10 and 11 updates
  • 17 methods to hurry up Home windows 10
  • How you can defend your privateness in Home windows 10
  • How you can share a Home windows 10 PC
  • How you can defend Home windows 10 and 11 PCs from ransomware
  • How you can repair 5 Home windows 10 complications
  • Workarounds for 4 duties Home windows 11 makes more durable
  • 12 traditional however important (and free!) utilities for Home windows 10 and 11
  • 30+ free and low cost apps for Home windows 10
  • How you can restore Home windows 10 (and 11) in 4 steps

Workplace 365/Microsoft 365

Phrase for Workplace 365/Microsoft 365 cheat sheet

Study to make use of the perfect options launched in Microsoft Phrase for Workplace 365/Microsoft 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/Microsoft 365 subscribers. Associated: a listing of useful Phrase keyboard shortcuts for Home windows and Mac, a quick-reference information to the Ribbon in Phrase for Workplace 365/Microsoft 365 for downloading and printing, and our information to the Phrase cellular app.

Excel for Workplace 365/Microsoft 365 cheat sheet

Study all of the options launched in Excel 2016 and 2019, plus a number of extra unique to Workplace 365/Microsoft 365 subscribers. Associated: a listing of helpful Excel keyboard shortcuts for Home windows and Mac and a quick-reference information to the Ribbon in Excel for Workplace 365/Microsoft 365 you can obtain and print.

PowerPoint for Workplace 365/Microsoft 365 cheat sheet

Microsoft launched a number of extremely helpful options in PowerPoint 2016 and 2019, and it frequently rolls out extra for customers with Workplace 365/Microsoft 365 subscriptions. Learn how to benefit from the brand new options. Associated: uncover useful PowerPoint keyboard shortcuts for Home windows and Mac and be taught to grasp the Ribbon with our downloadable quick-reference Ribbon information for PowerPoint for Workplace 365/Microsoft 365.

Outlook for Workplace 365/Microsoft 365 cheat sheet

Uncover all the key options launched in PowerPoint 2016 and 2019, plus extra solely for Workplace 365/Microsoft 365 subscribers — together with a simplified Ribbon that exhibits solely probably the most generally used instructions. The story additionally exhibits useful keyboard shortcuts for Outlook, and now we have a separate quick-reference Ribbon information for Outlook in Workplace 365/Microsoft 365 you can obtain.

Microsoft Groups cheat sheet: How you can get began

Microsoft’s reply to Slack and Zoom, Groups offers group messaging, voice and video calls, and helpful integrations with different Microsoft 365 apps. Right here’s the best way to get arrange in Groups and discover your means round.

Microsoft Visio cheat sheet: How you can get began

Visio in Microsoft 365 is a wonderful instrument for creating customized diagrams for instance ideas which are tough to clarify by way of textual content. Right here’s the best way to use it.

Microsoft Planner cheat sheet

Planner provides Workplace 365/Microsoft 365 customers a built-in task-management instrument 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 Circulate: A newbie’s information

Circulate (not too long ago renamed Energy Automate) helps you to create automated workflows throughout apps and companies that ship notifications, ask for and provide approvals, and deal with rote duties mechanically — with no coding required. Learn to get began with this highly effective instrument.

SharePoint On-line cheat sheet

Learn to discover your means 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.

Extra suggestions for Workplace 365/Microsoft 365/Workplace On-line

  • Use Outlook’s new calendar board view to prepare your work
  • 8 Outlook add-ins to reinforce collaboration
  • How you can filter Outlook emails on all of your units
  • How you can verify another person’s schedule in Outlook
  • How you can work throughout time zones in Outlook
  • 28 energy consumer suggestions for Microsoft Groups
  • 11 greatest practices for Microsoft Groups video conferences
  • The ten greatest new Microsoft Groups assembly options
  • How you can have Groups conferences with folks outdoors your group
  • 10 extremely helpful add-ins for Microsoft Workplace
  • 5 collaboration instruments that improve Microsoft Workplace
  • 4 steps to restore Microsoft Workplace

Workplace 2016 and 2019

Phrase 2016 and 2019 cheat sheet

Learn to use Phrase’s reside collaborative enhancing options, Inform Me and Sensible Lookup, and the brand new Translator pane in Phrase 2019. Additionally included is a listing of useful keyboard shortcuts for Phrase 2016 and 2019. In case you simply need to know the place to seek 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 varieties launched in Excel 2016 and Excel 2019 for Home windows, in addition to the best way to use a number of spectacular new information evaluation instruments. We’ve additionally received a listing of useful 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, Sensible Lookup, reside collaborative enhancing and a slew of latest chart varieties. We cowl all that plus some useful 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 and 2019 cheat sheet

Outlook 2016 for Home windows has been enhanced with Sensible Lookup, Inform Me, and options that can assist you discover information you need to connect and hold a tidy inbox. And don’t miss our checklist of keyboard shortcuts for Outlook 2016 and 2019 and the Outlook 2016 and 2019 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 the best way to use all of them and offers useful 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 website, the place to go to seek out among the customization choices, and 5 superior SharePoint 2013 suggestions.

Workplace 2010

Phrase 2010 cheat sheet

Learn to use Phrase 2010’s Navigation pane, picture enhancing instruments, textual content results and different new options. Additionally see the checklist of useful keyboard shortcuts for Phrase 2010 and our Phrase 2010 Ribbon fast reference charts.

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.

PowerPoint 2010 cheat sheet

Learn to use PowerPoint 2010’s multimedia enhancing instruments, sharing choices and different useful options. As standard, we’ve received keyboard shortcuts for PowerPoint 2010 and a information to discovering previous PowerPoint 2003 instructions on the PowerPoint 2010 Ribbon.

Outlook 2010 cheat sheet

The Ribbon was solely half-present in Outlook 2007, however in Outlook 2010 it’s 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 the best way to use all of them, present some useful keyboard shortcuts for Outlook 2010 and element the place previous Outlook 2003 instructions are positioned in Outlook 2010.

SharePoint 2010 cheat sheet

Not like earlier variations of SharePoint, SharePoint 2010 is predicated on the Ribbon interface. Right here’s the best way to discover your means round and get began with a SharePoint website. Additionally see 5 suggestions for working with SharePoint 2010 for extra superior strategies.

Home windows 8

Home windows 8 cheat sheet