Excel for Professionals - Spreadsheet Success Live at Your Desk

Introduction

This live broadcast session will provide an introduction to three essential topics in Excel for all professionals from creating cell values to working with pivot tables.

If you are looking to brush up on your Excel skills with online exercises and practical tips then this session is for you - from the comfort of your own desk!

What You Will Learn

This live and interactive session will cover the following:

• Conditional formatting to give your data meaning. How to use conditional formatting to change the colour, or display an icon automatically dependent upon cell values. This tool is great for visualising KPI's, metrics, targets, deadlines, budgets and other data on your spreadsheets.
• Mastering VLOOKUP - VLOOKUP is one of the most well-known functions of Excel. It can help in many ways from consolidating data into one worksheet, comparing lists, testing values and ensuring data entry accuracy. Master this important function.
• Working with PivotTables - An introductory session to using PivotTables in Excel. This is one of Excel's most useful tools. It makes summarising data and creating reports simple. PivotTables are fast, versatile and powerful.

Recording of live sessions: Soon after the Learn Live session has taken place you will be able to go back and access the recording - should you wish to revisit the material discussed.