Skip to main content

IT Courses – Foundation Microsoft Excel

Microsoft Excel is the world's favourite spreadsheet application and has an incredible number of uses. Our Excel for Beginners workshop is designed for individuals with little or no experience of the application.

Apply Now

Course Summary

Subject Area: Professional Training
Adult and Community
Full Time or Part Time: PT
Level: N/A
Number Of Years: 1
Interview Required?: N
Weeks: 1
Hours: 7.00
Start: Flexible
Tuition: £125
Days/Times: flexible
Ilkeston

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

Course Information for Students

Microsoft Excel is the world’s favourite spreadsheet application, with an incredible number of uses. Our Excel for Beginners workshop is designed for individuals with little or no experience of the application. It gives them the knowledge, skills and expertise to build practical, functional spreadsheets that aid productivity both in the workplace and at home.

There are no entry requirements. 

An Introduction to Microsoft Excel

  • The anatomy of Excel
  • Manipulating Sheet tabs
  • Cells, rows and columns
  • Cell locking, protection and security
  • Saving in different file formats
  • Savings and using templates

Formatting 

  • Using the ribbon to format
  • Cell styles
  • The format painter
  • The format cells menu

Useful Commands

  • The find and replace tool
  • Freeze panes
  • The fill handle
  • Flash fill


Basic Formulas and Functions

  • Understanding formulas
  • Introducing AutoSum
  • Cumulative totals
  • Working with basic functions: AVERAGE, MIN, MAX, COUNT, COUNTA, COUNTBLANK, TRIM, PROPER, UPPER, LOWER, LEN, ROUND, ROUNDUP, ROUNDDOWN, TODAY, NOW

Printing and PDF Creation

  • Common printing problems and how to solve them
  • Page breaks
  • Print areas
  • Headers & Footers

Data Analysis

  • Sorting
  • Filtering
  • Getting started with Charts
  • Sparklines

This workshop will be delivered on-site.

You may want to progress to our Intermediate Excel course.

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

DCG Success Stories

Discover how our students have achieved success. Their hard work and dedication to learning has enabled them to succeed in rewarding careers or progress onto higher education.

role model

We encourage progress and aspirational outcomes by guiding people onto learning pathways that lead to positive destinations. Our students have gone on to achieve great things since leaving the College. We would like to share some of their inspiring success stories with you.

View Role Models

Find out what funding could be available to you:

Thinking about returning to education or developing new skills? Use our funding calculator below to get an estimate of the financial support you may be eligible for based on where you live.

Whether you’re looking to retrain, progress in your career, or try something new, funding could make your next step more accessible than you think.

Simply enter your postcode into the calculator to see an estimate of the funding that may be available in your area. This is based on regional funding allocations and typical eligibility criteria for adult learners.

Important:

The results shown are a guide only and are not a guarantee of funding.

Funding availability can vary depending on:

  • Your personal circumstances (such as age, employment status, and prior qualifications)
  • The course you choose
  • Government and local funding rules at the time of enrolment

If you’re considering adult learning, there’s never been a better time to explore your options.

Our courses are designed to fit around your life, with flexible study options and expert support every step of the way.

Find out more about the courses available. Adult Courses

If you have any questions about funding, eligibility, or courses, our team is here to help. Contact Us

online application form

Get Started...

Use our online application form to apply for this course.

Apply Now

Course Information Last Updated On: January 14, 2026 9:05 am