Digital Skills for Business – Microsoft Excel

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