Excel Formulas for Absolute Beginners

Learn MS Excel formulas in a fun and interesting way by solving puzzles and playing games!
Free tutorial
Rating: 4.3 out of 5 (444 ratings)
9,772 students
Excel Formulas for Absolute Beginners
Free tutorial
Rating: 4.3 out of 5 (444 ratings)
9,763 students
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!

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
Course content
4 sections • 11 lectures • 30m total length
  • Introduction
    02:56
  • Introduction to Cell References
    02:18
  • Cell References
    8 questions
  • Introduction to Excel Formula
    03:15
  • Excel Formula Introduction
    4 questions
  • Formula Basics - 1
    1 question
  • Formula Basics - 2
    1 question
  • Formula Basics - 3
    1 question
  • Formula Basics - 4
    1 question
  • Formula Basics - 5
    1 question
  • Formula Basics - 6
    1 question
  • Absolute and Relative Cell Referencing
    07:56
  • Cell References across Worksheets
    01:48
  • Formula Cross-Sheet Cell References - 1
    1 question
  • Formula - Cross Sheet Referencing - 2
    1 question
  • Introduction to Functions
    01:46
  • Text Functions
    02:32
  • Logical Operators
    00:36
  • Logical Functions
    02:49
  • vLOOKUP - Lookup and Reference Functions
    03:42
  • Functions - 1
    1 question
  • Functions - 2
    1 question
  • Functions - 3
    1 question
  • Function - 4
    1 question
  • Mini-Project
    00:55

Instructor
Best Selling Instructor| Author of Top 3% of Udemy's courses
Mumshad Mannambeth
  • 4.6 Instructor Rating
  • 78,116 Reviews
  • 254,842 Students
  • 15 Courses

I am an IT Solutions Architect and specializes in Cloud, Automation and DevOps and the author of Top 3% of Udemy's courses. I am passionate about learning new technology and teaching. I believe the best way to learn is to learn by doing and in a fun way.  I have authored multiple courses on DevOps, Cloud and Automation technologies and I teach over 200,000 Students worldwide. My courses focus on providing students with an interactive and hands-on experience in learning new technology that makes learning really interesting.


"The best way to learn is to teach" - Frank Oppenheimer