EXCEL TRAINING COURSES NORMANTON
About Enable Technology Normanton Excel Training Courses
We are company which specialises in short, two and three day intensive Excel technology training courses. All of our tutors are Microsoft Certified Professionals. Every person attending a Excel course will be provided with training materials and practice files to retain after the course. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with Excel queries.
We provide instructor led training coupled with hands on training. We are set up to deliver Excel training courses onsite at your premises. Alternatively we could schedule a course at a local socially distanced venue in Normanton. Every Excel course can be modified to meet your bespoke requirements.
This instructor led Excel training is also available online. Participants can see the tutors screen, ask questions and share their screen with the tutor.
The Enable Technology team have been providing IT training primarily in the Midlands for two decades. Some of our clients are Norfolk Police Constabulary, Cadbury PLC, Aston University, Nuclear Engineering Services, West Bromwich Building Society, Nationwide Building Society Limited, University of Birmingham and GKN PLC.
Excel Advanced
- 1 day course
- Location: Normanton
- 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
- See Training Course Details...
Setting Excel Options
Editing Worksheet Comments
Accepting or Rejecting Changes
Assigning a Macro to the Ribbon
Consolidating Data Using the SUM Function Data Tables
Linking Between Worksheets
Understanding Data Validation
Inserting a PivotChart
Defining the PivotTable Structure
Grouping in PivotTable Reports
Moving PivotCharts to Chart Sheets Advanced Filters
Creating a Two-Variable Data Table Scenarios
Using the Cell Link to Display the Selection
Understanding How Controls Work
Assigning a Macro to the Toolbar
Switching PivotTable Fields
Opening a Password Protected Workbook
Copying a Macro
Using DSUM
Formatting a PivotTable
Excel Basic
- 1 day course
- Location: Normanton
- 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 ... How Excel Works
- See Training Course Details...
Using the SUM Function to Add
Absolute Versus Relative Referencing
Recent Files and Folders Editing in a Workbook
Resizing a Chart
Using Shortcut Menus
Using a Recommended Chart
Creating Mixed References Font Formatting
Selecting Contiguous Ranges
Using Undo and Redo Selecting Ranges
Creating Absolute References
Understanding the Charting Process
Formatting as Fractions
Applying General Formatting
Copying From One Cell to a Range
What if Formulas
Understanding the Status Bar
Safely Closing a Workbook Working With Workbooks
Approximating Column Widths
Changing the Chart Style
Specifying the Number of Copies
Microsoft Excel PowerPivot Data Analytic Expressions DAX Language
- 2 day course
- Location: Normanton
- 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 ... Explaining Syntax
- See Training Course Details...
Statistical Functions
Date Functions
Filter Functions
Relational Functions Understanding Evaluation Contexts
Exploring Data Types
Understanding Values
Many-to-Many Relationships
Conversion Functions
Using Multiple Calendars Utilising Advanced DAX Functionality
Utilizing Operators
Handling Errors Using DAX Functions
Working with Calendars
PowerPivot Data Model
Logical Functions
Multiple Table Evaluation Context Working with Dates
Aggregation Functions
Introduction to DAX
Mathematical Functions
Text Functions
Microsoft Excel Power Query
- 1 day course
- Location: Normanton
- 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 ... Loading into Power BI Desktop
- See Training Course Details...
Understand working with relational data.
Loading into Excel
Understand the M interface.
Using PivotTables CONNECTING TO DATABASES
Introduction to Power BI Desktop
Data Sources GROUPING AND SUMMARISING WITH POWER QUERY
Power Query Interface
Performing Merges
Understanding Data Types WORKING WITH CSV, TXT AND EXCEL WORKSHEETS
Understand and perform importing from SQL Server Analysis Services Tabular. PERFORMING MERGES
Importing, Transforming, and Loading Data into Excel and Power Pivot
Working with Folders and Files
Understand Power Query formulas.
Combining Worksheets
Transforming Data
Understand and perform importing from SQL Server Analysis Services Multidimensional.
Importing Data
Appending Operations
Using Ranges in Excel
Understanding the Issues
Excel Power Pivot
- 1 day course
- Location: Normanton
- 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 ... Reducing Data Rows
- See Training Course Details...
Understanding Relational Data
Working With Height and Category
Changing a Power Pivot View
Rearranging and Sorting Fields
Enabling Power View
Merging Queries
Creating a Timeline
Working With Merged Queries
Creating a New Query From a File
Changing the Look
Working With the Data Model
Connecting to a Data Source
Adding Slicers Get & Transform
Working With Time Settings
Power Pivot
Understanding Power Map
Displaying the Query Editor
Tiling Data in Power View
Switching Visualisations
Using Related Power Pivot Fields
Excel Intermediate
- 1 day course
- Location: Normanton
- Telephone on 01952 305730
- Course Outline
-
A one day course covering Microsoft Excel Intermediate topics.
- Some of the training topics covered include ... Scoping Names to a Worksheet
- See Training Course Details...
Clearing the Print Area
Formatting the Chart Area
Applying a Bottom Border
Adding Axes Titles
Applying Alternate Date Formats
Renaming a Worksheet
Showing Gridlines
Editing Sparklines Goal Seeking
Copying a Worksheet
Formatting
Fit to a Specific Number of Pages Applying Borders
Understanding Page Layout
Specifying the Paper Size
Removing Duplicates
The More Borders Command
Using Names in Typed Formulas
Formulas
Quick Charting
Excel Programming Using VBA
- 2 day course
- Location: Normanton
- 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 ... Running a Macro
- See Training Course Details...
Understanding UserForms
Determining the Value of Expressions
Understanding Procedures
Using the Do...Loop Structure
Understanding Errors
Using Intrinsic Constants
Working with Forms and Controls
Using the Toolbox
Using the If...End If Decision Structures
Understanding the Development Environment
Using the For Each...Next Structure
Understanding VBA's Error Trapping Options
Adding Code to Controls
Writing an Error-Handling Routine
Working with the PivotFields Collection
Understanding Controls
Setting the Tab Order
Recording a Macro
Email us about this courses
Other Normanton Enable Technology Training Courses
Mobile Normanton Training Courses
SSAS 2005 - Normanton SQL Server Analysis Services Training Courses
Report Builder - Normanton SQL Server Reporting Services Training Courses
SSIS 2005 Normanton Training Courses
Project 2016 - Normanton Microsoft Project Training Courses
Project 2016 L1 - Normanton Microsoft Project Training Courses
SSIS 2008 - Normanton SQL Server Integration Services Training Courses
Oracle BI Normanton Training Courses
SSAS Tabular Normanton Training Courses
Crystal 2008 - Normanton Crystal Reports Training Courses
PowerPoint Basic - Normanton Office Training Courses
SSRS 2016 - Normanton SQL Server Reporting Services Training Courses
SSAS 2014 - Normanton SQL Server Analysis Services Training Courses
Oracle SQL - Normanton SQL Training Courses
JQuery - Normanton JavaScript Training Courses
PL/SQL Normanton Training Courses
SSRS 2008 - Normanton SQL Server Reporting Services Training Courses
TSQL - Normanton SQL Training Courses
SSAS 2008 - Normanton SQL Server Analysis Services Training Courses
Crystal 2011 Normanton Training Courses
Microsoft Project Level 3 - Normanton Microsoft Project Training Courses
North - Possible Excel Training Course Locations
Leeds Excel Training Courses
Sheffield Excel Training Courses
Harrogate Excel Training Courses
Newcastle Upon Tyne Excel Training Courses
North East Excel Training Courses
Castleford Excel Training Courses
Bridlington Excel Training Courses
Hartlepool Excel Training Courses
Doncaster Excel Training Courses
Pudsey Excel Training Courses
South Shields Excel Training Courses
Durham Excel Training Courses
Grimsby Excel Training Courses
Halifax Excel Training Courses
Keighley Excel Training Courses
Middlesbrough Excel Training Courses
Dewsbury Excel Training Courses
Barnsley Excel Training Courses
Normanton Excel Training Courses
York Excel Training Courses
Yorkshire Excel Training Courses
Batley Excel Training Courses
Scunthorpe Excel Training Courses
Wetherby Excel Training Courses
Scarborough Excel Training Courses
Wakefield Excel Training Courses
Huddersfield Excel Training Courses
Hexham Excel Training Courses
Gateshead Excel Training Courses
Rotherham Excel Training Courses
Sunderland Excel Training Courses
Leeds, Sheffield, Harrogate, Newcastle Upon Tyne, North East, Castleford, Bridlington, Hartlepool, Doncaster, Pudsey, South Shields, Durham, Grimsby, Halifax, Keighley, Middlesbrough, Dewsbury, Barnsley, Normanton, York, Yorkshire, Batley, Scunthorpe, Wetherby, Scarborough, Wakefield, Huddersfield, Hexham, Gateshead, Rotherham, Sunderland