EXCEL TRAINING COURSES SOLIHULL
About Enable Technology Solihull Excel Training Courses
We have a twenty year history of providing skills based Excel industry training. The tutor teaching the course will be an experienced developer and Microsoft certified professional. Everyone attending a Excel course receives learning resources which also serves as a reference source after the course. Course participants are welcome contact the Tutor after the course with specific Excel queries. This support is open ended.
We provide instructor led training coupled with hands on training. We can bring the equipment necessary to deliver Excel courses at your site. Alternatively we could schedule a course at a local socially distanced venue in Solihull. We are more than happy to incorporate additional topics to accommodate your organisations Excel training needs.
This course can also be 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.
The Enable group of companies has been delivering technical training principally in the Midlands region for twenty years. Some of our clients are Queen's Medical Centre Nottingham, West Bromwich Building Society, Loughborough University, EDF Energy PLC, Fujistu PLC, Halfords Group PLC, TalkTalk Direct Limited and Keele University.
Microsoft Excel Power Query
- 1 day course
- Location: Solihull
- 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
- See Training Course Details...
Summarising WORKING WITH THE POWER QUERY LANGUAGE “M”
Importing Data
Appending Operations
Understand and utilize merges. LOADING YOUR DATA
Introduction to Power BI Desktop
Understand and perform importing from SQL Server Analysis Services Multidimensional.
Using PivotTables CONNECTING TO DATABASES
Loading into Excel
Using Ranges in Excel
Course topics include- INTRODUCTION TO POWER QUERY
Understand Power Query formulas.
Data Sources GROUPING AND SUMMARISING WITH POWER QUERY
Loading Data
Loading into Power Pivot
Understanding the Issues
Loading into Power BI Desktop
Understanding and Handling Special Situations
Working with Folders and Files
Power Query Interface
Importing, Transforming, and Loading Data into Excel and Power Pivot
Excel Programming Using VBA
- 2 day course
- Location: Solihull
- 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
- See Training Course Details...
Understanding Control-of-Flow Structures
Declaring and Using Object Variables
Navigating the Excel Object Hierarchy
Working with Forms and Controls
Understanding UserForms
Guidelines for use of Control-of-Flow Structures
Populating a Control
Setting Control Properties in the Properties Window
Understanding Modules
Working with Procedures and Functions
Using the Object Browser
Adding Code to Controls
Understanding Macro Security
Determining the Value of Expressions
Working with the Frame Control
Understanding Procedures
Displaying the Developer Tab in the Ribbon
Excel Advanced
- 1 day course
- Location: Solihull
- Telephone on 01952 305730
- Course Outline
-
A one-day course covering Microsoft Excel advanced topics.
- Some of the training topics covered include ... Formatting PivotTable Values
- See Training Course Details...
Moving PivotCharts to Chart Sheets Advanced Filters
Formatting a PivotTable
Creating a One-Variable Table
Exporting to Microsoft Word
Adding a List Box Control
Understanding Data Protection
Creating Calculated Items
Understanding Data Validation
Using the PivotChart Filter Field Buttons
Understanding Grouping and Outlining
Removing Invalid Circles
Defining the PivotTable Structure
Understanding Data Linking
Exporting Data as Text
Understanding How Controls Work
Finding the Percentage of Total
Disabling Worksheet Protection
Creating Scenarios
Assigning a Keyboard Shortcut to a Macro
Setting Advanced Options Protecting Data
Microsoft Excel PowerPivot Data Analytic Expressions DAX Language
- 2 day course
- Location: Solihull
- 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...
Introduction to DAX
Exploring Data Types
Handling Errors Using DAX Functions
Utilizing Operators
Aggregation Functions
Logical Functions
Mathematical Functions
Understanding Values
Explaining Syntax
Single Table Evaluation Context
Date Functions
Using Multiple Calendars Utilising Advanced DAX Functionality
PowerPivot Data Model
Statistical Functions
Filter Functions
Introduction to DAX
Text Functions
Relational Functions Understanding Evaluation Contexts
Information Functions
Conversion Functions
Excel Basic
- 1 day course
- Location: Solihull
- 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 ... Using Go To
- See Training Course Details...
Deleting Rows and Columns
Launching Dialog Boxes
Using Undo and Redo Selecting Ranges
Printing an Embedded Chart
Approximating Row Height
Getting to Know Excel
Accessing the Backstage View
Editing Formulas
Using Wildcards Printing
Working With Live Preview
Understanding the Backstage View
Using the SUM Function to Add
Editing Longer Cells
Moving Cells and Ranges
Creating Absolute References
Creating Custom Filters
Filling a Series
Changing Font Colours
Saving a New Workbook on Your Computer
Excel Intermediate
- 1 day course
- Location: Solihull
- Telephone on 01952 305730
- Course Outline
-
A one day course covering Microsoft Excel Intermediate topics.
- Some of the training topics covered include ... Strategies for Printing Worksheets
- See Training Course Details...
Setting Custom Margins
Using the More Borders Command
Applying a Border to a Cell
Fit to a Specific Number of Pages Applying Borders
Filling a Series
Splitting a Table
Unhiding a Worksheet
Formulas
Specifying the Paper Size
Adding a Trendline
Workbook
Removing Borders
Formatting Text
Understanding Borders
Working With Data Bars
Moving a Worksheet
Centring on a Page
More Top and Bottom Formatting
The DATE Function
Removing Table Columns
Excel Power Pivot
- 1 day course
- Location: Solihull
- 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 ... Adding Power View to the Ribbon
- See Training Course Details...
Formatting Data Model Fields
Understanding Relational Data
The Advanced Editor
Working With Scene Options
Working With Mapping Confidence
Working With Scenes
Adding More Power Views
Working With Power View Fields
Working With the Data Model
Working With Layers
Creating a Timeline
Viewing and Editing a Tour
Using Related Power Pivot Fields
Rearranging and Sorting Fields
Managing Data Columns
Power Map
Understanding Power Map
Understanding Power Pivot
Working With Merged Queries
Email us about this courses
Other Solihull Enable Technology Training Courses
PL/SQL - Solihull SQL Training Courses
SSRS 2014 Solihull Training Courses
JavaScript - Solihull JavaScript Training Courses
CSS - Solihull Web Development Training Courses
Project 2016 L1 - Solihull Microsoft Project Training Courses
Crystal 2016 Solihull Training Courses
TSQL - Solihull SQL Training Courses
Access VBA - Solihull Access Training Courses
HTML - Solihull Web Development Training Courses
Crystal 2008 Solihull Training Courses
Report Builder - Solihull SQL Server Reporting Services Training Courses
Mobile - Solihull Web Development Training Courses
Visio 2013 Solihull Training Courses
Microsoft Project Level 3 Solihull Training Courses
Oracle SQL Solihull Training Courses
Crystal 2013 - Solihull Crystal Reports Training Courses
Access 2016 Solihull Training Courses
Oracle BI - Solihull Data Analytics Training Courses
SSRS 2016 Solihull Training Courses
SSIS 2005 Solihull Training Courses
SSAS 2005 - Solihull SQL Server Analysis Services Training Courses
Midlands - Possible Excel Training Course Locations
Wolverhampton Excel Training Courses
Rugeley Excel Training Courses
Worcestershire Excel Training Courses
Leamington Spa Excel Training Courses
Bedworth Excel Training Courses
Stafford Excel Training Courses
Smethwick Excel Training Courses
Droitwich Excel Training Courses
Derby Excel Training Courses
Nottingham Excel Training Courses
Telford Excel Training Courses
Warwick Excel Training Courses
Malvern Excel Training Courses
Chester Excel Training Courses
Birmingham Excel Training Courses
Bromsgrove Excel Training Courses
Kidsgrove Excel Training Courses
Kenilworth Excel Training Courses
Burton On Trent Excel Training Courses
Leicestershire Excel Training Courses
Evesham Excel Training Courses
Tamworth Excel Training Courses
Dudley Excel Training Courses
Midlands Excel Training Courses
Oxford Excel Training Courses
Newcastle Under Lyme Excel Training Courses
Milton Keynes Excel Training Courses
Warwickshire Excel Training Courses
Atherstone Excel Training Courses
Stoke On Trent Excel Training Courses
Coventry Excel Training Courses
Shrewsbury Excel Training Courses
Hereford Excel Training Courses
Herefordshire Excel Training Courses
Rugby Excel Training Courses
Shropshire Excel Training Courses
Staffordshire Excel Training Courses
Solihull Excel Training Courses
Worcester Excel Training Courses
Leicester Excel Training Courses
West Bromwich Excel Training Courses
Kidderminster Excel Training Courses
Oswestry Excel Training Courses
Walsall Excel Training Courses
East Midlands Excel Training Courses
Redditch Excel Training Courses
Cheltenham Excel Training Courses
Northhampton Excel Training Courses
Cannock Excel Training Courses
Halesowen Excel Training Courses
Stourbridge Excel Training Courses
Lichfield Excel Training Courses
Nuneaton Excel Training Courses
West Midlands Excel Training Courses
Black Country Excel Training Courses
Stratford Upon Avon Excel Training Courses
Tipton Excel Training Courses
Crewe Excel Training Courses
Staffordshire Excel Training Courses
Bridgnorth Excel Training Courses
Wednesbury Excel Training Courses
Rowley Excel Training Courses
Uttoxeter Excel Training Courses
Stourbridge Excel Training Courses
Leek Excel Training Courses
Sandwell Excel Training Courses
Wolverhampton, Rugeley, Worcestershire, Leamington Spa, Bedworth, Stafford, Smethwick, Droitwich, Derby, Nottingham, Telford, Warwick, Malvern, Chester, Birmingham, Bromsgrove, Kidsgrove, Kenilworth, Burton On Trent, Leicestershire, Evesham, Tamworth, Dudley, Midlands, Oxford, Newcastle Under Lyme, Milton Keynes, Warwickshire, Atherstone, Stoke On Trent, Coventry, Shrewsbury, Hereford, Herefordshire, Rugby, Shropshire, Staffordshire, Solihull, Worcester, Leicester, West Bromwich, Kidderminster, Oswestry, Walsall, East Midlands, Redditch, Cheltenham, Northhampton, Cannock, Halesowen, Stourbridge, Lichfield, Nuneaton, West Midlands, Black Country, Stratford Upon Avon, Tipton, Crewe, Staffordshire, Bridgnorth, Wednesbury, Rowley, Uttoxeter, Stourbridge, Leek, Sandwell