EXCEL TRAINING COURSES DONCASTER
About Enable Technology Doncaster Excel Training Courses
We have a twenty year history of providing skills based Excel industry training. The training will be delivered by a Microsoft professional with development experience. Every course participant will receives course practice files and Excel course resources that can be referenced post training. We also provide an ongoing support service to people attending our Excel courses. Delegates can contact the course tutor with specific Excel questions for as long as they need following the course.
Enable Technology Excel courses are instructor led and taught by an experienced Microsoft expert. Enable Technology can provide Excel courses onsite at your location. We will bring the necessary laptops with the required software installed. Alternatively we could schedule a course at a local socially distanced venue in Doncaster. The Excel syllabus can be adjusted and additional topics incorporated if helpful.
This instructor led Excel training is also available online. Participants can see the tutors screen, ask questions and share their screen with the tutor.
The Enable Technology group of companies has been operating continuously providing IT training since 1998. Some of our clients are Lloyds TSB Bank PLC, Wolverhampton City Council, Dollond & Aitchison Limited, Homeserve PLC, Aston University, Norfolk Police Constabulary, TalkTalk Direct Limited and Boots UK Limited.
Excel Power Pivot
- 1 day course
- Location: Doncaster
- 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 ... Power Pivot
- See Training Course Details...
Rearranging and Sorting Fields
Working With Data Model Fields
Understanding the Query Editor
Filtering Data
Working With the Data Model
Power View
Working With Time Settings
Tiling Data in Power View
The Advanced Editor
Working With Merged Queries
Working With Scenes
Adding Slicers Get & Transform
Transforming Data
Working With a Power View Object
Editing Query Steps
Working With Height and Category
Connecting to a Data Source
Understanding Power Map
Creating a New Query From a File
Microsoft Excel PowerPivot Data Analytic Expressions DAX Language
- 2 day course
- Location: Doncaster
- 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 ... Text Functions
- See Training Course Details...
Explaining Syntax
Date Functions
Aggregation Functions
Mathematical Functions
Understanding Values
Multiple Table Evaluation Context Working with Dates
Relational Functions Understanding Evaluation Contexts
Introduction to DAX
Utilizing Operators
Handling Errors Using DAX Functions
PowerPivot Data Model
Using Multiple Calendars Utilising Advanced DAX Functionality
Statistical Functions
Many-to-Many Relationships
Working with Calendars
Logical Functions
Information Functions
Introduction to DAX
Conversion Functions
Single Table Evaluation Context
Excel Programming Using VBA
- 2 day course
- Location: Doncaster
- 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 ... Introducing Visual Basic for Applications
- See Training Course Details...
Understanding VBA's Error Trapping Options
Understanding Data Types
Getting Started
Working with the PivotTable Objects
Understanding Objects
Understanding Expressions and Statements
Creating a Function Procedure
Using the Select Case...End Select Structure
Naming Procedures
Creating a PivotTable Using Worksheet Data
Using the If...End If Decision Structures
Debugging Code
Trapping Errors with the On Error Statement
Understanding Procedures
Using the For Each...Next Structure
Working with the PivotTable Object
Using Message Boxes
Setting Control Properties in the Properties Window
Running a Macro
Excel Intermediate
- 1 day course
- Location: Doncaster
- Telephone on 01952 305730
- Course Outline
-
A one day course covering Microsoft Excel Intermediate topics.
- Some of the training topics covered include ... Working With Colour Scales
- See Training Course Details...
Understanding Conditional
Using Built in Margins
Showing Data Labels
Formatting Text
Applying a Border to a Range
Understanding Sparklines
Nesting IF Functions
Removing Page Breaks
Hiding Rows and Columns
Adding a Chart Title
Defining Names for Constant Values
Formatting the Chart Area
Setting Custom Margins
Adding a Data Table Chart Object Formatting
Understanding Format Codes
More Complex Flash Fill Extractions
Changing Individual Bar Colours
Quick Sparklines
Unhiding a Worksheet
Microsoft Excel Power Query
- 1 day course
- Location: Doncaster
- 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 Power Query formulas.
- See Training Course Details...
Combining Worksheets
Understanding the Issues
Loading into Excel
Understanding and Handling Special Situations
Transforming Data
Grouping Options
Introduction to Power BI Desktop
Power Query Interface
Importing Data
Summarising WORKING WITH THE POWER QUERY LANGUAGE “M”
Data Sources GROUPING AND SUMMARISING WITH POWER QUERY
Performing Merges
Understand and perform importing from SQL Server Analysis Services Tabular. PERFORMING MERGES
Understand and utilize merges. LOADING YOUR DATA
Importing, Transforming, and Loading Data into Excel and Power Pivot
Using PivotTables CONNECTING TO DATABASES
Understand and perform importing from SQL Server Analysis Services Multidimensional.
Understand working with relational data.
Working with Folders and Files
Loading into Power Pivot
Excel Advanced
- 1 day course
- Location: Doncaster
- Telephone on 01952 305730
- Course Outline
-
A one-day course covering Microsoft Excel advanced topics.
- Some of the training topics covered include ... Changing Control Properties
- See Training Course Details...
Working With an Outline
Merging Scenarios PivotTables
Viewing a Macro
Assigning a Keyboard Shortcut to a Macro
Adding a Spin Button Control
Editing Worksheet Comments
Creating a Linked Consolidation
Setting Save Options
Creating Calculated Items
Running a Recorded Macro
Understanding Data Protection
Filtering a PivotTable
Sorting in a PivotTable PivotCharts
Running a Macro From the Toolbar
Password Protecting a Workbook
Exporting Data as Text
Importing Space Delimited Text
Using Compound Fields
Creating a Drop Down List
Using Subtotals With AutoFilter
Excel Basic
- 1 day course
- Location: Doncaster
- 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 ... Selecting Larger Ranges
- See Training Course Details...
Printing a Chart Sheet
Saving a New Workbook on Your Computer
Using the Thousands Separator
Using Fill for Quick Copying
Formulas That Multiply and Divide
Filling a Series
Vertical Cell Alignment
Printing a Help Topic
Making Cells Bold
Changing the Chart Type
Navigating Using the Keyboard
Understanding Functions
Changing Font Colours
Understanding the Backstage View
Launching Dialog Boxes
Using Wildcards Printing
Viewing Worksheet Gridlines
Changing the Chart Style
Inserting Rows Into a Worksheet
Creating Formulas That Add
Email us about this courses
Other Doncaster Enable Technology Training Courses
JavaScript Doncaster Training Courses
JQuery - Doncaster JavaScript Training Courses
SSAS 2017 - Doncaster SQL Server Analysis Services Training Courses
Data Mining Doncaster Training Courses
SSRS 2014 Doncaster Training Courses
SSIS 2008 - Doncaster SQL Server Integration Services Training Courses
SSAS 2005 - Doncaster SQL Server Analysis Services Training Courses
SSRS 2016 - Doncaster SQL Server Reporting Services Training Courses
Mobile Doncaster Training Courses
Microsoft Project Level 2 - Doncaster Microsoft Project Training Courses
TSQL - Doncaster SQL Training Courses
SSIS 2005 Doncaster Training Courses
Crystal 2016 Doncaster Training Courses
Power BI Doncaster Training Courses
SSAS Tabular Doncaster Training Courses
PowerPoint Basic - Doncaster Office Training Courses
Access 2016 Doncaster Training Courses
Visio 2013 Doncaster Training Courses
PL/SQL Doncaster Training Courses
Project 2016 Doncaster Training Courses
HTML Doncaster Training Courses
North - Possible Excel Training Course Locations
York Excel Training Courses
Bridlington Excel Training Courses
Dewsbury Excel Training Courses
Halifax Excel Training Courses
Scunthorpe Excel Training Courses
Pudsey Excel Training Courses
Huddersfield Excel Training Courses
Newcastle Upon Tyne Excel Training Courses
Wetherby Excel Training Courses
Harrogate Excel Training Courses
Doncaster Excel Training Courses
Castleford Excel Training Courses
Hartlepool Excel Training Courses
Sunderland Excel Training Courses
Sheffield Excel Training Courses
South Shields Excel Training Courses
Wakefield Excel Training Courses
North East Excel Training Courses
Gateshead Excel Training Courses
Grimsby Excel Training Courses
Normanton Excel Training Courses
Middlesbrough Excel Training Courses
Yorkshire Excel Training Courses
Scarborough Excel Training Courses
Hexham Excel Training Courses
Keighley Excel Training Courses
Barnsley Excel Training Courses
Batley Excel Training Courses
Durham Excel Training Courses
Rotherham Excel Training Courses
Leeds Excel Training Courses
York, Bridlington, Dewsbury, Halifax, Scunthorpe, Pudsey, Huddersfield, Newcastle Upon Tyne, Wetherby, Harrogate, Doncaster, Castleford, Hartlepool, Sunderland, Sheffield, South Shields, Wakefield, North East, Gateshead, Grimsby, Normanton, Middlesbrough, Yorkshire, Scarborough, Hexham, Keighley, Barnsley, Batley, Durham, Rotherham, Leeds