↑ Return to Microsoft Training

Excel Training

excel_2013_150I have used spreadsheets for over 25 years. I train people at all levels of Microsoft Excel, from Beginner to Advanced and I develop Excel spreadsheets for all types of organisations. I have also setup Microsoft Excel courses for Graduate Training in the Financial and Accountancy sectors. With my own background in accountancy I have a unique insight  into what clients want from Microsoft Excel.

Among some of the many topics that I cover are the following:

  • Designing Workbooks
  • Entering and Editing Data
  • Formatting Worksheets
  • Functions for data, logical, lookup, date/time and financial analysis.
  • Vital importance of using Range Names
  • Conditional Formula, IF statements and nested functions
  • Charting Data and Customising Charts to the nth degree
  • Setting Up Chart Templates
  • Using Excel’s new Chart Combos
  • Data Analysis
  • Using Solver and Scenarios
  • Adding Subtotals, Filters and Customer Filters
  • Data Consolidation
  • Validating Data
  • Database Features
  • Linking Data to External Sources
  • Printing and Automating Printing
  • Taming the Ribbon in Excel 2007 / Excel 2010 / Excel 2013 / Excel 2016
  • Automating Actions with Macros
  • VBA Programming
  • Working with Procedures and Functions
  • Understanding Objects
  • Setting up Form Controls
  • Using Expressions, Variables, and Intrinsic Functions
  • Controlling Program Execution
  • Working with Forms and Controls
  • Working with Barcodes in Excel
  • Data Tables and Table Slices
  • Data Mining
  • Working with the PivotTable, Reports and PivotCharts Object and Pivot Slices
  • Excel PowerPivot
  • Integrating Microsoft Excel and Microsoft Access Database
  • Debugging Code
  • Handling Errors
  • Using Excel on iPad and Tablets
  • 1,000s of real life worked examples

All versions of Microsoft Excel covered including Microsoft Excel 97, Microsoft Excel 2000, Microsoft Excel 2003, Microsoft Excel 2007, Microsoft Excel 2010, Microsoft Excel 365, Microsoft Excel 2013 and Microsoft Excel 2013.

All versions of Microsoft Office covered including Microsoft Office 97, Microsoft Office 2000, Microsoft Office 2003, Microsoft Office 2007, Microsoft Office 2010, Microsoft Office 365, Microsoft Office 2013 and Microsoft Office 2016.

 

Excel – Kaplan-Meier Plot

Excel – Kaplan-Meier Plot You can use Excel to do Kaplan-Meier Plot. The Kaplan–Meier estimator is a non-parametric statistic used to estimate the survival function from lifetime data. In medical research, it is often used to measure the fraction of patients living for a certain amount of time after treatment.

View page »

Excel – Statistics

In this course I will introduce you to the use Excel Statistical Functions and free Excel Statistical Add-ins. Excel has a huge range of statistical functions and add-ins available. We will also cover the major statistical formulas from first principles including: Mean Standard Deviation Normal Distributions Central Limit Theorem t-Distribution Regression Analysis Correlation ANOVA Testing …

View page »

Excel Dashboards Training

Excel Dashboards Training Excel Dashboards are reports that allow senior management or directors to get high-level overview of the business or organisation.Excel Dashboards are reports that allow senior management to get high-level overview of the business or organisation. I produce Excel Dashboards for senior management and Directors in Dublin, Wicklow and Ireland. Excel is an …

View page »