Enable Technology

EXCEL TELFORD TRAINING COURSES 

EXCEL TRAINING COURSES TELFORD




About Enable Technology Telford Excel Training Courses

Enable Technology specialise in succinct skills based Excel training. The course will always be taught by a Microsoft Certified Professional (MCP). Every course participant is given Excel courseware which they can refer to after the training. Anyone attending the course can contact the Tutor for as long as they like after the Excel course. The ongoing support by a Microsoft expert is an important part of the service we offer.

We provide instructor led training coupled with hands on training. We are delivering this instructor led Excel training online during the current crisis. Participants can se the tutors screen, ask questions and share their screen with the tutor. The Excel syllabus can be adjusted and additional topics incorporated if helpful.

We have operated primarily in the West Midlands for twenty years. Our clients include: Total Telecommunications Limited, Shell UK Oil Products Ltd, Canadian High Commission, DHL Express, Queen's Medical Centre Nottingham, Boots UK Limited, Vodafone Group Services and Halfords Group PLC.




Excel Programming Using VBA

  • 2 day course
  • Location: Telford
  • 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 ...
  • Creating a PivotTable Using Worksheet Data
    Understanding the Err Object
    Creating a Function Procedure
    Understanding Errors
    Guidelines for use of Control-of-Flow Structures
    Understanding the Development Environment
    Understanding PivotTables
    Using Debugging Tools
    Debugging Code
    Displaying the Developer Tab in the Ribbon
    Using the Select Case...End Select Structure
    Understanding Data Types
    Working with the Command Button Control
    Working with the Text Box Control
    Working with Boolean Expressions
    Using Input Boxes
    Working with the PivotFields Collection
    Working with the PivotTable Object
    Using Message Boxes
    Creating a Sub Procedure

  • See Training Course Details...


Excel Advanced

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

  • Some of the training topics covered include ...
  • Sharing Workbooks via the Network
    Recording a Simple Macro
    Creating a Linked Consolidation
    Disabling Tracked Changes
    Creating Relative Names for Subtotals
    Understanding Data Protection
    Setting Excel Options
    Adding a Check Box Control
    Testing a Validation
    Understanding Advanced Filtering
    Running a Macro With Relative References
    Understanding Grouping and Outlining
    Setting Save Options
    Formatting a PivotTable
    Creating Your Own PivotTable
    Adding a Combo Box Control
    Assigning a Macro to the Toolbar
    Formatting PivotTable Values
    Creating a Default Scenario
    Preparing a Worksheet for Controls
    Adding a Scroll Bar Control

  • See Training Course Details...


Excel Power Pivot

  • 1 day course
  • Location: Telford
  • 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 ...
  • Power Map
    Formatting Data Model Fields
    Filtering in Power View
    Using Calculated Fields
    Working With a Power View Object
    Merging Queries
    Saving and Sharing Queries
    Creating a Timeline
    Understanding the Query Editor
    Editing Query Steps
    Adding More Power Views
    Adding a Data Column
    Understanding Get & Transform
    Exporting a Tour as a Video
    Working With the Data Model
    Working With Height and Category
    Viewing and Editing a Tour
    Understanding Relational Data
    Displaying the Query Editor
    Formatting Power View Data

  • See Training Course Details...


Microsoft Excel Power Query

  • 1 day course
  • Location: Telford
  • 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 ...
  • Power Query Interface
    Loading into Power Pivot
    Understand and perform importing from SQL Server Analysis Services Multidimensional.
    Grouping Options
    Transforming Data
    Working with Folders and Files
    Loading Data
    Using Ranges in Excel
    Introduction to Power BI Desktop
    Understand and utilize merges. LOADING YOUR DATA
    Importing Data
    Loading into Excel
    Combining Worksheets
    Course topics include- INTRODUCTION TO POWER QUERY
    Understand and perform importing from SQL Server Analysis Services Tabular. PERFORMING MERGES
    Appending Operations
    Performing Merges
    Understand the M interface.
    Loading into Power BI Desktop
    Data Sources GROUPING AND SUMMARISING WITH POWER QUERY
    Understand working with relational data.

  • See Training Course Details...


Excel Basic

  • 1 day course
  • Location: Telford
  • 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 ...
  • Moving Cells and Ranges
    Exiting Safely From Excel Creating a New Workbook
    Using the Ribbon
    Clearing Cells
    Typing Dates
    Creating a New Chart From Scratch
    Changing Fonts
    Accessing the Backstage View
    Printing an Embedded Chart
    Inserting Columns Into a Worksheet
    Understanding the Excel Start Screen
    Editing Formulas
    Typing Numbers
    Increasing and Decreasing Decimals Row and Column Formatting
    Understanding Filling
    Understanding Functions
    Getting to Know Excel
    Creating Custom Filters
    Understanding the Charting Process
    Overwriting Cell Contents
    Accessing the Help Window

  • See Training Course Details...


Microsoft Excel PowerPivot Data Analytic Expressions DAX Language

  • 2 day course
  • Location: Telford
  • 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 ...
  • Introduction to DAX
    Aggregation Functions
    Information Functions
    Introduction to DAX
    Conversion Functions
    Understanding Values
    Logical Functions
    Using Multiple Calendars Utilising Advanced DAX Functionality
    PowerPivot Data Model
    Explaining Syntax
    Handling Errors Using DAX Functions
    Statistical Functions
    Relational Functions Understanding Evaluation Contexts
    Text Functions
    Multiple Table Evaluation Context Working with Dates
    Date Functions
    Utilizing Operators
    Many-to-Many Relationships
    Working with Calendars
    Exploring Data Types

  • See Training Course Details...


Excel Intermediate

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

  • Some of the training topics covered include ...
  • Using IF With Numbers
    Changing Line Chart Colours
    Documenting Defined Names Number Formatting Techniques
    Printing Headings
    Filling a Series Backwards
    Copying a Worksheet
    Changing WordArt Effects
    Drawing a Border Grid
    Manipulative Functions
    Understanding Chart Formatting
    Understanding Goal Seeking
    Drawing Borders
    Quick Totals
    Unhiding a Worksheet
    Defining Names From Worksheet
    Changing Orientation
    Scaling to a Percentage
    Changing the Colour of a Series
    Working With Table Styles
    Quick Tables Worksheet Tables
    Quick Formatting

  • See Training Course Details...



Email us about this courses



Other Telford Enable Technology Training Courses

JQuery Mobile - Telford JavaScript Training Courses
SSRS 2005 - Telford SQL Server Reporting Services Training Courses
TSQL - Telford SQL Training Courses
SQL Telford Training Courses
Access VBA Telford Training Courses
Oracle BI Telford Training Courses
Crystal XI Telford Training Courses
PowerPoint Basic - Telford Office Training Courses
Power BI Telford Training Courses
SSAS 2017 - Telford SQL Server Analysis Services Training Courses
SSIS 2005 - Telford SQL Server Integration Services Training Courses
SSIS 2008 - Telford SQL Server Integration Services Training Courses
Report Builder - Telford SQL Server Reporting Services Training Courses
PL/SQL - Telford SQL Training Courses
Microsoft Project Level 2 - Telford Microsoft Project Training Courses
SSRS 2014 - Telford SQL Server Reporting Services Training Courses
SSAS Tabular - Telford SQL Server Analysis Services Training Courses
SSAS 2008 - Telford SQL Server Analysis Services Training Courses
Access 2016 - Telford Access Training Courses
SSAS 2005 - Telford SQL Server Analysis Services Training Courses
Mobile - Telford Web Development Training Courses



Midlands - Possible Excel Training Course Locations


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