Because of Excel’s tabular format a lot of people believe that they are already familiar with tables, but they were only introduced in Excel 2010 – prior to this a crude version existed as a List. Excel Tables use a new type of cell referencing, called Structured Referencing, and have a lot of amazing new features, one of the main benefits being that their dynamic behaviour allows the data to grow over time. In this one-hour session we look at tables and structured referencing in detail. Introduction level, no experience necessary.
You must be logged in to access these events
This one-hour session is an essential for any Excel user that has never had formal training or is a bit rusty! In it we cover some...
This one-hour session explores fundamental Excel skills that every user should benefit from including Sorting on multiple fields, Changing...
One of the most used features of Excel is the ability to visualise data with charts, and this session focusses on the Types of chart,...
Learn how to get the most out of Microsoft Excel. In this course, you will learn how to automatically total rows and columns, use conditional...
This is a 5-part series though sessions don't need to be completed in succession. This one-hour session covers some more hints...
This one-hour session continues the discussion of charts made in Part 1 and covers Plotting on a second axis, Adding Trendlines, Forecasting...
This is a 5-part series though sessions don't need to be completed in succession. This one-hour session covers some more hints...
This is a 5-part series though sessions don't need to be completed in succession. This one-hour session covers some hints and tips...
