Wolverhampton Enable Technology

Excel VBA  

Wolverhampton Wolverhampton Excel VBA Training Courses

Wolverhampton Excel VBA Training Courses

Based at e-Innovation Centre Enable Technology run scheduled Microsoft Excel and VBA training raining courses. We run regular courses on the 2007. 2010, 2013 and 365 versions of Excel.

Class sizes are small, training is tutor led and all delegates receive detailed Microsoft approved training materials.

In addition to scheduled Excel courses at e-Innovation Centre we can deliver on-site bespoke training. Please feel free to contact us if you would like to book a course, discuss our Excel training syllabuses or would like to arrange bespoke or on site training.



Excel 2007 Advanced - Wolverhampton Courses

  • 1 day course
  • £260 plus VAT
  • Course Outline
  • A one day course at e-Innovation Centre covering advanced Microsoft Excel 2007 topics. The course introduces candidates to advanced functions (IF statements, nested IF statements, COUNTIFS, SUMIFS, DSUM, DCOUNT)., lookup functions, how to import and export data and how to work with scenarios. Essentially by the end of the training day delegates will be able work with complex filtered aggregations derived from multiple worksheets.



Excel 2007 Basic - Wolverhampton Courses

  • 1 day course
  • £260 plus VAT
  • Course Outline
  • A one day course introducing Microsoft Excel 2007. Participants will learn how to work with formulas, aggregate figures, format worksheets and create charts.

    No prior Excel knowledge is assumed.



Excel 2007 Intermediate - Wolverhampton Courses

  • 1 day course
  • £260 plus VAT
  • Course Outline
  • A one day course covering Microsoft Excel 2007 intermediate topics. Delegates will learn how to filter and sort data, aggregate data on different worksheets and work with PivotTables and advanced chart formatting.

    The knowledge of basic Excel 2007 is required.



Excel 2010 Advanced - Wolverhampton Courses

  • 1 day course
  • £260 plus VAT
  • Course Outline
  • A one day intensive course covering advanced Microsoft Excel  2010 topics.  The course will cover a range of advanced Excel functions including Vlookup, IF statements, nested IF statements, date and array functions. Topics includes data validation, scenario management, database functions and basic Macros. The course also explores how to import and export data and link Excel to external data sources.



Excel 2010 Basic - Wolverhampton Courses

  • 1 day course
  • £260 plus VAT
  • Course Outline
  • A one day course introducing Microsoft Excel 2010. Participants will learn how to create and format worksheets, use functions and create formulas, create charts and print out large workbooks.

    No prior Excel knowledge is assumed.



Excel 2010 Intermediate - Wolverhampton Courses

  • 1 day course
  • £260 plus VAT
  • Course Outline
  • A one day intensive course covering Microsoft Excel 2010 intermediate topics.  Participants will learn a number of techniques for sorting, filtering and aggregating data. The course covers the use of PivotTables and Tables. The use of  three dimensional formulas. How to share and merge workbooks.  Password protecting worksheets.

    The course also covers advanced formatting and chart options.

    The knowledge of basic Excel is required.



Excel 2013 Advanced - Wolverhampton Courses

  • 1 day course
  • £260 plus VAT
  • Course Outline
  • A one-day course covering Microsoft Excel 2013 advanced topics.



Excel 2013 Basic - Wolverhampton Courses

  • 1 day course
  • £260 plus VAT
  • Course Outline
  • A one day basic level course covering Microsoft Excel 2013 topics.



Excel 2013 Intermediate - Wolverhampton Courses

  • 1 day course
  • £260 plus VAT
  • Course Outline
  • A one day course covering Microsoft Excel 2013 intermediate topics.



Excel MCAS 2007 - Wolverhampton Courses

  • 2 day course
  • £495 plus VAT
  • Course Outline
  • This course assumes no prior knowledge, introduces candidates to Excel 2007 and moves onto advanced topics within the two training days. The syllabus is mapped against the Microsoft Application Specialist qualification and gives a detailed overview of the Excel 2007 application.



Excel MOS 2010 - Wolverhampton Courses

  • 2 day course
  • £495 plus VAT
  • Course Outline
  • This course assumes no prior knowledge, introduces candidates to Excel 2010 and moves onto advanced topics within the two training days. The syllabus is mapped against the Microsoft Office Specialist (MOS) qualification and gives a detailed overview of the Excel 2010 application.



Excel MOS 2013 - Wolverhampton Courses

  • 2 day course
  • £495 plus VAT
  • Course Outline
  • This course assumes no prior knowledge, introduces candidates to Excel 2013 and moves onto advanced topics within the two training days. The syllabus is mapped against the Microsoft Office Specialist (MOS) exam.



Excel Programming Using VBA - Wolverhampton Courses

  • 2 day course
  • £625 plus VAT
  • Course Outline
  • A two day Excel VBA programming course which introduces advanced Excel users to the process of writing and editing Macros. No prior programming experience is assumed.




Enable Technology
e-Innovation Centre
University of Wolverhampton
Wolverhampton
TF2 9FT

Telephone:  01952 305730
email: enquiries@enableit.co.uk



e-Innovation Centre Location:





Wolverhampton Scheduled Courses:
Wolverhampton Microsoft Access; Wolverhampton Excel VBA;Wolverhampton MS Project; Wolverhampton Visio; Adobe Illustrator Wolverhampton ; Wolverhampton Photoshop; Wolverhampton Dreamweaver;InDesign; Wolverhampton Flash; Wolverhampton HTML CSS; Wolverhampton JavaScript; Wolverhampton SQL; Wolverhampton Microsoft Office;Adobe;

Wolverhampton Access Onsite Courses: Wolverhampton Microsoft MCAS Access 2007 Training Courses; Wolverhampton Access Programming Using VBA Training Courses; Wolverhampton Microsoft MOS Access 2013 Training Courses; Wolverhampton Microsoft MOS Access 2010 Training Courses; Wolverhampton Training Courses;

Wolverhampton Adobe Onsite Courses: Wolverhampton InDesign CS5 Training Courses; Wolverhampton InDesign CS6 Training Courses; Wolverhampton Photoshop CS6 Training Courses; Wolverhampton Dreamweaver CS6 Training Courses; Wolverhampton Illustrator CS5 Training Courses; Wolverhampton Dreamweaver CS5 Training Courses;

Wolverhampton Web Development Onsite Courses: Wolverhampton HTML 5 Training Courses; Wolverhampton Python Training Courses; Wolverhampton Google Script Programming Training Courses; Wolverhampton JQuery Training Courses; Wolverhampton ASP.NET using VB.NET Training Courses; Wolverhampton Flash ActionScript 3.0 Training Courses;

Wolverhampton Crystal Reports Onsite Courses: Wolverhampton Crystal Reports 2008 Training Courses; Wolverhampton Crystal Reports XI Training Courses; Wolverhampton Crystal Reports 2011 Training Courses; Wolverhampton Crystal Reports 2013 Training Courses; Wolverhampton Training Courses;

Wolverhampton Visio Onsite Courses: Wolverhampton Visio 2013 Training Courses; Wolverhampton Visio 2007 Training Courses; Wolverhampton Visio 2010 Training Courses; Wolverhampton Training Courses;

Wolverhampton Database Onsite Courses: Wolverhampton Microsoft SQL Server 2005 Integration Services SSIS Training Courses; Wolverhampton SQL Server Reporting Services SSRS 2012/2014 Training Courses; Wolverhampton SQL Server 2008 Reporting Services SSRS Training Courses; Wolverhampton SQL Server 2012 Data Warehouse Implementation Training Courses; Wolverhampton Microsoft SQL Server 2012-2014 Analysis Services SSAS Training Courses; Wolverhampton Oracle PL/SQL Training Courses;

Wolverhampton Excel Onsite Courses: Wolverhampton Excel 2013 Intermediate Training Courses; Wolverhampton Excel 2010 Basic Training Courses; Wolverhampton Excel 2010 Intermediate Training Courses; Wolverhampton Excel 2013 Basic Training Courses; Wolverhampton Excel Programming Using VBA Training Courses; Wolverhampton Excel MOS 2013 Training Courses;

Wolverhampton Project Onsite Courses: Wolverhampton Project 2013 Training Courses; Wolverhampton Project 2010 Training Courses; Wolverhampton Project 2007 Training Courses; Wolverhampton Training Courses;

Wolverhampton Office Onsite Courses: Wolverhampton PowerPoint 2010 Training Courses; Wolverhampton Word 2013 Basic Training Courses; Wolverhampton Publisher 2013 Training Courses; Wolverhampton Publisher 2010 Training Courses; Wolverhampton Word 2010 Basic Training Courses; Wolverhampton Word 2010 Advanced Training Courses;