EXCEL TRAINING COURSES EAST MIDLANDS
About Enable Technology East Midlands Excel Training Courses
We have a twenty year history of providing skills based Excel industry training. The person delivering the course will be a Microsoft Solutions Expert (MCSE). All course participants are issued Excel training manuals they can refer to after the course. Course participants are welcome contact the Tutor after the course with specific Excel queries. This support is open ended.
Delegates are taught by an experienced Microsoft professional. Excel courses are delivered through a mix of practical hands on exercises and walk throughs. Enable Technology Excel courses can be delivered onsite at your premises. We bring a fully equipped training lab with us. Another way we could deliver the Excel course is at a local socially distanced training site. 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.
Our teaching team have been delivering technical training in the Midlands for twenty years. Our clients include: Birmingham City University, DHL Express, Yell Group PLC, University of Birmingham, EDF Energy PLC, Nuclear Engineering Services, Unipart Group and Keele University.
Excel Basic
- 1 day course
- Location: East 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 ... Showing and Collapsing the Ribbon
- See Training Course Details...
Understanding Number Formatting
Saving a New Workbook on Your Computer
Inserting Rows Into a Worksheet
Creating Absolute References
Indenting Cells
Finding a Minimum Value
Using Tell Me
Selecting Columns Copying Data
Changing Background Colours
Understanding Copying in Excel
Exiting Safely From Excel Creating a New Workbook
Understanding Filling
Selecting Larger Ranges
Growing and Shrinking Fonts
Embedding a Chart Into a Worksheet
Understanding Worksheets
Navigating the Help Window
Accessing the Backstage View
Printing an Entire Workbook
Applying General Formatting
Excel Programming Using VBA
- 2 day course
- Location: East 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 ... Using Debugging Tools
- See Training Course Details...
Debugging Code
Guidelines for use of Control-of-Flow Structures
Working with Forms and Controls
Working with Variable Scope
Setting Control Properties in the Properties Window
Using the If...End If Decision Structures
Understanding Procedures
Determining the Value of Expressions
Declaring and Using Object Variables
Working with the Combo Box Control
Closing the Visual Basic Editor
Understanding Constants
Understanding Data Types
Working with Methods
Creating a Function Procedure
Calling Procedures
Using the Select Case...End Select Structure
Understanding Modules
Trapping Errors with the On Error Statement
Microsoft Excel PowerPivot Data Analytic Expressions DAX Language
- 2 day course
- Location: East 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 ... The CALCULATE Function
- See Training Course Details...
Working with Calendars
Single Table Evaluation Context
Mathematical Functions
Aggregation Functions
Introduction to DAX
Date Functions
Introduction to DAX
Exploring Data Types
Explaining Syntax
PowerPivot Data Model
Filter Functions
Logical Functions
Understanding Values
Conversion Functions
Using Multiple Calendars Utilising Advanced DAX Functionality
Multiple Table Evaluation Context Working with Dates
Statistical Functions
Information Functions
Text Functions
Microsoft Excel Power Query
- 1 day course
- Location: East 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 ... Importing, Transforming, and Loading Data into Excel and Power Pivot
- See Training Course Details...
Understanding the Issues
Working with Folders and Files
Loading into Power Pivot
Combining Worksheets
Loading into Power BI Desktop
Power Query Interface
Performing Merges
Transforming Data
Understand and perform importing from SQL Server Analysis Services Tabular. PERFORMING MERGES
Introduction to Power BI Desktop
Summarising WORKING WITH THE POWER QUERY LANGUAGE “M”
Grouping Options
Understanding Data Types WORKING WITH CSV, TXT AND EXCEL WORKSHEETS
Data Sources GROUPING AND SUMMARISING WITH POWER QUERY
Understand Power Query formulas.
Importing Data
Appending Operations
Using PivotTables CONNECTING TO DATABASES
Understand and perform importing from SQL Server Analysis Services Multidimensional.
Using Ranges in Excel
Excel Power Pivot
- 1 day course
- Location: East 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 ... Understanding Power View
- See Training Course Details...
Switching Visualisations
Creating a New Query From the Web
Working With Layers
Power Map
Updating a Power View Report
Working With a Power View Object
Tiling Data in Power View
Filtering Data
Understanding Get & Transform
Creating a Power Map Tour
Power View
Understanding the Query Editor
Saving and Sharing Queries
Navigating a Data Map
Exporting a Tour as a Video
Understanding Relational Data
Formatting Data Model Fields
The Advanced Editor
Filtering in Power View
Excel Intermediate
- 1 day course
- Location: East Midlands
- Telephone on 01952 305730
- Course Outline
-
A one day course covering Microsoft Excel Intermediate topics.
- Some of the training topics covered include ... Splitting a Table
- See Training Course Details...
Splitting Windows Page Setup
Hiding a Worksheet
Moving a Worksheet
Nesting IF Functions
Clearing Conditional Formatting
Modifying a Custom Fill List
Working With Table Styles
Removing Duplicates
Using the Name Manager
Using the More Borders Command
Using IF With Text
Quick Formatting
Formatting With WordArt
Changing WordArt Fill
Applying Names to Existing Formulas
Changing WordArt Effects
The DATE Function
Custom Formatting Large Numbers
Using Goal Seek The Quick Analysis Tools
Pasting Values From Formulas
Excel Advanced
- 1 day course
- Location: East Midlands
- Telephone on 01952 305730
- Course Outline
-
A one-day course covering Microsoft Excel advanced topics.
- Some of the training topics covered include ... Using the DMIN Function
- See Training Course Details...
Using an Advanced Filter
Testing a Validation
Understanding Data Protection
Using a Simple What-If Model
Setting the Default File Location
Adding a Combo Box Control
Viewing a Macro
Counting in a PivotTable
Using Compound Fields
Providing Restricted Access to Cells
Assigning a Macro to the Ribbon
Creating Nested Subtotals
Understanding Save Options
Deleting a Macro
Setting the Default Font
Working With an Outline
Defining the PivotTable Structure
Editing Worksheet Comments
Creating a Number Range Validation
Importing Comma Delimited Text
Email us about this courses
Other East Midlands Enable Technology Training Courses
SQL East Midlands Training Courses
Crystal 2011 - East Midlands Crystal Reports Training Courses
Report Builder East Midlands Training Courses
Oracle BI East Midlands Training Courses
JQuery - East Midlands JavaScript Training Courses
Crystal 2016 East Midlands Training Courses
SSAS Tabular East Midlands Training Courses
SSRS 2008 - East Midlands SQL Server Reporting Services Training Courses
SSAS 2014 East Midlands Training Courses
SSAS 2017 - East Midlands SQL Server Analysis Services Training Courses
Mobile East Midlands Training Courses
Visio 2013 - East Midlands Visio Training Courses
Microsoft Project Level 3 East Midlands Training Courses
Crystal 2008 East Midlands Training Courses
SSIS 2005 East Midlands Training Courses
HTML - East Midlands Web Development Training Courses
Access VBA - East Midlands Access Training Courses
JavaScript East Midlands Training Courses
SSIS 2014 East Midlands Training Courses
SSAS 2008 East Midlands Training Courses
Project 2016 L1 - East Midlands Microsoft Project Training Courses
Midlands - Possible Excel Training Course Locations
Walsall Excel Training Courses
Kenilworth Excel Training Courses
Leicester Excel Training Courses
Burton On Trent Excel Training Courses
Kidderminster Excel Training Courses
Cannock Excel Training Courses
Shropshire Excel Training Courses
West Bromwich Excel Training Courses
Stourbridge Excel Training Courses
Evesham Excel Training Courses
Warwickshire Excel Training Courses
Stourbridge Excel Training Courses
Nuneaton Excel Training Courses
West Midlands Excel Training Courses
Coventry Excel Training Courses
Leek Excel Training Courses
Bridgnorth Excel Training Courses
Staffordshire Excel Training Courses
Wednesbury Excel Training Courses
Atherstone Excel Training Courses
Cheltenham Excel Training Courses
Redditch Excel Training Courses
Nottingham Excel Training Courses
Birmingham Excel Training Courses
Hereford Excel Training Courses
Crewe Excel Training Courses
Derby Excel Training Courses
Uttoxeter Excel Training Courses
Tamworth Excel Training Courses
Tipton Excel Training Courses
Leamington Spa Excel Training Courses
Malvern Excel Training Courses
Rugeley Excel Training Courses
Oxford Excel Training Courses
Oswestry Excel Training Courses
Warwick Excel Training Courses
Staffordshire Excel Training Courses
Smethwick Excel Training Courses
Chester Excel Training Courses
Bromsgrove Excel Training Courses
Halesowen Excel Training Courses
Droitwich Excel Training Courses
Northhampton Excel Training Courses
Kidsgrove Excel Training Courses
Rowley Excel Training Courses
Black Country Excel Training Courses
Herefordshire Excel Training Courses
Solihull Excel Training Courses
Midlands Excel Training Courses
Telford Excel Training Courses
Stoke On Trent Excel Training Courses
Milton Keynes Excel Training Courses
Shrewsbury Excel Training Courses
Worcester Excel Training Courses
Stafford Excel Training Courses
Stratford Upon Avon Excel Training Courses
Lichfield Excel Training Courses
Sandwell Excel Training Courses
Newcastle Under Lyme Excel Training Courses
Worcestershire Excel Training Courses
Bedworth Excel Training Courses
Dudley Excel Training Courses
Leicestershire Excel Training Courses
Rugby Excel Training Courses
East Midlands Excel Training Courses
Wolverhampton Excel Training Courses
Walsall, Kenilworth, Leicester, Burton On Trent, Kidderminster, Cannock, Shropshire, West Bromwich, Stourbridge, Evesham, Warwickshire, Stourbridge, Nuneaton, West Midlands, Coventry, Leek, Bridgnorth, Staffordshire, Wednesbury, Atherstone, Cheltenham, Redditch, Nottingham, Birmingham, Hereford, Crewe, Derby, Uttoxeter, Tamworth, Tipton, Leamington Spa, Malvern, Rugeley, Oxford, Oswestry, Warwick, Staffordshire, Smethwick, Chester, Bromsgrove, Halesowen, Droitwich, Northhampton, Kidsgrove, Rowley, Black Country, Herefordshire, Solihull, Midlands, Telford, Stoke On Trent, Milton Keynes, Shrewsbury, Worcester, Stafford, Stratford Upon Avon, Lichfield, Sandwell, Newcastle Under Lyme, Worcestershire, Bedworth, Dudley, Leicestershire, Rugby, East Midlands, Wolverhampton