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 basics like simple calculations, the Order of calculation, Absolute references, Named ranges, Outlining and if time allows) VLOOKUP. Introduction level.
You must be logged in to access these events
There are no upcoming events at this time.
"Office 365 For Dummies" is a comprehensive guide to the cloud-based productivity and collaboration suite from Microsoft. The book is written by Rosemarie Withee, Ken Withee, and Jennifer Reed and is designed to help users get up and running with Office 365 quickly and easily.
"Excel Formulas & Functions For Dummies" is a comprehensive guide designed to help readers unlock the full potential of Microsoft Excel's formula and function capabilities. Authored by Ken Bluttman and Peter G. Aitken, this book caters to users of all levels, from beginners to experienced Excel enthusiasts, providing clear explanations, practical examples, and useful tips for mastering Excel formulas and functions
In this session we discover how a simple Pivot Table and Chart can be graphically filtered to show your best performers over time,...
This one-hour session continues the discussion of charts made in Part 1 and covers Plotting on a second axis, Adding Trendlines, Forecasting...
In this one-hour session we continue our exploration of Pivot Tables, and cover Expanding Pivot Table functionality, Adding a Calculated...
If your role involves combining sets of data that span several periods of time, it can be tricky if they are laid out and formatted...
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,...
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...
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...