#MICROSOFT EXCEL 2016 GUIDE BOOK PDF SOFTWARE LICENSE#
#MICROSOFT EXCEL 2016 GUIDE BOOK PDF PLUS#
#MICROSOFT EXCEL 2016 GUIDE BOOK PDF DOWNLOAD#
#MICROSOFT EXCEL 2016 GUIDE BOOK PDF WINDOWS#

To make the title bar green again, instead choose the “Colorful” option from the drop-down list. In the “Personalize your copy of Microsoft Office” section, click the down arrow next to Office Theme, and select Dark Gray or White (or Black) from the drop-down menu.

(In Excel 2019, there’s also a black option.) To do it, select File > Options > General.

Show Tabs and Commands: Selecting this shows both the tabs and commands.Īnd if for some reason that nice green color on the title bar is just too much for you, you can turn it white or gray.

To display the commands underneath the tabs when they’re hidden, press Ctrl-F1, click a tab, or click the Ribbon display icon and select “Show Tabs and Commands.”

Show Tabs: This shows the tabs but hides the commands underneath them.

To show the Ribbon again, click at the top of PowerPoint.

Auto-hide Ribbon: This hides the entire Ribbon, both the tabs and commands underneath them.

A drop-down menu appears with these three options: To get to them, click the Ribbon Display Options icon at the top right of the screen, just to the left of the icons for minimizing and maximizing PowerPoint.

You’ve got other options for displaying the Ribbon as well. To make it appear again, press Ctrl-F1 and it comes back. Just as in previous versions of Excel, if you want the Ribbon to go away, press Ctrl-F1. Also see the nifty new Tell Me feature described below.

#MICROSOFT EXCEL 2016 GUIDE BOOK PDF DOWNLOAD#

To find out which commands reside on which tabs on the Ribbon, download our Excel 20 Ribbon quick reference. The Ribbon hasn’t changed a great deal from Excel 2013. But it still works in the same way, and you’ll find most of the commands in the same locations as in earlier versions. The 20 Ribbon is smaller than it was in Excel 2013, the title bar is solid green rather than white, and the text for the Ribbon tabs (File, Home, Insert and so on) is a mix of upper- and lowercase rather than all caps. If you need a refresher, see our Excel 2010 cheat sheet.Īs in Excel 2013, the Ribbon in Excel 20 has a flattened look that’s cleaner and less cluttered than in Excel 20. Since the Ribbon has been included in Office suite applications since Office 2007, we assume that by now you’re familiar with how it works. The Ribbon interface that you came to know and love (or perhaps hate) in earlier versions of Excel hasn’t changed much in Excel 2016 or 2019. Share this story: IT folks, we hope you'll pass this guide on to your users to help them learn to get the most from Excel 20.

Near the end is a section for Excel 2019 only. Most of the tips in this article apply to both Excel 20 for Windows. If you or your organization has an Office 365 subscription, see our separate Excel for Office 365 cheat sheet for coverage of all the latest features.

#MICROSOFT EXCEL 2016 GUIDE BOOK PDF PLUS#

In Office 365, Excel has all those features, plus several more. This cheat sheet gets you up to speed on the features that were introduced in Excel 2016 and Excel 2019, the perpetual-license versions of Excel included with Office 2016 and Office 2019, respectively. (For more details, see “ What are the differences between Microsoft Office 2019 and Office 365?”) When you purchase a perpetual version of the suite - say, Office 2016 or Office 2019 - its applications will never get new features, whereas Office 365 apps are continually updated with new features.

#MICROSOFT EXCEL 2016 GUIDE BOOK PDF SOFTWARE LICENSE#

Microsoft sells Office under two models: Individuals and businesses can pay for the software license up front and own it forever (what the company calls the “perpetual” version of the suite), or they can purchase an Office 365 subscription, which means they have access to the software for only as long as they keep paying the subscription fee. And if you use spreadsheets, that generally means Excel.Įxcel is, of course, part of Microsoft’s Office suite of productivity tools.

#MICROSOFT EXCEL 2016 GUIDE BOOK PDF WINDOWS#

Microsoft Windows may get all the press coverage, but when you want to get real work done, you turn your attention to the applications that run on it.

Microsoft excel 2016 guide book pdf