Accreditation
ESS Certificate
Microsoft Excel Beginners Certificate
Course duration
15 Hours
Certificate valid for
Never expires
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: