#MICROSOFT OFFICE 2016 TUTORIAL FULL#
#MICROSOFT OFFICE 2016 TUTORIAL SERIES#
#MICROSOFT OFFICE 2016 TUTORIAL FREE#

Select the data you wish to apply functions located in the Quick Analysis tool to.Дў. New to Excel 2016 is a set of options which appear when content has been selected called the Quick Analysis Tool.ДЎ. Tip: Copy a Map Chart and paste it as an image into Microsoft Word or other applications.

#MICROSOFT OFFICE 2016 TUTORIAL SERIES#

Add or remove country labels by double clicking the country region on the map and selecting Series Options in the right-hand panel.Дepending on which options, color and formatting you choose, a Map Chart, which can be created in minutes, can look like this: Copy and paste or type a title for your map into the box.Д¦. Select the image and double click on the Chart Title block. A world map with shading indicating high or low values, will be inserted into your worksheet.ДҐ. In the Charts group click on the Maps button (circled in orange in the screenshot below) and select Filled Map.Д¤. Select the two columns containing the data and click on the Insert tab on the Ribbon.ДЈ. Open a data sheet with two columns, one of which contains country names and the other the values you wish to display.Дў. An internet connection is needed to carry out this action as Excel will connect to the Microsoft search engine, Bing, to complete the action.ДЎ. Tip: A People Graph created in Excel can be copied and pasted into other applications, such as Microsoft Word, or saved as an image.Д®xcel 2016 has a built-in Map Chart which you can use to visually display data that relates to countries or specific geographical regions. You can change the Type, Theme and Shapes used.Дepending on which options you choose, Type, Theme or Shapes, your completed graph may look something like this: Format your data using the Settings button. Click on the Create button to add your data to the graph.ДЎ0. 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.Д©. Click on the Data icon and enter the name for your graph into the box:ДЁ. You may have to click this area again should the icons disappear.Д§. 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. It will open up with generic data which you can then edit:Д¦. In the Add-Ins group, click on the Transform cold data into a cool picture button (circled in orange in the screenshot below):ДҐ. Important: for the infographic chart tool to work correctly, your data must be contained in two columns only.ДЈ. You can create your own infographics or people graphs using your data in Excel.Дў.В Use your own data or add the following data to the worksheet to use for the graph: Infographics are visual representations of data using charts, icons and images. 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. 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. Consider the options that appear and click to select the most appropriate one:ДҐ.

An example could be to type the word Print if you are looking for options relating to printing your document.Д¤. Click in the Tell me what you want to do box and start typing the name of the function you are looking for. Find the Tell Me box on the Ribbon (see circled in orange in screenshot below):ДЈ. 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.Дў. 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. This tutorial will introduce you to a couple of the highlights of Excel 2016.

#MICROSOFT OFFICE 2016 TUTORIAL FULL#

It is packed full with improvements to existing functions and a host of new useful and exciting features. WhatвЂ™s New in Excel 2016? Excel 2016 TestД®xcel 2016 is the latest version of MicrosoftвЂ™s well-known spreadsheet program.

#MICROSOFT OFFICE 2016 TUTORIAL FREE#

Test your Excel skills with the corresponding FREE Online Multiple Choice WhatвЂ™s New in Excel 2016? вЂ“ Excel 2016 Tutorial вЂ“ Excel Basics Free Microsoft Excel Training 2016 WhatвЂ™s New in Excel 2016? Excel 2016 Tutorial

Microsoft office 2016 tutorial