Excel Courses Milton Keynes

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>>>

Ready for Action?

Are you ready to check dates and book? Then take action now and click below.
Check Dates

Harben House Hotel
Tickford Street
Newport Pagnell
MK16 9EY

Tel: 01908 92 50 58
        0330 32 100 58
(Calls may be recorded for quality purposes) 

linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close