Insert Tab screen shot
INSERT Tab on Excel 2016/Office 365

The Insert Tab is the one which has changed the most.

Here is a summary of the new features which can now be achieved using this Tab.

Table

Entering data and then creating a Table means you get sorting and filtering and design options as part of the deal. Simply type in your data and then click Table. See below for an example.

Table screen shot insert tab
Headers and Footers

The process of inserting a header or and a footer hasn’t changed, but where you find it has. This option is now located under the ‘Text’ button on the far right hand side of the Insert Tab.

Header and Footer screen shot insert tab
Recommended Pivot Tables

With this option you get some sample ready made Pivot Table layouts which may be suitable for your data. See below for an example.

Pivot Table screen shot
Illustrations

There are now several options to introduce colourful graphic/pictures into your worksheets. See below for an example.

Illustrations screen shot insert tab
Add Ins

Store and Add ins lets you introduce a useful app to use in Excel. An example is the percentage calculator. Simply search the Store and Insert and Use. See below for the ‘What % of’ example.

What % Of Add In insert tab
Bing Maps (Add Ins)

This allows you to see locations on a map with corresponding data. See below for an example.

Bing Maps screen shot insert tab
Maps (Charts Section)

This allows you to see a map chart of your data. See below for an example.

Maps Charts screen shot insert tab
3D Maps

This facility allows you to create a geographical tour in 3D on your data. See below for a simple example.

Here’s the Excel data:

3D map data screen shot insert tab

Here’s the 3D map:

3D Map screen shot insert tabIt can be get quite involved including creating a video of your tour.

Sparkline

This feature allows you to create a sparkline (chart in a cell) of the data. See below for an example.

Sparklines screen shot insert tab

Slicers and Timelines in Pivot Tables

These features are an alternative to filtering. See below for an example.

Slicers screen shot insert tab

We hope you’ve found this article useful, you might also like to read more about our microsoft excel training.

Cookie Control

Cookie control

We have placed cookies on your device to help make this website better.

I'm fine with this

We have placed cookies on your device to help make this website better.

You can use this tool to change your cookie settings. Otherwise, we’ll assume you’re OK to continue.

Some of the cookies we use are essential for the site to work.

We also use some non-essential cookies to collect information for making reports and to help us improve the site. The cookies collect information in an anonymous form.

To control third party cookies, you can also adjust your browser settings.

I'm fine with this
(One cookie will be set to store your preference)
(Ticking this sets a cookie to hide this popup if you then hit close. This will not store any personal information)
Information and Settings Cookie policy