Skip to main content

0800 028 0289

IT Courses – Advanced Microsoft Excel

This one-day workshop is designed to give individuals who already have a good understanding of Excel's key features the opportunity to learn more advanced skills.

Apply Now

Course Summary

Subject Area: Adult Digital
Adult and Community
Location:
Full Time or Part Time: PT
Level: N/A
Number Of Years: 1
Interview Required?: N
Weeks: 1
Hours: 7.00
Start: Flexible
Tuition: £180
Ilkeston

Apply now at: https://www.derby-college.ac.uk/course/it-courses-advanced-excel
QR Code

Course Information for Students

Extend your knowledge of Excel’s advanced features and learn how to perform more complex tasks. This workshop will help put the full power and potential of Excel at your fingertips.

You must already have a good understanding of Excel’s key features. 

Course content 

Functions and Formulas

  • IF Statements
  • Nesting functions
  • Lookup and referencing functions: VLOOKUP, HLOOKUP and XLOOKUP
  • INDEX and MATCH

Creating Dashboards

  • Working with Excel Tables
  • Using slicers with Excel tables
  • Create an Excel Table-based dashboard
  • Creating a PivotTable based dashboard

An Introduction to Macros

  • Understanding Macro security
  • Recording a Macro
  • Assigning a Macro to Command Button
  • Assigning a Macro to a Quick Access Toolbar

Understanding Power Query

  • Exploring the benefits of Power Query
  • Important data
  • Understanding transformation techniques in Power Query

Working with PowerPivot

  • Understanding and assigning Relationships
  • Working with data models and schemas
  • Creating measures and calculated columns using DAX
  • Building PowerPivot reports from data models

The course will be delivered on-site.

For more information, contact dcgprofessional@dcg.ac.uk  

Course Information for Employers

If you are an employer and would like to know more about the apprenticeships and professional training we deliver or how you can get involved in co-creating and co-delivering the curriculum, please contact us via email on businessenquiries@derby-college.ac.uk, call us on 01332 387 421 or visit our employer pages here.

Career Information

ERROR -cURL error 28: Operation timed out after 5002 milliseconds with 0 bytes received
online application form

Get Started...

Use our online application form to apply for this course.

Apply Now

Course Information Last Updated On: July 18, 2025 9:26 am