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