On Course for Success – Excel Spreadsheet Training

Level 4

Level 4 – Masterclass

1: Who is the Course for?

This course is ideal experienced users who are responsible for analysing data from many sources and have a good understanding of Excel functions and formulas. 

2: The Course

Courses delivered by InIT Learning are tutor led. The tutor will use demonstration and discussion along with hands-on practical tasks and assignments to ensure each user has gained an understanding of each topic. Questions are encouraged throughout the session. During each task and assignment the tutor will give one to one support as required.

3: COURSE OBJECTIVES

  • Concepts & Terms
  • Import Raw Data
  • Connect to Data
  • Shape & Transform
  • Create Relationships
  • Data Analysis Expressions
    (DAX)

4: Certificates

Each delegate will receive a manual and a certificate of attendance.

5: Course Content

  • Introduction to Excel Power
  • Business Intelligence
  • Enable Power Pivot
  • Power Query
  • Power Query Editor
  • Query Editor Tools
  • Loading Data
  • Pivoting and Unpivoting
  • Merging Queries
  • Appending Queries
  • Data Model Views
  • Database Normalisation
  • Data and Lookup Tables
  • Power Pivot
  • DAX Measures
  • Data Analysis Expressions (DAX)
  • Basic Measures
  • SWITCH and SWITCH(TRUE) Functions
  • Date and Time Functions (Basic)

 

 

Check Availability and Book>>>

One Day Scheduled Training Courses Available 10:00 to 4:30

PowerPoint Courses Milton Keynes Microsoft Word Courses Milton Keynes Outlook Courses Milton Keynes Excel Power Pivot Courses Milton Keynes

Click the required image/course above to find out more


0330 32 100 58
01908 92 50 58

One Day Courses

Excel Training Courses
Milton Keynes

£134.00 per person

Level 1, 2 & 3 £134.00
Level 4 Power Pivot £154

Includes:

Manual

Certificate of Attendance

InIT Learning for In-house computer courses
InIT Learning

Milton Keynes Chamber Member

InIT Learning
Harben House Business Centre
Tickford Street
Newport Pagnell
MK16 9EY

01908 925058

0330 32 100 58

Map

Only 10 minutes from Central Milton Keynes or 4 minutes from M1 Junction 14

  • Easy to find
  • Plenty of Free Parking on-site for delegates

More>>>