Welcome, Guest: Register On Nairaland / LOGIN! / Trending / Recent / New
Stats: 3,143,337 members, 7,780,881 topics. Date: Friday, 29 March 2024 at 02:17 AM

Microsoft Office Excel Cheat Sheet - Education - Nairaland

Nairaland Forum / Nairaland / General / Education / Microsoft Office Excel Cheat Sheet (1823 Views)

Activate Microsoft Office LTSC Pro Plus 2021 Without Any Software Or Crack Free / UNILAG Law Attendance Sheet Used To Sell Suya Causes Stir Online / Microsoft Office Word Cheat Sheet (2) (3) (4)

(1) (Reply) (Go Down)

Microsoft Office Excel Cheat Sheet by Yinksdavid(m): 6:21pm On Sep 22, 2021


Excel is without a doubt the best application when it comes to creating and managing spreadsheets. You can find it as part of the Microsoft Office suite alongside other productivity apps. Everyone can find a suitable option to get access to Excel.

I have researched and put together this cheat sheet to help you get up and running with Excel, and give you some useful tips.

Get to know the Ribbon interface

The Ribbon has been a major part of Excel for several years now as it was developed to allow for quicker work as opposed to navigating complicated and old-fashioned menus, sub-menus, sub-sub menus, and so on. With the Ribbon, you get easy navigation with a mostly visual interface that helps you get to the tools you know and love quicker.

It’s known that Excel’s signature color is green, however, you can always change the top part of your Ribbon to white, gray or black. Simply navigate to the FileOptionsGeneral menu, and look under “Personalize your copy of Microsoft Office” to choose the theme you prefer.



When needed, just hide the Ribbon at any point in time by pressing the Ctrl + F1 keys on your keyboard. To make it appear again, press the same two keys.

There are several settings and ways to alter how the Ribbon displays itself. At the top right of your screen, you'll see an icon titled "Ribbon Display Options" which opens a drop-down menu with three different options:

Auto-hide Ribbon: This option hides the Ribbon itself, as well as the tabs and commands in it by default. When this is selected, the only way to make the Ribbon and its contents appear is by clicking on the top section of the Excel screen.

Show Tabs: This option keeps the tabs of the Ribbon but hides all commands underneath. You can show commands by either click on one of the tabs, pressing the Ctrl + F1 keys on your keyboard, or selecting the “Show Tabs and Commands” option instead.

Show Tabs and Commands: With this option, you get to see the full Ribbon with both its tabs and commands visible at all times.

File menu, the backstage area



When you click the File menu in Excel, you'll arrive at the area Microsoft calls "backstage". Here, instead of seeing a tab with commands, you get a full-page view of basic features such as opening or saving files, as well as printing and sharing. Sub-menus in File focus on exporting your work, as you can save locally, use cloud-bases services you're connected to (such as SharePoint and OneDrive), share via email, and even print your work straight from Excel.

Additionally, you can use the File menu to see information about your current workbook. This means seeing the time it was created, last modified, the owner, as well as the file size and much more. You can also check for accessibility issues, add password protection, or as the owner, change the permissions of your co-editors.

Tell me what you want to do



It's easy to tell that Excel isn't one of the most beginner-friendly applications available, however, Microsoft has made a change that helps with that. Because of the tremendous amount of features and capabilities of Excel, it can become tough to use Excel to its full extent without spending a lot of time on learning and memorizing tools.

For example, let's say that you have a set of data and want to visualize it in a pie chart. Type in “create pie chart” and a menu will show several results. In this example, clicking on the first result directly allows you to insert a pie chart without having to navigate through the Ribbon and find the option there.

Other results may come in handy too and suggest possible solutions to your problem. With each task you type in, you always have a link to get help on the topic or use the Smart Lookup feature for searching online.

In conclusion, the Tell Me feature allows you to perform tasks quicker and search for solutions right within Excel. Even if you consider yourself a veteran with the software, you can continue to find ways for speeding up your work. Tell Me remembers tasks you’ve previously searched for, allowing for even better reachability in the future.

Use charts to visualize your data

You might have a powerful and informative set of data, however, it can quickly become hard to understand when it comes to presenting to an audience or adding in more and more information. Charting allows you to visually display parts of your spreadsheet, which enhances your spreadsheets by making information more comprehensive. This allows you to identify data trends, patterns and quickly analyze things with a glance.

When creating a chart, you need to select the data you want to visualize first. You can do this by clicking on a cell then holding either the Shift or Alt keys to select a group of data or other individual cells respectively. After every cell you need has been selected, click on the Insert tab from the Ribbon and choose the chart style suitable for your information.



In the 2019 release of Excel, you can find over 15 different charts and many chart type options to customize the look and feel of your documents. You’re also able to modify the colors, as well as the font and style of your charts.

Search online with Smart Lookup



This new feature gives you an easily accessible way of looking up information online. Simply right-click on a cell with some word(s) in it, and select Smart Lookup from the context menu. This will open up a pane on the side of Excel, where the Microsoft Bing search engine performs a web search of the word(s) in your selected cell.

Note: You might be required to enable Microsoft’s intelligent services to have access to Smart Lookup. This means that your search terms and some contents from your spreadsheets and documents will be collected by Microsoft to provide learning material to these services. If you prefer to not take risks when it comes to privacy, you should reconsider whether or not searching online right from Excel is worth it.

You’ll see definitions, related Wikipedia entries, and other useful results from the Internet. By clicking on any of the results, you can further explore web pages and gather more information yourself.

While Smart Lookup isn’t perfect for specific queries such as looking up the inflation rate in Germany during 2016, you can definitely get some use out of it when you need to define a word or understand a term.

Essential Excel Shortcuts(Attached): This has been attached below and you can reach out if you need the excel file containing the shortcuts

Select an entire column or row

To select an entire column, simply click on a cell in that column and press the Ctrl + Space [/b]combination. You can do the same with an entire row by pressing [b]Shift + Space instead.

Start a new line in the same cell

One of the most tedious things to do in Excel is creating a new line within the same cell, as you’d naturally have to type the text out in a separate application such as Word or Notepad and copy-paste it in Excel. You can avoid this procedure by using the Alt + Enter shortcut as you type to start a new line.

Insert current time and date

You can insert the current time into your spreadsheet by pressing the Ctrl + Shift + Colon keys. To do the same with the current date, press Ctrl + Colon only.

Hide a column or a row

There are instances where you want to compare data between a row or a column, but there’s another one in the middle of it. You can temporarily hide a column by selecting a cell in it and pressing Ctrl + 0, and do the same with a row by pressing Ctrl + 9 instead.

Re: Microsoft Office Excel Cheat Sheet by Yinksdavid(m): 10:32am On Sep 23, 2021
Do you want your OS environment and apps to respond quicker and run faster?

Do you want to always get the newest security updates, patches to restrict easy access of viruses, malwares, spywares affecting your OS environment?

Do you want to get critical updates to improve all app functions on your environment

Do you want to have personalization settings unblocked?

Do you want to have free support from MS Agent?

Kindly check if your Windows OS is activated and if not, ensure you get a valid activation/license key as this will save you the stress of resolving issues on your system by paying technicians all the time for OS related issues.

Genuine and Legitimate Activation/License retail keys directly from Microsoft available at a very low cost. kindly reach out via my signature for more details.

Exchange Server 2016 (Standard and Enterprise Edition)
Exchange Server 2019 (Standard and Enterprise Edition)

Office 2013 (Professional, Standard and Ultimate version)
Office 2016 (Professional, Standard and Ultimate version)
Office 2019 (Professional, Standard and Ultimate version)

Office 365
- Project Professional 2019
- Office Home and Business 2019
- Visio Professional 2019
- Office Professional Plus 2019

Office Home and Business 2016 for Mac
Office Home and Business 2019 for Mac

Office Professional Plus 2016
Office Professional Plus 2019

SharePoint Server 2016 (Standard and Enterprise)
SharePoint Server 2019 (Standard and Enterprise)

Visual Studio Enterprise 2017
Visual Studio Enterprise 2019

Visual Studio 2017 for Mac
Visual Studio 2019 for Mac

Windows 10 Pro Plus
Windows 10 Enterprise
Windows 10 Pron N
Windows 10 Education


Windows Server 2016 (Datacenter, Remote Desktop Services user connection(50) and Standard)

Windows Server 2019 (Datacenter, Remote Desktop Services user connection(50) and Standard).
Re: Microsoft Office Excel Cheat Sheet by Hahjascho(m): 11:04pm On Sep 23, 2021
Nice
Re: Microsoft Office Excel Cheat Sheet by Yinksdavid(m): 12:28pm On Sep 24, 2021
Hahjascho:
Nice

Thanks

(1) (Reply)

Can Any School Allow This / SE Lead As WAEC release Public School Performance / .

(Go Up)

Sections: politics (1) business autos (1) jobs (1) career education (1) romance computers phones travel sports fashion health
religion celebs tv-movies music-radio literature webmasters programming techmarket

Links: (1) (2) (3) (4) (5) (6) (7) (8) (9) (10)

Nairaland - Copyright © 2005 - 2024 Oluwaseun Osewa. All rights reserved. See How To Advertise. 31
Disclaimer: Every Nairaland member is solely responsible for anything that he/she posts or uploads on Nairaland.