EXCEL TRAINING COURSES ALTRINCHAM
About Enable Technology Altrincham Excel Training Courses
Enable Technology specialise in succinct skills based Excel training. The tutor delivering the course will be a Microsoft certified expert. Everyone attending a Excel course receives learning resources which also serves as a reference source after the course. 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 training courses are delivered as instructor led courses. We are set up to deliver Excel training courses onsite at your premises. Alternatively we could schedule a course at a local socially distanced venue in Altrincham. We are happy to modify the Excel syllabus to match your teams training requirements.
We can also deliver Excel courses through an online virtual classroom. You log onto a scheduled virtual classroom, can view the tutor and exercise demonstrations, ask questions and allow the tutor to share your screen if need help completing the course exercises.
We have two decades of delivering technical training predominantly in the West Midlands. Our clients include: Royal & Sun Alliance Group PLC, Queen's Medical Centre Nottingham, Birmingham Heartlands Hospital, DHL Express, Lloyds TSB Bank PLC, Loughborough University, Shell UK Oil Products Ltd and Keele University.
Excel Intermediate
- 1 day course
- Location: Altrincham
- 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...
Quick Tables Worksheet Tables
Formulas
Adding More Operations
Understanding Conditional
Using the More Borders Command
Using Page Break Preview
Formatting Calculated Time
Values Conditional Formatting
Quick Sparklines
The MOD Function
Aligning Numbers Using Custom
Strategies for Printing Worksheets
Applying Top and Bottom Borders
Adding a Trendline
Specifying the Paper Size
Clearing Print Titles
Top Ten Items
Using Built in Margins
Changing Worksheet Tab Colours
Renaming a Table
Excel Power Pivot
- 1 day course
- Location: Altrincham
- 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 Data Model PivotTable
- See Training Course Details...
Understanding Power Map
Viewing and Editing a Tour
Working With Data Model Fields
Filtering in Power View
Creating a New Query From a File
Understanding the Query Editor
Managing Data Columns
Changing a Power Pivot View
Using Calculated Fields
Understanding the Navigator Pane
Navigating a Data Map
Creating a Concatenated Field
Updating a Power View Report
Working With the Data Model
Tiling Data in Power View
Adding Slicers Get & Transform
Power Pivot
Working With Layers
Excel Programming Using VBA
- 2 day course
- Location: Altrincham
- 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 ... Declaring Variables
- See Training Course Details...
Working with Methods
Displaying the Developer Tab in the Ribbon
Populating a Control
Using Visual Basic Help
Using Message Boxes
Understanding Modules
Understanding Objects
Working with the PivotFields Collection
Assigning a Macro to the Quick Access Toolbar
Stepping through Code
Understanding Error Handling
Understanding UserForms
Understanding Errors
Understanding Collections
Setting Control Properties in the Properties Window
Working with Control Appearance
Working with Inline Error Handling
Getting Started
Microsoft Excel Power Query
- 1 day course
- Location: Altrincham
- 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 Ranges in Excel
- See Training Course Details...
Understand and perform importing from SQL Server Analysis Services Tabular. PERFORMING MERGES
Course topics include- INTRODUCTION TO POWER QUERY
Importing, Transforming, and Loading Data into Excel and Power Pivot
Summarising WORKING WITH THE POWER QUERY LANGUAGE “M”
Performing Merges
Loading into Power BI Desktop
Working with Folders and Files
Transforming Data
Understand Power Query formulas.
Understanding and Handling Special Situations
Grouping Options
Loading Data
Data Sources GROUPING AND SUMMARISING WITH POWER QUERY
Introduction to Power BI Desktop
Loading into Excel
Appending Operations
Using PivotTables CONNECTING TO DATABASES
Power Query Interface
Understand the M interface.
Understanding Data Types WORKING WITH CSV, TXT AND EXCEL WORKSHEETS
Excel Advanced
- 1 day course
- Location: Altrincham
- Telephone on 01952 305730
- Course Outline
-
A one-day course covering Microsoft Excel advanced topics.
- Some of the training topics covered include ... Accepting or Rejecting Changes
- See Training Course Details...
Switching PivotTable Fields
Creating a Default Scenario
Creating Subtotals
Consolidating With Identical Layouts
Consolidating From Different Layouts
Inserting a Picture
Formatting PivotTable Values
Creating Relative Names for Subtotals
Understanding PivotTables
Adding Option Button Controls
Understanding Data Validation
Recommended PivotTables
Removing Invalid Circles
PivotTable Options
Using a Simple What-If Model
Sorting in a PivotTable PivotCharts
Sharing Workbooks
Copying a Macro
Assigning a Keyboard Shortcut to a Macro
Assigning a Macro to the Toolbar
Microsoft Excel PowerPivot Data Analytic Expressions DAX Language
- 2 day course
- Location: Altrincham
- 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 ... Filter Functions
- See Training Course Details...
The CALCULATE Function
Handling Errors Using DAX Functions
Working with Calendars
Using Multiple Calendars Utilising Advanced DAX Functionality
Explaining Syntax
Relational Functions Understanding Evaluation Contexts
Mathematical Functions
Understanding Values
Multiple Table Evaluation Context Working with Dates
Introduction to DAX
Date Functions
Utilizing Operators
Introduction to DAX
Many-to-Many Relationships
Exploring Data Types
Aggregation Functions
Conversion Functions
Information Functions
Text Functions
Excel Basic
- 1 day course
- Location: Altrincham
- 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 ... Deleting Cells From a Worksheet
- See Training Course Details...
Printing a Help Topic
Using the Thousands Separator
Using the Ribbon
Finding a Maximum Value
Navigating the Help Window
Opening an Existing Workbook
Printing a Chart Sheet
Understanding the Charting Process
Understanding the Status Bar
Deleting Data
Applying General Formatting
Editing Formulas
Setting the Default Column Width
Setting Precise Columns Widths
Changing the Chart Style
Worksheet Zooming
Printing an Entire Workbook
Growing and Shrinking Fonts
Changing Font Size
Clearing Cells
Email us about this courses
Other Altrincham Enable Technology Training Courses
Report Builder - Altrincham SQL Server Reporting Services Training Courses
Data Mining Altrincham Training Courses
Crystal 2013 - Altrincham Crystal Reports Training Courses
JQuery Altrincham Training Courses
Oracle BI - Altrincham Data Analytics Training Courses
JQuery Mobile - Altrincham JavaScript Training Courses
PowerPoint Advanced - Altrincham Office Training Courses
SSIS 2014 Altrincham Training Courses
Crystal 2016 - Altrincham Crystal Reports Training Courses
HTML Altrincham Training Courses
CSS - Altrincham Web Development Training Courses
Crystal XI Altrincham Training Courses
SSIS 2008 Altrincham Training Courses
SSRS 2014 - Altrincham SQL Server Reporting Services Training Courses
SSRS 2016 - Altrincham SQL Server Reporting Services Training Courses
Power BI - Altrincham Microsoft Power BI Training Courses
Crystal 2008 - Altrincham Crystal Reports Training Courses
SSRS 2005 - Altrincham SQL Server Reporting Services Training Courses
PL/SQL Altrincham Training Courses
SSAS 2017 - Altrincham SQL Server Analysis Services Training Courses
PowerPoint Basic - Altrincham Office Training Courses
North West - Possible Excel Training Course Locations
Preston Excel Training Courses
Blackpool Excel Training Courses
Morecambe Excel Training Courses
Eccles Excel Training Courses
Chorley Excel Training Courses
Warrington Excel Training Courses
Northwich Excel Training Courses
Prestwich Excel Training Courses
Lancashire Excel Training Courses
Rochdale Excel Training Courses
Farnworth Excel Training Courses
Merseyside Excel Training Courses
Crewe Excel Training Courses
Burnley Excel Training Courses
Skelmersdale Excel Training Courses
Manchester Excel Training Courses
Runcorn Excel Training Courses
Wythenshawe Excel Training Courses
Macclesfield Excel Training Courses
Oldham Excel Training Courses
Liverpool Excel Training Courses
Leyland Excel Training Courses
Altrincham Excel Training Courses
Huyton Excel Training Courses
Widnes Excel Training Courses
Stockport Excel Training Courses
Southport Excel Training Courses
Sale Excel Training Courses
North West Excel Training Courses
Barrow-in-Furness Excel Training Courses
Bootle Excel Training Courses
Middleton Excel Training Courses
Stretford Excel Training Courses
Lancaster Excel Training Courses
Crosby Excel Training Courses
Hyde Excel Training Courses
Chadderton Excel Training Courses
Leigh Excel Training Courses
Saddleworth Excel Training Courses
Winsford Excel Training Courses
Salford Excel Training Courses
Kirkby Excel Training Courses
Bury Excel Training Courses
Chester Excel Training Courses
Cheshire Excel Training Courses
Ellesmere Port Excel Training Courses
Lytham Urmston Excel Training Courses
Wigan Excel Training Courses
Carlisle Excel Training Courses
Ashton-under-Lyne Excel Training Courses
Bolton Excel Training Courses
Wallasey Excel Training Courses
Accrington Excel Training Courses
Denton Excel Training Courses
Thornton-Cleveleys Excel Training Courses
Blackburn Excel Training Courses
Birkenhead Excel Training Courses
Preston, Blackpool, Morecambe, Eccles, Chorley, Warrington, Northwich, Prestwich, Lancashire, Rochdale, Farnworth, Merseyside, Crewe, Burnley, Skelmersdale, Manchester, Runcorn, Wythenshawe, Macclesfield, Oldham, Liverpool, Leyland, Altrincham, Huyton, Widnes, Stockport, Southport, Sale, North West, Barrow-in-furness, Bootle, Middleton, Stretford, Lancaster, Crosby, Hyde, Chadderton, Leigh, Saddleworth, Winsford, Salford, Kirkby, Bury, Chester, Cheshire, Ellesmere Port, Lytham Urmston, Wigan, Carlisle, Ashton-under-lyne, Bolton, Wallasey, Accrington, Denton, Thornton-cleveleys, Blackburn, Birkenhead