EXCEL TRAINING COURSES STRATFORD UPON AVON
About Enable Technology Stratford Upon Avon Excel Training Courses
Enable Technology has twenty year track record of providing short intensive Excel skills based training courses. All of our tutors are Microsoft Certified Professionals. Every course participant is given Excel courseware which they can refer to after the training. Course participants are welcome contact the Tutor after the course with specific Excel queries. This support is open ended.
Courses are instructor led and groups sizes small. Enable Technology Excel training courses can be delivered at your offices. We can supply the necessary software and computers. Alternatively we could schedule a course at a local socially distanced venue in Stratford Upon Avon. The Excel syllabus can be adjusted and additional topics incorporated if helpful.
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 two decades of delivering technical training predominantly in the West Midlands. Our clients include: Homeserve PLC, Boots UK Limited, South Staffordshire Water PLC, Halfords Group PLC, University of Birmingham, Nuclear Engineering Services, Wolverhampton City Council and Birmingham City Council.
Microsoft Excel Power Query
- 1 day course
- Location: Stratford Upon Avon
- 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 ... Data Sources GROUPING AND SUMMARISING WITH POWER QUERY
- See Training Course Details...
Using Ranges in Excel
Using PivotTables CONNECTING TO DATABASES
Understand and utilize merges. LOADING YOUR DATA
Performing Merges
Loading into Power Pivot
Power Query Interface
Appending Operations
Understand and perform importing from SQL Server Analysis Services Multidimensional.
Course topics include- INTRODUCTION TO POWER QUERY
Loading into Excel
Importing, Transforming, and Loading Data into Excel and Power Pivot
Summarising WORKING WITH THE POWER QUERY LANGUAGE “M”
Loading Data
Loading into Power BI Desktop
Understand Power Query formulas.
Importing Data
Transforming Data
Understanding Data Types WORKING WITH CSV, TXT AND EXCEL WORKSHEETS
Understand working with relational data.
Understand and perform importing from SQL Server Analysis Services Tabular. PERFORMING MERGES
Excel Intermediate
- 1 day course
- Location: Stratford Upon Avon
- Telephone on 01952 305730
- Course Outline
-
A one day course covering Microsoft Excel Intermediate topics.
- Some of the training topics covered include ... The PMT Function Complex Formulas
- See Training Course Details...
Copying a Worksheet
Changing the Colour of a Series
Creating a Table From Scratch
Values Conditional Formatting
Exploding Pie Slices
Creating Names From a Selection
Changing Column Colour Schemes
Colouring the Chart Background
Settings Rows as Repeating Print
Using Names to Select Ranges
Adding a Trendline
Changing WordArt Fill
Formatting With WordArt
Using IF With Text
Printing Gridlines
Applying Alternate Date Formats
Understanding Goal Seeking
Clearing the Print Area
Using the Name Manager
Customising the Display of Negative
Excel Basic
- 1 day course
- Location: Stratford Upon Avon
- 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 ... Viewing Worksheet Gridlines
- See Training Course Details...
Horizontal Cell Alignment
Specifying the Number of Copies
Accessing the Help Window
Printing a Range
Editing Formulas
What if Formulas
Understanding Formulas
Understanding the Status Bar
Understanding Number Formatting
Accessing the Backstage View
Selecting Rows
Setting Precise Columns Widths
Understanding Font Formatting
Using the Format Painter Cell Alignment
Formulas That Multiply and Divide
Inserting Columns Into a Worksheet
Multiple Value Filters
Finding a Maximum Value
Understanding Worksheets
Underlining Text
Excel Power Pivot
- 1 day course
- Location: Stratford Upon Avon
- 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 ... Connecting to a Data Source
- See Training Course Details...
Saving and Sharing Queries
Changing the Look
Understanding Power Map
Enabling Power View
Understanding Power Pivot
Editing Query Steps
Working With Data Model Fields
Changing a Power Pivot View
Switching Visualisations
Rearranging and Sorting Fields
Working With the Data Model
Tiling Data in Power View
Enabling Power Pivot
Updating a Power View Report
Working With Scene Options
Power Map
Adding More Power Views
Working With a Power View Object
Transforming Data
Microsoft Excel PowerPivot Data Analytic Expressions DAX Language
- 2 day course
- Location: Stratford Upon Avon
- 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 ... Working with Calendars
- See Training Course Details...
Logical Functions
PowerPivot Data Model
Explaining Syntax
Using Multiple Calendars Utilising Advanced DAX Functionality
Aggregation Functions
Date Functions
Relational Functions Understanding Evaluation Contexts
Mathematical Functions
Information Functions
Utilizing Operators
Introduction to DAX
Handling Errors Using DAX Functions
The CALCULATE Function
Statistical Functions
Many-to-Many Relationships
Multiple Table Evaluation Context Working with Dates
Conversion Functions
Filter Functions
Introduction to DAX
Excel Advanced
- 1 day course
- Location: Stratford Upon Avon
- Telephone on 01952 305730
- Course Outline
-
A one-day course covering Microsoft Excel advanced topics.
- Some of the training topics covered include ... Deleting a Macro
- See Training Course Details...
Providing Total Access to Cells
Understanding Text File Formats
Defining the PivotChart Structure
Sorting in a PivotTable PivotCharts
Protecting a Worksheet With Controls Sharing Workbooks
Assigning a Macro to the Ribbon
Working With PivotTable Grand Totals
Sharing Workbooks via the Network
Understanding Types of Controls
Importing From an Earlier Version
Recording a Simple Macro
Using a Subtotalled Worksheet
Understanding Data Protection
Setting Excel Options
Working With a Protected Worksheet
Setting Formula Options
Understanding Scenarios
Providing Restricted Access to Cells
Linking Between Workbooks
Running a Recorded Macro
Excel Programming Using VBA
- 2 day course
- Location: Stratford Upon Avon
- 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 ... Closing the Visual Basic Editor
- See Training Course Details...
Understanding Controls
Working with the PivotTable Object
Using the Object Browser
Determining the Value of Expressions
Running a Macro
Working with UserForm Properties, Events, and Methods
Working with Control Appearance
Understanding Constants
Debugging Code
Understanding Objects
Using the Toolbox
Using Intrinsic Constants
Writing an Error-Handling Routine
Creating an Event Procedure
Recording a Macro
Working with the Text Box Control
Working with Forms and Controls
Understanding the Development Environment
Understanding Macro Security
Working with the PivotTable Objects
Email us about this courses
Other Stratford Upon Avon Enable Technology Training Courses
Power Graphics Stratford Upon Avon Training Courses
PowerPoint Basic Stratford Upon Avon Training Courses
Data Mining - Stratford Upon Avon Data Analytics Training Courses
SSRS 2014 Stratford Upon Avon Training Courses
Microsoft Project Level 3 - Stratford Upon Avon Microsoft Project Training Courses
SSRS 2008 Stratford Upon Avon Training Courses
SSIS 2014 - Stratford Upon Avon SQL Server Integration Services Training Courses
JQuery Mobile - Stratford Upon Avon JavaScript Training Courses
PHP - Stratford Upon Avon PHP Training Courses
SSAS Tabular - Stratford Upon Avon SQL Server Analysis Services Training Courses
Oracle SQL Stratford Upon Avon Training Courses
SSRS 2005 Stratford Upon Avon Training Courses
SSAS 2014 Stratford Upon Avon Training Courses
JavaScript - Stratford Upon Avon JavaScript Training Courses
Access VBA Stratford Upon Avon Training Courses
PL/SQL Stratford Upon Avon Training Courses
Oracle BI - Stratford Upon Avon Data Analytics Training Courses
SSIS 2008 - Stratford Upon Avon SQL Server Integration Services Training Courses
TSQL - Stratford Upon Avon SQL Training Courses
Microsoft Project Level 2 - Stratford Upon Avon Microsoft Project Training Courses
Crystal XI - Stratford Upon Avon Crystal Reports Training Courses
Midlands - Possible Excel Training Course Locations
Rowley Excel Training Courses
Uttoxeter Excel Training Courses
Solihull Excel Training Courses
Burton On Trent Excel Training Courses
Oxford Excel Training Courses
East Midlands Excel Training Courses
Kenilworth Excel Training Courses
Leamington Spa Excel Training Courses
Birmingham Excel Training Courses
Nottingham Excel Training Courses
Worcestershire Excel Training Courses
Kidsgrove Excel Training Courses
Oswestry Excel Training Courses
Wednesbury Excel Training Courses
Stafford Excel Training Courses
Staffordshire Excel Training Courses
Rugby Excel Training Courses
Dudley Excel Training Courses
Worcester Excel Training Courses
Lichfield Excel Training Courses
Midlands Excel Training Courses
Rugeley Excel Training Courses
Nuneaton Excel Training Courses
Malvern Excel Training Courses
Atherstone Excel Training Courses
Droitwich Excel Training Courses
Smethwick Excel Training Courses
Coventry Excel Training Courses
Kidderminster Excel Training Courses
Stoke On Trent Excel Training Courses
Sandwell Excel Training Courses
Stourbridge Excel Training Courses
Bromsgrove Excel Training Courses
Derby Excel Training Courses
Chester Excel Training Courses
Newcastle Under Lyme Excel Training Courses
Northhampton Excel Training Courses
Leicestershire Excel Training Courses
Milton Keynes Excel Training Courses
Leek Excel Training Courses
West Bromwich Excel Training Courses
Halesowen Excel Training Courses
Wolverhampton Excel Training Courses
Redditch Excel Training Courses
Telford Excel Training Courses
Leicester Excel Training Courses
Bedworth Excel Training Courses
West Midlands Excel Training Courses
Black Country Excel Training Courses
Tamworth Excel Training Courses
Staffordshire Excel Training Courses
Stourbridge Excel Training Courses
Hereford Excel Training Courses
Tipton Excel Training Courses
Warwickshire Excel Training Courses
Herefordshire Excel Training Courses
Bridgnorth Excel Training Courses
Stratford Upon Avon Excel Training Courses
Evesham Excel Training Courses
Warwick Excel Training Courses
Cannock Excel Training Courses
Cheltenham Excel Training Courses
Walsall Excel Training Courses
Shropshire Excel Training Courses
Crewe Excel Training Courses
Shrewsbury Excel Training Courses
Rowley, Uttoxeter, Solihull, Burton On Trent, Oxford, East Midlands, Kenilworth, Leamington Spa, Birmingham, Nottingham, Worcestershire, Kidsgrove, Oswestry, Wednesbury, Stafford, Staffordshire, Rugby, Dudley, Worcester, Lichfield, Midlands, Rugeley, Nuneaton, Malvern, Atherstone, Droitwich, Smethwick, Coventry, Kidderminster, Stoke On Trent, Sandwell, Stourbridge, Bromsgrove, Derby, Chester, Newcastle Under Lyme, Northhampton, Leicestershire, Milton Keynes, Leek, West Bromwich, Halesowen, Wolverhampton, Redditch, Telford, Leicester, Bedworth, West Midlands, Black Country, Tamworth, Staffordshire, Stourbridge, Hereford, Tipton, Warwickshire, Herefordshire, Bridgnorth, Stratford Upon Avon, Evesham, Warwick, Cannock, Cheltenham, Walsall, Shropshire, Crewe, Shrewsbury