Enable Technology

EXCEL HARROGATE TRAINING COURSES 

EXCEL TRAINING COURSES HARROGATE




About Enable Technology Harrogate Excel Training Courses

Enable Technology provides practical Excel skills based technology training. The course will always be taught by a Microsoft Certified Professional (MCP). Every course participant will receives course practice files and Excel course resources that can be referenced post training. Course participants are welcome contact the Tutor after the course with specific Excel queries. This support is open ended.

Enable Technology Excel courses are instructor led and taught by an experienced Microsoft expert. Enable Technology can provide Excel courses onsite at your location. We will bring the necessary laptops with the required software installed. The Excel course could also be scheduled at a socially distanced site near you in Harrogate. Every Excel course can be modified to meet your bespoke requirements.

This instructor led course is also available online. Participants can log onto a virtual classroom and will be able to see the tutors screen, ask questions real time and share their screen with the Tutor.

We have two decades of delivering technical training predominantly in the West Midlands. Some of our clients are TalkTalk Direct Limited, Nuclear Engineering Services, Fujistu PLC, Unipart Group, Homeserve PLC, Vodafone Group Services, Birmingham City University and Norwich Union PLC.




Excel Programming Using VBA

  • 2 day course
  • Location: Harrogate
  • 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 Text Box Control
    Working with Inline Error Handling
    Understanding Expressions and Statements
    Navigating the Excel Object Hierarchy
    Stepping through Code
    Launching a Form in Code
    Understanding Data Types
    Using Intrinsic Constants
    Using Expressions, Variables, and Intrinsic Functions
    Creating a Standard Module
    Understanding Controls
    Working with Control Appearance
    Using the For Each...Next Structure
    Running a Macro
    Setting Breakpoints
    Using the With Statement
    Getting Started
    Declaring and Using Object Variables
    Setting the Tab Order
    Using the Toolbox
    Declaring Variables

  • See Training Course Details...


Microsoft Excel PowerPivot Data Analytic Expressions DAX Language

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

  • See Training Course Details...


Excel Advanced

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

  • Some of the training topics covered include ...
  • Opening a Password Protected Workbook
    Relative Cell References
    Extracting Records With Advanced Filter
    Creating Scenarios
    Assigning a Macro to the Toolbar
    Protecting a Worksheet With Controls Sharing Workbooks
    Enabling Tracked Changes
    Understanding Slicers
    Using Names in Scenarios
    Understanding Data Linking
    Assigning a Keyboard Shortcut to a Macro
    Adding a Combo Box Control
    Using Formulas in Criteria
    Providing Custom Names
    Using a Subtotalled Worksheet
    Running a Recorded Macro
    Using DSUM
    Adding Worksheet Comments
    Creating Slicers
    Sharing Workbooks via the Network
    Creating Calculated Items

  • See Training Course Details...


Excel Intermediate

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

  • Some of the training topics covered include ...
  • Using Shape Effects
    Splitting a Table
    Understanding Borders
    Extracting Dates and Numbers Worksheet Techniques
    Adding More Operations
    Switching to Manual Recalculation
    Freezing Rows and Columns
    Quick Totals
    Rounding Up and Rounding Down
    Manipulative Functions
    Copying Nested Functions
    Changing WordArt Fill
    Creating Sparklines
    Workbook
    Working With Icon Sets
    Formatting the Chart Area
    Creating the Base Formula
    Inserting and Deleting Worksheets
    Aligning Numbers Using Custom
    Fit to a Specific Number of Pages Applying Borders

  • See Training Course Details...


Excel Power Pivot

  • 1 day course
  • Location: Harrogate
  • 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 ...
  • Working With Power View Fields
    Filtering Data
    Power Map
    Updating a Power View Report
    Understanding Power View
    Working With a Power View Object
    Exporting a Tour as a Video
    Working With Data Model Fields
    Rearranging and Sorting Fields
    Creating a Timeline
    Creating a Calculated Field
    Creating a Concatenated Field
    Creating a New Query From a File
    Understanding Power Map
    Viewing and Editing a Tour
    Using Related Power Pivot Fields
    The Advanced Editor
    Tiling Data in Power View
    Working With Scene Options
    Understanding Get & Transform

  • See Training Course Details...


Microsoft Excel Power Query

  • 1 day course
  • Location: Harrogate
  • 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 ...
  • Course topics include- INTRODUCTION TO POWER QUERY
    Understand the M interface.
    Power Query Interface
    Importing Data
    Understanding the Issues
    Loading into Power BI Desktop
    Loading into Power Pivot
    Loading into Excel
    Understanding and Handling Special Situations
    Using PivotTables CONNECTING TO DATABASES
    Understand and perform importing from SQL Server Analysis Services Multidimensional.
    Understand and utilize merges. LOADING YOUR DATA
    Appending Operations
    Introduction to Power BI Desktop
    Transforming Data
    Loading Data
    Combining Worksheets
    Performing Merges
    Understand Power Query formulas.
    Understand working with relational data.
    Working with Folders and Files

  • See Training Course Details...


Excel Basic

  • 1 day course
  • Location: Harrogate
  • 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 ...
  • Using Shortcut Menus
    Selecting Non Contiguous Ranges
    Inserting Cells Into a Worksheet
    Using Go To
    Summing Non-Contiguous Ranges
    Creating Absolute References
    Checking the Spelling
    Editing Formulas
    Previewing Before You Print
    Overwriting Cell Contents
    The Excel Workbook Screen
    Selecting a Printer
    Performing a Numerical Sort
    Using the Format Painter Cell Alignment
    Worksheet Wisdom Sorting Data
    Recent Files and Folders Editing in a Workbook
    Repositioning a Chart
    Working With Multiple Worksheets
    Copying From One Cell to Another
    Increasing and Decreasing Decimals Row and Column Formatting

  • See Training Course Details...



Email us about this courses



Other Harrogate Enable Technology Training Courses

Crystal 2008 Harrogate Training Courses
CSS Harrogate Training Courses
JQuery Harrogate Training Courses
Data Mining Harrogate Training Courses
PHP Harrogate Training Courses
SSAS 2005 - Harrogate SQL Server Analysis Services Training Courses
Power Graphics - Harrogate Data Analytics Training Courses
PL/SQL Harrogate Training Courses
Access VBA Harrogate Training Courses
Project 2016 - Harrogate Microsoft Project Training Courses
Access 2016 - Harrogate Access Training Courses
Oracle SQL - Harrogate SQL Training Courses
HTML Harrogate Training Courses
JavaScript - Harrogate JavaScript Training Courses
SSAS 2008 Harrogate Training Courses
Mobile - Harrogate Web Development Training Courses
SSRS 2008 Harrogate Training Courses
SSAS 2014 - Harrogate SQL Server Analysis Services Training Courses
SSRS 2014 Harrogate Training Courses
Data Warehouse Harrogate Training Courses
SSRS 2005 Harrogate Training Courses



North - Possible Excel Training Course Locations


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

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