Multiple headings in table

Multiple Headings in a Pivot Table This quick video explains how to have Multiple Headings in a Pivot Table. We can add additional fields to create additional columns and rows to our Pivot Table. This creates different levels of grouping within our pivot table....

Using Action settings

Using Action Settings This quick video will show you how to use the Action Settings in Excel. Within a Pivot Table we have an options Tab and within this there is a group called Actions – which gives us additional options to manage our Pivot Table – including removing...

Editing Pivot Table options

Editing Pivot Table Options This quick video will show you your different Options to Edit in Pivot Tables . The Pivot Table options allows us to name our Pivot Table – useful if you have a number of Pivot Tables. We can also modify change the layout, totals, display,...

Importing CSV files

Importing CSV Files This quick video explains how to Import Text or CSV Files. CSV Files are one of the most common TXT file types you will come across. We are regularly required to work CSV files in Excel and there are a number of options that are presented when...

Manipulating imported .CSV data files in Excel

Manipulating Imported .CSV Data Files in Excel Manipulating Imported CSV Data Files in Excel. Let’s look at a scenario where data is given to you in .CSV format or already has been imported into Excel for you. It may be the case that you have a list of ID numbers,...