Hints and Tips: Excel Further Use

 Registration is closed for this event
Find out Excel's underutilised features and how to use them to save time and improve your productivity.

 

Microsoft Excel has lots of underutilised features that can help to save time and improve productivity. The primary objective of this 90-minute Further Use session is to show you how to use these features and to demonstrate their effectiveness, challenging you to do things differently.

Karen will guide you through the topics and suggest lots of time-saving tips along the way.

The course includes access to a month's free support on any of the topics learned.

 

What will be covered?

Working with Formulas and Functions

  • Save time and apply Formulas and Functions to your everyday tasks
  • Search for a value in one place and insert it in another using lookup functions
  • Avoid the "pitfalls" of relative cell references
  • Test certain conditions and return one of two entries
  • Work with named cells to work faster and smarter with your formulas

Managing large workbooks

  • Trace and audit formulas in a worksheet
  • Create a simple dashboard
  • Produce summary reports from different worksheets
  • Merge data from multiple users by linking workbooks

 

Course Details

Duration: 90 mins Credits: 0.2
Time: 10am - 11.30am Member Cost: £40+VAT
  Non-member Cost: £60+VAT
When
February 11th, 2021 from 10:00 AM to 11:30 AM
Location
Online
United Kingdom
Event Fee(s)
Course Fee: £60.00 £60.00
Event+
URL hints-and-tips-excel-further-use-11022021
Reference
Premium Event Expires
Publish On
Show Places Available FALSE
Show in main event list TRUE
Contact Name Sarah Gleadell
Places still available 12
Threshold level 1
Equipment
Event Location URL
Event Image
Featured Event?
SEOheading Excel training

Please check our latest courses available in our online listings.

View courses