Enable Technology

EXCEL STAFFORDSHIRE TRAINING COURSES 

EXCEL TRAINING COURSES STAFFORDSHIRE




About Enable Technology Staffordshire Excel Training Courses

Enable Technology specialise in succinct skills based Excel training. All Enable Technology tutors are Microsoft certified experts. We provide every candidate with Excel training materials which they keep after the course. Our policy is to provide open ended Excel post training support to participants. This additional service is an important part ofhow we help people implement the skills they have learned in the workplace.

Enable Technology offers instructor led training taught by technology specialists. During the current lockdown this course is delivered in a virtual classroom. Delegates can log into a scheduled Excel course, watch the tutor demonstrate tasks, ask questions and share their own screen. We are happy to discuss customising the course content should you have particular Excel training requirements.

The Enable Technology group of companies has been operating continuously providing IT training since 1998. Some of our clients are Carillion PLC, Nationwide Building Society Limited, Canadian High Commission, Nuclear Engineering Services, Wolverhampton City Council, University of Birmingham, Barclays Bank PLC and Norwich Union PLC.




Excel Power Pivot

  • 1 day course
  • Location: Staffordshire
  • 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 ...
  • Reducing Data Rows
    Working With Location Fields
    Working With Scene Options
    Enabling Power Pivot
    Enabling Power View
    Adding Power View to the Ribbon
    Creating a New Query From a File
    Using Calculated Fields
    Understanding Get & Transform
    Formatting Power View Data
    Rearranging and Sorting Fields
    Tiling Data in Power View
    Working With Scenes
    Working With Time Settings
    Connecting to a Data Source
    Transforming Data
    Viewing and Editing a Tour
    Updating a Power View Report
    Displaying the Query Editor
    Adding Titles and Images
    Creating a New Query From the Web

  • See Training Course Details...


Microsoft Excel PowerPivot Data Analytic Expressions DAX Language

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

  • See Training Course Details...


Excel Intermediate

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

  • Some of the training topics covered include ...
  • Long-Hand Formulas
    Using Counting Functions
    Setting Custom Margins
    Formatting the Drawing Pencil Essential Functions
    Showing Data Labels
    Freezing Rows and Columns
    Colouring the Chart Background
    Formatting the Chart Area
    Customising the Display of Negative
    Creating Names From a Selection
    Changing WordArt Effects
    Creating a Table From Scratch
    Filling Using Options
    Creating the Base Formula
    Printing Gridlines
    Applying Alternate Currencies
    Adding More Operations
    Creating Names Using the Name Box
    Copying a Sheet to Another
    Documenting Defined Names Number Formatting Techniques
    Changing Individual Bar Colours

  • See Training Course Details...


Microsoft Excel Power Query

  • 1 day course
  • Location: Staffordshire
  • 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 ...
  • Summarising WORKING WITH THE POWER QUERY LANGUAGE “M”
    Appending Operations
    Course topics include- INTRODUCTION TO POWER QUERY
    Understand and perform importing from SQL Server Analysis Services Multidimensional.
    Data Sources GROUPING AND SUMMARISING WITH POWER QUERY
    Using Ranges in Excel
    Understand and perform importing from SQL Server Analysis Services Tabular. PERFORMING MERGES
    Combining Worksheets
    Transforming Data
    Understand and utilize merges. LOADING YOUR DATA
    Understand the M interface.
    Power Query Interface
    Grouping Options
    Performing Merges
    Understanding the Issues
    Loading Data
    Understand Power Query formulas.
    Using PivotTables CONNECTING TO DATABASES
    Loading into Power Pivot
    Introduction to Power BI Desktop
    Understanding and Handling Special Situations

  • See Training Course Details...


Excel Advanced

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

  • Some of the training topics covered include ...
  • Changing the PivotChart Type
    Inserting a PivotChart
    Creating Scenarios
    Providing Custom Names
    Using an Advanced Filter
    Password Protecting a Workbook
    Creating Subtotals
    Creating Running Totals
    Creating Calculated Items
    Changing Control Properties
    Working With Connected Data Unlinking Connections
    Deleting a Macro
    Filtering a PivotTable
    Recommended PivotTables
    Removing a Password From a Workbook Importing and Exporting
    Creating a Manual Group
    Protecting a Worksheet
    Saving a Document as Macro Enabled
    Importing From an Earlier Version
    Consolidating With Identical Layouts
    Disabling Tracked Changes

  • See Training Course Details...


Excel Basic

  • 1 day course
  • Location: Staffordshire
  • 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 by Dragging Formulas and Functions
    The Print Options Creating Charts
    Navigating the Help Window
    Printing an Embedded Chart
    Creating Mixed References Font Formatting
    Inserting Columns Into a Worksheet
    Changing the Chart Style
    Adding Commands to the QAT
    Changing the Chart Layout
    Creating More Complex Formulas
    Sorting on More Than One Column Filtering Data
    Clearing Cells
    Understanding Lists
    Calculating an Average
    Printing a Chart Sheet
    Navigating Using the Keyboard
    Using the Ribbon
    Creating Formulas That Subtract
    Selecting Non Contiguous Ranges
    Selecting a Printer
    Launching Dialog Boxes

  • See Training Course Details...


Excel Programming Using VBA

  • 2 day course
  • Location: Staffordshire
  • 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 Collections
    Populating a Control
    Guidelines for use of Control-of-Flow Structures
    Determining the Value of Expressions
    Understanding Control-of-Flow Structures
    Using the With Statement
    Working with the PivotTable Objects
    Using the For Each...Next Structure
    Using Intrinsic Constants
    Understanding Modules
    Using Visual Basic Help
    Using the Immediate Window to Call Procedures
    Using the Object Browser
    Setting the Tab Order
    Understanding Errors
    Naming Procedures
    Creating a Standard Module
    Declaring and Using Object Variables

  • See Training Course Details...



Email us about this courses



Other Staffordshire Enable Technology Training Courses

SSRS 2016 - Staffordshire SQL Server Reporting Services Training Courses
SSIS 2008 - Staffordshire SQL Server Integration Services Training Courses
Access VBA - Staffordshire Access Training Courses
SQL Staffordshire Training Courses
Project 2016 Staffordshire Training Courses
Microsoft Project Level 2 Staffordshire Training Courses
JQuery - Staffordshire JavaScript Training Courses
JQuery Mobile - Staffordshire JavaScript Training Courses
PowerPoint Advanced - Staffordshire Office Training Courses
SSRS 2014 Staffordshire Training Courses
SSIS 2014 Staffordshire Training Courses
TSQL Staffordshire Training Courses
Microsoft Project Level 3 - Staffordshire Microsoft Project Training Courses
Crystal XI - Staffordshire Crystal Reports Training Courses
PL/SQL - Staffordshire SQL Training Courses
SSIS 2005 - Staffordshire SQL Server Integration Services Training Courses
SSAS Tabular Staffordshire Training Courses
Visio 2013 Staffordshire Training Courses
SSAS 2014 - Staffordshire SQL Server Analysis Services Training Courses
Crystal 2016 Staffordshire Training Courses
Crystal 2008 - Staffordshire Crystal Reports Training Courses



Midlands - Possible Excel Training Course Locations


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