Microsoft Office is still the most popular office suite used by companies and individuals across the world. These Word, Excel, PowerPoint, and OneNote cheat sheets will help boost your productivity and save time when you’re working in these programs.
This post is part of Microsoft Office Week, a series at Lifehacker where we offer tips to get started with or master Microsoft Office. Want more? Check out the Office Week tag page.
10. Useful Excel Tricks and Features
Excel is packed with features spreadsheet ninjas should know, but for a visual reference, save or download one or all of these cheat sheets: 8 Great Tools to Make You an Excel Expert (includes how to combine cells, use VLOOKUP, and conditional formatting), Excel Tricks That Will Impress Your Boss (includes flash fill, pivot tables, and goal seeking), and 8 Time-Saving Excel Shortcuts (includes selecting the entire spreadsheet, resizing columns in just two clicks, and inserting the current date). They might sound the same, but they offer different tips and tricks. Excel has so many!
9. See Excel Keyboard Shortcuts for PC and Mac Side-by-Side
Excel’s keyboard shortcuts are similar on the PC and Mac, but not always. Some are quite different between the two OSes and others are Windows-only. The side-by-side comparison can help if you’re moving between the two operating systems.
8. Popular Office Shortcuts
New Horizons offers this printable PDF that covers frequently used Word, Excel, Outlook, and PowerPoint keyboard shortcuts. If you fold the paper along the lines and glue the edges, you’ll get a pyramid you can place in front of your keyboard for easy reference. (This one might be best for Office newbies.)
7. Quick Reference Cards for Excel Keyboard Shortcuts
Microsoft offers three reference sheets for Excel, including Ctrl combinations, Function key combinations, and miscellaneous shortcuts. Though it’s for Excel 2010, they should apply to other versions of Excel as well.
6. Keyboard Sequences for PowerPoint
You might be familiar with PowerPoint’s keyboard shortcuts, but some tasks in PowerPoint require keyboard sequences—pressing two buttons together and then a third. As we’ve shared previously, Indezine offers a full list of these powerful sequences for PowerPoint 2016 and earlier, which you can check out here. There’s a printable e-book version for 2013 and earlier there as well.
5. Office for Mac Keyboard Shortcuts
I couldn’t find any Office for Mac cheat sheets, but did find this reference PDF that’s chock full of keyboard shortcuts for Office on the Mac, care of Dean Pirera at OS X Keyboard Shortcuts. They should help with any version of Office on the Mac.
This tutorial will show you how to best use this free Premiere Pro preset pack. Premiere pro preset free download. HAWAII94) by Mark Redito Creative Commons — Attribution 3.0 Unported— CC BY 3.0. Works well in travel films or music videos. Included in the pack: Retro Dream TV Box Lines VHS Stylize VHS Stylize (Damaged) RGB Split Download Preset Pack here: My Favorite Filmmaking Gear: ▶︎ My Gear: ▶︎ Sony a6300 ▶︎ Sigma 30mm 1.4 ▶︎ Sony 16-50 kit lens ▶︎ GoPro Hero Session ▶︎ Evecase Camera Backpack ▶︎ $29 Fotasy 35mm 1.7 lens Update to the latest Adobe Creative Cloud here: ▶︎ The screen recorder I use: ▶︎ Connect with me on: Instagram- Twitter - Facebook- Graded w Lumetri in Adobe Premiere Pro Sony a6300 Picture Profile: Cine4 Music by: Missed Call (feat. Music provided by Audio Library For business inquiries: firstname.lastname@example.org *Amazon links are affiliate links and help to support the channel.
4. All the Word Keyboard Shortcuts
Stimpson business studies free download. Microsoft Word has over 200 keyboard shortcuts. If you’d like to see them all in one place, you can use a macro in Word to generate the list—or just download our PDF or Word version.
3. Quick Reference Guides from CustomGuide
CustomGuide offers a ton of free cheat sheets for Microsoft Office, including Access and Office 2011 on the Mac. This might be the motherload of cheat sheets for Office.
2. Microsoft’s Quick Reference Guides
Microsoft offers its own cheat sheets or quick reference guides for its Office suite, which you can view online or download as PDFs. They’re for Office 2016. MSDN also has the collection of 2013 quick start guides here.
1. 20 Most Common Keyboard Shortcuts Everyone Should Know
This isn’t specific to Microsoft Office, but most of these common keyboard shortcuts can be used in Office as well as other programs, so they’re worth memorizing. Here’s our cheat sheet, from our guide to using keyboard shortcuts like a ninja.
Title image by Nick Criscuolo.
How well do you know your Windows key shortcuts in Windows 10? If you need a cheat sheet, Microsoft has just published one that you can download and print.
Novel bahasa inggris. English Book Elementary School.
While Microsoft already offers online documentation on keyboard shortcuts, the format of the page can be difficult to sift through. Fortunately, Microsoft now offers an offline version in Word .DOCX format. (Hat tip to ZDNet’s Mary Jo Foley for spotting it.)
There are 42 shortcuts in total, mostly dealing with window management, the Start menu, the Task view, and Cortana. Keep in mind the list only includes Windows key shortcuts, not shortcuts involving Ctrl or Alt.
But Microsoft didn’t do a great job formatting its new document. The gigantic header takes up half of the first page, splitting the document across three pages as a result. That’s hardly ideal if you want to print out the list or view them on a single screen.
With a simple edit, however, you can delete the header, and everything will fit on two pages. When viewed in “Multiple Pages” mode, you can view the full list of shortcuts on a single screen. We’ve posted our modified version on Dropbox. Otherwise you can grab the official document straight from Microsoft.
Why this matters: Microsoft has added several new Windows key shortcuts in Windows 10, and they’re especially important if you want to snap programs side-by-side on a single display, manage multiple monitors, or juggle several Virtual Desktops. Taking a moment to print or save these shortcuts could save you lots of time in the long run.