Excel: tricks and tips for productivity

Do you have some familiarity with Excel? Would you like to learn methods that will make your use of the software easier and more efficient? The focus of the day will be to look at different features of Excel as well as adjusting settings and other shortcuts to improve your experience and productivity.

What is the course about?

This course covers various ways of manipulating Microsoft Excel so that it is easier to work with, and will also cover various aspects of the program to give you knowledge of the different ways you can view, amend and present your data.

What will we cover?

Features of the program such as basic formatting, subtotalling and conditional formatting.
Basic formulas and how to use them efficiently
Tips on how to quickly sort, fill and view data.
How to protect your spreadsheets
Inserting pivot tables and charts.

What will I achieve?By the end of this course you should be able to...

Use Excel more efficiently in your work
Distinguish more about Excel's features
Improve your decision making to know which feature to use and when.

What level is the course and do I need any particular skills?

This course is aimed at people who have some familiarity with Excel, perhaps but not necessarily using it regularly, but who would like to gain more knowledge. You should be relatively comfortable working with the basics of spreadsheet software such as entering data.

How will I be taught, and will there be any work outside the class?

Each learner will work on a P.C. in the classroom, and there will be demonstrations from the tutor and practical tasks to complete which will help you to understand the material being presented.
There will be no work outside of the class.

Please note: we offer a wide variety of financial support to make courses affordable. For more information visit our online
Help Center.
You can also visit the Information, Advice and Guidance drop-in service, open from 12 – 6.45, Monday to Friday.