Enable Technology

EXCEL KIDSGROVE TRAINING COURSES 

EXCEL TRAINING COURSES KIDSGROVE




About Enable Technology Kidsgrove Excel Training Courses

Enable Technology specialise in succinct skills based Excel training. The tutor delivering the course will be a Microsoft certified expert. Everyone attending a Excel course receives learning resources which also serves as a reference source 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.

Our primary method of delivery is instructor led training coupled with practical hands on activities. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the Excel onsite. Alternatively we could schedule a course at a local socially distanced venue in Kidsgrove. The Excel syllabus can be modified to accommodate your specific training needs.

Excel courses are also available online. Participants can join scheduled virtual classes, watch the tutor demonstrate the topic, ask questions and share their screen

We have operated primarily in the West Midlands for twenty years. Our clients include: GKN PLC, Unipart Group, Nuclear Engineering Services, Birmingham Heartlands Hospital, Keele University, Birmingham City University, Dollond & Aitchison Limited and Birmingham City Council.




Excel Programming Using VBA

  • 2 day course
  • Location: Kidsgrove
  • 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 ...
  • Working with Variable Scope
    Guidelines for use of Control-of-Flow Structures
    Introducing Visual Basic for Applications
    Understanding the Err Object
    Displaying the Developer Tab in the Ribbon
    Understanding Error Handling
    Controlling Program Execution
    Running a Macro
    Understanding VBA's Error Trapping Options
    Using the Do...Loop Structure
    Debugging Code
    Working with Procedures and Functions
    Creating an Event Procedure
    Creating a Sub Procedure
    Working with the Combo Box Control
    Understanding Macro Security
    Closing the Visual Basic Editor
    Using Message Boxes
    Using Debugging Tools

  • See Training Course Details...


Excel Power Pivot

  • 1 day course
  • Location: Kidsgrove
  • 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 a Power View Object
    Working With Power View Fields
    Switching Visualisations
    Creating a Power Map Tour
    Working With Layers
    Viewing and Editing a Tour
    Working With Scenes
    Power Pivot
    Working With Mapping Confidence
    Transforming Data
    Updating a Power View Report
    Understanding Power Map
    Enabling Power View
    Working With Scene Options
    Formatting Data Model Fields
    Rearranging and Sorting Fields
    Creating a New Query From a File
    Working With Data Model Fields
    Working With the Data Model

  • See Training Course Details...


Excel Advanced

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

  • Some of the training topics covered include ...
  • Creating a One-Variable Table
    Understanding Data Consolidation
    Using a Simple What-If Model
    Protecting a Worksheet With Controls Sharing Workbooks
    Using Relative Names for Subtotals Data Consolidation
    Exporting Data as Text
    Inserting a Picture
    Adding a Group Box Control
    Creating a Linked Consolidation
    Updating Links Between Workbooks Grouping and Outlining
    Creating an Error Message
    Using a Subtotalled Worksheet
    Consolidating With Identical Layouts
    Using Formulas as Validation Criteria
    Changing the PivotChart Type
    Setting Macro Security
    Running a Macro From the Toolbar
    Linking Between Workbooks
    Providing Total Access to Cells
    Understanding Data Linking
    Testing a Validation

  • See Training Course Details...


Excel Basic

  • 1 day course
  • Location: Kidsgrove
  • 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 ...
  • Copying From One Range to Another Filling Data
    Printing a Range
    Creating Compound Filters
    Finding a Minimum Value
    Common Error Messages Formula Referencing
    Making Cells Bold
    Deleting Rows and Columns
    Vertical Cell Alignment
    Inserting Columns Into a Worksheet
    Creating Absolute References
    Using Shortcut Menus
    Selecting Rows
    Starting Excel From the Desktop
    Overwriting Cell Contents
    Using the Ribbon
    Creating Custom Filters
    Understanding Cell Alignment
    Using Fill for Quick Copying
    Previewing Before You Print
    Understanding Filling
    Selecting Columns Copying Data

  • See Training Course Details...


Excel Intermediate

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

  • Some of the training topics covered include ...
  • Moving a Worksheet
    Creating a Table From Scratch
    Clearing Conditional Formatting
    Documenting Defined Names Number Formatting Techniques
    Understanding the Format Pane
    The MOD Function
    Exploding Pie Slices
    The LOOKUP Function
    Filtering Tables
    Applying Top and Bottom Borders
    Grouping Worksheets
    Adding More Complexity
    Filling Using Options
    Quick Formatting
    Defining Names for Constant Values
    Nesting IF Functions
    The NOW Function
    Values Conditional Formatting
    Using IF With Text
    Adding a Trendline

  • See Training Course Details...


Microsoft Excel PowerPivot Data Analytic Expressions DAX Language

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

  • See Training Course Details...


Microsoft Excel Power Query

  • 1 day course
  • Location: Kidsgrove
  • 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 ...
  • Understand and perform importing from SQL Server Analysis Services Tabular. PERFORMING MERGES
    Working with Folders and Files
    Understanding Data Types WORKING WITH CSV, TXT AND EXCEL WORKSHEETS
    Understand Power Query formulas.
    Introduction to Power BI Desktop
    Loading into Power Pivot
    Importing Data
    Loading into Excel
    Grouping Options
    Data Sources GROUPING AND SUMMARISING WITH POWER QUERY
    Course topics include- INTRODUCTION TO POWER QUERY
    Understand and perform importing from SQL Server Analysis Services Multidimensional.
    Combining Worksheets
    Using PivotTables CONNECTING TO DATABASES
    Understanding the Issues
    Loading into Power BI Desktop
    Loading Data
    Understand the M interface.
    Transforming Data
    Appending Operations
    Power Query Interface

  • See Training Course Details...



Email us about this courses



Other Kidsgrove Enable Technology Training Courses

Data Warehouse - Kidsgrove SQL Training Courses
HTML - Kidsgrove Web Development Training Courses
Project 2016 Kidsgrove Training Courses
Access VBA - Kidsgrove Access Training Courses
Oracle SQL Kidsgrove Training Courses
Visio 2013 Kidsgrove Training Courses
Microsoft Project Level 3 - Kidsgrove Microsoft Project Training Courses
PowerPoint Advanced - Kidsgrove Office Training Courses
SSRS 2014 Kidsgrove Training Courses
SSAS 2005 - Kidsgrove SQL Server Analysis Services Training Courses
Data Mining - Kidsgrove Data Analytics Training Courses
Microsoft Project Level 2 - Kidsgrove Microsoft Project Training Courses
Crystal 2011 Kidsgrove Training Courses
Crystal 2016 - Kidsgrove Crystal Reports Training Courses
PL/SQL - Kidsgrove SQL Training Courses
Crystal XI - Kidsgrove Crystal Reports Training Courses
Access 2016 Kidsgrove Training Courses
SSAS 2008 Kidsgrove Training Courses
Crystal 2008 Kidsgrove Training Courses
SSRS 2008 Kidsgrove Training Courses
Crystal 2013 Kidsgrove Training Courses



Midlands - Possible Excel Training Course Locations


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

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