EXCEL TRAINING COURSES BARROW-IN-FURNESS
About Enable Technology Barrow-in-furness Excel Training Courses
Enable Technology has twenty year track record of providing short intensive Excel skills based training courses. We guarantee the training will be delivered by a Microsoft certified expert. Every course participant is given Excel courseware which they can refer to after the training. 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.
Excel courses are taught by a Microsoft Certified Solutions Expert. Enable Technology Excel training courses can be delivered at your offices. We can supply the necessary software and computers. If you prefer we can offer an offsite socially distanced training location in Barrow-in-furness. 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 Birmingham Heartlands Hospital, Shell UK Oil Products Ltd, Royal Air Force, Halfords Group PLC, West Bromwich Building Society, Barclays Bank PLC, Loughborough University and Fujistu PLC.
Excel Power Pivot
- 1 day course
- Location: Barrow-in-furness
- 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 ... Creating a Data Model PivotTable
- See Training Course Details...
Rearranging and Sorting Fields
Editing Query Steps
Working With Merged Queries
Managing Data Columns
Working With Height and Category
Working With the Data Model
Power Map
Understanding Relational Data
Working With a Power View Object
Enabling Power Pivot
Using Calculated Fields
Understanding Power Map
Working With Scenes
Adding More Power Views
Understanding the Query Editor
Adding a Data Column
Displaying the Query Editor
Understanding Power Pivot
Understanding Power View
Working With Time Settings
Excel Programming Using VBA
- 2 day course
- Location: Barrow-in-furness
- 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 ... Guidelines for use of Control-of-Flow Structures
- See Training Course Details...
Using the Select Case...End Select Structure
Creating a PivotTable Using Worksheet Data
Using the Immediate Window to Call Procedures
Understanding Objects
Creating a Standard Module
Understanding Controls
Handling Errors
Using the Object Browser
Using the For...To...Next Structure
Understanding the Development Environment
Naming Procedures
Using Debugging Tools
Understanding the Err Object
Controlling Program Execution
Debugging Code
Using the If...End If Decision Structures
Working with the PivotTable Objects
Microsoft Excel PowerPivot Data Analytic Expressions DAX Language
- 2 day course
- Location: Barrow-in-furness
- 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 ... Understanding Values
- See Training Course Details...
Introduction to DAX
Aggregation Functions
Many-to-Many Relationships
The CALCULATE Function
Statistical Functions
Text Functions
Information Functions
Relational Functions Understanding Evaluation Contexts
Working with Calendars
Filter Functions
Introduction to DAX
Date Functions
PowerPivot Data Model
Exploring Data Types
Single Table Evaluation Context
Conversion Functions
Utilizing Operators
Explaining Syntax
Handling Errors Using DAX Functions
Excel Intermediate
- 1 day course
- Location: Barrow-in-furness
- 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...
Exploding Pie Slices
Filling Data
Using Counting Functions
Extracting Dates and Numbers Worksheet Techniques
More Cell Formatting Options
Understanding Tables
Working With Icon Sets
Changing Worksheet Tab Colours
Understanding Chart Formatting
Removing Table Columns
Editing Sparklines Goal Seeking
Drawing a Border Grid
Drawing Borders
Rounding Up and Rounding Down
Documenting Formulas Defined Names
Formulas
Quick Formatting
Using the More Borders Command
Creating Names Using the Name Box
Excel Advanced
- 1 day course
- Location: Barrow-in-furness
- Telephone on 01952 305730
- Course Outline
-
A one-day course covering Microsoft Excel advanced topics.
- Some of the training topics covered include ... Working With an Outline
- See Training Course Details...
Viewing a Macro
Inserting a PivotChart
Using Relative Names for Subtotals Data Consolidation
Importing Space Delimited Text
Understanding Data Linking
Opening a Password Protected Workbook
Grouping by Columns Summarising and Subtotalling
Editing a Macro
Using One-Variable Data Tables
Sharing Workbooks
Creating a Linked Consolidation
Using the Cell Link to Display the Selection
Understanding PivotTables
Adding a Check Box Control
Understanding Save Options
Adding Worksheet Comments
Merging Scenarios PivotTables
Understanding Data Validation
Using a Subtotalled Worksheet
Creating Slicers
Excel Basic
- 1 day course
- Location: Barrow-in-furness
- 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 ... Selecting a Printer
- See Training Course Details...
Understanding the Excel Start Screen
Understanding Copying in Excel
Absolute Versus Relative Referencing
The Excel Workbook Screen
Changing Font Size
Understanding How Help Works
Understanding the Backstage View
Using Go To
Growing and Shrinking Fonts
Creating Formulas That Add
Using the SUM Function to Add
Using Wildcards Printing
Navigating the Help Window
Copying From One Cell to a Range
Previewing Before You Print
Setting Precise Columns Widths
Changing Fonts
Changing the Worksheet View
Navigating a Workbook
Showing and Collapsing the Ribbon
Microsoft Excel Power Query
- 1 day course
- Location: Barrow-in-furness
- 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 ... Understanding Data Types WORKING WITH CSV, TXT AND EXCEL WORKSHEETS
- See Training Course Details...
Using PivotTables CONNECTING TO DATABASES
Loading into Power BI Desktop
Working with Folders and Files
Grouping Options
Course topics include- INTRODUCTION TO POWER QUERY
Summarising WORKING WITH THE POWER QUERY LANGUAGE “M”
Combining Worksheets
Understand working with relational data.
Importing, Transforming, and Loading Data into Excel and Power Pivot
Data Sources GROUPING AND SUMMARISING WITH POWER QUERY
Importing Data
Loading into Excel
Understand and perform importing from SQL Server Analysis Services Multidimensional.
Loading into Power Pivot
Loading Data
Understand Power Query formulas.
Understand and perform importing from SQL Server Analysis Services Tabular. PERFORMING MERGES
Introduction to Power BI Desktop
Understand the M interface.
Performing Merges
Email us about this courses
Other Barrow-in-furness Enable Technology Training Courses
SSIS 2005 - Barrow-in-furness SQL Server Integration Services Training Courses
PowerPoint Basic Barrow-in-furness Training Courses
Crystal 2013 Barrow-in-furness Training Courses
Microsoft Project Level 3 Barrow-in-furness Training Courses
Data Warehouse - Barrow-in-furness SQL Training Courses
Crystal 2016 - Barrow-in-furness Crystal Reports Training Courses
SSAS Tabular - Barrow-in-furness SQL Server Analysis Services Training Courses
Mobile Barrow-in-furness Training Courses
Power BI Barrow-in-furness Training Courses
Access 2016 Barrow-in-furness Training Courses
Report Builder - Barrow-in-furness SQL Server Reporting Services Training Courses
Oracle SQL Barrow-in-furness Training Courses
CSS - Barrow-in-furness Web Development Training Courses
SSAS 2017 Barrow-in-furness Training Courses
JQuery Barrow-in-furness Training Courses
SSIS 2008 Barrow-in-furness Training Courses
Project 2016 L1 - Barrow-in-furness Microsoft Project Training Courses
Project 2016 Barrow-in-furness Training Courses
JavaScript - Barrow-in-furness JavaScript Training Courses
SSIS 2014 Barrow-in-furness Training Courses
PL/SQL - Barrow-in-furness SQL Training Courses