Learn SUM, IF, COUNT, TEXT and DATE formulas with practical examples for daily office, business and reporting work
Sub Category
- Other Office Productivity
{inAds}
Objectives
- Apply essential Excel formulas like SUM, SUMIF, SUMIFS, AVERAGE, COUNT, MAX and MIN to perform daily data calculations accurately.
- Use logical and error-handling formulas such as IFERROR and dynamic formulas to clean data and avoid common Excel calculation mistakes.
- Master text formulas like LEFT, RIGHT, MID, LEN, TRIM, CONCATENATE, TEXTJOIN and TEXT SPLIT for professional data formatting.
- Work confidently with date, time and random functions including DATE, NOW, TODAY, RAND and RANDBETWEEN for real-world Excel tasks.
Pre Requisites
- No prior Excel or formula knowledge is required. This course starts from the basics and gradually moves to advanced formulas.
- A computer or laptop with Microsoft Excel installed (any version) is needed to practice along with the lectures.
- Basic computer skills such as using a keyboard, mouse and opening files are enough.
FAQ
- Q. How long do I have access to the course materials?
- A. You can view and review the lecture materials indefinitely, like an on-demand channel.
- Q. Can I take my courses with me wherever I go?
- A. Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
{inAds}
Coupon Code(s)