EXCEL TRAINING COURSES DERBY
About Enable Technology Derby Excel Training Courses
Enable Technology Excel courses are short, skill focused and hands on. We guarantee the training will be delivered by a Microsoft certified expert. All candidates receive comprehensive Excel training materials and practice files which are theirs to refer to after the course. If delegates have have questions about Excel after the course they are welcome to contact the course Tutor. This post training support is ongoing.
Excel training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. Enable Technology Excel courses can be delivered onsite at your premises. We bring a fully equipped training lab with us. The Excel course could also be scheduled at a socially distanced site near you in Derby. All Excel courses can be customised to meet your particular requirements.
We also deliver this course online through virtual classrooms. Delegates can join scheduled Excel classes, view the tutors demonstrations, ask questions and share their screen with the trainer if they need assistance.
The Enable group of companies has been delivering technical training principally in the Midlands region for twenty years. Some of our clients are Total Telecommunications Limited, EDF Energy PLC, Birmingham Heartlands Hospital, Birmingham City Council, Dollond & Aitchison Limited, Canadian High Commission, Barclays Bank PLC and National Power PLC.
Excel Power Pivot
- 1 day course
- Location: Derby
- 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 View
- See Training Course Details...
Working With Mapping Confidence
Updating a Power View Report
Exporting a Tour as a Video
Working With Time Settings
Formatting Data Model Fields
Creating a New Query From the Web
Working With Layers
Filtering in Power View
Working With Location Fields
Adding Power View to the Ribbon
Tiling Data in Power View
Working With Scene Options
Working With Power View Fields
Editing Query Steps
Adding a Data Column
Managing Data Columns
Creating a Data Model PivotTable
Transforming Data
Understanding Relational Data
Microsoft Excel PowerPivot Data Analytic Expressions DAX Language
- 2 day course
- Location: Derby
- 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 ... Relational Functions Understanding Evaluation Contexts
- See Training Course Details...
Using Multiple Calendars Utilising Advanced DAX Functionality
Logical Functions
Introduction to DAX
PowerPivot Data Model
Introduction to DAX
Mathematical Functions
Information Functions
Handling Errors Using DAX Functions
The CALCULATE Function
Multiple Table Evaluation Context Working with Dates
Aggregation Functions
Single Table Evaluation Context
Text Functions
Utilizing Operators
Date Functions
Filter Functions
Explaining Syntax
Statistical Functions
Working with Calendars
Excel Programming Using VBA
- 2 day course
- Location: Derby
- 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 ... Setting the Tab Order
- See Training Course Details...
Using Break Mode during Run mode
Working with Forms and Controls
Setting Breakpoints
Launching a Form in Code
Understanding Control-of-Flow Structures
Creating a PivotTable Using Worksheet Data
Understanding Macro Security
Using the For Each...Next Structure
Declaring Variables
Working with the Command Button Control
Understanding Procedures
Understanding Constants
Working with Inline Error Handling
Debugging Code
Creating a Function Procedure
Recording a Macro
Working with Variable Scope
Creating a Sub Procedure
Working with Boolean Expressions
Excel Advanced
- 1 day course
- Location: Derby
- Telephone on 01952 305730
- Course Outline
-
A one-day course covering Microsoft Excel advanced topics.
- Some of the training topics covered include ... Grouping by Columns Summarising and Subtotalling
- See Training Course Details...
Running a Macro With Relative References
Creating a Number Range Validation
Sorting in a PivotTable PivotCharts
Using Relative Names for Subtotals Data Consolidation
Using One-Variable Data Tables
Setting Save Options
Creating Scenarios
Finding the Difference From
Adding a Combo Box Control
Creating a One-Variable Table
Using DSUM
Inserting a Timeline Filter PivotTable Features
Creating Subtotals
Adding a Spin Button Control
Modifying an Inserted Picture Data Linking
Understanding Save Options
Using the PivotChart Filter Field Buttons
Working With a Protected Worksheet
Creating Your Own PivotTable
Changing the PivotChart Type
Excel Basic
- 1 day course
- Location: Derby
- 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 ... Filling a Growth Series
- See Training Course Details...
Indenting Cells
Starting Excel From the Desktop
Understanding the Backstage View
Viewing the Formula Bar
Vertical Cell Alignment
Approximating Row Height
Relative Formulas
Typing Text
Multiple Value Filters
Calculating an Average
Selecting Larger Ranges
Overwriting Cell Contents
Recent Files and Folders Editing in a Workbook
Understanding How Help Works
Increasing and Decreasing Decimals Row and Column Formatting
Safely Closing a Workbook Working With Workbooks
Using the Ribbon
Typing Numbers
Printing an Entire Workbook
What if Formulas
Microsoft Excel Power Query
- 1 day course
- Location: Derby
- 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 ... Using PivotTables CONNECTING TO DATABASES
- See Training Course Details...
Understanding Data Types WORKING WITH CSV, TXT AND EXCEL WORKSHEETS
Loading into Power Pivot
Understanding and Handling Special Situations
Grouping Options
Power Query Interface
Importing Data
Understand Power Query formulas.
Loading into Power BI Desktop
Loading into Excel
Performing Merges
Importing, Transforming, and Loading Data into Excel and Power Pivot
Understand the M interface.
Loading Data
Understand and utilize merges. LOADING YOUR DATA
Course topics include- INTRODUCTION TO POWER QUERY
Combining Worksheets
Appending Operations
Using Ranges in Excel
Understand working with relational data.
Understand and perform importing from SQL Server Analysis Services Tabular. PERFORMING MERGES
Excel Intermediate
- 1 day course
- Location: Derby
- Telephone on 01952 305730
- Course Outline
-
A one day course covering Microsoft Excel Intermediate topics.
- Some of the training topics covered include ... Inserting Table Columns
- See Training Course Details...
Creating a Table From Scratch
The CHOOSE Function
Adding More Complexity
Manipulative Functions
Switching to Manual Recalculation
Using Names in Typed Formulas
Using IF With Text
Using Page Break Preview
Formatting Cells Containing Values
Understanding Defined Names
Nesting IF Functions
The PMT Function Complex Formulas
Applying Names to Existing Formulas
Understanding Goal Seeking
Scaling to a Percentage
Fit to a Specific Number of Pages Applying Borders
Understanding Page Layout
Unhiding Rows and Columns
Creating Names Using the Name Box
Splitting a Table
Email us about this courses
Other Derby Enable Technology Training Courses
PowerPoint Basic - Derby Office Training Courses
PHP - Derby PHP Training Courses
Power BI Derby Training Courses
Crystal 2013 Derby Training Courses
SSRS 2008 Derby Training Courses
Oracle SQL Derby Training Courses
JQuery Derby Training Courses
PowerPoint Advanced - Derby Office Training Courses
Microsoft Project Level 2 Derby Training Courses
HTML - Derby Web Development Training Courses
SSIS 2005 Derby Training Courses
Report Builder Derby Training Courses
Power Graphics Derby Training Courses
Microsoft Project Level 3 Derby Training Courses
SSAS Tabular - Derby SQL Server Analysis Services Training Courses
SSRS 2014 - Derby SQL Server Reporting Services Training Courses
Project 2016 L1 Derby Training Courses
SSAS 2014 Derby Training Courses
Data Warehouse - Derby SQL Training Courses
TSQL Derby Training Courses
Crystal 2011 - Derby Crystal Reports Training Courses
Midlands - Possible Excel Training Course Locations
Staffordshire Excel Training Courses
Telford Excel Training Courses
Stourbridge Excel Training Courses
Warwickshire Excel Training Courses
Crewe Excel Training Courses
Tamworth Excel Training Courses
Redditch Excel Training Courses
Derby Excel Training Courses
Tipton Excel Training Courses
Herefordshire Excel Training Courses
Stoke On Trent Excel Training Courses
Rowley Excel Training Courses
Worcester Excel Training Courses
Lichfield Excel Training Courses
West Midlands Excel Training Courses
Warwick Excel Training Courses
Atherstone Excel Training Courses
Kenilworth Excel Training Courses
Wednesbury Excel Training Courses
Uttoxeter Excel Training Courses
Bromsgrove Excel Training Courses
Milton Keynes Excel Training Courses
Dudley Excel Training Courses
Malvern Excel Training Courses
Oxford Excel Training Courses
Walsall Excel Training Courses
Bridgnorth Excel Training Courses
Coventry Excel Training Courses
Cheltenham Excel Training Courses
Nuneaton Excel Training Courses
Leamington Spa Excel Training Courses
Birmingham Excel Training Courses
Leicestershire Excel Training Courses
Chester Excel Training Courses
Leek Excel Training Courses
Sandwell Excel Training Courses
Nottingham Excel Training Courses
Droitwich Excel Training Courses
Cannock Excel Training Courses
East Midlands Excel Training Courses
Kidderminster Excel Training Courses
Wolverhampton Excel Training Courses
Black Country Excel Training Courses
Shropshire Excel Training Courses
Solihull Excel Training Courses
Stafford Excel Training Courses
Newcastle Under Lyme Excel Training Courses
Bedworth Excel Training Courses
Worcestershire Excel Training Courses
Rugeley Excel Training Courses
Stratford Upon Avon Excel Training Courses
Midlands Excel Training Courses
Oswestry Excel Training Courses
Northhampton Excel Training Courses
Shrewsbury Excel Training Courses
Rugby Excel Training Courses
Burton On Trent Excel Training Courses
Evesham Excel Training Courses
Smethwick Excel Training Courses
Kidsgrove Excel Training Courses
West Bromwich Excel Training Courses
Hereford Excel Training Courses
Halesowen Excel Training Courses
Stourbridge Excel Training Courses
Leicester Excel Training Courses
Staffordshire Excel Training Courses
Staffordshire, Telford, Stourbridge, Warwickshire, Crewe, Tamworth, Redditch, Derby, Tipton, Herefordshire, Stoke On Trent, Rowley, Worcester, Lichfield, West Midlands, Warwick, Atherstone, Kenilworth, Wednesbury, Uttoxeter, Bromsgrove, Milton Keynes, Dudley, Malvern, Oxford, Walsall, Bridgnorth, Coventry, Cheltenham, Nuneaton, Leamington Spa, Birmingham, Leicestershire, Chester, Leek, Sandwell, Nottingham, Droitwich, Cannock, East Midlands, Kidderminster, Wolverhampton, Black Country, Shropshire, Solihull, Stafford, Newcastle Under Lyme, Bedworth, Worcestershire, Rugeley, Stratford Upon Avon, Midlands, Oswestry, Northhampton, Shrewsbury, Rugby, Burton On Trent, Evesham, Smethwick, Kidsgrove, West Bromwich, Hereford, Halesowen, Stourbridge, Leicester, Staffordshire