Enable Technology

EXCEL NORTH EAST TRAINING COURSES 

EXCEL TRAINING COURSES NORTH EAST




About Enable Technology North East Excel Training Courses

We are company which specialises in short, two and three day intensive Excel technology training courses. The tutor teaching the course will be an experienced developer and Microsoft certified professional. All candidates receive comprehensive Excel training materials and practice files which are theirs to 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 offers instructor led training taught by technology specialists. We are set up to deliver Excel training courses onsite at your premises. The Excel course could also be scheduled at a socially distanced site near you in North East. We will work with you prior to the course to tailor the Excel syllabus to match your 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.

The Enable Technology team have been providing IT training primarily in the Midlands for two decades. Our clients include: Countrywide Homes Limited, Keele University, South Staffordshire Water PLC, Yell Group PLC, Total Telecommunications Limited, Wolverhampton City Council, Boots UK Limited and University of Birmingham.




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 ...
  • Date Functions
    Handling Errors Using DAX Functions
    Single Table Evaluation Context
    Explaining Syntax
    Many-to-Many Relationships
    Filter Functions
    Information Functions
    Mathematical Functions
    Multiple Table Evaluation Context Working with Dates
    Working with Calendars
    Text Functions
    Using Multiple Calendars Utilising Advanced DAX Functionality
    Statistical Functions
    Logical Functions
    Conversion Functions
    Introduction to DAX
    Exploring Data Types
    Utilizing Operators
    Relational Functions Understanding Evaluation Contexts
    The CALCULATE Function

  • 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 ...
  • Rounding Up and Rounding Down
    Scoping Names to a Worksheet
    The PMT Function Complex Formulas
    Scaling to a Percentage
    Editing a Complex Formula
    Selecting Chart Objects
    Pasting Defined Names Into
    Quick Tables Worksheet Tables
    Preparing for Complex Formulas
    Copying a Worksheet
    Copying Nested Functions
    Understanding Borders
    Changing Worksheet Tab Colours
    Understanding Tables
    Understanding Conditional
    Fit to a Specific Number of Pages Applying Borders
    Understanding Number Formatting
    Unhiding a Worksheet
    Using IF With Numbers
    Changing Individual Bar Colours
    Using Counting Functions

  • 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 ...
  • Working with UserForm Properties, Events, and Methods
    Working with the Frame Control
    Understanding PivotTables
    Working with Variable Scope
    Populating a Control
    Working with Option Button Controls
    Launching a Form in Code
    Working with Inline Error Handling
    Working with Methods
    Understanding UserForms
    Setting Control Properties in the Properties Window
    Understanding Modules
    Getting Started
    Understanding Controls
    Adding Code to Controls
    Using Input Boxes
    Determining the Value of Expressions
    Using Message Boxes

  • 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 ...
  • Understanding How Help Works
    Filling a Growth Series
    Inserting Cells Into a Worksheet
    Calculating an Average
    Deleting Rows and Columns
    Previewing Before You Print
    Deleting a Chart Getting Help
    Viewing Worksheet Gridlines
    Creating More Complex Formulas
    Working With Live Preview
    Understanding Cell Alignment
    Typing Formulas
    Easy Formulas
    Sorting on More Than One Column Filtering Data
    Deleting Data
    Worksheet Zooming
    Printing a Chart Sheet
    Absolute Versus Relative Referencing
    Creating Formulas That Subtract
    Typing Dates
    Understanding the Quick Access Toolbar

  • 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 ...
  • Protecting a Worksheet With Controls Sharing Workbooks
    Understanding Text File Formats
    Defining the PivotTable Structure
    Working With Connected Data Unlinking Connections
    Working With an Outline
    Adding a Group Box Control
    Using the DCOUNT Function Validating Data
    Understanding Data Importing
    Sharing Workbooks via the Network
    Creating Calculated Items
    Understanding Save Options
    Consolidating Data Using the SUM Function Data Tables
    Creating Running Totals
    Disabling Worksheet Protection
    Using DSUM
    Changing Control Properties
    Creating a Drop Down List
    Viewing a Macro
    Understanding Data Consolidation
    PivotTable Options
    Creating Scenarios

  • 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 ...
  • Changing the Look
    Working With Scene Options
    Working With Power View Fields
    Navigating a Data Map
    Power View
    Adding More Power Views
    Formatting Power View Data
    Enabling Power View
    Exporting a Tour as a Video
    Filtering in Power View
    Filtering Data
    Using Calculated Fields
    Reducing Data Rows
    Power Pivot
    Switching Visualisations
    Understanding Get & Transform
    Working With a Power View Object
    Creating a Concatenated Field
    Working With Location Fields
    Understanding Power View
    Adding a Data Column

  • See Training Course Details...


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 ...
  • Transforming Data
    Understanding the Issues
    Using PivotTables CONNECTING TO DATABASES
    Summarising WORKING WITH THE POWER QUERY LANGUAGE “M”
    Understand working with relational data.
    Understand and perform importing from SQL Server Analysis Services Tabular. PERFORMING MERGES
    Understanding and Handling Special Situations
    Working with Folders and Files
    Grouping Options
    Power Query Interface
    Loading into Power Pivot
    Loading into Excel
    Importing, Transforming, and Loading Data into Excel and Power Pivot
    Loading Data
    Understand and perform importing from SQL Server Analysis Services Multidimensional.
    Understand Power Query formulas.
    Performing Merges
    Appending Operations
    Data Sources GROUPING AND SUMMARISING WITH POWER QUERY
    Introduction to Power BI Desktop
    Combining Worksheets

  • See Training Course Details...



Email us about this courses



Other North East Enable Technology Training Courses

PHP - North East PHP Training Courses
SSRS 2005 North East Training Courses
Project 2016 L1 North East Training Courses
SSAS 2014 North East Training Courses
PL/SQL - North East SQL Training Courses
CSS - North East Web Development Training Courses
SSAS 2005 North East Training Courses
SSIS 2014 North East Training Courses
SSIS 2008 - North East SQL Server Integration Services Training Courses
Power Graphics North East Training Courses
Power BI North East Training Courses
SSRS 2014 North East Training Courses
PowerPoint Advanced North East Training Courses
HTML North East Training Courses
Crystal 2008 - North East Crystal Reports Training Courses
SSAS Tabular - North East SQL Server Analysis Services Training Courses
Data Mining North East Training Courses
SSRS 2008 - North East SQL Server Reporting Services Training Courses
Oracle BI North East Training Courses
Report Builder - North East SQL Server Reporting Services Training Courses
Microsoft Project Level 2 North East Training Courses



North - Possible Excel Training Course Locations


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

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