Fun Excel Learning
4.2 (17 ratings)
1,429 students enrolled
Wishlisted Wishlist

# Fun Excel Learning

Learn MS Excel formulas in a fun and interesting way by solving puzzles and playing games!
4.2 (17 ratings)
1,429 students enrolled
Last updated 5/2017
English
Price: Free
Includes:
• 31 mins on-demand video
• 10 Supplemental Resources
• Access on mobile and TV
• Certificate of Completion
What Will I 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!
View Curriculum
Requirements
• You should be able to use a PC at a beginners level
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 is the target audience?
• Anyone who likes Fun!
• Anyone who likes to learn by doing
• Anyone who wants to learn basics of Excel Formulas
Students Who Viewed This Course Also Viewed
Curriculum For This Course
11 Lectures
30:33
+
Introduction
1 Lecture 02: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
02:56
+
Formula Basics
4 Lectures 15:17

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
Introduction to Cell References
02:18

Cell References
8 questions

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
Introduction to Excel Formula
03:15

Excel Formula Introduction
4 questions

Absolute and Relative Cell Referencing
07:56

This module discusses Cell References Across Worksheets and we practice using some fun games.

Exercises:

• Country Game
Cell References across Worksheets
01:48
+
Functions
5 Lectures 11:25

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

Introduction to Functions
01:46

We look at Text Functions such as CONCATENATE, LEN, LOWER/UPPER, FIND, LEFT, RIGHT, MID

Exercises:

Concatenate words

Word Games

Text Functions
02:32

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 Operators
00:36

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.
Logical Functions
02:49

Understand Lookup and reference functions - vLOOKUP.

Exercises:

• Lookup price from a list
• Lookup student marks from other spreadsheets
vLOOKUP - Lookup and Reference Functions
03:42
+
Mini-Project
1 Lecture 00: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.

Mini-Project
00:55