Enable Technology

EXCEL MIDLANDS TRAINING COURSES 

EXCEL TRAINING COURSES MIDLANDS




About Enable Technology Midlands Excel Training Courses

We are a company that provides short intensive Excel training courses. The tutor delivering the course will be a Microsoft certified expert. Each person attending a course takes away Excel courseware which can be used as reference materials after the training. We also provide an ongoing support service to people attending our Excel courses. Delegates can contact the course tutor with specific Excel questions for as long as they need following the course.

Excel training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. We are set up to deliver Excel training courses onsite at your premises. Alternatively we could schedule a Excel course at an alternative training site in the Midlands. We are more than happy to incorporate additional topics to accommodate your organisations Excel training needs.

This instructor led course is also available online. Participants can log onto a virtual classroom and will be able to see the tutors screen, ask questions real time and share their screen with the Tutor.

The Enable Technology group of companies has been operating continuously providing IT training since 1998. Some of our clients are Royal & Sun Alliance Group PLC, Boots UK Limited, Lloyds TSB Bank PLC, EDF Energy PLC, Barclays Bank PLC, Homeserve PLC, Carillion PLC and Canadian High Commission.




Microsoft Excel PowerPivot Data Analytic Expressions DAX Language

  • 2 day course
  • Location: Midlands
  • 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 ...
  • Explaining Syntax
    Statistical Functions
    Introduction to DAX
    Filter Functions
    Many-to-Many Relationships
    Using Multiple Calendars Utilising Advanced DAX Functionality
    Aggregation Functions
    The CALCULATE Function
    Information Functions
    Relational Functions Understanding Evaluation Contexts
    Logical Functions
    Mathematical Functions
    Multiple Table Evaluation Context Working with Dates
    Date Functions
    Text Functions
    Exploring Data Types
    PowerPivot Data Model
    Introduction to DAX
    Working with Calendars
    Single Table Evaluation Context

  • See Training Course Details...


Excel Power Pivot

  • 1 day course
  • Location: Midlands
  • 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 ...
  • Working With Time Settings
    Creating a Calculated Field
    Using Calculated Fields
    Filtering in Power View
    Exporting a Tour as a Video
    Creating a Power View Sheet
    Working With the Data Model
    Enabling Power Pivot
    Editing Query Steps
    Connecting to a Data Source
    Switching Visualisations
    Updating a Power View Report
    The Advanced Editor
    Working With Scene Options
    Formatting Power View Data
    Power View
    Enabling Power View
    Working With Data Model Fields
    Changing a Power Pivot View
    Understanding the Query Editor

  • See Training Course Details...


Excel Intermediate

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

  • Some of the training topics covered include ...
  • Sorting Tables
    Padding Numbers Using Custom
    Hiding a Worksheet
    Using Counting Functions
    Filtering Tables
    The ROUND Function
    Splitting Windows Page Setup
    Adding Error Bars
    Centring on a Page
    Formatting Text
    Renaming a Worksheet
    Scaling to a Percentage
    Creating a Table From Data
    Using Names to Select Ranges
    Filling Using Options
    Aligning Numbers Using Custom
    Using Shape Effects
    More Cell Formatting Options
    Formatting the Chart Area
    Clearing Conditional Formatting
    Creating the Base Formula

  • See Training Course Details...


Excel Programming Using VBA

  • 2 day course
  • Location: Midlands
  • 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 ...
  • Understanding VBA's Error Trapping Options
    Using the For...To...Next Structure
    Understanding the Development Environment
    Introducing Visual Basic for Applications
    Understanding Collections
    Understanding Modules
    Using Message Boxes
    Using Break Mode during Run mode
    Working with Methods
    Populating a Control
    Understanding Objects
    Recording a Macro
    Using Debugging Tools
    Saving a Macro-Enabled Workbook
    Setting Control Properties in the Properties Window
    Navigating the Excel Object Hierarchy
    Working with the Label Control
    Working with Inline Error Handling
    Working with the PivotTable Objects

  • See Training Course Details...


Excel Advanced

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

  • Some of the training topics covered include ...
  • Creating Subtotals
    Counting in a PivotTable
    Creating a Default Scenario
    Deleting a Macro
    Grouping by Columns Summarising and Subtotalling
    Recommended PivotTables
    Extracting Records With Advanced Filter
    Using Formulas in Criteria
    Running a Recorded Macro
    Using Database Functions
    Clearing a Report Filter
    Changing Control Properties
    Defining the PivotTable Structure
    Relative Cell References
    Recording a Simple Macro
    Changing the PivotChart Type
    Setting the Default Font
    Running a Macro From the Toolbar
    Creating Calculated Items
    Understanding Database Functions
    Using a Simple What-If Model

  • See Training Course Details...


Excel Basic

  • 1 day course
  • Location: Midlands
  • 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 ...
  • Summing Non-Contiguous Ranges
    Filling a Series
    Selecting Non Contiguous Ranges
    Viewing the Formula Bar
    Specifying the Number of Copies
    Typing Numbers
    Understanding Lists
    Formulas That Multiply and Divide
    Typing Dates
    Filling a Growth Series
    Changing Background Colours
    Checking the Spelling
    Formatting as Dates
    Selecting Rows
    Using Fill for Quick Copying
    Deleting Cells From a Worksheet
    Deleting Data
    Changing Font Colours
    Making Cells Bold
    Accessing the Backstage View
    Selecting Contiguous Ranges

  • See Training Course Details...


Microsoft Excel Power Query

  • 1 day course
  • Location: Midlands
  • 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 ...
  • Grouping Options
    Loading Data
    Loading into Power BI Desktop
    Appending Operations
    Working with Folders and Files
    Understand the M interface.
    Understand and perform importing from SQL Server Analysis Services Multidimensional.
    Understand working with relational data.
    Transforming Data
    Loading into Excel
    Performing Merges
    Understanding Data Types WORKING WITH CSV, TXT AND EXCEL WORKSHEETS
    Data Sources GROUPING AND SUMMARISING WITH POWER QUERY
    Combining Worksheets
    Summarising WORKING WITH THE POWER QUERY LANGUAGE “M”
    Importing, Transforming, and Loading Data into Excel and Power Pivot
    Using PivotTables CONNECTING TO DATABASES
    Loading into Power Pivot
    Understand and utilize merges. LOADING YOUR DATA
    Understand and perform importing from SQL Server Analysis Services Tabular. PERFORMING MERGES
    Course topics include- INTRODUCTION TO POWER QUERY

  • See Training Course Details...



Email us about this courses



Other Midlands Enable Technology Training Courses

SSRS 2016 - Midlands SQL Server Reporting Services Training Courses
Visio 2013 - Midlands Visio Training Courses
Oracle SQL - Midlands SQL Training Courses
Access 2016 Midlands Training Courses
SSRS 2005 Midlands Training Courses
Data Mining Midlands Training Courses
Microsoft Project Level 3 - Midlands Microsoft Project Training Courses
SSAS Tabular - Midlands SQL Server Analysis Services Training Courses
Power Graphics Midlands Training Courses
PHP - Midlands PHP Training Courses
Crystal 2008 - Midlands Crystal Reports Training Courses
SSIS 2014 Midlands Training Courses
Crystal XI Midlands Training Courses
SSRS 2014 Midlands Training Courses
PowerPoint Basic Midlands Training Courses
SSRS 2008 Midlands Training Courses
SSAS 2008 Midlands Training Courses
Project 2016 L1 - Midlands Microsoft Project Training Courses
Power BI - Midlands Microsoft Power BI Training Courses
Data Warehouse - Midlands SQL Training Courses
JavaScript - Midlands JavaScript Training Courses



Midlands - Possible Excel Training Course Locations


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

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