Microsoft Excel – Beginner Online Course - Accredited - Best Selling Beginners

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

Course Modules/Lessons

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: Pie Charts

Module 29: Doughnut Charts

Module 30: Line Charts

Module 31: Column Charts

Module 32: Bar Charts

Module 33: Number Formatting

Module 34: Create Borders

Module 35: Conditional Formatting

Module 36: Comments FAQ's