Digital Skills for Business – Microsoft Excel

Subject Area Leisure and Community
Age Group(s) Adults

Part of the Microsoft Office suite, Microsoft Excel is the world’s leading spreadsheet programme. It is a critical piece of software for office environments and financial businesses.

Excel courses teach users how to fully utilise this programme. In them, you will learn how to manage, calculate and format data in clear and visually appealing ways. This includes making basic calculations, displaying data as graphs or charts and creating complex formulas.

The MS Excel course will give you a full overview of all of the most common features of Excel and how to use them. Some of the highlights of this course include:

  • A basic overview of Excel
  • Calculating sums, averages, and totals
  • Counting cells
  • Learning formulas, such as IF, COUNTIF, SUMIF, VLOOKUP, HLOOKUP, and AVERAGEIF
  • Pivot tables
  • Inserting, editing, and deleting comments
  • Creating borders
  • Wrapping text
  • Merging cells
  • Pasting, sorting, and converting columns to rows
  • Creating graphs and charts
  • Using the dictionary

 

We've put some small files called cookies on your device to make our site work.

We'd also like to use analytics cookies. These send information about how our site is used to a service called Google Analytics, and we also perform our own in-house tracking. We use this information to improve our site, and it does not personally identify you.

Let us know if this is OK. We'll use a cookie to save your choice. You can read more about our cookies before you choose.

I'm OK with analytics cookies Do not set analytics cookies
.