EXCEL TRAINING COURSES SALFORD
About Enable Technology Salford Excel Training Courses
Enable Technology offer short intensive skills based Excel training courses. All training will be delivered by an appropriately qualified Microsoft Certified Solutions Expert. Each course participant will be issued with training Excel resources which they can continue to use after the training. Course participants are welcome contact the Tutor after the course with specific Excel queries. This support is open ended.
We specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. We are set up to deliver Excel training courses onsite at your premises. Another way we could deliver the Excel course is at a local socially distanced training site. We offer the option of working with you to develop a bespoke Excel programme which precisely matches your organisations training requirements.
We also deliver this course online. Delegates participate in a virtual Excel class and can both talk to and share their screen with the tutor.
Our teaching team have been delivering technical training in the Midlands for twenty years. Our clients include: South Staffordshire Water PLC, Birmingham Heartlands Hospital, Keele University, EDF Energy PLC, Birmingham City Council, Canadian High Commission, GKN PLC and Birmingham City University.
Excel 365 Basic
- 1 day course
- Location: Salford
- Telephone on 01952 938014
- Course Outline
-
In this course, you will learn fundamental Excel skills. You will:
Familiarize yourself with Excel's layout, its various parts, its commands, and its terminology.
Outline Excel's abilities to quickly, efficiently, and accurately calculate data.
Update worksheets without throwing away all of the valuable work you've already done.
Format a worksheet and organize your data.
Print workbooks.
Manage the overall structure of your workbooks. - Some of the training topics covered include ... Navigate the Excel User Interface
- See Training Course Details...
Manage Worksheets
Apply Number Formats
Create and Save a Basic Workbook
Set Up the Page Layout
Use Proofing and Research Tools Formatting a Worksheet
Align Cell Contents
Navigate in Excel for the Web
Configure Headers and Footers Managing Workbooks
Apply Text Formats
Preview and Print a Workbook
Enter Cell Data Performing Calculations
Search for and Replace Data
Apply Colors, Borders, and Styles
Use Excel Commands
Reuse Formulas and Functions Modifying a Worksheet
Adjust Cells, Columns, and Rows
Apply Basic Conditional Formatting Printing Workbooks
Insert Functions
Getting Started with Excel
Manage Workbook Properties
Excel 365 Advanced
- 1 day course
- Location: Salford
- Telephone on 01952 938014
- Course Outline
-
Upon successful completion of this course, you will be able to perform advanced data analysis, collaborate on workbooks with other users, and automate workbook functionality. You will:
Work with multiple worksheets and workbooks.
Share and protect workbooks.
Automate workbook functionality.
Use Lookup functions and formula auditing.
Forecast data.
Create sparklines and map data. - Some of the training topics covered include ... Search for Invalid Data and Formulas with Errors
- See Training Course Details...
Collaborate on a Workbook
Forecast Data Trends
Trace Cells
Watch and Evaluate Formulas Forecasting Data
Determine Potential Outcomes Using Data Tables
Use Links and External References
Determine Potential Outcomes Using Scenarios
Working with Multiple Worksheets and Workbooks
Apply Data Validation
Use Lookup Functions
Use 3-D References
Use the Goal Seek Feature
Consolidate Data Sharing and Protecting Workbooks
Protect Worksheets and Workbooks Automating Workbook Functionality
Work with Macros Using Lookup Functions and Formula Auditing
Microsoft Excel PowerPivot Data Analytic Expressions DAX Language
- 2 day course
- Location: Salford
- Telephone on 01952 938014
- 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...
Statistical Functions
The CALCULATE Function
Information Functions
Date Functions
Exploring Data Types
Many-to-Many Relationships
Relational Functions Understanding Evaluation Contexts
PowerPivot Data Model
Using Multiple Calendars Utilising Advanced DAX Functionality
Conversion Functions
Text Functions
Introduction to DAX
Single Table Evaluation Context
Explaining Syntax
Aggregation Functions
Filter Functions
Utilizing Operators
Mathematical Functions
Working with Calendars
Excel 365 Intermediate
- 1 day course
- Location: Salford
- Telephone on 01952 938014
- Course Outline
-
Upon successful completion of this course, you will be able to leverage the power of data analysis and presentation in order to make informed, intelligent organizational decisions. You will:
Work with functions.
Work with lists.
Analyze data.
Visualize data with charts.
Use PivotTables and PivotCharts. - Some of the training topics covered include ... Work with Text Functions Working with Lists
- See Training Course Details...
Sort Data
Present Data with PivotCharts
Apply Intermediate Conditional Formatting
Working with Functions Work with Ranges
Apply Advanced Conditional Formatting Visualizing Data with Charts
Create Charts
Use Advanced Chart Features Using PivotTables and PivotCharts
Analyze PivotTable Data
Create a PivotTable
Filter Data by Using Timelines and Slicers
Use Specialized Functions
Create and Modify Tables
Modify and Format Charts
Work with Date and Time Functions
Work with Logical Functions
Outline and Subtotal Data Analyzing Data
Query Data with Database Functions
Filter Data
Microsoft Excel Power Query
- 1 day course
- Location: Salford
- Telephone on 01952 938014
- 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 and Handling Special Situations
- See Training Course Details...
Understand and perform importing from SQL Server Analysis Services Multidimensional.
Understand and utilize merges. LOADING YOUR DATA
Appending Operations
Summarising WORKING WITH THE POWER QUERY LANGUAGE “M”
Understand and perform importing from SQL Server Analysis Services Tabular. PERFORMING MERGES
Working with Folders and Files
Introduction to Power BI Desktop
Loading Data
Importing, Transforming, and Loading Data into Excel and Power Pivot
Understand Power Query formulas.
Importing Data
Grouping Options
Understand working with relational data.
Course topics include- INTRODUCTION TO POWER QUERY
Loading into Power Pivot
Loading into Excel
Understanding Data Types WORKING WITH CSV, TXT AND EXCEL WORKSHEETS
Loading into Power BI Desktop
Transforming Data
Understand the M interface.
Excel Power Pivot
- 1 day course
- Location: Salford
- Telephone on 01952 938014
- Course Outline
-
A one day course introducing candidates to Power View and Power Pivot Excel tools.
- Some of the training topics covered include ... Using Related Power Pivot Fields
- See Training Course Details...
Power View
Power Map
Working With Scenes
Merging Queries
Working With Scene Options
Understanding Get & Transform
Viewing and Editing a Tour
Working With Location Fields
Power Pivot
Changing a Power Pivot View
Saving and Sharing Queries
Changing the Look
Working With Layers
Working With Mapping Confidence
Updating a Power View Report
Creating a Timeline
Transforming Data
Adding More Power Views
The Advanced Editor
Understanding Relational Data
Excel Programming Using VBA
- 2 day course
- Location: Salford
- Telephone on 01952 938014
- 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 ... Understanding Controls
- See Training Course Details...
Working with Boolean Expressions
Working with Control Appearance
Using Message Boxes
Understanding Data Types
Using Visual Basic Help
Understanding PivotTables
Understanding Constants
Working with Properties
Understanding the Development Environment
Stepping through Code
Creating a Sub Procedure
Understanding VBA's Error Trapping Options
Using Break Mode during Run mode
Working with Option Button Controls
Assigning a Macro to the Quick Access Toolbar
Determining the Value of Expressions
Using the Toolbox
Getting Started
Email us about this courses
Other Salford Enable Technology Training Courses
SSRS - Salford SQL Server Reporting Services Training Courses
JavaScript Salford Training Courses
SSAS Tabular Salford Training Courses
Report Builder - Salford SQL Server Reporting Services Training Courses
PL/SQL - Salford SQL Training Courses
JQuery Mobile Salford Training Courses
Access Salford Training Courses
Access VBA - Salford Access Training Courses
SQL - Salford SQL Training Courses
TSQL - Salford SQL Training Courses
SSIS Salford Training Courses
JQuery - Salford JavaScript Training Courses
Oracle SQL Salford Training Courses
Data Warehouse Salford Training Courses
SSAS - Salford SQL Server Analysis Services Training Courses
Power BI Salford Training Courses