Excel Financial Modelling Course

Excel Financial Modelling Course

Our Excel Financial Modelling courses cover a range of topics, which will enhance your knowledge of Excel Financial Modelling and the steps required to use these features correctly.

Our one day Excel Financial Modelling course will help learners develop a solid understanding of financial modelling using Excel. We will show learners how to build efficient and error-free financial models, using best practices from their industry. During this course will focus on formatting data professionally and inputting base data, how to get the maximum use out of excel applications and how to become comfortable when using existing and new financial models.

Support

Dedicated team of trainers and staff, committed to delivering support and advice to our customers.

Experience

We have over 12 years experience providing training for individuals, small, medium and large companies.

Training Team

Our trainers combine professional know-how with experience in their chosen training field.

Quality Assured

Safeguard your training investment. We offer courses accredited by national and international certification bodies.

TRUSTED BY THESE GREAT COMPANIES

Get the Excel Financial Modelling Course Brochure & 2020 Timetable Instantly

Get the Excel Financial Modelling Course Brochure & 2020 Timetable Instantly

Course Options The course is run in Dublin, Cork, Galway, Limerick and Waterford. Other venues also available.

Full Course Outline What's Inside the Brochure: Course Format; Trainer Profiles; Testimonials; Full 2020 & Fee.

What’s Included? A delicious lunch each day with morning and afternoon tea/coffee; Free parking, WIFI and course materials.

Team Development Needs?

Do you have team development needs? An inhouse training solution is typically less expensive per head than publicly scheduled courses and provides greater business relevance.

WHY CHOOSE THIS EXCEL FINANCIAL MODELLING COURSE?

A case-study led examination of the principles and practice of financial modelling. The course focuses on a project finance-style scenario.

Practical Approach

Role-play exercises, with feedback from fellow delegates and the trainer, will be a feature of the course and delegates will be encouraged to share real life experiences.

Convenient Locations in Ireland

We run the course in a number of different locations in Ireland. What's included: Hot lunch with tea/coffee, free parking, WIFI and course materials.

Small Intimate Class Size

Wedged in a room with 30 other people might work for some, but it's not for us and probably not for you either. You work and learn best in small groups.

96% Of people who attended our training courses would recommend to others

521 Number of companies & government agencies we worked with in 2018.

93% Of our customers say they're very or extremely satisfied with our trainers

What is covered in this course?

This course is aimed at both intermediate and experienced staff – it is expected that all participants will have a good grasp of Excel prior to attending this course.

1

Module 1

Workbook set up & use of shortcuts
Formatting data professionally, inputting base data & Style
Basics Setting update flexibility using EDATE, EOMONTH
Breakdown and grouping of accounting elements
Determine drivers of the model & Assumptions for projections

2

Module 2

Effective use of short-keys and functions
Applicable financial, logical functions & data transfer and links
Professional use of Excel –protection, range names, data validation
Maximum use of Excel applications
Flexible and user-friendly models & sensitivities

3

Module 3

Model diagnostics Using existing models
How to become comfortable with ‘new’ models
Auditing models
Professional showcase
Use of graphs
Using switches

Please Note: Each delegate will leave the course with an action plan for the workplace

Need Some Advice?

We have an excellent team who are more than happy to give you advice about the course. It doesn't matter what the question please ask, we'd be delighted to help.

DCM Learning _ Who We Are and What We’re About

DCM Learning is an award provider of training and consultancy solutions to global brands.

What We Do

Founded in Dublin, DCM Learning is fast becoming recognised as a leading training organisation. We work closely with industry to define the skills and qualifications required to thrive.

At our core, we believe people learn best by doing. We design fun, powerful experiences that have a profound and lasting impact on people and their careers, inspiring new ways of thinking, building critical capabilities and unleashing business success.

Our Customers

We work with small and large companies, individuals, Government Agencies, Universities and blue-chip companies such as Keelings, Google, Zendesk, Novartis, IBM and Symantec, so you can have confidence in our ability to deliver the results you want to achieve.

Our Certification Partners

In House Training In Your Office. Wherever You Are.

Have Team Development Needs?

We’ll work with you to create the course that your team and your business need. Get in touch today and we can give you a quote within an hour.

978 THE NUMBER OF COMPANIES WE DELIVERED INHOUSE TRAINING IN THE LAST 2 YEARS

87.3% OF COMPANIES WHO RETURNED FOR MORE TRAINING

37 27 FULL TIME TRAINING CONSULTANTS PLUS 10 SUPPORT STAFF

Trusted by

Related Courses

Advanced MS Excel

Information Technology

Advanced MS Excel Course Details

Intermediate MS Excel

Information Technology

Intermediate MS Excel Course Details

VBA Excel

Information Technology

VBA Excel Course Details

Industry ready courses learn more

Make sure you Safeguard Your Training Investment. DCM offer courses accredited by:

Course Categories

Management Project Mgt. & Lean Agile Project Mgt.Learning & Development Communications + View All 187 Courses

Course Categories

Information Technology Finance Written Communication Personal Effectiveness Customer Service + View All 187 Courses