Enable Technology

EXCEL NORTH EAST TRAINING COURSES 

EXCEL TRAINING COURSES NORTH EAST




About Enable Technology North East Excel Training Courses

Enable Technology offer short intensive skills based Excel training courses. The person delivering the course will be a Microsoft Solutions Expert (MCSE). We will issue each Excel training participant with learning resources which they can refer to post training. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with Excel queries.

Courses are instructor led and groups sizes small. This Excel course is available online during the Covid 19 crisis. 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. We are happy to discuss customising the course content should you have particular Excel training requirements.

The Enable Technology group of companies has been operating continuously providing IT training since 1998. Our clients include: Keele University, Fujistu PLC, Royal & Sun Alliance Group PLC, GKN PLC, Countrywide Homes Limited, Norfolk Police Constabulary, Nationwide Building Society Limited and EDF Energy PLC.




Microsoft Excel Power Query

  • 1 day course
  • Location: North East
  • 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
    Loading Data
    Grouping Options
    Loading into Excel
    Introduction to Power BI Desktop
    Summarising WORKING WITH THE POWER QUERY LANGUAGE “M”
    Understand the M interface.
    Combining Worksheets
    Importing, Transforming, and Loading Data into Excel and Power Pivot
    Appending Operations
    Understanding Data Types WORKING WITH CSV, TXT AND EXCEL WORKSHEETS
    Understanding and Handling Special Situations
    Understand Power Query formulas.
    Understanding the Issues
    Transforming Data
    Understand and perform importing from SQL Server Analysis Services Tabular. PERFORMING MERGES
    Loading into Power Pivot
    Loading into Power BI Desktop
    Data Sources GROUPING AND SUMMARISING WITH POWER QUERY
    Course topics include- INTRODUCTION TO POWER QUERY
    Understand and utilize merges. LOADING YOUR DATA

  • See Training Course Details...


Excel Power Pivot

  • 1 day course
  • Location: North East
  • 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 ...
  • Viewing and Editing a Tour
    Filtering Data
    Understanding the Query Editor
    Creating a Concatenated Field
    Working With Layers
    Displaying the Query Editor
    Working With Data Model Fields
    Transforming Data
    Merging Queries
    Changing the Look
    Using Calculated Fields
    Working With Time Settings
    Exporting a Tour as a Video
    Working With Scene Options
    Switching Visualisations
    The Advanced Editor
    Working With Measure Fields
    Enabling Power Pivot
    Creating a Timeline
    Rearranging and Sorting Fields
    Adding a Data Column

  • See Training Course Details...


Excel Programming Using VBA

  • 2 day course
  • Location: North East
  • 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 ...
  • Using Debugging Tools
    Introducing Visual Basic for Applications
    Using Intrinsic Constants
    Working with the Command Button Control
    Naming Procedures
    Understanding Data Types
    Displaying the Developer Tab in the Ribbon
    Using the Do...Loop Structure
    Using Input Boxes
    Editing a Macro in the Visual Basic Editor
    Closing the Visual Basic Editor
    Using the Immediate Window to Call Procedures
    Working with the PivotFields Collection
    Understanding UserForms
    Understanding PivotTables
    Getting Started
    Working with the Code Editor
    Understanding Constants

  • See Training Course Details...


Microsoft Excel PowerPivot Data Analytic Expressions DAX Language

  • 2 day course
  • Location: North East
  • 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 ...
  • Utilizing Operators
    Understanding Values
    PowerPivot Data Model
    The CALCULATE Function
    Conversion Functions
    Introduction to DAX
    Explaining Syntax
    Text Functions
    Logical Functions
    Date Functions
    Many-to-Many Relationships
    Multiple Table Evaluation Context Working with Dates
    Exploring Data Types
    Introduction to DAX
    Single Table Evaluation Context
    Aggregation Functions
    Statistical Functions
    Filter Functions
    Information Functions
    Relational Functions Understanding Evaluation Contexts

  • See Training Course Details...


Excel Basic

  • 1 day course
  • Location: North East
  • 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 ...
  • Extracting With Flash Fill Moving Data
    Other Sources of Assistance  
    Printing an Entire Workbook
    Deleting Data
    Increasing and Decreasing Decimals Row and Column Formatting
    Inserting Columns Into a Worksheet
    Understanding Printing
    Finding a Minimum Value
    Formatting for Money
    Working With Live Preview
    Creating Compound Filters
    Setting the Default Column Width
    Understanding Filtering
    Navigating the Help Window
    Underlining Text
    Using Fill for Quick Copying
    Creating Mixed References Font Formatting
    Selecting Non Contiguous Ranges
    Approximating Row Height
    Navigating Using the Keyboard
    Using Shortcut Menus

  • See Training Course Details...


Excel Intermediate

  • 1 day course
  • Location: North East
  • Telephone on 01952 305730
  • Course Outline
  • A one day course covering Microsoft Excel Intermediate topics.

  • Some of the training topics covered include ...
  • Centring on a Page
    Creating Sparklines
    Removing Table Columns
    Key Worksheet Functions
    Changing Line Chart Colours
    Changing WordArt Fill
    Colouring the Chart Background
    Changing Orientation
    Formatting Clock Time
    The MOD Function
    Adding More Operations
    Filling a Growth Series
    Padding Numbers Using Custom
    Working With Data Bars
    Understanding Quick Analysis
    Understanding Format Codes
    The TODAY Function
    Applying Alternate Date Formats
    Understanding Page Layout
    More Top and Bottom Formatting

  • See Training Course Details...


Excel Advanced

  • 1 day course
  • Location: North East
  • Telephone on 01952 305730
  • Course Outline
  • A one-day course covering Microsoft Excel advanced topics.

  • Some of the training topics covered include ...
  • Creating Subtotals
    Adding Worksheet Comments
    Disabling Worksheet Protection
    Creating Running Totals
    Importing Comma Delimited Text
    Copying Subtotals
    Consolidating From Different Layouts
    Creating Scenarios
    Clearing a Report Filter
    Inserting a Timeline Filter PivotTable Features
    Opening Shared Workbooks
    Understanding Data Importing
    Sharing Workbooks via OneDrive
    Setting Advanced Options Protecting Data
    Consolidating With Identical Layouts
    Password Protecting a Workbook
    Understanding How Controls Work
    Finding the Difference From
    Updating Links Between Workbooks Grouping and Outlining
    Sharing Workbooks via the Network
    Editing a Macro

  • See Training Course Details...



Email us about this courses



Other North East Enable Technology Training Courses

Access 2016 - North East Access Training Courses
JavaScript - North East JavaScript Training Courses
Crystal 2011 - North East Crystal Reports Training Courses
TSQL North East Training Courses
Access VBA - North East Access Training Courses
Project 2016 L1 North East Training Courses
SSRS 2005 North East Training Courses
Oracle BI North East Training Courses
SQL - North East SQL Training Courses
SSIS 2008 North East Training Courses
HTML - North East Web Development Training Courses
Microsoft Project Level 2 North East Training Courses
SSAS 2017 North East Training Courses
Report Builder North East Training Courses
Crystal 2013 - North East Crystal Reports Training Courses
JQuery North East Training Courses
Oracle SQL - North East SQL Training Courses
JQuery Mobile North East Training Courses
Visio 2013 North East Training Courses
Mobile - North East Web Development Training Courses
SSAS Tabular - North East SQL Server Analysis Services Training Courses



North - Possible Excel Training Course Locations


Yorkshire Excel Training Courses
Doncaster Excel Training Courses
Dewsbury Excel Training Courses
Huddersfield Excel Training Courses
Hexham Excel Training Courses
Scarborough Excel Training Courses
Durham Excel Training Courses
Hartlepool Excel Training Courses
Sheffield Excel Training Courses
North East Excel Training Courses
Leeds Excel Training Courses
Halifax Excel Training Courses
Wakefield Excel Training Courses
Bridlington Excel Training Courses
Gateshead Excel Training Courses
Pudsey Excel Training Courses
Batley Excel Training Courses
York Excel Training Courses
South Shields Excel Training Courses
Castleford Excel Training Courses
Barnsley Excel Training Courses
Keighley Excel Training Courses
Scunthorpe Excel Training Courses
Wetherby Excel Training Courses
Grimsby Excel Training Courses
Middlesbrough Excel Training Courses
Sunderland Excel Training Courses
Newcastle Upon Tyne Excel Training Courses
Rotherham Excel Training Courses
Normanton Excel Training Courses
Harrogate Excel Training Courses

Yorkshire, Doncaster, Dewsbury, Huddersfield, Hexham, Scarborough, Durham, Hartlepool, Sheffield, North East, Leeds, Halifax, Wakefield, Bridlington, Gateshead, Pudsey, Batley, York, South Shields, Castleford, Barnsley, Keighley, Scunthorpe, Wetherby, Grimsby, Middlesbrough, Sunderland, Newcastle Upon Tyne, Rotherham, Normanton, Harrogate