Excel for Beginners

Introduction to the Microsoft Excel for Beginners Course

This beginners course is recommended for anyone who might use Excel at home or at work for uncomplicated reasons, such as tracking simple expenditures or for calculating sums or totals. This course is ideal for anyone who has never used Excel or for those who have only a rudimentary understanding of the software. It is also perfect for anyone who is familiar with the older versions of the software, but not the latest version. If you are re-entering the workforce, you will also find that this course will suit you well, and will certainly get you caught up with your peers.

Course Summary

The course begins with explaining concepts, such as ‘What is a cell?’ and how to tell the difference between a column and a row. The course continues by explaining basic Excel concepts such as how to create, copy, delete, and cut information from Excel cells. You will also learn how to edit information that is put into a cell and how to insert and edit comments when using Excel.

Excel overview, which is only a small part of the beginners course, will cover sheets, which is an entirely different concept than cells. In this section, you will learn how to rename a sheet, delete a sheet, hide and unhide a sheet, and move and copy a sheet. You will also learn how to change the colour of tabs.

What you will learn

The MS Excel beginners 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
Using hyperlinks

Excel Beginners Course Modules

Module 1: Introduction to Excel
Module 2 : Add
Module 3 : Multiply
Module 4 : Subtraction in Excel
Module 5 : Dividing
Module 6 : Sort
Module 7 : Percentage
Module 8 : Running Totals
Module 9 : Print
Module 10 : Paste Special
Module 11 : Merge
Module 12 : Filter
Module 13 : Average
Module 14 : AVERAGEIF
Module 15: SUMIF Formula
Module 16: IF Formula
Module 17: VLOOKUP
Module 18: HLOOKUP
Module 19 : Countif Formula
Module 20 : CountBlank
Module 21 : Counta Formula
Module 22 : Count Formula
Module 23 : Concatenate
Module 24 : Transpose
Module 25: Date Formula
Module 26: Month Formula
Module 27: Pivot Tables
Module 28: Pivot Table – Filter & Calculate – The Values Area
Module 29: Pivot Table – Tabular Data Structure
Module 30: Filter & Calculate on Multiple Fields
Module 31: Pivot Table – Filter the Entire Pivot Table
Module 32: Working with charts – Different Charts and Graphs in Excel
Module 33: Number Formatting
Module 34: Create Borders
Module 35: Conditional Formatting
Module 36: Comments