Microsoft Excel Training
Excel is one of the most widely used software packages currently in use. The package can be used for a variety of tasks. On a basic level, you can use Excel for creating tables, storing data and setting up simple calculations like addition, multiplication, division or subtraction.
For more demanding uses, Excel can be used to create charts, automate spreadsheets, apply advanced formulas, create Pivot tables and much much more!
Please select the version that you’re interested in
Please select the level that you’re interested in
Microsoft Excel PowerPivot Introduction
This course is designed for users of Microsoft Excel who would like detail analysis of their data using the powerful feature incorporated within Excel.The course covers all aspects of PowerPivot to get customised reports including Formatting, table relationships, etc.
Learners should have advanced level of knowledge of Microsoft Excel including knowledge of Pivot Table.
This is a 1 day PowerPivot Introduction Course. The course starts at 09:30 and runs until 16:30. Alternate timings can be arranged upon request. The course can be held on a date that suits you.
Our Microsoft PowerPivot Introduction course can be run at our training venue near Liverpool Street (London) or any preferred location in the UK or Europe.
Excel PowerPivot Introduction Course Outline
Navigating the PowerPivot window
Exploring the PowerPivot tab and field list in Excel
CONNECTING TO DATA SOURCES
Data sources and types supported in PowerPivot workbooks
Add Data by using Excel Linked Tables
PREPARATION FOR DATA ANALYSIS
Working with Tables and Columns
Filtering and Sorting Data
Creating Relationships Between Tables
Creating and Working with calculations
DATA AND COLUMN FORMATTING
Creating, deleting a table
Rename a Table or Column
Set the Data Type of a Column
Hide or Freeze Columns
Undo or Redo an Action
Sorting and filtering data in a table
Create a Relationship Between Two Tables
View and Edit Relationships
INTRODUCTION TO DAX FORMULAS
Overview of Data Analysis Expressions (DAX) language
Building Formulas for Calculated Columns and Measures
Create a Pivot Table or Pivot Chart Report
Create a Measure in a Pivot Table
Use Slicers to filter data
One to One
(which includes a tailor-made training programme for the individual where they can mix and match the topics from various levels to get the most cost-effective training
Group for up to 8 learners
What Our Clients Say
This is a sample of some of the Short training videos. Please note that you can get access to many more, once you have done a course with us and are registered as one of our delegates.