Enable Technology

EXCEL BRIDLINGTON TRAINING COURSES 

EXCEL TRAINING COURSES BRIDLINGTON




About Enable Technology Bridlington Excel Training Courses

We are company which specialises in short, two and three day intensive Excel technology training courses. All of our tutors are Microsoft Certified Professionals. Every course participant is given Excel courseware which they can refer to after the training. 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.

We provide instructor led training coupled with hands on training. We are set up to deliver Excel training courses onsite at your premises. We are also more than happy to organise a local course at a socially distanced training location in Bridlington. We are happy to modify the Excel syllabus to match your teams training requirements.

Excel courses are also available online. Participants can join scheduled virtual classes, watch the tutor demonstrate the topic, ask questions and share their screen

We have two decades of delivering technical training predominantly in the West Midlands. Our clients include: Lloyds TSB Bank PLC, University of Birmingham, Yell Group PLC, Nationwide Building Society Limited, Aston University, DHL Express, Birmingham Heartlands Hospital and West Bromwich Building Society.




Excel Programming Using VBA

  • 2 day course
  • Location: Bridlington
  • 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 ...
  • Recording a Macro
    Understanding Collections
    Handling Errors
    Using the Toolbox
    Using the For Each...Next Structure
    Creating a Function Procedure
    Using the With Statement
    Populating a Control
    Working with Inline Error Handling
    Understanding Control-of-Flow Structures
    Understanding Expressions and Statements
    Determining the Value of Expressions
    Using the Object Browser
    Working with Procedures and Functions
    Navigating the Excel Object Hierarchy
    Creating a Sub Procedure
    Using Intrinsic Functions
    Understanding Objects
    Understanding the Err Object
    Working with Methods

  • See Training Course Details...


Microsoft Excel Power Query

  • 1 day course
  • Location: Bridlington
  • 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 ...
  • Introduction to Power BI Desktop
    Appending Operations
    Course topics include- INTRODUCTION TO POWER QUERY
    Loading into Excel
    Using Ranges in Excel
    Combining Worksheets
    Working with Folders and Files
    Summarising WORKING WITH THE POWER QUERY LANGUAGE “M”
    Understanding the Issues
    Using PivotTables CONNECTING TO DATABASES
    Loading into Power BI Desktop
    Understand and perform importing from SQL Server Analysis Services Tabular. PERFORMING MERGES
    Loading into Power Pivot
    Loading Data
    Importing, Transforming, and Loading Data into Excel and Power Pivot
    Data Sources GROUPING AND SUMMARISING WITH POWER QUERY
    Understand the M interface.
    Understand working with relational data.
    Understanding and Handling Special Situations
    Performing Merges
    Understand and utilize merges. LOADING YOUR DATA

  • See Training Course Details...


Excel Basic

  • 1 day course
  • Location: Bridlington
  • 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 ...
  • Typing Dates
    Previewing Before You Print
    Vertical Cell Alignment
    Understanding Data Editing
    Making Basic Changes
    Making Cells Bold
    Exiting Safely From Excel Creating a New Workbook
    Changing the Chart Layout
    Horizontal Cell Alignment
    Common Error Messages Formula Referencing
    Underlining Text
    Inserting Columns Into a Worksheet
    Changing Background Colours
    Using Tell Me
    Finding a Maximum Value
    Navigating the Help Window
    Using Google to Get Help
    Using the Thousands Separator
    Using Wildcards Printing
    Viewing Worksheet Gridlines
    Creating Formulas That Add

  • See Training Course Details...


Excel Advanced

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

  • Some of the training topics covered include ...
  • Understanding Excel Macros
    Deleting Comments Recorded Macros
    Counting in a PivotTable
    Navigating Worksheet Comments
    Using Database Functions
    Consolidating From Different Layouts
    Creating an Automatic Outline
    Understanding Data Importing
    Providing Restricted Access to Cells
    Working With Connected Data Unlinking Connections
    Creating Calculated Fields
    Understanding Data Protection
    Password Protecting a Workbook
    Setting the Default Font
    Creating an Input Message
    Grouping by Columns Summarising and Subtotalling
    Setting Save Options
    Sharing Workbooks
    Creating a Scenario Summary Report
    Running a Macro From the Toolbar
    Inserting a Timeline Filter PivotTable Features

  • See Training Course Details...


Excel Power Pivot

  • 1 day course
  • Location: Bridlington
  • 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 ...
  • Understanding Power Map
    Adding Titles and Images
    Working With the Data Model
    Working With a Power View Object
    Changing the Look
    Merging Queries
    Working With Layers
    Working With Time Settings
    Displaying the Query Editor
    Enabling Power Pivot
    Saving and Sharing Queries
    Working With Data Model Fields
    Adding Power View to the Ribbon
    Filtering in Power View
    Working With Scenes
    Rearranging and Sorting Fields
    Tiling Data in Power View
    Creating a New Query From a File
    Working With Merged Queries
    Working With Power View Fields

  • See Training Course Details...


Microsoft Excel PowerPivot Data Analytic Expressions DAX Language

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

  • See Training Course Details...


Excel Intermediate

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

  • Some of the training topics covered include ...
  • Clearing Print Titles
    Values Conditional Formatting
    Filling Data
    Changing Line Chart Colours
    Working With Data Bars
    Centring on a Page
    Sorting Tables
    The ROUND Function
    The PMT Function Complex Formulas
    Formatting Calculated Time
    Applying Alternate Currencies
    Creating Names Using the Name Box
    Removing Table Columns
    Adding a Chart Title
    Quick Sparklines
    Defining Names From Worksheet
    Understanding Defined Names
    The TODAY Function
    Working With Colour Scales
    Aligning Numbers Using Custom
    Filling a Series

  • See Training Course Details...



Email us about this courses



Other Bridlington Enable Technology Training Courses

JQuery Mobile Bridlington Training Courses
PowerPoint Advanced Bridlington Training Courses
Access 2016 Bridlington Training Courses
SSIS 2014 Bridlington Training Courses
Visio 2013 Bridlington Training Courses
SSRS 2016 Bridlington Training Courses
SSIS 2008 - Bridlington SQL Server Integration Services Training Courses
PHP - Bridlington PHP Training Courses
SSRS 2008 - Bridlington SQL Server Reporting Services Training Courses
Crystal 2008 - Bridlington Crystal Reports Training Courses
Power BI Bridlington Training Courses
SSAS 2017 - Bridlington SQL Server Analysis Services Training Courses
SSAS Tabular - Bridlington SQL Server Analysis Services Training Courses
JavaScript Bridlington Training Courses
Crystal 2013 Bridlington Training Courses
Report Builder - Bridlington SQL Server Reporting Services Training Courses
SSAS 2005 - Bridlington SQL Server Analysis Services Training Courses
Oracle SQL - Bridlington SQL Training Courses
SSRS 2005 Bridlington Training Courses
PL/SQL - Bridlington SQL Training Courses
HTML Bridlington Training Courses



North - Possible Excel Training Course Locations


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

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