
This Lecture will give the overall view of the course and the contents in it
Learn how to calculate averages in Excel using the average formula, apply it to monthly sales data for multiple salespersons, and explore conditional formatting.
Learn how to use the max function in Excel to find each person's month with the highest seats, using a data range.
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.
Master the hlookup formula and its static versus dynamic use, compare it with xlookup and index match, and practice pulling last-column values for dashboards.
Explore how to use the index function to find a student's name by position in a list of 50 and apply fixed row and column numbers to retrieve the intersection.
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.
Apply the and formula to require both conditions for eligibility: years at the company greater than 5 and performance rating greater than 8, to qualify for a 5 percent hike.
Use the Excel IF formula to classify student scores with a logical test of greater than 50 to return pass or fail outcomes, illustrated with ten student marks.
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.