Services

Legal Documents

Use Microsoft Word to create powerful legal documents on your own computer. Use the header to draw dividing lines. Use column breaks to divide pages. Section breaks to create legal docs.

Accountancy Reports and Processes

Using the power of Excel, Access and database packages create compelling accountancy reports, trial balances, P+Ls. Use macros to build reports, set up at the touch of a button.

Online Teaching & Training

Browse my online teaching and training web page. All classes are delivered online. All you need is a computer with an internet connection!



Web Design

Do you need to develop a website or need some help with one you have already?

Contact Management

Build up contact databases in MS Access and SQL Server. Link these to MS Office at front end to generate reports and contact mail shots and emails.

Report Automation

Customise and automate reports using macros and formula driven spreadsheets. Take the pain out of updating and maintaining such reports cutting down on man hours and costs whilst improving accuracy.



Among other things I act as a data, business analysis, teaching and training resource.

I am good at delivering solutions by resolving business issues in a timely and cost effective manner. I also offer teaching & training services.



Read more





About

About


I specialise in helping with computer problems.


Good data and good training is essential for any business these days. Getting that information in a reliable fashion is very important.


Many businesses have a lot of data containing insights on customer preferences that can be mined and utilised.


MS office offers the reporting and analysis tools.


Want to know more.. Contact Us

Me

Twenty years experience in analysis, reporting, consulting, training and teaching.
Team Menber

Hugh McGovern

BA Econ, MA Econ, Hdip Computer Science

With over twenty years experience working in a wide variety of multinationals and local companies as an analyst, consultant and trainer. I have a strong appreciation of business needs and requirements. Working as a contractor and an employee I noticed the same issues arose again and again in the work place.


Click for LinkedIn Profile

Issues

My impression was often that software was under utilised and huge opportunities for time saving, improved accuracy and efficiency were often missed.

In many cases companies had purchased the necessary software but staff did not have the right training or knowledge to use it.

Some History

Background

A graduate with honours from Trinity College, Dublin with a post-graduate in UCD I specialised early on in economics and economic analysis.

After a sojourn in the States where I worked in consulting I returned to Ireland and undertook a Computer Studies course to update and consolidate my computer experience.

Past Roles

Prior Work

As a contractor I worked in a wide variety of companies both at home and abroad.

Some of those include Citibank, Elavon, Irish Rail, Northern Trust, Ulster Bank, Microsoft, Wells, Dell, Vodafone, Hammacher and Cornerstone Research.

Issues often arose through lack of training and poor use of existing software resources.

Online Courses

Click below to see the range of courses we offer online. Remember content and duration can be adjusted to suit.

Read More

Principal

Principal

Welcome to our online training and teaching web page. We provide online training and teaching direct to you in your home.

Read More

Prices

Please call for prices. All courses and help can be tailored.

Read More

Tutorials

Click the click to watch some tutorials from our online classes. Note all our classes can be customised to suit you.

Read More →

Sample Tutorials (Click to play video)

Excel Speedometer

Create a speedometer in Excel to jazz up your dashboards or reports using a simple method - using a doughnut and pie chart.

Visual Basic

Use Visual Basic to create a simple macro which allows the user to transfer data from one workbook to another in seconds.

Java Introduction

See how to write a simple program in Java to convert Fahrenheit to Celsius using the NetBeans IDE.

About

Offer strictly online courses at very affordable prices. Study Excel & Access (all levels) & VBA, Java and C++ from the comfort of your own home for a modest fee. Courses are tailored to your own timetable and budget. So you only learn when you want too.

Everything is done online. I supply the course materials and the content and all you need is a computer with internet access to participate.

Using Google online meeting we create a virtual classroom between us. We can share screens, documents, review and discuss content as you would in a normal classroom.

All you need is an internet connection and a computer to join.

Some Courses

MS App Courses (email to request detailed outline)

Excel Introduction

Learn the basics of excel. No prior knowledge is assumed. Benefit from the experience an excel expert with over 20 years experience.

Excel Intermediate

This class is designed for attendees who have some knowledge of Excel, use the package regularly and would like to learn more about formulas, shortcuts and linking and much more.

Excel Advanced

This class covers topics such as Vlookup, Lookup, If function and also Sumif, Sumifs and more.

Excel Dashboard

Take your reports to the next level with a dashboard class using the advanced formulas and features such as tables to build exciting, customised and responsive reports.

Excel Pivot Tables

Explore the world of pivot tables and PowerPivot in this session specially designed to cover all advanced features of Excel Pivot Tables.

Access Introduction

Learn the basics of Access databases setting up your own tables, forms, queries and reports in this step by step tutorial.

Access Intermediate

Learn advanced file task, working with tables, importing data from other sources, using calculations in forms and reports and much more.

Access Advanced

Learn to manage your data, enforce referential integrity, create relationships between tables, use forms subforms and reports, explore macros and visual basic and more.

Microsoft Apps Training

Portfolio 1

World Class Training At Affordable Prices

Portfolio 1

Excel

Portfolio 1

Access

Portfolio 1

Word

Portfolio 1

Customised Courses

PRICES IN EUROS

Portfolio 1

Excel Introduction

Portfolio 1

Excel Intermediate

Portfolio 1

Excel Advanced

Portfolio 1

Excel Pivot Tables

Portfolio 1

Excel Dashboards

Portfolio 1

Excel Macros

Portfolio 1

Excel VBA

Computer Courses (email for outline)

Excel Visual Basic

Recording macros and data transfer. VBA theory - theory around object oriented programming languages. Selections - If & Case. Loops - Do, While etc. Arrays & Collections. Classes, Form controls & User Forms.

Java Introduction

Learn about variables, good practice, selections, loops, methods, classes and input/output. Using the NetBeans IDE we review numerous coding examples. All code is shared and reuseable.

Java Advanced

Learn about object oriented programming, inheritance, polymorphism, abstract classes and interfaces. Take a detailed look at the class structure, data structures and java extensions. Also includes databases. Using windows forms.

C# Introduction

Using Visual Studio we explore data representation, operators, control statements, loops, arrays and strings, program modules, testing and bugging and more.

C# Advanced

Introduction to object oriented principals. Databases. Windows forms. XML. Class structure, principles, testing and bugging. Using SQL Server with Visual Studio.

Web Design

Client and server side models, local development environment, DOM manipulation, JavaScript introduction, resposive design, Bootstrap, databases, functions and much more.

Python Introduction

Using JetBrains IDE we explore data representation, operators, control statements, loops, arrays and strings, program modules, testing and bugging, classes, functions and more.

Python Advanced

Learn about object oriented programming, inheritance, polymorphism, abstract classes and interfaces. Take a detailed look at the class structure, data structures and java extensions. Also includes databases. Using tkinter forms.

Send us a message

Let us know your availability, preferences and specifically what courses you are interested in and we will get back to you as soon as possible.


Our Address

Address

Roebuck Road, Clonskeagh, Dublin 14, IRELAND

Email

hugh@mcgovernconsultancy.com

Home | Services | About | Tutorials | About | Applications | Languages | MS Apps

Copyright © 2024 mcgovernconsultancy.com