Enable Technology

EXCEL GRIMSBY TRAINING COURSES 

EXCEL TRAINING COURSES GRIMSBY




About Enable Technology Grimsby Excel Training Courses

We are a company that provides short intensive Excel training courses. We guarantee the training will be delivered by a Microsoft certified expert. Each person attending a course takes away Excel courseware which can be used as reference materials after the training. We offer a post training support service and delegates will have access to a Microsoft expert on Excel for as long as they need.

We provide instructor led training coupled with hands on training. We can deliver at your premises. We can provide the equipment. We also offer the option of scheduling of Excel course at a socially distanced venue near you in Grimsby. The Excel syllabus can be adjusted and additional topics incorporated if helpful.

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

The Enable Technology team have been providing IT training primarily in the Midlands for two decades. Our clients include: Homeserve PLC, Birmingham City Council, GKN PLC, Yell Group PLC, Norfolk Police Constabulary, Vodafone Group Services, Halfords Group PLC and Nuclear Engineering Services.




Excel Advanced

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

  • Some of the training topics covered include ...
  • Understanding Data Consolidation
    PivotTable Options
    Opening a Password Protected Workbook
    Understanding Grouping and Outlining
    Creating a Linked Consolidation
    Editing Worksheet Comments
    Creating an Error Message
    Creating a Scenario Summary Report
    Working With Connected Data Unlinking Connections
    Preparing a Worksheet for Controls
    Creating a Two-Variable Data Table Scenarios
    Navigating Worksheet Comments
    Saving a Document as Macro Enabled
    Creating an Input Message
    Protecting a Worksheet With Controls Sharing Workbooks
    Setting Macro Security
    Copying Subtotals
    Setting Excel Options
    Setting the Default File Location
    Grouping in PivotTable Reports
    Understanding Data Linking

  • See Training Course Details...


Microsoft Excel PowerPivot Data Analytic Expressions DAX Language

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

  • See Training Course Details...


Excel Basic

  • 1 day course
  • Location: Grimsby
  • 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 Moving in Excel
    Understanding the Backstage View
    Setting Precise Columns Widths
    Editing Formulas
    Printing a Range
    Embedding a Chart Into a Worksheet
    Copying From One Cell to a Range
    Finding a Minimum Value
    Working With Live Preview
    Applying General Formatting
    Printing an Entire Workbook
    Specifying the Number of Copies
    Selecting Contiguous Ranges
    Approximating Column Widths
    Understanding Cells and Ranges
    Creating Compound Filters
    Creating Absolute References
    Creating Formulas That Subtract
    Using Wildcards Printing
    Previewing Before You Print
    Understanding Filling

  • See Training Course Details...


Excel Intermediate

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

  • Some of the training topics covered include ...
  • Adding Axes Titles
    Adding More Operations
    Repositioning the Legend
    More Top and Bottom Formatting
    Colouring the Chart Background
    Strategies for Printing Worksheets
    Removing Borders
    Understanding Chart Elements
    Understanding Defined Names
    Inserting or Deleting Table Records
    Manipulative Functions
    Understanding Conditional
    Splitting a Table
    Pasting Values From Formulas
    Understanding Borders
    Applying a Border to a Cell
    Splitting Windows Page Setup
    Changing Orientation
    Long-Hand Formulas
    Top Ten Items
    Editing Sparklines Goal Seeking

  • See Training Course Details...


Excel Power Pivot

  • 1 day course
  • Location: Grimsby
  • 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 View
    Working With Scenes
    Adding a Data Column
    Merging Queries
    Understanding Get & Transform
    Formatting Power View Data
    Understanding Power Pivot
    Editing Query Steps
    Creating a Power View Sheet
    Understanding the Query Editor
    Working With Layers
    Power Pivot
    Creating a New Query From a File
    Power Map
    Adding Power View to the Ribbon
    Working With Measure Fields
    Creating a Concatenated Field
    Creating a New Query From the Web
    Using Related Power Pivot Fields

  • See Training Course Details...


Excel Programming Using VBA

  • 2 day course
  • Location: Grimsby
  • 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 UserForms
    Handling Errors
    Setting Breakpoints
    Working with Procedures and Functions
    Using the With Statement
    Understanding the Err Object
    Getting Started
    Working with the PivotTable Objects
    Using Expressions, Variables, and Intrinsic Functions
    Understanding Modules
    Understanding Procedures
    Working with the Frame Control
    Understanding Macro Security
    Understanding PivotTables
    Setting Control Properties in the Properties Window
    Working with Boolean Expressions
    Working with Option Button Controls
    Controlling Program Execution
    Understanding the Development Environment

  • See Training Course Details...


Microsoft Excel Power Query

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

  • See Training Course Details...



Email us about this courses



Other Grimsby Enable Technology Training Courses

SSRS 2016 Grimsby Training Courses
Visio 2013 Grimsby Training Courses
Access VBA - Grimsby Access Training Courses
HTML Grimsby Training Courses
PHP Grimsby Training Courses
Microsoft Project Level 2 - Grimsby Microsoft Project Training Courses
Crystal XI Grimsby Training Courses
Crystal 2013 Grimsby Training Courses
Crystal 2011 - Grimsby Crystal Reports Training Courses
SSRS 2014 - Grimsby SQL Server Reporting Services Training Courses
Data Warehouse Grimsby Training Courses
Crystal 2008 - Grimsby Crystal Reports Training Courses
Report Builder Grimsby Training Courses
SSRS 2008 Grimsby Training Courses
JavaScript Grimsby Training Courses
JQuery Mobile - Grimsby JavaScript Training Courses
JQuery - Grimsby JavaScript Training Courses
SSIS 2008 Grimsby Training Courses
Project 2016 - Grimsby Microsoft Project Training Courses
Project 2016 L1 - Grimsby Microsoft Project Training Courses
SSRS 2005 - Grimsby SQL Server Reporting Services Training Courses



North - Possible Excel Training Course Locations


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

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