courses in Ireland

Excel For Business

Course Type: Part Time and Evening
Institute Name: Malahide Community School - Adult Learning
Fee: 110
Duration: 10 Weeks
Time: Monday 7:30-9:30
Course Locations: County Dublin

Course Details

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.

Our class tutor is David McLaughlin with a cost of andeuro;120

Enquiry Form

* Required Fields

Click here to view other Computers and IT Training courses

Course Quick-Search

Upcoming Booking Deadlines

13-Dec-2016 Lean Six Sigma (Green Belt) North Dublin City Dorset College Dublin
15-Dec-2016 ITEC Level 3 Diploma Sports Massage FEB 2017! Limerick, Limerick City Institute of Massage and Sports Therapy
06-Jan-2017 Cibtac Electrolysis South Dublin City Bronwyn Conroy Beauty School
07-Jan-2017 Personal Training Course Cork City, County Dublin, Galway City Academy One
28-Jan-2017 Advanced Diploma in Pilates Matwork North Dublin City, Dublin City Centre National Training Centre
30-Jan-2017 ITEC Diploma in Personal Training and Fitness Class Instructor (Two Days Per Week, Gorey) Carlow, Wicklow, Wexford Sprint Health and Fitness College
01-Feb-2017 Beauty Therapy Qualification County Dublin CIBHT College
05-Feb-2017 Fashion Eyeliner Course County Galway Swiss Color Ireland
24-Feb-2017 Professional Master of Education in Post Primary Education Carlow, Cavan, Clare, County Cork, Cork City,... Hibernia College
01-Sep-2017 Introduction to Hairdressing level 5 Mayo St. Louis Community School
View More Upcoming Courses
fitness courses Ireland
-
Management Training Courses 06/12/16
management training coursesToday‚Äôs corporate world requires a manager to do more than might have been necessary in the past. Employers look for a reflective and inspirational motivator; a leader who will inspire others to achieve shared company goals. In a rapidly changing … Continue reading