Excel for Business

Course description

EXCEL FOR BUSINESS

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.

Tutor: David McLaughlin                         Cost: €110

Registration for our courses 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, by postal registration using the form on the inside cover of our Programme or on our walk-in enrolment night on Monday 21st January 2019, 7:30pm – 9.00pm. Students can meet the course tutors at this session.  Complimentary tea/coffee will also be available at this enrolment/open evening.