Excel Formulas Made Easy - Learn more than 100 Formulas

Master Excel formulas with our comprehensive course, perfect for beginners and advanced users alike. Learn essential skills to write and fix complex formulas easily.

  • Overview
  • Curriculum
  • Instructor
  • Review

Brief Summary

This course makes learning Excel formulas super easy! Dive into over 60 functions, tackle practical projects, and gain the confidence to work with formulas, whether you're just starting or looking to level up your skills.

Key Points

  • Learn Excel formulas from basics to advanced techniques.
  • Over 60 different Excel functions covered.
  • Practice with mini projects and working files.
  • Recognize and fix common formula errors.
  • Suitable for all skill levels, from beginners to advanced users.

Learning Outcomes

  • Master essential Excel formula skills.
  • Create complex formulas effortlessly.
  • Understand and fix formula errors.
  • Utilize lookup functions effectively.
  • Perform calculations with different data types.

About This Course

Learn Excel formulas with this comprehensive course taking you from the fundamentals to writing advanced formulas

Excel Formulas can seem daunting and even scary at first. In this course Excel formulas are made easy as you learn all the essential skills to writing formulas.

Master Excel Formulas Easily with this Comprehensive Course

  • Understand Excel formulas inside out.

  • Learn over 60 different Excel functions.

  • Write complex formulas with ease.

  • Recognise formula errors and fix common problems.

Hear What Some of our Students have Been Saying

"Great instructor and excellent way of explaining."

"Brilliant course! Finally a course that leaves you understanding everything without needing to review a dozen times. I have reviewed and learned much more from this easy to follow course due to the step by step tutorials and its clear, engaging delivery by an excellent and knowledgeable instructor. It has helped me understand more formulas in excel that can help me with my business. Many thanks to all involved and keep up the great work."

"straight to the point, clear explanation and demo, use common sense language to interpret the formula, and simple and easy illustrative example."

Learn Everything You Need to Write Formulas with Ease.

Formulas are what drive Excel. They are the muscles allowing users to manipulate, lookup, aggregate and test data with ease.

Learning how to write formulas is an important skill for any Excel user looking to develop their talents.

Content and Overview

This course was designed for anybody who needs to be able to confidently work with formulas in Excel. It is suitable both for complete beginners who want to start from the basics, and for those that have some experience but want to take things further.

The course is broken into different sections. It starts with building an understanding of the different elements of a formula, what the various symbols mean, some basic functions and different techniques for referencing cells.

Each section then focuses on a specific function category such as date or lookup functions. It starts to take things further by tackling mini projects and looking at more advanced formulas.

In over 80 lectures this course will teach you all the necessary skills to write advanced formulas with ease, and make those formula demons a thing of the past.

Working files are provided so that you can follow along and practice. You can also get assistance from myself with any queries you may have.

  • Write advanced formulas for summing and counting values in a list.

  • Use lookup functions to fetch values on a spreadsheet.

  • Perform calculations with dates and times

Course Curriculum

2 Lectures

Instructor

Profile photo of Alan Murray
Alan Murray

Alan Murray is a Microsoft MVP and an Excel & Power BI trainer. He has been training for over 20 years for businesses around the world.He is the founder of the Computergaga blog and YouTube channel. It has over 650 videos and more than 45 million views. He regularly shares new Excel tips and tutorials.He is the author of the...

Review
4.9 course rating
4K ratings
ui-avatar of Sandeep
Sandeep
5.0
7 months ago

AWESOME

  • Helpful
  • Not helpful
ui-avatar of Monika Barcikowska
Monika B.
5.0
7 months ago

Amazing course! Very easy to learn this way. I've tried Excel courses, but they were very chaotic and hard to follow. This one is just perfect!

  • Helpful
  • Not helpful
ui-avatar of Juliet Ramagoshi
Juliet R.
4.5
8 months ago

The course was good as it was teaching how to great formulas using different Maths signs in excel.

  • Helpful
  • Not helpful
ui-avatar of Shaneika Smith
Shaneika S.
5.0
8 months ago

Absolutely amazing course. I learned so much.

  • Helpful
  • Not helpful
ui-avatar of Dimpho Kelesitse
Dimpho K.
4.5
9 months ago

this course will help me with my daily work

  • Helpful
  • Not helpful
ui-avatar of Ellen Waldron
Ellen W.
5.0
10 months ago

Thank you, Alan. I used this class to review and practice functions to prepare for the advanced excel certification, which I expect to pass on the first try. Thanks again.

  • Helpful
  • Not helpful
ui-avatar of SHARANYA V
Sharanya V.
3.5
10 months ago

good information

  • Helpful
  • Not helpful
ui-avatar of Naresh Jain
Naresh J.
5.0
11 months ago

Good

  • Helpful
  • Not helpful
ui-avatar of Daniel Dinakaran Nirmal Raj M
Daniel D. N. R. M.
5.0
1 year ago

nice

  • Helpful
  • Not helpful
ui-avatar of Joann Mccrary
Joann M.
5.0
1 year ago

The teacher does a great job explaining how to do things, showing us how and at a great pace. Thank you!!

  • Helpful
  • Not helpful
Leave A Reply

Your email address will not be published. Required fields are marked *

Ratings

Courses You May Like

Lorem ipsum dolor sit amet elit
Show More Courses