Microsoft Excel in the Workplace

Course description

A 10 week course covering techniques and methods for anyone who uses MS Excel in the workplace.

MS Excel is an extremely versatile tool and one that can be used effectively either for data

gathering, analysis or presentation. Many admin or reporting requirements can be met solely

though creative use of Excel and this course aims to show you techniques and tips to get the most

out of your version of Excel whatever the size of your organisation.

Starting with the basics, linking cells, formulas, worksheets and workbooks. Using formulas, text

formulas and basic statistics. Charting and charting across 2 data sets. Using excel as a database,

limitations and getting information as the data changes. Setting up Templates, restricting data entry

to certain forms. Using Lookups, Matching and Index functions. Pivot tables, charts and their uses.

Logical testing (If…then functions) for checking. Cost modelling with Excel. Building a simple

example budget solution for domestic use to see how the formula link, adding valuable data to the

budget and seeing it change real time with scroll bars and other dynamic controls. Creating a small

macro to automate repetitive tasks then saving the macro to the toolbar as a button.

Last but not least we will try to guide the student through some real life Excel solutions and help

them with any excel challenges they need to find solutions for.

Course Day & Time: Monday Evening 7.30 – 9.30pm

Cost: €110

Course Format: In class with tutor. Maximum of 12  students

Duration: 10 weeks

Enrol: Registration is available by going onto website www.malahidecsadulted.ie
and clicking on the ‘Enrol Here’ button.

Enrolment for this class will open on the 01st Dec 2022

Tutor: David McLaughlin

Note: Please bring your own laptop