Course Description

Microsoft EXCEL in the Workplace

Malahide Community School Adult Education



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

Start Date: 19/09/22

Cost: €110

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

Duration: 10 weeks

Enrolment: Will open on the 2nd of August You can enrol online then through our website www.malahidecsadulted.ie by clicking on the Enrol Here Easy Payments Plus button

Tutor: David McLaughlin

Note: Please bring your own laptop


College Name Malahide Community School Adult Education
Course Category Computers & IT (Information Technology), Microsoft Excel
Course Type Classroom Based
Course Location Malahide, Dublin, Ireland
Location Postcode Co. Dublin
Course Start Date 19th September 2022
Course End Date 28th November 2022
Course Fee €110
Course Duration 10 weeks
Course Times Monday evening 7.30 - 9.30 pm
For information about Malahide Community School Adult Education, please visit our college page on www.nightcourses.com by clicking here.

Course Provider

Make Enquiry

Please insert your contact details and any additional information you require and we will forward your request to Malahide Community School Adult Education.




Captcha code        I confirm I have read the Privacy Policy, Terms and Conditions & Cookie Information and agree to join the Nightcourses.com community.
 

Map

Malahide Community School Adult Education
Broomfield
Dublin
Dublin
Visit Website

Comments, Questions & Reviews

Submit A Comment, Question or Review About
Microsoft EXCEL in the Workplace
at Malahide Community School Adult Education

Your email address will not be published.

Click to Rate

We'd love to send you the latest news and articles about evening classes, further learning and adult education by email. We'll always treat your personal details with the utmost care and will never sell them to other companies for marketing purposes.

Comments and Reviews Policy