What’s New in Excel 2016? Excel 2016 Tutorial
Excel Basics Tutorial
Free Microsoft Excel Training 2016
* Tell Me Search Box in Excel
Excel 2016 is the latest version of Microsoft’s well-known spreadsheet program. It is packed full with improvements to existing functions and a host of new useful and exciting features. This tutorial will introduce you to a couple of the highlights of Excel 2016.
* Tell Me Search Box in Excel
The Tell Me what you want to do search box is located on the Excel 2016 Ribbon and allows users to search for any function in Excel. The Tell Me function is so advanced; a user doesn’t even have to insert the correct name for the function they are looking for, the Tell Me function will still make accurate suggestions.
To use the Tell Me search box:
1. Open Excel 2016.
2. Find the Tell Me box on the Ribbon (see circled in orange in screenshot below):
3. Click in the Tell me what you want to do box and start typing the name of the function you are looking for. An example could be to type the word Print if you are looking for options relating to printing your document.
4. Consider the options that appear and click to select the most appropriate one:
5. By selecting an option in the list, that function will be applied or Excel will take you to the dialog box or screen pertaining to the function for further options.
Tip: You can access the Tell me what you want to do function quickly by using the shortcut key combination: Alt+Q and then typing your query.
* People Graph Add-In Excel
Infographics are visual representations of data using charts, icons and images. You can create your own infographics or people graphs using your data in Excel.
To create a simple graph:
1. Open a blank worksheet in Excel 2016.
2. Use your own data or add the following data to the worksheet to use for the graph:
Important: for the infographic chart tool to work correctly, your data must be contained in two columns only.
3. Click on the Insert tab on the Ribbon.
4. In the Add-Ins group, click on the Transform cold data into a cool picture button (circled in orange in the screenshot below):
5. Wait for the add-in to load. It will open up with generic data which you can then edit:
6. Click to select the image and then move your cursor to the top right-hand corner of the image (see area circled green in screenshot above) until the Data and Settings icons appear. You may have to click this area again should the icons disappear.
7. Click on the Data icon and enter the name for your graph into the box:
8. Next click on the Select your data button and then select the two columns in your worksheet on which you wish to base the infographic.
9. Click on the Create button to add your data to the graph.
10. Format your data using the Settings button. You can change the Type, Theme and Shapes used.
Depending on which options you choose, Type, Theme or Shapes, your completed graph may look something like this:
Tip: A People Graph created in Excel can be copied and pasted into other applications, such as Microsoft Word, or saved as an image.
* Map Chart in Excel
Excel 2016 has a built-in Map Chart which you can use to visually display data that relates to countries or specific geographical regions. An internet connection is needed to carry out this action as Excel will connect to the Microsoft search engine, Bing, to complete the action.
To create a simple Map Chart:
1. Open a data sheet with two columns, one of which contains country names and the other the values you wish to display.
2. Select the two columns containing the data and click on the Insert tab on the Ribbon.
3. In the Charts group click on the Maps button (circled in orange in the screenshot below) and select Filled Map.
4. A world map with shading indicating high or low values, will be inserted into your worksheet.
5. Select the image and double click on the Chart Title block. Copy and paste or type a title for your map into the box.
6. Add or remove country labels by double clicking the country region on the map and selecting Series Options in the right-hand panel.
Depending on which options, color and formatting you choose, a Map Chart, which can be created in minutes, can look like this:
Tip: Copy a Map Chart and paste it as an image into Microsoft Word or other applications.
* Quick Analysis Tool Excel 2016
New to Excel 2016 is a set of options which appear when content has been selected called the Quick Analysis Tool.
To use Quick Analysis Tools:
1. Select the data you wish to apply functions located in the Quick Analysis tool to.
2. Click on the Quick Analysis button in the bottom right-hand corner of the selected data (see circled in orange in screenshot below):
3. Select one of the of the tools listed in the Quick Analysis toolbox, for example, Totals, Tables or Conditional Formatting.
The Quick Analysis tool streamlines productivity and saves you the time of having to navigate to the relevant options using the Ribbon or Quick Access Toolbar.
Tip: Select data and access the Quick Analysis tool by using the keyboard shortcut: Ctrl+Q.
* Excel Lookup – Smart Lookup
The Smart Lookup tool is a research function built into Excel 2016. It functions much like a search engine and helps you to quickly look up words and definitions, which is especially useful for academic essays or school projects.
To use the Smart Lookup tool:
1. Open an Excel workbook.
2. Select a word or phrase in the worksheet that you wish to know more about.
3. Click on the Review tab on the Ribbon and in the Insights group click on Smart Lookup.
4. Depending on the word(s) you selected, Smart Lookup will display images, information and links to more information that you can then use in your worksheet, essay or report:
5. Copy information from Smart Lookup directly into your worksheet by right-clicking the data and selecting Copy. Then simply paste the copied data into the desired location in your worksheet.
Woohoo! Now that you have done the tutorial:
Test your Excel skills with the corresponding FREE Online Multiple Choice
What’s New in Excel 2016? Excel 2016 Test
TRY THE NEXT TUTORIAL: The different parts of the Excel Screen Tutorial
TRY THE NEXT TEST: The different parts of the Excel Screen Test