Excel Formulas for Absolute Beginners

Name: Excel Formulas for Absolute Beginners
Rating: 4.4 (1209 reviews)

Learn MS Excel formulas in a fun and interesting way by solving puzzles and playing games!

Created byMumshad Mannambeth

Last updated 4/2018

English

What you'll learn

Use Excel Formulas in spreadsheets
Use cell references in Excel - Relative, Absolute, Cross sheet referencing
Understand how formulas in Excel can make your day to day job easy!

Coding Exercises

This course includes our updated coding exercises so you can practice your skills as you learn.

Course content

4 sections • 11 lectures • 30m total length

Introduction2:56
Hello and welcome to this course on Excel Formula. My name is Mumshad Mannambeth and I love teaching technology in a fun, hands-on and interesting way.

In this course we’ll be learning about excel formulas and have a lot of fun while we are at it.
This course is going to be for Beginners who are just starting with Excel formulas and hopefully, by the end of course gain enough knowledge to be able to use formulas in their day-to-day activities. We will start with Cell References, and then move on to different types of formulas, functions such as Logical functions, text Functions and Lookup functions.

Introduction to Cell References2:18
In this module we are going to look at how cells are structured in Excel and how do we refer to each cell.
Exercises:
Identify Cell References
Identify Range References
Cell References
Introduction to Excel Formula3:15
In this module we are going to start with some basic formulas such as addition, subtraction, multiplication and division.
Exercises:
Formula – Mathematical Expressions
Formula – Cell References
Excel Formula Introduction
Formula Basics - 1
Formula Basics - 2
Formula Basics - 3
Formula Basics - 4
Formula Basics - 5
Formula Basics - 6
Absolute and Relative Cell Referencing7:56
Cell References across Worksheets1:48
This module discusses Cell References Across Worksheets and we practice using some fun games.
Exercises:
Country Game
Salary Spreadsheet
Formula Cross-Sheet Cell References - 1
Formula - Cross Sheet Referencing - 2

Introduction to Functions1:46
This module discusses about Basic Excel Functions such as SUM, MIN, MAX, AVERAGE
Exercises:
Compute the total sales in the team
Count the number of members in the team
Identify the highest sales by an individual
Identify the lowest sales by an individual
Identify the highest sales + bonus by an individual
Compute the average sales in the team
Text Functions2:32
We look at Text Functions such as CONCATENATE, LEN, LOWER/UPPER, FIND, LEFT, RIGHT, MID
Exercises:
Concatenate words

Word Games
Logical Operators0:36
Use Logical operators such as >, <, >=, <=, <> to compare values in different cells
Exercise:
Identify the students who scored greater than 45 in Maths.
Identify the students who scored exactly the pass mark in Science.
Count the number of students who scored exactly 45
One of the names below does not match. Identify the line. Use the not equal to operator.
Logical Functions2:49
Learn about Logical Functions such as AND, OR and NOT and how to apply them in formulas.
Exercises:
Identify the students with marks greater than 35 in Science and 45 in Maths
We need students who are either good in Language (>35) or Arts(30).
Identify those who have a score less than 20 in all subjects
Use the first formula with the NOT function to identify the students who scored <= 35 in Science and <= 45 in Maths.
vLOOKUP - Lookup and Reference Functions3:42
Understand Lookup and reference functions - vLOOKUP.
Exercises:
Lookup price from a list
Lookup student marks from other spreadsheets
Functions - 1
Functions - 2
Functions - 3
Function - 4

Mini-Project0:55
In this mini-project you are required to build a dashboard using Excel for a Software company. The first sheet is the dashboard sheet which must reflect a summary of employees, projects and customers. There are different worksheets for Employees, Projects and customers filled with sample data. The Green fields are pre-populated with data whereas the blue ones are to be updated by you using formulas.

Requirements

You should be able to use a PC at a beginners level
Must have access to Microsoft Excel Application

Description

In this course we’ll be learning about excel formulas and have a lot of fun while we are at it.

This course is for Beginners who are just starting with Excel formulas and hopefully, by the end of course gain enough knowledge to be able to use formulas in their day-to-day activities. We will start with Cell References, and then move on to different types of formulas, functions such as Logical functions, text Functions and Lookup functions. All the topics have associated Excel Workbook resources containing sample problems to solve, puzzles, games and real-world practice questions to practice on.

To conclude, work on a mini-project to build a dashboard for an imaginary software development firm.

Happy Learning!

Who this course is for:

Anyone who likes Fun!
Anyone who likes to learn by doing
Anyone who wants to learn basics of Excel Formulas

Excel Formulas for Absolute Beginners

What you'll learn

Explore related topics

Coding Exercises

Course content

Introduction1 lecture • 3min

Formula Basics4 lectures • 15min

Functions5 lectures • 11min

Mini-Project1 lecture • 1min

Requirements

Description

Who this course is for: