
This Lecture will give the overall view of the course and the contents in it
Learn how to use the rand between formula to generate random numbers within a specified range, such as 100 to 200, and apply it to various Excel problems.
Use the rank formula to identify the top scorer in physics from a class score set. Demonstrate how the rank function ranks students by marks through this problem.
Learn to compute total cost using the sumproduct formula by multiplying quantities by prices and summing the results, demonstrated through two problem-solving methods.
Use the match formula to find a student's position in the list, using exact match to identify June or Rhonda and determine the position.
use the or formula to determine raise eligibility when an employee has either more than five years at the company or a performance rating above eight.
Explore essential text formulas in Excel, including proper, upper, and lower case, and left, right, and concatenate to clean, extract, and join data for clean, unified results.
Do you want to learn how to use Excel Formulas but find it all a bit Difficult?
Do you need Excel to succeed at work, but wonder where to even start?
If your Answer is YES, in this course we will teach you 30+ Excel Formulas without any confusion by applying them on small Case Studies.
I'm so confident that this course will increase your efficiency and understanding of Excel formulas that I guarantee it!
This Module completely focuses on Excel Formulas from all categories Namely Mathematical, Logical, Look Up, Text & Date and Time. This Module will give you a firm grip on the formulas before you start with the next Modules.
Why should you take this course?
1. To Have a Mastery on Excel one should always start with the Basic things like learning the formulas, by mastering all the 30+ Formulas you can be a PRO in basic excel and move on to the next steps in learning Excel
2. Learning Excel anyone can do, but applying them on data sets with a business question, that’s when your concepts get cleared.
I guarantee you will have a complete & a sound understanding of all the 30 + Formulas by the end of this course.
I get right to the point in every lecture. I know you're busy so I don't waste a lot of time on tangents, personal stories or filler like many instructors do. If the lecture is about VLOOKUP, I'm going to get straight to teaching you how to use VLOOKUP so you can put it to use right away.
Who is this course for?
This course is designed for All Phases of Excel learners who are new to using formulas to make calculations in Excel. It is also appropriate for anyone who wants to learn to use formulas but feels intimidated or overwhelmed.
What's included in the course:
1. How to use the MIN, MAX, AVERAGE, SUM, LARGE, RAND BETWEEN, ROUND, SUBTOTAL, SUM PRODUCT & LARGE.
How to use VLOOK UP, HLOOK UP, MATCH , INDEX & COMBINATION OF BOTH INDEX & MATCH.
How to use CONCATENATE, LOWER CASE, UPPER CASE, PROPER, LEFT & RIGHT.
How to use DATE, NOW, TODAY & WEEKDAY.
How to use OR, AND, IF, SUMIF, SUMIFS, COUNTIF, COUNTIFS.
A complete demonstration of how to use each formula and what to use if for.
Thanks for taking the time to check out my course. I can't wait to help you take your Excel Formulas to the next level!
Remember, If you aren't 100% satisfied with ANYTHING that you've learned or you don't see the results in your work within 30 days of signing up, get a FULL REFUND.
If you're ready to get started, click on the "Take This Course" button and in just a couple of hours you'll be amazed at what you can do with Excel.
Who this course is for:
· This course is suitable for any level of Excel user from beginning to advance but it is mostly geared toward beginning and intermediate level learners.
· This course is for you if you are looking for a clearer understanding of how to use Excel Formulas where to find them and some tips and tricks to make your work with formulas easier.