Training Dublin | Training Ireland

MS Excel Intro

Microsoft Excel is an essential tool in today’s business environment. Just about every business large or small makes use of this market leading spreadsheet package which can generate spreadsheets from any number of data sources. Using calculations and formulas, users can manage data easily including budgets, financial data, statistical data, reports, charts, graphs, and small lists. On this course you will be introduced to many of the topics required for today’s fast paced commercial environment.

Objectives

The Excel Introduction course covers a series Excel features and the steps required to use these features. The one day course is a combination of theory and hands on practical experience coupled with learning exercises to test, reinforce and confirm what has just been demonstrated. Although we have a course outline and core material at McGovernConsulting we are more than happy to cover topics of direct interest to course delegates and we respond quickly and directly to their requests for information and demonstration. On completion of this course, participants will be able to do the following:

Click to Download Outline

MS Excel Intermediate

Microsoft Excel is an essential tool in today’s business environment. Just about every business large or small makes use of this market leading spreadsheet package which can generate spreadsheets from any number of data sources. Using calculations and formulas, formatting and built in presentation tools users can manage data easily. On the intermediate course delegates gain a deeper understanding of formulas and functions – coupled with the unique presentation features available in more recent versions of Excel including 2010 and 2013.

Objectives

The Excel Intermediate course is divided into five main modules. The table object and its advantages is covered in detail. The one day course is a combination of theory and hands on practical experience coupled with learning exercises to test, reinforce and confirm what has just been demonstrated. Although we have a course outline and core material at McGovernConsulting we are more than happy to cover topics of direct interest to course delegates and we respond quickly and directly to their requests for information and demonstration. On completion of this course, participants will be able to do the following:

Click to Download Outline

MS Excel Advanced

The Excel Advanced course looks at some of the more advanced features of MS Excel. There is a section on complex formulas which can be customised depending on the requirements of the delegates on the day. There is a major focus on pivot tables and also Power Pivot which is an add on in the MS Excel 2010 and 2013 versions which allows for combining files into one linked pivot. Also explored are the new features of 2013 including the data model and more graphical tools such as slicers.

Objectives

On completion of this course, participants will be able to do the following: Please click on the button below to show the course content.

Click to Download Outline

MS Excel Pivot Tables

This half day course takes an in-depth and intensive look at the world of Excel pivot tables. The course covers building complex pivot tables, using some of the built in calculation options in the reports, formatting, adding calculated fields and groups to the pivot table. We look at using pivot charts, slicers, timelines, linking slicers to different pivot reports, creating the dashboard effect, modifying slicers, their properties, features and appearance. In the 2013 version we look at using the data model to link different tables of data in the same spreadsheet into the same pivot. We also cover the COUNT DISTINCT feature. Also we look at the Power Pivot add in in 2010 and 2013 versions and we explore linking different files together.

Objectives

On completion of this course, participants will be able to do the following: Please click on the button below to expand the course content.

Click to Download Outline

MS Excel Dashboards

The Excel Dashboards 1 day course is an introduction to building sophisticated interactive dashboards which allow users of the reports a high level of interactivity with the data – allowing them the facility of choosing different types of reports and combinations of reports. The course looks at a number of methods including a formula driven dashboard which makes use of drop downs to recalculate and regenerate charts. Also covered is a slicer method of dashboard generation and using charting tools to create KPI dials.

Objectives

On completion of this course, participants will be able to do the following: Please click on the button below to show and download the course outline.

Click to Download Outline

MS Excel Macros

The purpose of this 1 day course is to introduce participants to excel macros. The course identifies a covers a few key areas where macros can be extremely beneficial in business reporting and processing. No macro course can be complete without an introduction to visual basic programming also and delegates will discover how simple macros can be huge time savers in the routine aspects of the daily processes.

Objectives

On completion of this course, participants will be able to do the following: Please click on the button below to expand the course content.

Click to Download Outline

MS Access Intro

The Microsoft Access introductory 1 day course is designed to give delegates a thorough grounding in the fundamentals of using this powerful relational database application. Topics include a review of menu options, database security, planning and creating a database, designing tables and choosing appropriate data types. Also covered is an introduction to creating and using forms, queries and reports.

Objectives

On completion of this course, participants will be able to do the following: Please click on the button below to expand the course content.

Click to Download Outline

MS Access Inter

The Intermediate Access course covers features of this relational database package including setting relationships between tables. Using the correct data types, indexing, adding captions to fields, validation and input masks, building advanced queries using Access command functions including IIF, aggregate queries, make table queries and also takes a look at form and report building.

Objectives

On completion of this course, participants will be able to do the following: Please click on the button below to show and download the course content.

Click to Download Outline

Welcome To My Training Page

My name is Hugh McGovern. I am a free-lance trainer.

I have worked with large agencies and also as an employee using MS office products to their advanced potential.

I can come to your workplace and train your staff on MS Office - all versions. I have a wealth of experience and knowledge.

Because my overheads are low and I don’t have a staff working for me I can offer rates approximately half of that which the larger agencies will charge. (Select Training Rates to see my rates.)

Contact Details

I would love to discuss your training needs and how I might fill them better over the phone so please leave me a message or send me a quick email

Contact	Details
Email	hugh@mcgovernconsultancy.com
Phone	086-172-0394

I would be happy to call you back and discuss how I might be of help. Also you can use the drop down above to view different course options. This is not a rigid guide and all training can be customised as required. Feel free to browse my site by clicking here to go to my homepage.

Alternatively you get in touch via our Contact Form. Don't forget you can download details by clicking on the pdf button.

Regards,

Hugh McGovern.

Excel VBA

This two day course covers all the essential elements of Visual Basic and how it can help to improve efficiencies in the work place. Topics include recording macros, using the immediate window, using the Range Object, creating strings and other variables in VB. How to automate some of the essential processes in using MS Excel.

Objectives

On completion of this course, participants will be able to do the following: Please click on the button below to show and download the course content.

Click to Download Outline

Duration	Hours	In Class €	Online €
½ Day	9.30am - 1.00pm	€300	€200
Full Day	9.30am - 4.00pm	€400	€400

Please note:
Outside Dublin mileage and other expenses may apply.
Class sizes of up to 12 people.

Duration	Hours	In class £	Online £
½ Day	9.30am - 1.00pm	£250	£200
Full Day	9.30am - 4.00pm	£350	£400

Please note:
Outside Dublin mileage and other expenses may apply.
Class sizes of up to 12 people.

Consulting	Includes	Cost
Initial Consultation	Free Report	No Charge
Full Day Rate		€250
5 days or more		negotiable

Note: Free consultation only available in Dublin area.

Web Design	Includes	Cost
Assessment	Meeting	No Charge
Full Rate	Approx	€300
Rates	are	negotiable

Note: Free assessment only available in Dublin area.

McGovernConsultancy - Course Outlines

Microsoft Excel Introduction

Microsoft Excel Intermediate

Microsoft Excel Advanced

Microsoft Excel Pivot Tables

Microsoft Excel Dashboards

Microsoft Excel Macros

Microsoft Access Introduction

Microsoft Access Intermediate

Training Rates

Sterling Prices

Free Consultation & Report

Web Design & Development

Introduction & Welcome

Excel VBA

Back to Training

Back to Consulting

MS Excel Intro

Objectives

Click to Download Outline

MS Excel Intermediate

Objectives

Click to Download Outline

MS Excel Advanced

Objectives

Click to Download Outline

MS Excel Pivot Tables

Objectives

Click to Download Outline

MS Excel Dashboards

Objectives

Click to Download Outline

MS Excel Macros

Objectives

Click to Download Outline

MS Access Intro

Objectives

Click to Download Outline

MS Access Inter

Objectives

Click to Download Outline

Welcome To My Training Page

Contact Details

Excel VBA

Objectives

Click to Download Outline