Udemy – Mastering Microsoft Excel Formulas 2024-1

Mastering Microsoft Excel Formulas course. This comprehensive Excel course is offered by Ahmed Oyelowo, who has a brilliant track record in the field of Excel. He has won the Microsoft MVP title 4 times, has been an official Microsoft trainer since 2018, and is also a Microsoft Office expert (Excel expert).

In this course, you will learn how to use more than 50 everyday Excel functions using practical examples. You will also learn how to easily combine multiple Excel functions into one Excel formula. One of them is used by the instructor, which you should use to follow the lessons, and the other is for your own practice. The exercise file automatically determines your score after completing the exercises in it. You’ll also learn cell referencing logic, which is the backbone of writing precise formulas when you need to repeat formulas across multiple cells in Excel.

What you will learn in the Mastering Microsoft Excel Formulas course:

• Using more than 50 everyday Excel functions
• Easy combination of multiple functions in Excel
• Using cumulative functions in Excel
• Using text functions like LEFT, CONCATENATE, TEXTJOIN, etc
• Use date functions like EOMONTH, EDATE, DATEDIF, etc
• Use search functions such as VLOOKUP, XLOOKUP, INDEX&MATCH
• Using mathematical and statistical functions such as SUMIF, COUNTIF, AVERAGEIF, etc
• Use logical functions like IF, AND, OR, etc

Who is this course suitable for?

• This course is suitable for all categories of Excel learners.
• Looking to advance your Excel knowledge beyond the basics?
• Looking to start or improve your data analysis skills?

Mastering Microsoft Excel Formulas course specifications

• Publisher:  Udemy
• Lecturer:  Foresight BI & Analytics
• Training level: beginner to advanced
• Training duration: 4 hours and 21 minutes
• Number of courses: 59

Course headings

Prerequisites for Mastering Microsoft Excel Formulas course

Course images

Sample video of the course

download link

Download part 1 – 1 GB

Download part 2 – 769 MB

File(s) password: www.downloadly.ir

Size

1.7 GB