Enable Technology

Training 

Excel Programming Using VBA

  • 2 day course
  • 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.



Power Pivot

  • 1 day course
  • Course Outline
  • A one day course introducing candidates to Power View and Power Pivot Excel tools.



Excel 2016

  • 2 day course
  • Course Outline
  • This integrated two day Excel 2016 course assumes no prior knowledge and aims to give a comprehensive understanding of how Excel can be used



Excel 2016 Basic

  • 1 day course
  • Course Outline
  • A one day course introducing Excel 2016.  Participants will learn how to writing formulas, use conditional formatting, create charts and print workbooks.



Excel 2016 Intermediate

  • 1 day course
  • Course Outline
  • A one day course covering Microsoft Excel 2016 Intermediate topics.



Excel 2016 Advanced

  • 1 day course
  • Course Outline
  • A one-day course covering Microsoft Excel 2016 advanced topics.



Excel MOS 2013

  • 2 day course
  • 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 2013 Basic

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



Excel 2013 Intermediate

  • 1 day course
  • Course Outline
  • A one day course covering Microsoft Excel 2013 intermediate topics.



Excel 2013 Advanced

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



Excel MOS 2010

  • 2 day course
  • 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 2010 Basic

  • 1 day course
  • 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

  • 1 day course
  • Course Outline
  • A one day intensive course covering Microsoft Excel 2010 intermediate topics.  Participants will learn a number of techniques for sorting, filtering and totalling and subtotalling 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 2010 Advanced

  • 1 day course
  • 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 populate Excel with external  data .



Excel MCAS 2007

  • 2 day course
  • 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 2007 Basic

  • 1 day course
  • Course Outline
  • A one day course introducing Microsoft Excel 2007. 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 2007 Intermediate

  • 1 day course
  • Course Outline
  • A one day course covering Microsoft Excel 2007 intermediate topics.  Participants will learn a number of techniques for sorting, filtering and totalling and subtotalling data. How to  use three dimensional formulas. Sharing and merging workbooks. How to password worksheets.

    The course also covers advanced formatting and chart options.

    The knowledge of basic Excel 2007 is required.



Excel 2007 Advanced

  • 1 day course
  • Course Outline
  • A one day course covering advanced Microsoft Excel 2007 topics.  The course will cover a range of advanced Excel functions including Vlookup, IF statements, nested IF statements, database functions. Topics include the use of PivotTables, data validation, scenarios and basic Macros. The course also explores how to populate Excel with external data .





Contact Us By Email         Telephone on 01902 837406







Training Locations: Enable Technology run courses in Wolverhampton, Telford, Shrewsbury, Birmingham, Cannock, Walsall, Dudley, Sandwell, Bridgnorth, Lichfield, Burton-upon-Trent, Stafford, Redditch, Bromsgrove, Solihull, Tamworth, Worcester, Shropshire, Staffordshire, Worcestershire and across the West Midlands.



West Midlands Scheduled Courses: Excel VBA; MS Project, SSRS; SQL; Crystal Reports; HTML;Adobe Illustrator; ASP.NET; Dreamweaver; Flash; Photoshop; InDesign; Google Scripting; Visio; PHP; Microsoft Access; JQuery JavaScript; Web Development; Office;

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

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

Telford Scheduled Courses: SQL; Excel VBA; MS Project; Visio; PowerPoint; Photoshop; Adobe InDesign; Illustrator; Dreamweaver; Web Design; Office;

Cannock Scheduled Courses: Excel VBA; PHP; Microsoft Access; Visio; MS Project; PowerPoint; Dreamweaver; Photoshop; InDesign; Adobe Illustrator; Flash; JavaScript; HTML CSS;

Walsall Scheduled Courses: Excel; Access; MS Project; Visio; Photoshop; InDesign; Adobe Illustrator; Dreamweaver; Flash; SQL; JavaScript; HTML CSS;

Dudley Scheduled Courses: Excel; MS Access; SQL; MS Project;Visio; Adobe Illustrator; InDesign; Photoshop; Dreamweaver; Flash; JavaScript; HTML CSS;

Sandwell Scheduled Courses: Access;Excel; Microsoft Project; Visio; PowerPoint; Adobe Illustrator; Photoshop; Adobe InDesign; Dreamweaver; Flash; JavaScript; HTML CSS; SQL;

Shropshire Scheduled Courses: Illustrator; InDesign; Adobe; Dreamweaver; Flash; Photoshop; Excel; Project; Visio; PowerPoint; Office; JavaScript; HTML; Access;

Staffordshire Scheduled Courses: Illustrator; InDesign; Photoshop; Dreamweaver; Flash; Adobe; Excel;