Microsoft Excel - Mastering Formulas in Excel

Master Formulas in Excel from a self confessed Microsoft Excel fanatic (Windows Excel 2007 to Excel 2019)
Rating: 4.2 out of 5 (41 ratings)
1,549 students
English
English [Auto]
How to count cells
How to round numbers
How to compare two lists
How to use vlookup
How to use hlookup
How to copy formulas

Requirements

  • A very basic knowledge of Excel
  • A working copy of Excel installed. I am using Excel version 2019 for Windows, but hopefully your version will not be much different

Description

Welcome to my Mastering Formulas in Excel course.

You will learn the fundamentals of working with formulas, which really unleashes the hidden power of Excel.

I used the Windows version of Excel current in 2020 to make this course, but other versions should not be that different.

I will be creating a spreadsheet during the course that you can download. The idea is that you work along with me, then you can compare our spreadsheets. This is the very best way to learn.

I love Excel, and I hope to share my passion and enthusiasm for this amazing software onto you, as well as passing on all my skill and knowledge. Pretty soon you will be using Excel like a master, and you will save yourself so much time, as well as look like a genius!

In this course I cover:



Basic introduction to finding and using Formulas in Excel

  • A closer look at some simple formulas

  • How to count cells with data

  • How to round numbers

  • How to compare two lists

  • Extracting data from a table using vlookup and hlookup functions

  • Copying formulas so that they work - absolute and relative references

I hope that you love this course and get a lot out of it.

Happy Excelling!

Keith

Who this course is for:

  • Beginner and Intermediate students of Excel who want to unleash its full power and learn about formulas

Course content

3 sections9 lectures42m total length
  • Welcome to the course
    02:10
  • Introduction
    00:07
  • Introduction to formulas and the course
    00:53

Instructor

Excel Trainer and Fanatic
Keith Griggs
  • 4.2 Instructor Rating
  • 450 Reviews
  • 42,899 Students
  • 5 Courses

I an English and live near London. I am a qualified accountant. I worked for many years in industry as a Financial Controller and CFO.

I really love Excel and have been using it pretty much all day every day for over 30 years.

Now my mission is to share my knowledge and passion for Excel so that other people can benefit from it as much as I do.