Enable Technology

EXCEL NEWCASTLE UPON TYNE TRAINING COURSES 

EXCEL TRAINING COURSES NEWCASTLE UPON TYNE




About Enable Technology Newcastle Upon Tyne Excel Training Courses

Enable Technology specialise in succinct skills based Excel training. All of our tutors are Microsoft Certified Professionals. Each person attending a course takes away Excel courseware which can be used as reference materials after the training. 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.

Delegates are taught by an experienced Microsoft professional. Excel courses are delivered through a mix of practical hands on exercises and walk throughs. We can deliver at your premises. We can provide the equipment. If delivery onsite is an issue we will organise a socially distanced venue near you in Newcastle Upon Tyne. The Excel syllabus can be adjusted and additional topics incorporated if helpful.

This instructor led Excel training is also available online. Participants can see the tutors screen, ask questions and share their screen with the tutor.

Our teaching team have over twenty years continuous technical training experience. Some of our clients are Loughborough University, Aston University, Homeserve PLC, University of Birmingham, Royal & Sun Alliance Group PLC, Birmingham City Council, Dollond & Aitchison Limited and Shell UK Oil Products Ltd.




Excel Intermediate

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

  • Some of the training topics covered include ...
  • The More Borders Command
    Showing Data Labels
    Adding a Chart Title
    The MOD Function
    Moving a Worksheet
    Clearing Print Titles
    Working With Table Styles
    Preparing for Complex Formulas
    Understanding Conditional
    Clearing Conditional Formatting
    Scoping a Formula
    Understanding Defined Names
    Strategies for Printing Worksheets
    Removing Table Columns
    Using Page Break Preview
    Understanding Filling
    Removing Borders
    Formatting the Chart Area
    Creating the Base Formula
    Using Names in Typed Formulas

  • See Training Course Details...


Excel Advanced

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

  • Some of the training topics covered include ...
  • Testing a Validation
    Understanding Types of Controls
    Using Compound Fields
    Working With an Outline
    Working With a Protected Worksheet
    Importing Tab Delimited Text
    Working With PivotTable Subtotals
    Editing a Macro
    Sorting in a PivotTable PivotCharts
    Saving to OneDrive
    Recommended PivotTables
    Exporting Data as Text
    Adding a List Box Control
    Using the DMIN Function
    Removing Invalid Circles
    Enabling Tracked Changes
    Creating a Two-Variable Data Table Scenarios
    Using a Subtotalled Worksheet
    Finding the Difference From
    Deleting Comments Recorded Macros
    Using the Cell Link to Display the Selection

  • See Training Course Details...


Excel Basic

  • 1 day course
  • Location: Newcastle Upon Tyne
  • 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 Functions
    Making Basic Changes
    Number Formatting
    Formatting as Fractions
    Typing Text
    Absolute Versus Relative Referencing
    Extracting With Flash Fill Moving Data
    Understanding Copying in Excel
    Making Cells Bold
    Changing Font Colours
    Editing Longer Cells
    Formatting for Money
    Deleting Rows and Columns
    Understanding Lists
    Worksheet Wisdom Sorting Data
    Performing an Alphabetical Sort
    Performing a Numerical Sort
    Summing Non-Contiguous Ranges
    What if Formulas
    Typing Formulas
    Creating Formulas That Add

  • See Training Course Details...


Microsoft Excel PowerPivot Data Analytic Expressions DAX Language

  • 2 day course
  • Location: Newcastle Upon Tyne
  • 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 ...
  • Working with Calendars
    Understanding Values
    PowerPivot Data Model
    Relational Functions Understanding Evaluation Contexts
    Using Multiple Calendars Utilising Advanced DAX Functionality
    Statistical Functions
    Explaining Syntax
    Aggregation Functions
    Exploring Data Types
    Date Functions
    Text Functions
    Logical Functions
    Conversion Functions
    Filter Functions
    Introduction to DAX
    Utilizing Operators
    Many-to-Many Relationships
    Handling Errors Using DAX Functions
    Information Functions
    Introduction to DAX
    The CALCULATE Function

  • See Training Course Details...


Excel Programming Using VBA

  • 2 day course
  • Location: Newcastle Upon Tyne
  • 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 ...
  • Understanding the Err Object
    Understanding VBA's Error Trapping Options
    Working with the Code Editor
    Using the Object Browser
    Using Expressions, Variables, and Intrinsic Functions
    Understanding Macro Security
    Declaring and Using Object Variables
    Editing a Macro in the Visual Basic Editor
    Understanding Expressions and Statements
    Creating a Standard Module
    Working with the Text Box Control
    Using Visual Basic Help
    Working with Properties
    Creating a PivotTable Using Worksheet Data
    Displaying the Developer Tab in the Ribbon
    Understanding the Development Environment
    Working with UserForm Properties, Events, and Methods
    Understanding Errors
    Creating a Function Procedure
    Calling Procedures
    Working with the Frame Control

  • See Training Course Details...


Excel Power Pivot

  • 1 day course
  • Location: Newcastle Upon Tyne
  • 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 ...
  • Working With Measure Fields
    Working With Merged Queries
    Creating a Timeline
    Working With Layers
    Working With Height and Category
    Viewing and Editing a Tour
    Working With Scenes
    Using Calculated Fields
    Understanding Power Pivot
    Merging Queries
    Creating a Data Model PivotTable
    Working With Data Model Fields
    Filtering in Power View
    Reducing Data Rows
    Understanding Get & Transform
    Tiling Data in Power View
    Displaying the Query Editor
    Exporting a Tour as a Video
    Changing the Look
    Working With Time Settings
    Power View

  • See Training Course Details...


Microsoft Excel Power Query

  • 1 day course
  • Location: Newcastle Upon Tyne
  • 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
    Understanding Data Types WORKING WITH CSV, TXT AND EXCEL WORKSHEETS
    Understand and utilize merges. LOADING YOUR DATA
    Power Query Interface
    Loading Data
    Data Sources GROUPING AND SUMMARISING WITH POWER QUERY
    Grouping Options
    Summarising WORKING WITH THE POWER QUERY LANGUAGE “M”
    Transforming Data
    Using PivotTables CONNECTING TO DATABASES
    Understand working with relational data.
    Combining Worksheets
    Understand and perform importing from SQL Server Analysis Services Tabular. PERFORMING MERGES
    Understand the M interface.
    Working with Folders and Files
    Course topics include- INTRODUCTION TO POWER QUERY
    Understand Power Query formulas.
    Understanding and Handling Special Situations
    Performing Merges
    Loading into Power BI Desktop
    Understand and perform importing from SQL Server Analysis Services Multidimensional.

  • See Training Course Details...



Email us about this courses



Other Newcastle Upon Tyne Enable Technology Training Courses

SSAS 2017 - Newcastle Upon Tyne SQL Server Analysis Services Training Courses
Access VBA Newcastle Upon Tyne Training Courses
Crystal 2013 - Newcastle Upon Tyne Crystal Reports Training Courses
SSRS 2005 Newcastle Upon Tyne Training Courses
Microsoft Project Level 3 Newcastle Upon Tyne Training Courses
Power Graphics - Newcastle Upon Tyne Data Analytics Training Courses
JQuery Mobile Newcastle Upon Tyne Training Courses
Data Mining - Newcastle Upon Tyne Data Analytics Training Courses
SSAS 2008 - Newcastle Upon Tyne SQL Server Analysis Services Training Courses
Crystal 2008 - Newcastle Upon Tyne Crystal Reports Training Courses
Crystal XI - Newcastle Upon Tyne Crystal Reports Training Courses
SSAS 2014 - Newcastle Upon Tyne SQL Server Analysis Services Training Courses
Report Builder Newcastle Upon Tyne Training Courses
PL/SQL - Newcastle Upon Tyne SQL Training Courses
Data Warehouse Newcastle Upon Tyne Training Courses
PHP - Newcastle Upon Tyne PHP Training Courses
PowerPoint Advanced - Newcastle Upon Tyne Office Training Courses
HTML Newcastle Upon Tyne Training Courses
SSRS 2014 Newcastle Upon Tyne Training Courses
Power BI - Newcastle Upon Tyne Microsoft Power BI Training Courses
SSAS 2005 Newcastle Upon Tyne Training Courses



North - Possible Excel Training Course Locations


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

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