Enable Technology

EXCEL YORK TRAINING COURSES 

EXCEL TRAINING COURSES YORK




About Enable Technology York Excel Training Courses

Enable Technology Excel courses are short, skill focused and hands on. The tutor teaching the course will be an experienced developer and Microsoft certified professional. All candidates receive comprehensive Excel training materials and practice files which are theirs to refer to after the course. It is our policy to support delegates apply their new skill after the course. All candidate will be able to contact the course Tutor for as long as they feel they need help.

Enable Technology training courses are delivered as instructor led courses. Our Excel training courses can be delivered onsite at your location. You simply need to provide a room. We can supply the equipment and software. Another option is we can organise a local socially distanced training site in York. The Excel syllabus can be modified to accommodate your specific training needs.

We also deliver this course online. Delegates participate in a virtual Excel class and can both talk to and share their screen with the tutor.

The Enable Technology team have had two decades of experience delivering technical training mainly in the Midlands region. Our clients include: Loughborough University, Cadbury PLC, Norwich Union PLC, Unipart Group, Royal & Sun Alliance Group PLC, Countrywide Homes Limited, Yell Group PLC and West Bromwich Building Society.




Excel Programming Using VBA

  • 2 day course
  • Location: York
  • 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 ...
  • Working with the Combo Box Control
    Using the If...End If Decision Structures
    Populating a Control
    Running a Macro
    Recording a Macro
    Working with the Frame Control
    Understanding Objects
    Declaring and Using Object Variables
    Understanding the Err Object
    Understanding Control-of-Flow Structures
    Using Debugging Tools
    Assigning a Macro to the Quick Access Toolbar
    Calling Procedures
    Declaring Variables
    Using the With Statement
    Using the Object Browser
    Working with the Command Button Control
    Working with Procedures and Functions
    Working with the Label Control
    Using Input Boxes

  • See Training Course Details...


Excel Power Pivot

  • 1 day course
  • Location: York
  • 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 ...
  • Filtering in Power View
    Adding Power View to the Ribbon
    Working With Time Settings
    Managing Data Columns
    Creating a Concatenated Field
    Creating a Power Map Tour
    Understanding Power Map
    Understanding the Navigator Pane
    The Advanced Editor
    Connecting to a Data Source
    Changing the Look
    Updating a Power View Report
    Transforming Data
    Working With Merged Queries
    Understanding Power Pivot
    Editing Query Steps
    Power Pivot
    Working With Power View Fields
    Adding Slicers Get & Transform
    Displaying the Query Editor
    Formatting Data Model Fields

  • See Training Course Details...


Excel Basic

  • 1 day course
  • Location: York
  • 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 ...
  • Easy Formulas
    Understanding the Backstage View
    Understanding the Excel Start Screen
    Sorting on More Than One Column Filtering Data
    Creating Compound Filters
    How Excel Works
    Italicising Text
    Recent Files and Folders Editing in a Workbook
    Checking the Spelling
    Understanding Number Formatting
    Understanding the Charting Process
    Finding a Maximum Value
    Creating a New Chart From Scratch
    Using Shortcut Menus
    Calculating an Average
    Approximating Column Widths
    Using Go To
    Typing Text
    Horizontal Cell Alignment
    Inserting Cells Into a Worksheet
    Relative Formulas

  • See Training Course Details...


Excel Advanced

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

  • Some of the training topics covered include ...
  • Preparing a Worksheet for Controls
    Consolidating With Identical Layouts
    Consolidating Data Using the SUM Function Data Tables
    Importing Comma Delimited Text
    Navigating Worksheet Comments
    Opening a Password Protected Workbook
    Deleting Comments Recorded Macros
    Assigning a Macro to the Ribbon
    Understanding Data Validation
    Creating a Scenario Summary Report
    Defining the PivotChart Structure
    Finding the Percentage of Total
    Password Protecting a Workbook
    Assigning a Keyboard Shortcut to a Macro
    Creating a Drop Down List
    Creating Calculated Items
    Setting Macro Security
    Using a Simple What-If Model
    Understanding Excel Macros
    Using Formulas in Criteria
    Grouping by Columns Summarising and Subtotalling

  • See Training Course Details...


Excel Intermediate

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

  • Some of the training topics covered include ...
  • Renaming a Table
    Understanding Quick Analysis
    Key Worksheet Functions
    Exploding Pie Slices
    Using IF With Text
    Preparing for Complex Formulas
    Fit to a Specific Number of Pages Applying Borders
    Changing Orientation
    Changing Line Chart Colours
    Hiding a Worksheet
    Filling a Growth Series
    Changing Column Colour Schemes
    Formatting
    Drawing Borders
    Top Ten Items
    Using Goal Seek The Quick Analysis Tools
    Removing Borders
    Understanding Number Formatting
    Specifying the Paper Size
    Copying a Sheet to Another
    The DATE Function

  • See Training Course Details...


Microsoft Excel PowerPivot Data Analytic Expressions DAX Language

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

  • See Training Course Details...


Microsoft Excel Power Query

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

  • See Training Course Details...



Email us about this courses



Other York Enable Technology Training Courses

SSIS 2014 - York SQL Server Integration Services Training Courses
Oracle SQL - York SQL Training Courses
SSRS 2016 York Training Courses
Mobile York Training Courses
Project 2016 L1 York Training Courses
JavaScript - York JavaScript Training Courses
CSS - York Web Development Training Courses
SSAS 2017 - York SQL Server Analysis Services Training Courses
SSAS 2008 - York SQL Server Analysis Services Training Courses
Power Graphics York Training Courses
Power BI York Training Courses
Crystal 2011 York Training Courses
Data Warehouse - York SQL Training Courses
SSRS 2008 - York SQL Server Reporting Services Training Courses
Access VBA York Training Courses
SSAS Tabular - York SQL Server Analysis Services Training Courses
Report Builder - York SQL Server Reporting Services Training Courses
Visio 2013 - York Visio Training Courses
Microsoft Project Level 2 York Training Courses
PL/SQL - York SQL Training Courses
SSRS 2005 York Training Courses



North - Possible Excel Training Course Locations


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

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