Enable Technology

EXCEL MIDLANDS TRAINING COURSES 

EXCEL TRAINING COURSES MIDLANDS




Excel Programming Using VBA

  • 2 day course
  • Location: Midlands
  • 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 Boolean Expressions
    Using Expressions, Variables, and Intrinsic Functions
    Assigning a Macro to the Quick Access Toolbar
    Understanding Collections
    Working with the PivotTable Objects
    Setting Control Properties in the Properties Window
    Working with the PivotTable Object
    Creating a Function Procedure
    Using the Immediate Window to Call Procedures
    Declaring and Using Object Variables
    Closing the Visual Basic Editor
    Using the Select Case...End Select Structure
    Using Intrinsic Constants
    Launching a Form in Code
    Working with the Code Editor
    Creating a Sub Procedure
    Understanding PivotTables
    Creating a Standard Module
    Setting Breakpoints
    Adding Code to Controls

  • See Training Course Details...


Excel Intermediate

  • 1 day course
  • Location: Midlands
  • Course Outline
  • A one day course covering Microsoft Excel Intermediate topics.

  • Some of the training topics covered include ...
  • Printing Headings
    Changing Margins by Dragging
    Using Counting Functions
    Understanding Goal Seeking
    Clearing Print Titles
    Strategies for Printing Worksheets
    Understanding Format Codes
    Adding Error Bars
    Drawing a Border Grid
    Grouping Worksheets
    Changing WordArt Fill
    Using Names in Typed Formulas
    Aligning Numbers Using Custom
    Clearing the Print Area
    Adding a Data Table Chart Object Formatting
    Inserting and Deleting Worksheets
    Working With Icon Sets
    Using Shape Styles
    Removing Borders
    Editing a Complex Formula
    The ROUND Function

  • See Training Course Details...


Microsoft Excel Power Query

  • 1 day course
  • Location: Midlands
  • 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 ...
  • Combining Worksheets
    Loading into Power BI Desktop
    Working with Folders and Files
    Transforming Data
    Introduction to Power BI Desktop
    Understand and perform importing from SQL Server Analysis Services Tabular. PERFORMING MERGES
    Course topics include- INTRODUCTION TO POWER QUERY
    Summarising WORKING WITH THE POWER QUERY LANGUAGE “M”
    Understand the M interface.
    Importing, Transforming, and Loading Data into Excel and Power Pivot
    Using PivotTables CONNECTING TO DATABASES
    Using Ranges in Excel
    Grouping Options
    Loading Data
    Appending Operations
    Importing Data
    Understand working with relational data.
    Understand and utilize merges. LOADING YOUR DATA
    Understanding the Issues
    Understand Power Query formulas.
    Understanding and Handling Special Situations

  • See Training Course Details...


Excel Basic

  • 1 day course
  • Location: Midlands
  • 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 ...
  • Creating Absolute References
    Filling a Growth Series
    Worksheet Zooming
    Finding a Maximum Value
    Approximating Row Height
    Creating More Complex Formulas
    Changing Font Colours
    Safely Closing a Workbook Working With Workbooks
    Setting the Default Column Width
    Working With Multiple Worksheets
    Deleting Rows and Columns
    Selecting Rows
    Checking the Spelling
    Specifying the Number of Copies
    Formatting as Fractions
    Using Tell Me
    Working With Live Preview
    Problems With Relative Formulas
    Printing a Chart Sheet
    Launching Dialog Boxes
    Applying General Formatting

  • See Training Course Details...


Excel Power Pivot

  • 1 day course
  • Location: Midlands
  • Course Outline
  • A one day course introducing candidates to Power View and Power Pivot Excel tools.

  • Some of the training topics covered include ...
  • Enabling Power View
    Power Pivot
    Working With Data Model Fields
    Understanding the Navigator Pane
    Filtering in Power View
    Understanding Relational Data
    Understanding Power Map
    Power Map
    The Advanced Editor
    Working With Merged Queries
    Creating a New Query From the Web
    Adding Slicers Get & Transform
    Working With Power View Fields
    Connecting to a Data Source
    Power View
    Navigating a Data Map
    Adding a Data Column
    Managing Data Columns
    Understanding Get & Transform

  • See Training Course Details...


Excel Advanced

  • 1 day course
  • Location: Midlands
  • Course Outline
  • A one-day course covering Microsoft Excel advanced topics.

  • Some of the training topics covered include ...
  • Sharing Workbooks
    Using DSUM
    Editing a Macro
    Navigating Worksheet Comments
    Creating Relative Names for Subtotals
    Testing a Validation
    Understanding Scenarios
    Sorting in a PivotTable PivotCharts
    Linking Between Worksheets
    Using the PivotChart Filter Field Buttons
    Creating Calculated Fields
    Assigning a Macro to the Ribbon
    Providing Total Access to Cells
    Assigning a Macro to the Toolbar
    Importing Space Delimited Text
    Linking Between Workbooks
    Understanding Types of Controls
    Copying Subtotals
    Understanding PivotTables
    Using Relative Names for Subtotals Data Consolidation
    Switching PivotTable Fields

  • See Training Course Details...


Microsoft Excel PowerPivot Data Analytic Expressions DAX Language

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

  • See Training Course Details...




Contact Us By Email         Telephone on 01952 305730




Other Midlands Enable Technology Training Courses

Publisher 2013 - Midlands Office Training Courses
Visio 2007 Midlands Training Courses
Crystal 2008 Midlands Training Courses
SSAS 2017 Midlands Training Courses
SSRS 2008 - Midlands SQL Server Reporting Services Training Courses
SSAS Tabular - Midlands SQL Server Analysis Services Training Courses
Project 2007 Midlands Training Courses
Crystal 2011 - Midlands Crystal Reports Training Courses
PowerPoint 2010 Midlands Training Courses
Word 2013 Advanced Midlands Training Courses
Power Graphics Midlands Training Courses
Word 2010 Basic - Midlands Office Training Courses
SQL - Midlands SQL Training Courses
Access 2013 Midlands Training Courses
SSAS 2008 - Midlands SQL Server Analysis Services Training Courses
HTML - Midlands Web Development Training Courses
Word 2010 Advanced - Midlands Office Training Courses
Access 2016 Midlands Training Courses
SSIS 2014 Midlands Training Courses
Photoshop - Midlands Adobe Training Courses
Data Mining Midlands Training Courses


All Enable Technology Excel Training Locations


Chester Excel Training Courses
Derby Excel Training Courses
Staffordshire Excel Training Courses
Redditch Excel Training Courses
Oxford Excel Training Courses
Nuneaton Excel Training Courses
Cannock Excel Training Courses
Leicestershire Excel Training Courses
Stafford Excel Training Courses
Wolverhampton Excel Training Courses
Burton on Trent Excel Training Courses
Telford Excel Training Courses
Worcester Excel Training Courses
Kidderminster Excel Training Courses
Nottingham Excel Training Courses
Lichfield Excel Training Courses
Stourbridge Excel Training Courses
Stoke On Trent Excel Training Courses
Cheltenham Excel Training Courses
Shrewsbury Excel Training Courses
Rugby Excel Training Courses
Leicester Excel Training Courses
Crewe Excel Training Courses
Manchester Excel Training Courses
Hereford Excel Training Courses
Milton Keynes Excel Training Courses
Sandwell Excel Training Courses
Bridgnorth Excel Training Courses
Shropshire Excel Training Courses
Birmingham Excel Training Courses
East Midlands Excel Training Courses
Dudley Excel Training Courses
Tamworth Excel Training Courses
Walsall Excel Training Courses
Bromsgrove Excel Training Courses
Solihull Excel Training Courses
Northhampton Excel Training Courses
Newcastle under Lyme Excel Training Courses
Liverpool Excel Training Courses
West Midlands Excel Training Courses
Leek Excel Training Courses
West Bromwich Excel Training Courses
Coventry Excel Training Courses
Black Country Excel Training Courses

Chester, Derby, Staffordshire, Redditch, Oxford, Nuneaton, Cannock, Leicestershire, Stafford, Wolverhampton, Burton On Trent, Telford, Worcester, Kidderminster, Nottingham, Lichfield, Stourbridge, Stoke On Trent, Cheltenham, Shrewsbury, Rugby, Leicester, Crewe, Manchester, Hereford, Milton Keynes, Sandwell, Bridgnorth, Shropshire, Birmingham, East Midlands, Dudley, Tamworth, Walsall, Bromsgrove, Solihull, Northhampton, Newcastle Under Lyme, Liverpool, West Midlands, Leek, West Bromwich, Coventry, Black Country