Course description
EXCEL FOR BUSINESS – Virtual & Face to Face Class
Tutor: David McLaughlin Cost: €90
This course in on Monday evenings 7:45 – 9:15pm, commencing 05th Oct 2020 and runs for 8 weeks.
Access to a laptop is necessary as work files will be shared.
You will be sent a link to join this class via Google Meets prior to class.
Course Format: Blended learning i.e. you can attend the class in Malahide Community School or join via web cam from home. Please ensure you select the correct course code for this.
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 guide the student through some real life Excel solutions and help them with any excel challenges they need to find solutions for.
Registration is available by going onto our school website www.malahidecs.ie and clicking on the ‘Enrol Here’ button on the right hand-side of the screen
Distance Learning and Online Courses are offered in a number of different formats, these include correspondence courses (by post), online via computer or a combination of online and classroom instruction (blended learning).. 
Further Education and PLCs (Post Leaving Cert Courses) have become a popular alternative to the CAO system here in Ireland. PLC Courses are validated by QQI (Quality & Qualifications Ireland) at levels 5 & 6 of the NFQ.. 
Continuous Professional Development (CPD) helps to keep skills and knowledge up to date and ensures the standard of registrations & qualifications are maintained.. 
Evening courses and part time learning options are a great way to enhance a CV, to socialise and make friends, as well as learn something completely new. There are an abundance of night courses and evening classes available.. 
Ireland has moved from a short-term emergency response approach to a medium-term approach to managing risk and repairing the damage that COVID-19 has inflicted on society. The priority guiding the plan will be to keep schools open, while keeping people safe and protecting communities and the economy.