↑ 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
  • Working with the PivotTable, Reports and PivotCharts Object and Pivot Slices
  • Excel PowerPivot
  • 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 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 »