Microsoft Excel Beginners Certificate

Accreditation

ESS Certificate

Course duration

15 Hours

Certificate valid for

Never expires

Book this course today. Call 0115 8970 529 or click here to send us a message

This Microsoft Excel for Beginners course is recommended for anyone who has an interest in learning more about the fundamental functions of Excel. For the novice user, this course will help you get to grips with simple formulas and functions to allow you to track simple expenditures, calculate sums and more.

Please Note: This course uses the Windows version of Microsoft Office 2016. Any other versions will have some differences in the functions. 

Microsoft Excel Beginners Course Overview

The Microsoft Excel Beginners course will give you a overview of some of the fundamentals of Excel usage, this includes;

  • An 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
  • Using hyperlinks


This Excel beginners course is broken down into 36 modules. Following completion of these 36 modules, there is a multiple choice test.

On completion of this course, you will receive a Microsoft Excel for Beginners Certification.

Further Progression

Following the completion of this course, you can move onto the following courses: