1
Type
Speaker
CPD Hours Level
Seminar 3 IntroductionInformation
Accreditation Information
SRA Competency D

Introduction

This course 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 exercises and practical tips then this course is for you.

What You Will Learn

This course 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.

Book now

Added to basket

Seminar | 11.01.2022

London | 2:00pm - 5:15pm


Excel for Professionals - Practical Tips & Spreadsheet Success

Checkout
Continue Shopping
Jan
11
2022
London
2:00pm - 5:15pm
Add
Prices (ex VAT)
Smart
Plan Information
£121.5
Season
Ticket Information
£135
Standard
£270
Group bookings
Discounts are available for multiple places and if you have 5 or more people interested in this course and would like to discuss holding it in your area or on an in-house basis then please email us at information@mblseminars.com
Can’t Make the Date?

Please let us know if you wish to be notified when new dates are added for this programme

Related Events