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
- See Training Course Details...
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
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
- See Training Course Details...
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
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
- See Training Course Details...
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
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
- See Training Course Details...
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
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
- See Training Course Details...
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
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
- See Training Course Details...
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
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
- See Training Course Details...
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
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