Enable Technology

EXCEL WOLVERHAMPTON TRAINING COURSES 

EXCEL TRAINING COURSES WOLVERHAMPTON




About Enable Technology Wolverhampton Excel Training Courses

We are a company that offers short, practical, Excel hands on technology courses. All of our tutors are Microsoft Certified Solutions Experts with development backgrounds. Every person attending a Excel course will be provided with training materials and practice files to retain after the course. It is our company policy to provide Excel training participants with ongoing support from the course Tutor. People who attend a Excel course can contact the Tutor for as long as they need assistance after the training.

Courses are instructor led and groups sizes small. Enable Technology Excel training courses can be delivered at your offices. We can supply the necessary software and computers. We can also deliver the Excel course at a socially distanced local training venue in Wolverhampton. We are happy to discuss customising the course content should you have particular Excel training requirements.

This instructor led Excel training is also available online. Participants can see the tutors screen, ask questions and share their screen with the tutor.

The Enable Technology team have had two decades of experience delivering technical training mainly in the Midlands region. Some of our clients are Norfolk Police Constabulary, Birmingham Heartlands Hospital, Vodafone Group Services, GKN PLC, DHL Express, Yell Group PLC, Royal & Sun Alliance Group PLC and Loughborough University.




Excel Programming Using VBA

  • 2 day course
  • Location: Wolverhampton
  • Telephone on 01952 305730
  • 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.

  • Some of the training topics covered include ...
  • Using Visual Basic Help
    Understanding Collections
    Working with the Combo Box Control
    Working with the Label Control
    Understanding Control-of-Flow Structures
    Working with UserForm Properties, Events, and Methods
    Closing the Visual Basic Editor
    Using Debugging Tools
    Using the Select Case...End Select Structure
    Setting Breakpoints
    Creating an Event Procedure
    Understanding Macro Security
    Populating a Control
    Determining the Value of Expressions
    Using the For Each...Next Structure
    Understanding UserForms
    Working with Properties
    Editing a Macro in the Visual Basic Editor
    Understanding Objects
    Understanding Data Types

  • See Training Course Details...


Excel Advanced

  • 1 day course
  • Location: Wolverhampton
  • Telephone on 01952 305730
  • Course Outline
  • A one-day course covering Microsoft Excel advanced topics.

  • Some of the training topics covered include ...
  • Merging Scenarios PivotTables
    Opening a Password Protected Workbook
    Understanding Data Protection
    Using an Advanced Filter
    Understanding PivotTables
    Creating Your Own PivotTable
    Using Formulas in Criteria
    Circling Invalid Data
    Creating Running Totals
    Relative Cell References
    Recording a Simple Macro
    Setting Macro Security
    Assigning a Macro to the Ribbon
    Creating a Linked Consolidation
    Navigating Worksheet Comments
    Adding a Combo Box Control
    Using a Subtotalled Worksheet
    Enabling Tracked Changes
    Understanding Excel Macros
    Deleting a Macro
    Understanding How Controls Work

  • See Training Course Details...


Excel Intermediate

  • 1 day course
  • Location: Wolverhampton
  • Telephone on 01952 305730
  • Course Outline
  • A one day course covering Microsoft Excel Intermediate topics.

  • Some of the training topics covered include ...
  • Unhiding a Worksheet
    Changing Orientation
    Scoping a Formula
    Long-Hand Formulas
    Hiding Rows and Columns
    Understanding Borders
    Editing Sparklines Goal Seeking
    Clearing the Print Area
    Using Built in Margins
    Creating Names Using the Name Box
    Quick Charting
    Freezing Rows and Columns
    Formatting Clock Time
    Using Names in Typed Formulas
    Scoping Names to a Worksheet
    Printing Gridlines
    Splitting a Table
    Applying Alternate Currencies
    Rounding Up and Rounding Down
    Formatting With WordArt

  • See Training Course Details...


Excel Basic

  • 1 day course
  • Location: Wolverhampton
  • Telephone on 01952 305730
  • Course Outline
  • A one day course introducing Excel.  Participants will learn how to writing formulas, use conditional formatting, create charts and print workbooks.

  • Some of the training topics covered include ...
  • Selecting Contiguous Ranges
    Vertical Cell Alignment
    Selecting Non Contiguous Ranges
    Deleting a Chart Getting Help
    Understanding Filling
    Using Fill for Quick Copying
    Changing the Worksheet View
    Editing Formulas
    Understanding Lists
    Approximating Row Height
    Number Formatting
    Printing an Entire Workbook
    Moving by Dragging Formulas and Functions
    Viewing Worksheet Gridlines
    Creating More Complex Formulas
    Indenting Cells
    Common Error Messages Formula Referencing
    Extracting With Flash Fill Moving Data
    Typing Numbers
    Formatting as Fractions
    Changing the Chart Style

  • See Training Course Details...


Excel Power Pivot

  • 1 day course
  • Location: Wolverhampton
  • Telephone on 01952 305730
  • Course Outline
  • A one day course introducing candidates to Power View and Power Pivot Excel tools.

  • Some of the training topics covered include ...
  • Understanding Power Pivot
    Understanding Relational Data
    Understanding Power View
    Working With Data Model Fields
    Working With Height and Category
    Changing the Look
    Editing Query Steps
    Enabling Power View
    Managing Data Columns
    Working With Location Fields
    Creating a Timeline
    Working With Mapping Confidence
    Formatting Data Model Fields
    Creating a New Query From the Web
    Creating a Concatenated Field
    Tiling Data in Power View
    Understanding Power Map
    Adding Titles and Images
    The Advanced Editor
    Adding More Power Views
    Working With Scenes

  • See Training Course Details...


Microsoft Excel PowerPivot Data Analytic Expressions DAX Language

  • 2 day course
  • Location: Wolverhampton
  • Telephone on 01952 305730
  • Course Outline
  • This course is intended for Power Users, Business Intelligence Developers and IT Professionals who will be involved with the development of Excel PowerPivot queries and tabular modelling. The course is intended to expose the delegates to the technology of DAX and to familiarise them with functionality of DAX at an advanced level.

     Prior experience with Excel and Microsoft SQL query writing is useful.

  • Some of the training topics covered include ...
  • Working with Calendars
    Text Functions
    Explaining Syntax
    Exploring Data Types
    Introduction to DAX
    Handling Errors Using DAX Functions
    Using Multiple Calendars Utilising Advanced DAX Functionality
    Utilizing Operators
    Understanding Values
    Aggregation Functions
    Statistical Functions
    Multiple Table Evaluation Context Working with Dates
    PowerPivot Data Model
    Single Table Evaluation Context
    Conversion Functions
    Filter Functions
    Mathematical Functions
    Introduction to DAX
    Information Functions
    Logical Functions

  • See Training Course Details...


Microsoft Excel Power Query

  • 1 day course
  • Location: Wolverhampton
  • Telephone on 01952 305730
  • Course Outline
  • This course familiarises the participant with Microsoft Power Query, a revolutionary data tool for Excel that allows you to intuitively discover and automate the import, transformation, and combination of data across a variety of data sources for use in Excel and Microsoft Power BI. Power Query is a free add-in for Excel that enhances the self-service Business Intelligence experience in Excel.  The course uses Excel 2016, however Power Query works with Excel 2010 and above.  

    Participants should be familiar with Excel and the concepts of datasets and basic reporting including the use of PivotTables.

  • Some of the training topics covered include ...
  • Loading into Power Pivot
    Understand Power Query formulas.
    Using PivotTables CONNECTING TO DATABASES
    Power Query Interface
    Course topics include- INTRODUCTION TO POWER QUERY
    Importing Data
    Data Sources GROUPING AND SUMMARISING WITH POWER QUERY
    Introduction to Power BI Desktop
    Appending Operations
    Understanding Data Types WORKING WITH CSV, TXT AND EXCEL WORKSHEETS
    Understanding the Issues
    Importing, Transforming, and Loading Data into Excel and Power Pivot
    Understand working with relational data.
    Performing Merges
    Understand and perform importing from SQL Server Analysis Services Multidimensional.
    Understanding and Handling Special Situations
    Understand and utilize merges. LOADING YOUR DATA
    Combining Worksheets
    Understand the M interface.
    Summarising WORKING WITH THE POWER QUERY LANGUAGE “M”
    Loading into Excel

  • See Training Course Details...



Email us about this courses



Other Wolverhampton Enable Technology Training Courses

SSAS 2005 - Wolverhampton SQL Server Analysis Services Training Courses
Power Graphics Wolverhampton Training Courses
PHP - Wolverhampton PHP Training Courses
Power BI - Wolverhampton Microsoft Power BI Training Courses
Oracle BI - Wolverhampton Data Analytics Training Courses
SSAS 2008 Wolverhampton Training Courses
JQuery Mobile - Wolverhampton JavaScript Training Courses
TSQL Wolverhampton Training Courses
PL/SQL Wolverhampton Training Courses
Microsoft Project Level 3 - Wolverhampton Microsoft Project Training Courses
Access VBA - Wolverhampton Access Training Courses
SSRS 2014 - Wolverhampton SQL Server Reporting Services Training Courses
Microsoft Project Level 2 Wolverhampton Training Courses
Crystal 2008 - Wolverhampton Crystal Reports Training Courses
SSRS 2005 Wolverhampton Training Courses
HTML Wolverhampton Training Courses
SSAS 2017 - Wolverhampton SQL Server Analysis Services Training Courses
Crystal 2013 - Wolverhampton Crystal Reports Training Courses
Project 2016 - Wolverhampton Microsoft Project Training Courses
Crystal XI Wolverhampton Training Courses
PowerPoint Advanced - Wolverhampton Office Training Courses



Midlands - Possible Excel Training Course Locations


East Midlands Excel Training Courses
Dudley Excel Training Courses
Halesowen Excel Training Courses
Newcastle Under Lyme Excel Training Courses
Atherstone Excel Training Courses
Wednesbury Excel Training Courses
Malvern Excel Training Courses
Midlands Excel Training Courses
Telford Excel Training Courses
Kidderminster Excel Training Courses
Stoke On Trent Excel Training Courses
Sandwell Excel Training Courses
Herefordshire Excel Training Courses
Stratford Upon Avon Excel Training Courses
Stafford Excel Training Courses
Coventry Excel Training Courses
Solihull Excel Training Courses
Tipton Excel Training Courses
Droitwich Excel Training Courses
Cheltenham Excel Training Courses
Kidsgrove Excel Training Courses
Burton On Trent Excel Training Courses
Lichfield Excel Training Courses
Shropshire Excel Training Courses
Nottingham Excel Training Courses
Leicestershire Excel Training Courses
Leamington Spa Excel Training Courses
Oswestry Excel Training Courses
Tamworth Excel Training Courses
Bedworth Excel Training Courses
Milton Keynes Excel Training Courses
Birmingham Excel Training Courses
Redditch Excel Training Courses
Walsall Excel Training Courses
West Midlands Excel Training Courses
Shrewsbury Excel Training Courses
Warwick Excel Training Courses
Derby Excel Training Courses
Black Country Excel Training Courses
Crewe Excel Training Courses
Nuneaton Excel Training Courses
Bridgnorth Excel Training Courses
Evesham Excel Training Courses
Worcester Excel Training Courses
Warwickshire Excel Training Courses
Rugby Excel Training Courses
Leek Excel Training Courses
Chester Excel Training Courses
Oxford Excel Training Courses
Stourbridge Excel Training Courses
Worcestershire Excel Training Courses
Northhampton Excel Training Courses
Staffordshire Excel Training Courses
Leicester Excel Training Courses
Rowley Excel Training Courses
Kenilworth Excel Training Courses
Wolverhampton Excel Training Courses
Staffordshire Excel Training Courses
Rugeley Excel Training Courses
West Bromwich Excel Training Courses
Smethwick Excel Training Courses
Stourbridge Excel Training Courses
Uttoxeter Excel Training Courses
Bromsgrove Excel Training Courses
Cannock Excel Training Courses
Hereford Excel Training Courses

East Midlands, Dudley, Halesowen, Newcastle Under Lyme, Atherstone, Wednesbury, Malvern, Midlands, Telford, Kidderminster, Stoke On Trent, Sandwell, Herefordshire, Stratford Upon Avon, Stafford, Coventry, Solihull, Tipton, Droitwich, Cheltenham, Kidsgrove, Burton On Trent, Lichfield, Shropshire, Nottingham, Leicestershire, Leamington Spa, Oswestry, Tamworth, Bedworth, Milton Keynes, Birmingham, Redditch, Walsall, West Midlands, Shrewsbury, Warwick, Derby, Black Country, Crewe, Nuneaton, Bridgnorth, Evesham, Worcester, Warwickshire, Rugby, Leek, Chester, Oxford, Stourbridge, Worcestershire, Northhampton, Staffordshire, Leicester, Rowley, Kenilworth, Wolverhampton, Staffordshire, Rugeley, West Bromwich, Smethwick, Stourbridge, Uttoxeter, Bromsgrove, Cannock, Hereford