Enable Technology

EXCEL ALTRINCHAM TRAINING COURSES 

EXCEL TRAINING COURSES ALTRINCHAM




About Enable Technology Altrincham Excel Training Courses

We have a twenty year history of providing skills based Excel industry training. The tutor delivering the course will be a Microsoft certified expert. All course participants are issued Excel training manuals they can refer to after the course. Enable Technology offer post course help to all delegates. Participants on the Excel course can contact the tutor for as long as they like if they encounter Excel problems.

Enable Technology training courses are delivered as instructor led courses. Enable Technology Excel courses can be delivered onsite at your premises. We bring a fully equipped training lab with us. Alternatively we could schedule a Excel course at an alternative training site in Altrincham. The Excel syllabus can be modified to accommodate your specific training needs.

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.

In the Midlands the Enable Technology team have been providing technical training since 1998. Our clients include: Lloyds TSB Bank PLC, Queen's Medical Centre Nottingham, Total Telecommunications Limited, Royal Air Force, Boots UK Limited, Aston University, Homeserve PLC and Birmingham City University.




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 ...
  • Editing Query Steps
    Changing a Power Pivot View
    Working With Data Model Fields
    Saving and Sharing Queries
    Power View
    Using Calculated Fields
    Power Map
    Rearranging and Sorting Fields
    Working With Height and Category
    Formatting Power View Data
    Working With Merged Queries
    Adding More Power Views
    Understanding Power Pivot
    Filtering in Power View
    Working With Time Settings
    Displaying the Query Editor
    Enabling Power Pivot
    Working With Scene Options
    Understanding Power Map
    Working With Mapping Confidence
    Viewing and Editing a Tour

  • See Training Course Details...


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 ...
  • Adding Option Button Controls
    Creating Calculated Fields
    Adding a Combo Box Control
    Inserting a Timeline Filter PivotTable Features
    Recording a Simple Macro
    Using Names in Scenarios
    Assigning a Keyboard Shortcut to a Macro
    Understanding Database Functions
    Understanding How Controls Work
    Importing From an Earlier Version
    Using the DMAX Function
    Running a Macro From the Toolbar
    Removing a Password From a Workbook Importing and Exporting
    Sharing Workbooks
    Creating a One-Variable Table
    Creating a Scenario Summary Report
    Circling Invalid Data
    Understanding Data Importing
    Creating an Input Message
    Understanding Grouping and Outlining
    Creating a Two-Variable Data Table Scenarios

  • See Training Course Details...


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 ...
  • Setting the Default Column Width
    Safely Closing a Workbook Working With Workbooks
    Viewing Worksheet Gridlines
    Clearing a Filter
    Growing and Shrinking Fonts
    Approximating Column Widths
    Typing Formulas
    Creating Custom Filters
    Vertical Cell Alignment
    Copying From One Range to Another Filling Data
    Understanding Workbooks
    Finding a Minimum Value
    Formatting as Fractions
    Indenting Cells
    Understanding the Excel Start Screen
    Printing an Embedded Chart
    Previewing Before You Print
    Applying and Using a Filter
    Increasing and Decreasing Decimals Row and Column Formatting
    Typing Numbers
    Typing Dates

  • See Training Course Details...


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 ...
  • Understanding Data Types WORKING WITH CSV, TXT AND EXCEL WORKSHEETS
    Introduction to Power BI Desktop
    Loading into Excel
    Working with Folders and Files
    Understand and perform importing from SQL Server Analysis Services Multidimensional.
    Performing Merges
    Grouping Options
    Course topics include- INTRODUCTION TO POWER QUERY
    Power Query Interface
    Appending Operations
    Loading Data
    Understand Power Query formulas.
    Understand and utilize merges. LOADING YOUR DATA
    Importing Data
    Understand the M interface.
    Loading into Power BI Desktop
    Understand working with relational data.
    Understanding and Handling Special Situations
    Summarising WORKING WITH THE POWER QUERY LANGUAGE “M”
    Combining Worksheets
    Importing, Transforming, and Loading Data into Excel and Power Pivot

  • See Training Course Details...


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 ...
  • The CHOOSE Function
    Using Built in Margins
    More Complex Flash Fill Extractions
    Using IF With Numbers
    Hiding Rows and Columns
    Adding More Complexity
    Creating Names From a Selection
    Adding Error Bars
    Inserting or Deleting Table Records
    Aligning Numbers Using Custom
    Understanding Page Layout
    The TODAY Function
    Pasting Values From Formulas
    Fit to a Specific Number of Pages Applying Borders
    Formatting
    The NOW Function
    Using Names to Select Ranges
    Scoping a Formula
    Creating Descriptive Custom Formats
    Filling a Series
    Quick Sparklines

  • See Training Course Details...


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 ...
  • Naming Procedures
    Saving a Macro-Enabled Workbook
    Understanding the Err Object
    Using Intrinsic Constants
    Working with UserForm Properties, Events, and Methods
    Navigating the Excel Object Hierarchy
    Creating a PivotTable Using Worksheet Data
    Setting the Tab Order
    Guidelines for use of Control-of-Flow Structures
    Using the Immediate Window to Call Procedures
    Understanding Error Handling
    Working with Boolean Expressions
    Stepping through Code
    Populating a Control
    Handling Errors
    Editing a Macro in the Visual Basic Editor
    Working with the Frame Control
    Adding Code to Controls
    Working with Variable Scope

  • See Training Course Details...


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 ...
  • Aggregation Functions
    Introduction to DAX
    Conversion Functions
    Multiple Table Evaluation Context Working with Dates
    Date Functions
    PowerPivot Data Model
    Logical Functions
    Statistical Functions
    Working with Calendars
    Many-to-Many Relationships
    The CALCULATE Function
    Mathematical Functions
    Handling Errors Using DAX Functions
    Understanding Values
    Explaining Syntax
    Single Table Evaluation Context
    Introduction to DAX
    Text Functions
    Information Functions
    Exploring Data Types

  • See Training Course Details...



Email us about this courses



Other Altrincham Enable Technology Training Courses

PowerPoint Basic Altrincham Training Courses
SSIS 2005 - Altrincham SQL Server Integration Services Training Courses
SQL Altrincham Training Courses
SSIS 2014 Altrincham Training Courses
Data Mining Altrincham Training Courses
PowerPoint Advanced - Altrincham Office Training Courses
Power Graphics Altrincham Training Courses
Microsoft Project Level 3 - Altrincham Microsoft Project Training Courses
Project 2016 - Altrincham Microsoft Project Training Courses
Visio 2013 Altrincham Training Courses
Mobile Altrincham Training Courses
SSRS 2008 Altrincham Training Courses
Data Warehouse Altrincham Training Courses
Report Builder - Altrincham SQL Server Reporting Services Training Courses
Access VBA Altrincham Training Courses
Project 2016 L1 - Altrincham Microsoft Project Training Courses
Crystal 2016 Altrincham Training Courses
SSIS 2008 - Altrincham SQL Server Integration Services Training Courses
HTML Altrincham Training Courses
SSRS 2014 - Altrincham SQL Server Reporting Services Training Courses
PHP Altrincham Training Courses



North West - Possible Excel Training Course Locations


Barrow-in-Furness Excel Training Courses
Saddleworth Excel Training Courses
Chester Excel Training Courses
Denton Excel Training Courses
Southport Excel Training Courses
North West Excel Training Courses
Crosby Excel Training Courses
Lytham Urmston Excel Training Courses
Leyland Excel Training Courses
Chadderton Excel Training Courses
Bolton Excel Training Courses
Sale Excel Training Courses
Lancaster Excel Training Courses
Huyton Excel Training Courses
Birkenhead Excel Training Courses
Salford Excel Training Courses
Warrington Excel Training Courses
Blackpool Excel Training Courses
Altrincham Excel Training Courses
Manchester Excel Training Courses
Merseyside Excel Training Courses
Middleton Excel Training Courses
Ellesmere Port Excel Training Courses
Skelmersdale Excel Training Courses
Crewe Excel Training Courses
Cheshire Excel Training Courses
Kirkby Excel Training Courses
Leigh Excel Training Courses
Wythenshawe Excel Training Courses
Winsford Excel Training Courses
Macclesfield Excel Training Courses
Lancashire Excel Training Courses
Runcorn Excel Training Courses
Carlisle Excel Training Courses
Farnworth Excel Training Courses
Widnes Excel Training Courses
Northwich Excel Training Courses
Stockport Excel Training Courses
Stretford Excel Training Courses
Chorley Excel Training Courses
Ashton-under-Lyne Excel Training Courses
Wigan Excel Training Courses
Oldham Excel Training Courses
Eccles Excel Training Courses
Burnley Excel Training Courses
Wallasey Excel Training Courses
Morecambe Excel Training Courses
Preston Excel Training Courses
Bootle Excel Training Courses
Hyde Excel Training Courses
Liverpool Excel Training Courses
Blackburn Excel Training Courses
Accrington Excel Training Courses
Thornton-Cleveleys Excel Training Courses
Prestwich Excel Training Courses
Rochdale Excel Training Courses
Bury Excel Training Courses

Barrow-in-furness, Saddleworth, Chester, Denton, Southport, North West, Crosby, Lytham Urmston, Leyland, Chadderton, Bolton, Sale, Lancaster, Huyton, Birkenhead, Salford, Warrington, Blackpool, Altrincham, Manchester, Merseyside, Middleton, Ellesmere Port, Skelmersdale, Crewe, Cheshire, Kirkby, Leigh, Wythenshawe, Winsford, Macclesfield, Lancashire, Runcorn, Carlisle, Farnworth, Widnes, Northwich, Stockport, Stretford, Chorley, Ashton-under-lyne, Wigan, Oldham, Eccles, Burnley, Wallasey, Morecambe, Preston, Bootle, Hyde, Liverpool, Blackburn, Accrington, Thornton-cleveleys, Prestwich, Rochdale, Bury