Copy and paste, one of the most wonderful things in Windows since before we even had Windows. But it gets even more useful in Excel. We are able to copy information of one data type, and paste it as another. We can repeat, we can fill and we can even copy formulas that will automatically update depending on where you paste them. Excel 2016's copy and paste feature is very well designed and will save you a lot of time.

This video takes you through the basics on how it is different from the copy and paste in other products, and how to best use it in Excel to save as much time as possible.

Transpose is a great feature in Excel that allows you to take information from a vertical to a horizontal position. If you have an Excel sheet with a table where your column headings are important, but you need the table to be rotated so columns become rows you can use the transpose feature very easily. 

As your Excel Spreadsheet starts to grow, you will find several columns that are not necessary for people to see, but you need the information there so formulas throughout your Excel Workbook can refer to them. This is where hiding columns becomes very useful. You can clean up your Excel sheet without losing any of the data.

When you copy and paste cells that have formulas in them, Excel will automatically adjust the cells reference in those formulas. As an example, if you have a formula in C5 that refers to C1, then you copy C5 and paste it to C6, Excel will automatically update the reference from C1 to C2. 

But sometimes you don't want that, sometimes you want Excel to leave the referenced formula alone completely. This is where learning Absolute Reference comes in handy.

Up until now, we have been using the Copy and Paste feature in Excel by only moving one section at a time. We can open up the clipboard, and copy separate sets of data in to it, and then pick and choose what we want to place down. 

Named Ranges allows you to select an area of data in your Excel Spreadsheet and give it a name. Instead of referring to a range as A1::C5 (every cell from those two points as a square) we can call it anything we want. We can even reference our named ranges in formulas. This is especially useful if you think that at a later time you will need to increase or decrease the area, and don't want to have to go and edit every single formula that refers to that range.

Excel is supposed to make your life easier, so everything we do is trying to get you to work less!

This lecture covers how to manage your Excel 2016 Workbook. It is best to learn these practices before your Excel workbook becomes too large to manage properly. We go through some of the basic functions like adding, moving, copying and deleting worksheets.

This lecture covers how to manage your Excel 2016 Workbook. It is best to learn these practices before your Excel workbook becomes too large to manage properly. This lecture covers how to set colours to your Excel worksheet tabs. The colours you choose is completely up to you. It is a good idea to get a good system before your sheet becomes unwieldy.

This is a rather sneaky way to use the Autocorrect feature in Excel to speed up your work and become more efficient. 

You can add notes and comments to cells in your Excel 2016 spreadsheet. This is especially useful if you are sharing a document with someone and you want to explain something with in it and not use up valuable work space to do so.

This lecture is not introducing any new features, but rather taking some of what we have learnt in order to clean up a messy Excel Spreadsheet.

One of the more fun features in Excel 2016! 

You can take a list of clients with addresses, and plot that information on a world map, all inside Excel! You will start finding excuses to use it, so here are some for you to test out.

1. By plotting customer addresses on a map, and adding in the value of purchases, we can see how profitable our marketing campaign has been by areas. Using heat maps, bar charts or anything else to graphically represent the most profitable areas.
2. It's cool

Either of those reasons should be sufficient enough excuse to use this Excel feature.

Excel has hundreds of functions that you can use in your formulas. One of the most popular and useful is the SumIf function. This video covers how it works, and how you can use it in your own Excel 2016 Spreadsheets.

Drop down cells in Excel allows you to create a list of options, and when someone clicks on the cell that you have set up, they will see the list and be able to select one. This is especially useful if that cell is being referred to by another formula somewhere else, and you need to make sure that people don't type in the incorrect information which could cause issues elsewhere in your Excel Workbook.

This lecture covers Drop Down lists again, but this time using independent information that is not reliant on data elsewhere in your Excel Workbook. Each option has its merits and flaws, so understanding both is important so you can decide which application to use to keep your Excel sheets as efficient as possible.

VLookup, explained in all its glory. Possibly the most used feature Excel has to offer, and for a very good reason. This lecture covers how it works, how to use it, and how to remember how to use it because everyone forgets the first few times.

We take Excel 2016's VlookUp to the next level, but referencing cells in other sheets to an existing one. So that we can create a clean Excel Sheet that pulls relevant information from various other sheets and then applies the VLookUp function to filter and find what you want.

the Left, Right and Mid functions allows us to format text cells in to a standard format. This is not only to make the spreadsheet more visually appealing, but it also allows us to start pulling pieces of information out of text to use in other areas of our Excel Workbook.

Find and Len functions allow us more control over pulling information from text in our Excel spreadsheets. We also cover nested formula for the first time in this video.

Nested formula, explained as simply as possible, is when we use a formula inside another formula. Watch the video for an example.

Creating tables inside an Excel Spreadsheet might seem a little counter-intuitive, but once you have seen the additional features it offers and how to use it, you will see that in many cases it can make your life a lot easier.

Slicers offer you a visual way of selecting filters. Not only do they look good, they also offer a lot of functionality. Your Excel sheet can have slicers offering several different filters, to reduce massive lists down to just a handful of options. This lecture covers how they work so that you can prepare for managing large amounts of information, or just make your regular Excel sheets look more impressive.

Pivot tables are one of Excel's most powerful features. A pivot table allows you to extract and sort the important information from a large, detailed data set.

This lecture covers how to setup a pivot table in Excel 2016, from selecting the data range to using it.

Pivot tables are one of Excel's most powerful features. A pivot table allows you to extract and sort the important information from a large, detailed data set.

This lecture covers how we can quickly setup a chart that pulls information from the created pivot table. This allows the chart to dynamically change as you change the data pulled and sorted in the Pivot Table.

Pivot tables are one of Excel's most powerful features. A pivot table allows you to extract and sort the important information from a large, detailed data set.

This lecture covers how we can use slicers to assist in quickly editing and selecting what information we want or need in our pivot tables.

Pivot tables are one of Excel's most powerful features. A pivot table allows you to extract and sort the important information from a large, detailed data set.

Timelines allow us to quickly sort data by time. So if you had a list of all your sales and one of those columns included invoice date, you can set up a time line which will allow you to highlight particular dates or even select a date range. This enhances the already powerful functionality of Pivot Tables in Excel 2016.

Concatenate is a useful function that allows you to join two or more different text cells in Excel together. 

Very often when you import data from different sources, the text fields like names and addresses will be in different cases. By using the Lower, Proper and Upper functions in Excel 2016 we can change the case to make everything uniform and legible. 

Excel's Repeat function allows you to repeat text as many times as you like.

The substitute function in Excel allows you to replace a piece of text within text, with another piece of text. Don't worry, I explain this much better in the actual video.

Another useful tool to quickly edit out poor formatting. Excel's Trim Function allows you to remove double spaces from text strings.