Enable Technology

EXCEL BRIDLINGTON TRAINING COURSES 

EXCEL TRAINING COURSES BRIDLINGTON




About Enable Technology Bridlington Excel Training Courses

We are a company that provides short intensive Excel training courses. The tutor delivering the course will be a Microsoft certified expert. Every course participant is given Excel courseware which they can refer to after the training. Our policy is to provide open ended Excel post training support to participants. This additional service is an important part ofhow we help people implement the skills they have learned in the workplace.

Excel courses are taught by a Microsoft Certified Solutions Expert. We are set up to deliver Excel training courses onsite at your premises. Another option is we can organise a local socially distanced training site in Bridlington. The Excel syllabus can be modified to accommodate your specific training needs.

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 operated primarily in the West Midlands for twenty years. Our clients include: Boots UK Limited, Norfolk Police Constabulary, Unipart Group, Vodafone Group Services, Loughborough University, Royal Air Force, Carillion PLC and Countrywide Homes Limited.




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 ...
  • Displaying Scenarios
    Opening Shared Workbooks
    Using Names in Scenarios
    Understanding Advanced Filtering
    Sharing Workbooks
    Creating a Default Scenario
    Adding a Check Box Control
    Adding a Spin Button Control
    Creating Calculated Fields
    Using a Subtotalled Worksheet
    Working With Connected Data Unlinking Connections
    Creating Your Own PivotTable
    Adding Option Button Controls
    Creating Nested Subtotals
    Setting Formula Options
    Running a Recorded Macro
    Using Compound Fields
    Understanding Data Protection
    Creating a Two-Variable Data Table Scenarios
    Creating Running Totals
    Adding a Scroll Bar Control

  • 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 ...
  • Adding More Power Views
    Navigating a Data Map
    Creating a New Query From a File
    Exporting a Tour as a Video
    Formatting Power View Data
    Adding Power View to the Ribbon
    Changing a Power Pivot View
    Working With Location Fields
    Filtering in Power View
    Working With Scene Options
    Reducing Data Rows
    Editing Query Steps
    Viewing and Editing a Tour
    Working With Measure Fields
    Working With a Power View Object
    Creating a Concatenated Field
    Using Related Power Pivot Fields
    Adding a Data Column
    Creating a Calculated Field
    Understanding Power Pivot

  • 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 ...
  • Formatting the Drawing Pencil Essential Functions
    Setting a Background
    Clearing Conditional Formatting
    Copying Nested Functions
    Values Conditional Formatting
    Changing Individual Bar Colours
    Copying a Worksheet
    Understanding the Format Pane
    Understanding Goal Seeking
    Renaming a Worksheet
    Formatting Cells Containing Values
    Changing WordArt Effects
    Selecting Chart Objects
    Inserting and Deleting Worksheets
    Using the Name Manager
    Applying a Border to a Cell
    Using Built in Margins
    Printing Headings
    Manipulative Functions
    Splitting a Table
    Using Names in Typed Formulas

  • See Training Course Details...


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 ...
  • Creating a Function Procedure
    Creating a Sub Procedure
    Working with Control Appearance
    Creating a Standard Module
    Understanding Expressions and Statements
    Working with the PivotTable Objects
    Understanding UserForms
    Navigating the Excel Object Hierarchy
    Running a Macro
    Using the Object Browser
    Understanding Controls
    Working with Boolean Expressions
    Setting the Tab Order
    Using Input Boxes
    Working with Variable Scope
    Handling Errors
    Using the For Each...Next Structure
    Working with UserForm Properties, Events, and Methods
    Closing the Visual Basic Editor
    Understanding Constants

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

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

  • 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 ...
  • Working With Multiple Worksheets
    Changing Background Colours
    Resizing a Chart
    Using Shortcut Menus
    Formatting as Fractions
    Formatting for Money
    Accessing the Backstage View
    Indenting Cells
    Italicising Text
    Exiting Safely From Excel Creating a New Workbook
    Applying and Using a Filter
    Changing the Worksheet View
    Understanding Filtering
    Understanding the Quick Access Toolbar
    Accessing the Help Window
    Viewing the Formula Bar
    Making Cells Bold
    How Excel Works
    Finding a Maximum Value
    Navigating a Workbook
    Creating Formulas That Subtract

  • See Training Course Details...



Email us about this courses



Other Bridlington Enable Technology Training Courses

SSAS 2008 - Bridlington SQL Server Analysis Services Training Courses
SSAS Tabular Bridlington Training Courses
SQL - Bridlington SQL Training Courses
Report Builder - Bridlington SQL Server Reporting Services Training Courses
SSAS 2017 Bridlington Training Courses
Project 2016 Bridlington Training Courses
JQuery Bridlington Training Courses
Mobile Bridlington Training Courses
Crystal 2008 Bridlington Training Courses
Microsoft Project Level 3 Bridlington Training Courses
HTML - Bridlington Web Development Training Courses
Access VBA Bridlington Training Courses
Microsoft Project Level 2 - Bridlington Microsoft Project Training Courses
SSRS 2005 Bridlington Training Courses
Crystal 2013 - Bridlington Crystal Reports Training Courses
PowerPoint Advanced Bridlington Training Courses
Power Graphics - Bridlington Data Analytics Training Courses
SSRS 2016 - Bridlington SQL Server Reporting Services Training Courses
Data Mining - Bridlington Data Analytics Training Courses
SSIS 2005 - Bridlington SQL Server Integration Services Training Courses
SSRS 2014 Bridlington Training Courses



North - Possible Excel Training Course Locations


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

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