Udemy

Excel Formulas Made Easy - Learn more than 100 Formulas

Enroll Now
  • 3,485 Students
  • Updated 6/2023
4.7
(501 Ratings)
CTgoodjobs selects quality courses to enhance professionals' competitiveness. By purchasing courses through links on our site, we may receive an affiliate commission.

Course Information

Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
8 Hour(s) 47 Minute(s)
Language
English
Taught by
Alan Murray
Rating
4.7
(501 Ratings)

Course Overview

Excel Formulas Made Easy - Learn more than 100 Formulas

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.

Course Content

  • 10 section(s)
  • 97 lecture(s)
  • Section 1 Introduction
  • Section 2 Formulas in a Nutshell
  • Section 3 Referencing Cells, Sheets and Workbooks in a Formula
  • Section 4 Using Logical Functions
  • Section 5 Formulas for Summing Values
  • Section 6 Counting Formulas
  • Section 7 Calculating Averages
  • Section 8 Specialised Functions for Summing and Counting
  • Section 9 Working with Text
  • Section 10 Date Formulas

What You’ll Learn

  • 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
  • Use formulas to clean and prepare data for analysis.
  • Identify and solve formula errors

Skills covered in this course


Reviews

  • H
    Henry Diaz
    5.0

    Learned a lot of great information

  • J
    Jaisurya Balan
    5.0

    This Course was very useful For me

  • C
    Charles David
    5.0

    In this course i have learned lot of excel formulas, it will huge help to my work.

  • G
    George Suthothanan
    4.5

    Great introduction to the course.

Start FollowingSee all

We use cookies to enhance your experience on our website. Please read and confirm your agreement to our Privacy Policy and Terms and Conditions before continue to browse our website.

Read and Agreed