EXCEL TRAINING COURSES PRESTON
About Enable Technology Preston Excel Training Courses
Enable Technology specialise in succinct skills based Excel training. We guarantee the training will be delivered by a Microsoft certified expert. Every person attending a Excel course will be provided with training materials and practice files to retain after the course. Our policy is to provide open ended Excel post training support to participants. This additional service is an important part ofhow we help people implement the skills they have learned in the workplace.
Enable Technology offers instructor led training taught by technology specialists. Our Excel training courses can be delivered onsite at your location. You simply need to provide a room. We can supply the equipment and software. Alternatively we could schedule a Excel course at an alternative training site in Preston. We are happy to discuss customising the course content should you have particular Excel training requirements.
Excel courses are also available online. Delegates join a virtual classroom and participate in a real time instructor led course. Delegates can see the tutors screen, ask questions real time and share their screen with the tutor.
Our teaching team have over twenty years continuous technical training experience. Our clients include: Carillion PLC, Birmingham City Council, Halfords Group PLC, Vodafone Group Services, Homeserve PLC, National Power PLC, Royal & Sun Alliance Group PLC and Countrywide Homes Limited.
Excel Programming Using VBA
- 2 day course
- Location: Preston
- 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 ... Understanding Control-of-Flow Structures
- See Training Course Details...
Understanding Objects
Debugging Code
Working with the PivotTable Objects
Using Intrinsic Functions
Working with Forms and Controls
Working with Procedures and Functions
Using the For...To...Next Structure
Recording a Macro
Trapping Errors with the On Error Statement
Understanding Expressions and Statements
Understanding Errors
Assigning a Macro to the Quick Access Toolbar
Understanding PivotTables
Writing an Error-Handling Routine
Running a Macro
Using Break Mode during Run mode
Working with the PivotFields Collection
Populating a Control
Stepping through Code
Excel Power Pivot
- 1 day course
- Location: Preston
- 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 ... Creating a Power View Sheet
- See Training Course Details...
Adding Power View to the Ribbon
Creating a Timeline
Working With Data Model Fields
Understanding Relational Data
Working With Time Settings
Understanding Power Pivot
Adding More Power Views
Transforming Data
Working With Layers
Working With Measure Fields
Creating a New Query From a File
Changing a Power Pivot View
Power Pivot
Working With Merged Queries
Working With Height and Category
Working With Scene Options
The Advanced Editor
Understanding Power Map
Using Calculated Fields
Enabling Power Pivot
Excel Basic
- 1 day course
- Location: Preston
- 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 ... Copying From One Cell to Another
- See Training Course Details...
Formatting as Fractions
Launching Dialog Boxes
Increasing and Decreasing Decimals Row and Column Formatting
Understanding Cell Alignment
Understanding the Excel Start Screen
Printing a Help Topic
Performing an Alphabetical Sort
Typing Dates
Resizing a Chart
Safely Closing a Workbook Working With Workbooks
Extracting With Flash Fill Moving Data
Getting to Know Excel
Setting Precise Columns Widths
Understanding the Quick Access Toolbar
Viewing Worksheet Gridlines
Vertical Cell Alignment
Understanding Printing
Adding Commands to the QAT
Approximating Row Height
Creating Mixed References Font Formatting
Microsoft Excel PowerPivot Data Analytic Expressions DAX Language
- 2 day course
- Location: Preston
- 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 ... Mathematical Functions
- See Training Course Details...
Utilizing Operators
Statistical Functions
Filter Functions
Multiple Table Evaluation Context Working with Dates
Introduction to DAX
Using Multiple Calendars Utilising Advanced DAX Functionality
Text Functions
Date Functions
The CALCULATE Function
Information Functions
Working with Calendars
Many-to-Many Relationships
Conversion Functions
Single Table Evaluation Context
Exploring Data Types
Handling Errors Using DAX Functions
Understanding Values
Introduction to DAX
Relational Functions Understanding Evaluation Contexts
Logical Functions
Excel Advanced
- 1 day course
- Location: Preston
- Telephone on 01952 305730
- Course Outline
-
A one-day course covering Microsoft Excel advanced topics.
- Some of the training topics covered include ... Creating Slicers
- See Training Course Details...
Using Subtotals With AutoFilter
Setting Advanced Options Protecting Data
Creating Calculated Items
Understanding PivotTables
Defining the PivotChart Structure
Working With a Protected Worksheet
Understanding Excel Macros
Understanding Excel Options
Sharing Workbooks via OneDrive
Creating Calculated Fields
Setting the Default Font
Exporting Data as Text
Creating a Number Range Validation
Removing Invalid Circles
Creating an Error Message
Switching PivotTable Fields
Filtering a PivotTable
Using DSUM
Extracting Records With Advanced Filter
Using a Simple What-If Model
Microsoft Excel Power Query
- 1 day course
- Location: Preston
- 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 ... Understanding Data Types WORKING WITH CSV, TXT AND EXCEL WORKSHEETS
- See Training Course Details...
Understanding and Handling Special Situations
Understanding the Issues
Loading Data
Appending Operations
Combining Worksheets
Loading into Excel
Course topics include- INTRODUCTION TO POWER QUERY
Introduction to Power BI Desktop
Understand and utilize merges. LOADING YOUR DATA
Data Sources GROUPING AND SUMMARISING WITH POWER QUERY
Loading into Power BI Desktop
Using PivotTables CONNECTING TO DATABASES
Power Query Interface
Transforming Data
Grouping Options
Understand and perform importing from SQL Server Analysis Services Tabular. PERFORMING MERGES
Summarising WORKING WITH THE POWER QUERY LANGUAGE “M”
Using Ranges in Excel
Importing, Transforming, and Loading Data into Excel and Power Pivot
Understand Power Query formulas.
Excel Intermediate
- 1 day course
- Location: Preston
- Telephone on 01952 305730
- Course Outline
-
A one day course covering Microsoft Excel Intermediate topics.
- Some of the training topics covered include ... Clearing the Background
- See Training Course Details...
Using Names to Select Ranges
Formatting Text
Working With Colour Scales
Scoping a Formula
Splitting Windows Page Setup
Editing Sparklines Goal Seeking
Hiding Rows and Columns
Understanding Chart Formatting
Centring on a Page
Customising the Display of Negative
Copying Nested Functions
The MOD Function
The ROUND Function
Quick Formatting
Applying a Border to a Cell
Filling a Series Backwards
Scoping Names to a Worksheet
Formatting Calculated Time
Adding a Chart Title
Defining Names From Worksheet
Email us about this courses
Other Preston Enable Technology Training Courses
PHP Preston Training Courses
SSAS 2005 Preston Training Courses
Crystal 2011 Preston Training Courses
SSAS 2008 - Preston SQL Server Analysis Services Training Courses
Visio 2013 Preston Training Courses
Microsoft Project Level 2 - Preston Microsoft Project Training Courses
PowerPoint Advanced - Preston Office Training Courses
HTML Preston Training Courses
Microsoft Project Level 3 - Preston Microsoft Project Training Courses
SSRS 2005 Preston Training Courses
SSAS 2014 Preston Training Courses
Power BI Preston Training Courses
SSIS 2008 - Preston SQL Server Integration Services Training Courses
Access VBA - Preston Access Training Courses
SQL - Preston SQL Training Courses
JavaScript - Preston JavaScript Training Courses
Crystal 2013 Preston Training Courses
JQuery - Preston JavaScript Training Courses
SSAS Tabular Preston Training Courses
SSRS 2008 Preston Training Courses
Data Mining - Preston Data Analytics Training Courses
North West - Possible Excel Training Course Locations
Birkenhead Excel Training Courses
Chorley Excel Training Courses
Carlisle Excel Training Courses
Blackpool Excel Training Courses
Bolton Excel Training Courses
Warrington Excel Training Courses
Denton Excel Training Courses
Wallasey Excel Training Courses
Barrow-in-Furness Excel Training Courses
Altrincham Excel Training Courses
Morecambe Excel Training Courses
Lancashire Excel Training Courses
Leyland Excel Training Courses
Crosby Excel Training Courses
Accrington Excel Training Courses
Stockport Excel Training Courses
Leigh Excel Training Courses
North West Excel Training Courses
Lancaster Excel Training Courses
Wythenshawe Excel Training Courses
Bootle Excel Training Courses
Preston Excel Training Courses
Widnes Excel Training Courses
Crewe Excel Training Courses
Eccles Excel Training Courses
Chadderton Excel Training Courses
Chester Excel Training Courses
Ashton-under-Lyne Excel Training Courses
Liverpool Excel Training Courses
Runcorn Excel Training Courses
Lytham Urmston Excel Training Courses
Middleton Excel Training Courses
Oldham Excel Training Courses
Merseyside Excel Training Courses
Cheshire Excel Training Courses
Sale Excel Training Courses
Hyde Excel Training Courses
Saddleworth Excel Training Courses
Winsford Excel Training Courses
Blackburn Excel Training Courses
Thornton-Cleveleys Excel Training Courses
Burnley Excel Training Courses
Huyton Excel Training Courses
Kirkby Excel Training Courses
Prestwich Excel Training Courses
Skelmersdale Excel Training Courses
Stretford Excel Training Courses
Northwich Excel Training Courses
Manchester Excel Training Courses
Macclesfield Excel Training Courses
Rochdale Excel Training Courses
Wigan Excel Training Courses
Farnworth Excel Training Courses
Ellesmere Port Excel Training Courses
Southport Excel Training Courses
Bury Excel Training Courses
Salford Excel Training Courses
Birkenhead, Chorley, Carlisle, Blackpool, Bolton, Warrington, Denton, Wallasey, Barrow-in-furness, Altrincham, Morecambe, Lancashire, Leyland, Crosby, Accrington, Stockport, Leigh, North West, Lancaster, Wythenshawe, Bootle, Preston, Widnes, Crewe, Eccles, Chadderton, Chester, Ashton-under-lyne, Liverpool, Runcorn, Lytham Urmston, Middleton, Oldham, Merseyside, Cheshire, Sale, Hyde, Saddleworth, Winsford, Blackburn, Thornton-cleveleys, Burnley, Huyton, Kirkby, Prestwich, Skelmersdale, Stretford, Northwich, Manchester, Macclesfield, Rochdale, Wigan, Farnworth, Ellesmere Port, Southport, Bury, Salford