Enable Technology

EXCEL ROCHDALE TRAINING COURSES 

EXCEL TRAINING COURSES ROCHDALE




About Enable Technology Rochdale Excel Training Courses

Enable Technology offer short intensive skills based Excel training courses. The course will always be taught by a Microsoft Certified Professional (MCP). Every course participant is given Excel courseware which they can refer to after the training. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with Excel queries.

Delegates are taught by an experienced Microsoft professional. Excel courses are delivered through a mix of practical hands on exercises and walk throughs. Enable Technology Excel training courses can be delivered at your offices. We can supply the necessary software and computers. The Excel course could also be scheduled at a socially distanced site near you in Rochdale. We are more than happy to incorporate additional topics to accommodate your organisations Excel training needs.

We also deliver this course online through virtual classrooms. Delegates can join scheduled Excel classes, view the tutors demonstrations, ask questions and share their screen with the trainer if they need assistance.

The Enable Technology team have had two decades of experience delivering technical training mainly in the Midlands region. Our clients include: Birmingham City University, Cadbury PLC, Vodafone Group Services, South Staffordshire Water PLC, Queen's Medical Centre Nottingham, Halfords Group PLC, Barclays Bank PLC and Norfolk Police Constabulary.




Excel Programming Using VBA

  • 2 day course
  • Location: Rochdale
  • 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 ...
  • Declaring Variables
    Working with the PivotTable Object
    Creating a Function Procedure
    Handling Errors
    Using the Object Browser
    Working with the PivotFields Collection
    Understanding Macro Security
    Working with UserForm Properties, Events, and Methods
    Understanding Error Handling
    Using Break Mode during Run mode
    Using the Toolbox
    Understanding Objects
    Using Intrinsic Functions
    Saving a Macro-Enabled Workbook
    Calling Procedures
    Naming Procedures
    Setting the Tab Order
    Working with Methods
    Editing a Macro in the Visual Basic Editor
    Working with Option Button Controls

  • See Training Course Details...


Excel Intermediate

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

  • Some of the training topics covered include ...
  • Settings Rows as Repeating Print
    Adding a Chart Title
    The LOOKUP Function
    Understanding Chart Formatting
    Filling Using Options
    Understanding Goal Seeking
    Pasting Values From Formulas
    Documenting Defined Names Number Formatting Techniques
    Clearing the Print Area
    The PMT Function Complex Formulas
    Splitting Windows Page Setup
    Working With Data Bars
    Working With Colour Scales
    Showing Data Labels
    Copying Nested Functions
    Adding More Complexity
    Understanding Conditional
    Padding Numbers Using Custom
    Creating Names Using the Name Box
    Applying a Border to a Range
    Top Ten Items

  • See Training Course Details...


Excel Advanced

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

  • Some of the training topics covered include ...
  • Disabling Tracked Changes
    Assigning a Macro to the Toolbar
    Creating a Drop Down List
    Formatting PivotTable Values
    Assigning a Keyboard Shortcut to a Macro
    Grouping in PivotTable Reports
    Adding a Combo Box Control
    Setting the Default File Location
    Adding a Group Box Control
    Deleting a Macro
    Creating Running Totals
    Removing Invalid Circles
    Using the DMIN Function
    Using Relative Names for Subtotals Data Consolidation
    Inserting a Timeline Filter PivotTable Features
    Consolidating With Identical Layouts
    Importing Space Delimited Text
    Understanding Database Functions
    Providing Custom Names
    Providing Total Access to Cells
    Using the PivotChart Filter Field Buttons

  • See Training Course Details...


Excel Basic

  • 1 day course
  • Location: Rochdale
  • 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 Non Contiguous Ranges
    Navigating Using the Keyboard
    Changing the Chart Layout
    Understanding Number Formatting
    Understanding Cells and Ranges
    Understanding Dialog Boxes
    Inserting Columns Into a Worksheet
    Creating a Chart Sheet
    Getting to Know Excel
    Editing Formulas
    Vertical Cell Alignment
    Opening an Existing Workbook
    Printing a Range
    Applying General Formatting
    Understanding Filling
    Typing Dates
    Accessing the Help Window
    Using Google to Get Help
    Creating Compound Filters
    Recent Files and Folders Editing in a Workbook
    Printing a Chart Sheet

  • See Training Course Details...


Microsoft Excel PowerPivot Data Analytic Expressions DAX Language

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

  • See Training Course Details...


Microsoft Excel Power Query

  • 1 day course
  • Location: Rochdale
  • 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 Data
    Power Query Interface
    Understand and perform importing from SQL Server Analysis Services Tabular. PERFORMING MERGES
    Understand Power Query formulas.
    Understanding the Issues
    Loading into Power BI Desktop
    Understand and perform importing from SQL Server Analysis Services Multidimensional.
    Understand working with relational data.
    Using Ranges in Excel
    Performing Merges
    Loading into Power Pivot
    Grouping Options
    Transforming Data
    Summarising WORKING WITH THE POWER QUERY LANGUAGE “M”
    Working with Folders and Files
    Course topics include- INTRODUCTION TO POWER QUERY
    Data Sources GROUPING AND SUMMARISING WITH POWER QUERY
    Using PivotTables CONNECTING TO DATABASES
    Appending Operations
    Combining Worksheets
    Understanding Data Types WORKING WITH CSV, TXT AND EXCEL WORKSHEETS

  • See Training Course Details...


Excel Power Pivot

  • 1 day course
  • Location: Rochdale
  • 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 ...
  • Switching Visualisations
    Working With Scene Options
    Understanding the Query Editor
    Working With Scenes
    Creating a New Query From a File
    Tiling Data in Power View
    Understanding Get & Transform
    Working With the Data Model
    Understanding Power View
    Updating a Power View Report
    Working With Time Settings
    Adding a Data Column
    Enabling Power Pivot
    Understanding the Navigator Pane
    Creating a Timeline
    Exporting a Tour as a Video
    Formatting Data Model Fields
    Formatting Power View Data
    Creating a Power Map Tour
    Adding Power View to the Ribbon

  • See Training Course Details...



Email us about this courses



Other Rochdale Enable Technology Training Courses

Oracle BI - Rochdale Data Analytics Training Courses
SSIS 2008 Rochdale Training Courses
SSIS 2005 - Rochdale SQL Server Integration Services Training Courses
PL/SQL Rochdale Training Courses
JavaScript - Rochdale JavaScript Training Courses
Data Mining - Rochdale Data Analytics Training Courses
PowerPoint Basic - Rochdale Office Training Courses
Mobile - Rochdale Web Development Training Courses
SSRS 2014 Rochdale Training Courses
Access 2016 - Rochdale Access Training Courses
SSAS 2014 Rochdale Training Courses
Visio 2013 - Rochdale Visio Training Courses
PHP Rochdale Training Courses
Data Warehouse - Rochdale SQL Training Courses
Microsoft Project Level 3 - Rochdale Microsoft Project Training Courses
SQL Rochdale Training Courses
HTML - Rochdale Web Development Training Courses
Project 2016 L1 - Rochdale Microsoft Project Training Courses
Crystal 2008 Rochdale Training Courses
Power BI Rochdale Training Courses
TSQL - Rochdale SQL Training Courses



North West - Possible Excel Training Course Locations


Farnworth Excel Training Courses
Middleton Excel Training Courses
Prestwich Excel Training Courses
Wigan Excel Training Courses
Accrington Excel Training Courses
Skelmersdale Excel Training Courses
Barrow-in-Furness Excel Training Courses
Chorley Excel Training Courses
Chester Excel Training Courses
Birkenhead Excel Training Courses
Leigh Excel Training Courses
Altrincham Excel Training Courses
Lancaster Excel Training Courses
Carlisle Excel Training Courses
Morecambe Excel Training Courses
Ellesmere Port Excel Training Courses
Blackpool Excel Training Courses
Bury Excel Training Courses
Warrington Excel Training Courses
Sale Excel Training Courses
Winsford Excel Training Courses
Blackburn Excel Training Courses
Denton Excel Training Courses
Cheshire Excel Training Courses
Burnley Excel Training Courses
Leyland Excel Training Courses
Ashton-under-Lyne Excel Training Courses
Bootle Excel Training Courses
Widnes Excel Training Courses
Rochdale Excel Training Courses
Bolton Excel Training Courses
Huyton Excel Training Courses
Stretford Excel Training Courses
Thornton-Cleveleys Excel Training Courses
Liverpool Excel Training Courses
Crewe Excel Training Courses
Runcorn Excel Training Courses
Wallasey Excel Training Courses
Wythenshawe Excel Training Courses
Northwich Excel Training Courses
Manchester Excel Training Courses
Eccles Excel Training Courses
Kirkby Excel Training Courses
Crosby Excel Training Courses
Oldham Excel Training Courses
Hyde Excel Training Courses
Chadderton Excel Training Courses
Stockport Excel Training Courses
Southport Excel Training Courses
Preston Excel Training Courses
Macclesfield Excel Training Courses
Lancashire Excel Training Courses
Saddleworth Excel Training Courses
Lytham Urmston Excel Training Courses
North West Excel Training Courses
Salford Excel Training Courses
Merseyside Excel Training Courses

Farnworth, Middleton, Prestwich, Wigan, Accrington, Skelmersdale, Barrow-in-furness, Chorley, Chester, Birkenhead, Leigh, Altrincham, Lancaster, Carlisle, Morecambe, Ellesmere Port, Blackpool, Bury, Warrington, Sale, Winsford, Blackburn, Denton, Cheshire, Burnley, Leyland, Ashton-under-lyne, Bootle, Widnes, Rochdale, Bolton, Huyton, Stretford, Thornton-cleveleys, Liverpool, Crewe, Runcorn, Wallasey, Wythenshawe, Northwich, Manchester, Eccles, Kirkby, Crosby, Oldham, Hyde, Chadderton, Stockport, Southport, Preston, Macclesfield, Lancashire, Saddleworth, Lytham Urmston, North West, Salford, Merseyside