Must rise up to hurry on the newest options in Excel? Wrestling with an previous model of Phrase? Discovering your approach round Home windows 11 or trying to get extra out of Home windows 10? Computerworld’s cheat sheets are easy-to-use guides that will help you navigate Microsoft’s core productiveness apps.
Right here’s 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’ve additionally obtained guides for Microsoft Groups, SharePoint, OneDrive, OneNote, Planner, and Home windows itself.
Microsoft’s subscription-based workplace suite, referred to 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 guess that many corporations and people will keep on older variations of the non-subscription software program (Workplace 2016, for instance) for a while to come back, so we’ve obtained cheat sheets for a number of generations of these merchandise as effectively.
Home windows 10 and 11
Home windows 11 cheat sheet
To an excellent extent, Home windows 11 seems 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 vital 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 characteristic updates each spring and fall. Get to know the interface and key options, and don’t miss our downloadable listing of useful gestures and shortcuts for Home windows 10. (Present for the Home windows 10 October 2020 Replace, model 20H2.)
Microsoft OneDrive cheat sheet
If in case you have Home windows 10 or 11, you will have OneDrive. Right here’s 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 and 11, OneNote is a strong note-taking app that can also be accessible as a free standalone product. Right here’s rise up and working with OneNote for Home windows 10/11. When you’ve mastered the fundamentals, take a look at 5 energy consumer ideas for Microsoft OneNote.
Extra ideas for Home windows 10 and 11
Workplace 365/Microsoft 365
Phrase for Workplace 365/Microsoft 365 cheat sheet
Study to make use of one of the best 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. We additionally embody helpful keyboard shortcuts, plus there’s a quick-reference information to the Ribbon in Phrase for Workplace 365/Microsoft 365 for downloading and printing.
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 cell app.
Excel for Workplace 365/Microsoft 365 cheat sheet
Find out about all of the options launched in Excel 2016 and 2019, plus a number of extra unique to Workplace 365/Microsoft 365 subscribers. You’ll additionally discover helpful keyboard shortcuts and a quick-reference information to the Ribbon in Excel for Workplace 365/Microsoft 365 that you could 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 the way to take advantage of the brand new options, uncover useful keyboard shortcuts, and study 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 most important options launched in PowerPoint 2016 and 2019, plus extra solely for Workplace 365/Microsoft 365 subscribers — together with a simplified Ribbon that reveals solely essentially the most generally used instructions. The story additionally reveals useful keyboard shortcuts for Outlook, and now we have a separate quick-reference Ribbon information for Outlook in Workplace 365/Microsoft 365 that you could obtain.
Microsoft Groups cheat sheet
Microsoft’s reply to Slack, Groups supplies group messaging, voice and video calls, and helpful integrations with different Workplace 365 apps. Right here’s get arrange in Groups and discover your approach round.
SharePoint On-line cheat sheet
Learn to discover your approach 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 ideas for working with SharePoint On-line.
Microsoft Planner cheat sheet
Planner provides 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 Stream: A newbie’s information
Stream (just lately renamed Energy Automate) allows you to create automated workflows throughout apps and companies that ship notifications, ask for and supply approvals, and deal with rote duties routinely — with no coding required. Learn to get began with this highly effective device.
Extra ideas for Workplace 365/Microsoft 365/Workplace On-line
Workplace 2016 and 2019
Phrase 2016 and 2019 cheat sheet
Learn to use Phrase’s stay collaborative enhancing options, Inform Me and Sensible Lookup, and the brand new Translator pane in Phrase 2019. Additionally included is an inventory of useful keyboard shortcuts for Phrase 2016 and 2019. For those who simply wish 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 sorts launched in Excel 2016 and Excel 2019 for Home windows, in addition to use a number of spectacular new knowledge evaluation instruments. We’ve additionally obtained an inventory 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 supply Inform Me, Sensible Lookup, stay collaborative enhancing and a slew of latest chart sorts. We cowl all that plus some useful options launched in PowerPoint 2019 — to not point out our listing 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 will help you discover recordsdata you wish to connect and hold a tidy inbox. And don’t miss our listing of keyboard shortcuts for Outlook 2016 and 2019 and the Outlook 2016 and 2019 Ribbon fast reference.
Phrase 2013 cheat sheet
Among the many main options launched in Phrase 2013 are a Begin display screen, a Design tab, Learn Mode, and OneDrive sync. Our information covers use all of them and supplies 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 web site, the place to go to seek out a number of the customization choices, and 5 superior SharePoint 2013 ideas.
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 listing 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 the way 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 regular, we’ve obtained 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 embody Dialog View to group e-mail messages, Schedule View for scheduling conferences, and an enhanced search operate. We present you 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 discover your approach round and get began with a SharePoint web site. Additionally see 5 ideas 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 to make it extra like a cell OS. However simply in case, right here’s assist discovering your approach round.
Copyright © 2021 Aghnai, Inc.
10 extremely helpful add-ins for Microsoft Workplace
Google Sheets energy suggestions: Create an mechanically updating spreadsheet
9 useful hidden options in Google Docs on Android