Quickfire Training

A computer is a tool to do a job.
The more you understand how to use it,
the more effective and efficiently it can be.

07710 988974info@quickfiretraining.co.uk

Case Study 3 – Module Title: Managing Files and Hyperlinks

Simplifying File Management.


The Brief: “I take too much time juggling files. I’ve knocked my numerous spreadsheets down to a handful by combining them, but how do I make the remaining connections quicker? I’ve tried buttons but I don’t understand the script.”


QuickFire Session: It’s all about connections, not just buttons. Learn about connecting cells, worksheets and workbooks by formulae, connecting appearance to content with conditional formatting, connecting outcome to conditions with IF functions, connecting circumstances to results with lookup tables, quick connections to files, folders and websites using icons, hyperlinks and buttons, shorten processes with macros (recording, operating, editing, adding to quick action buttons or objects) – and practice them all … ALL THIS IN A 2-HOUR SESSION …



– – – “Most definitely. Probably saved me about an hour a day. I’m not afraid to experiment more with my documents either.” Elayne (Quality Manager, Leeds)

For more details, why
not give us a call on:

07710 988974