EXCEL TRAINING COURSES ACCRINGTON
About Enable Technology Accrington Excel Training Courses
Enable Technology Excel courses are short, skill focused and hands on. 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. It is our policy to support delegates apply their new skill after the course. All candidate will be able to contact the course Tutor for as long as they feel they need help.
Enable Technology training courses are delivered as instructor led courses. We can deliver at your premises. We can provide the equipment. Another way we could deliver the Excel course is at a local socially distanced training site. Every Excel course can be modified to meet your bespoke requirements.
This instructor led course is also available online. Participants can log onto a virtual classroom and will be able to see the tutors screen, ask questions real time and share their screen with the Tutor.
We have operated primarily in the West Midlands for twenty years. Some of our clients are Boots UK Limited, Birmingham City Council, Total Telecommunications Limited, TalkTalk Direct Limited, Dollond & Aitchison Limited, Loughborough University, Canadian High Commission and Yell Group PLC.
Microsoft Excel PowerPivot Data Analytic Expressions DAX Language
- 2 day course
- Location: Accrington
- 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 ... Aggregation Functions
- See Training Course Details...
Mathematical Functions
Text Functions
Logical Functions
PowerPivot Data Model
Exploring Data Types
Statistical Functions
Using Multiple Calendars Utilising Advanced DAX Functionality
The CALCULATE Function
Relational Functions Understanding Evaluation Contexts
Date Functions
Introduction to DAX
Explaining Syntax
Utilizing Operators
Handling Errors Using DAX Functions
Introduction to DAX
Information Functions
Multiple Table Evaluation Context Working with Dates
Conversion Functions
Single Table Evaluation Context
Excel Intermediate
- 1 day course
- Location: Accrington
- Telephone on 01952 305730
- Course Outline
-
A one day course covering Microsoft Excel Intermediate topics.
- Some of the training topics covered include ... Freezing Rows and Columns
- See Training Course Details...
Fit to a Specific Number of Pages Applying Borders
Printing Gridlines
Formatting With WordArt
Applying Names to Existing Formulas
Filling a Series Backwards
Setting the Print Area
Extracting Dates and Numbers Worksheet Techniques
Creating Names From a Selection
Extracting With Flash Fill
Understanding Conditional
Understanding Format Codes
Working With Icon Sets
Creating Descriptive Custom Formats
Inserting Table Columns
Inserting Page Breaks
More Top and Bottom Formatting
Quick Charting
Understanding the Format Pane
Adding Error Bars
Excel Power Pivot
- 1 day course
- Location: Accrington
- 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 ... Using Calculated Fields
- See Training Course Details...
Changing a Power Pivot View
Power Pivot
The Advanced Editor
Formatting Data Model Fields
Working With Measure Fields
Working With Height and Category
Enabling Power Pivot
Enabling Power View
Adding Titles and Images
Understanding the Query Editor
Creating a Timeline
Updating a Power View Report
Adding Power View to the Ribbon
Navigating a Data Map
Switching Visualisations
Power Map
Working With Mapping Confidence
Microsoft Excel Power Query
- 1 day course
- Location: Accrington
- 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 ... Appending Operations
- See Training Course Details...
Performing Merges
Understand the M interface.
Importing, Transforming, and Loading Data into Excel and Power Pivot
Understand and utilize merges. LOADING YOUR DATA
Understand working with relational data.
Understanding and Handling Special Situations
Grouping Options
Understanding Data Types WORKING WITH CSV, TXT AND EXCEL WORKSHEETS
Transforming Data
Loading into Excel
Using Ranges in Excel
Loading into Power BI Desktop
Introduction to Power BI Desktop
Course topics include- INTRODUCTION TO POWER QUERY
Importing Data
Power Query Interface
Summarising WORKING WITH THE POWER QUERY LANGUAGE “M”
Using PivotTables CONNECTING TO DATABASES
Understand and perform importing from SQL Server Analysis Services Multidimensional.
Loading Data
Excel Programming Using VBA
- 2 day course
- Location: Accrington
- 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 ... Guidelines for use of Control-of-Flow Structures
- See Training Course Details...
Understanding Objects
Using the If...End If Decision Structures
Working with Methods
Understanding Errors
Understanding VBA's Error Trapping Options
Using the With Statement
Using Message Boxes
Working with the PivotFields Collection
Creating an Event Procedure
Displaying the Developer Tab in the Ribbon
Using the Select Case...End Select Structure
Understanding Error Handling
Creating a PivotTable Using Worksheet Data
Naming Procedures
Using the For...To...Next Structure
Saving a Macro-Enabled Workbook
Assigning a Macro to the Quick Access Toolbar
Working with the Combo Box Control
Excel Advanced
- 1 day course
- Location: Accrington
- Telephone on 01952 305730
- Course Outline
-
A one-day course covering Microsoft Excel advanced topics.
- Some of the training topics covered include ... Editing Worksheet Comments
- See Training Course Details...
Understanding Excel Options
Using Compound Fields
Providing Custom Names
Understanding Advanced Filtering
Creating an Input Message
Assigning a Macro to the Ribbon
Creating Running Totals
Understanding Grouping and Outlining
Sharing Workbooks
Relative Cell References
Running a Macro With Relative References
Using Formulas as Validation Criteria
Recording a Simple Macro
Protecting a Worksheet
Grouping by Columns Summarising and Subtotalling
Importing Tab Delimited Text
Creating Your Own PivotTable
Disabling Worksheet Protection
Filtering a PivotTable
Understanding How Controls Work
Excel Basic
- 1 day course
- Location: Accrington
- 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 ... Creating Formulas That Add
- See Training Course Details...
Inserting Rows Into a Worksheet
The Print Options Creating Charts
Formatting Percentages
Copying From One Cell to a Range
Showing and Collapsing the Ribbon
Other Sources of Assistance
Horizontal Cell Alignment
Understanding the Quick Access Toolbar
Editing Longer Cells
Navigating Using the Keyboard
Understanding Formulas
Calculating an Average
Using Undo and Redo Selecting Ranges
Worksheet Zooming
Using the Thousands Separator
Navigating a Workbook
Choosing the Right Chart
Deleting a Chart Getting Help
Using a Recommended Chart
Applying and Using a Filter
Email us about this courses
Other Accrington Enable Technology Training Courses
JQuery Accrington Training Courses
Data Mining - Accrington Data Analytics Training Courses
Project 2016 L1 - Accrington Microsoft Project Training Courses
PHP Accrington Training Courses
Access 2016 - Accrington Access Training Courses
JavaScript - Accrington JavaScript Training Courses
Power BI - Accrington Microsoft Power BI Training Courses
SSRS 2014 Accrington Training Courses
Crystal 2011 - Accrington Crystal Reports Training Courses
SSRS 2008 - Accrington SQL Server Reporting Services Training Courses
CSS Accrington Training Courses
SSRS 2016 Accrington Training Courses
Report Builder Accrington Training Courses
Crystal 2013 Accrington Training Courses
Project 2016 Accrington Training Courses
Crystal 2016 - Accrington Crystal Reports Training Courses
Oracle SQL Accrington Training Courses
SSIS 2008 Accrington Training Courses
SSAS 2017 - Accrington SQL Server Analysis Services Training Courses
PowerPoint Advanced - Accrington Office Training Courses
HTML - Accrington Web Development Training Courses
North West - Possible Excel Training Course Locations
Winsford Excel Training Courses
Lancashire Excel Training Courses
Wigan Excel Training Courses
Ellesmere Port Excel Training Courses
Chorley Excel Training Courses
Skelmersdale Excel Training Courses
Crewe Excel Training Courses
Carlisle Excel Training Courses
Runcorn Excel Training Courses
Middleton Excel Training Courses
Bootle Excel Training Courses
Stockport Excel Training Courses
Wallasey Excel Training Courses
Oldham Excel Training Courses
Barrow-in-Furness Excel Training Courses
Eccles Excel Training Courses
Cheshire Excel Training Courses
Farnworth Excel Training Courses
Hyde Excel Training Courses
Macclesfield Excel Training Courses
Merseyside Excel Training Courses
Blackpool Excel Training Courses
Northwich Excel Training Courses
Burnley Excel Training Courses
Saddleworth Excel Training Courses
Ashton-under-Lyne Excel Training Courses
Morecambe Excel Training Courses
Chester Excel Training Courses
Bolton Excel Training Courses
Sale Excel Training Courses
Salford Excel Training Courses
Leyland Excel Training Courses
Widnes Excel Training Courses
Chadderton Excel Training Courses
Huyton Excel Training Courses
Preston Excel Training Courses
Stretford Excel Training Courses
Manchester Excel Training Courses
Thornton-Cleveleys Excel Training Courses
Accrington Excel Training Courses
Kirkby Excel Training Courses
Rochdale Excel Training Courses
Birkenhead Excel Training Courses
Wythenshawe Excel Training Courses
Liverpool Excel Training Courses
Southport Excel Training Courses
Warrington Excel Training Courses
Lancaster Excel Training Courses
Prestwich Excel Training Courses
Bury Excel Training Courses
Crosby Excel Training Courses
Denton Excel Training Courses
Altrincham Excel Training Courses
Leigh Excel Training Courses
Blackburn Excel Training Courses
Lytham Urmston Excel Training Courses
North West Excel Training Courses
Winsford, Lancashire, Wigan, Ellesmere Port, Chorley, Skelmersdale, Crewe, Carlisle, Runcorn, Middleton, Bootle, Stockport, Wallasey, Oldham, Barrow-in-furness, Eccles, Cheshire, Farnworth, Hyde, Macclesfield, Merseyside, Blackpool, Northwich, Burnley, Saddleworth, Ashton-under-lyne, Morecambe, Chester, Bolton, Sale, Salford, Leyland, Widnes, Chadderton, Huyton, Preston, Stretford, Manchester, Thornton-cleveleys, Accrington, Kirkby, Rochdale, Birkenhead, Wythenshawe, Liverpool, Southport, Warrington, Lancaster, Prestwich, Bury, Crosby, Denton, Altrincham, Leigh, Blackburn, Lytham Urmston, North West