
This Video gives us the introduction and the curriculum of the course.
Learn how the hlookup formula performs a horizontal lookup on the first row of a table to return cost and product name from a row, using fixed ranges and exact-match.
Learn how the Excel index function returns a value at the intersection of a row and column, fix references, and copy formulas to retrieve product prices and quantities.
Learn to apply the if function in Excel to perform logical tests on summed marks, using thresholds like 300 and 150 to return true or false outcomes.
Apply the sum if formula to sum salaries that match a given criterion, such as vice presidents or managers, and learn how the sum range returns the correct total.
Learn to use sum, minimum, maximum, and average formulas in Excel to compute a student's total marks across physics, chemistry, and biology, plus min, max, and average scores.
Use the lowercase formula in Microsoft Excel to convert uppercase text to lowercase, demonstrated with an example converting A, B, C, D, E, F.
Learn the right function in Excel to extract characters from the right side of a string, the opposite of left, and apply it in office tasks.
This course teaches you 18 most useful formulas of Microsoft Excel that would help you to
1. Be more productive at office.
2. To be the fastest worker among your team when it some to Using Excel formulas.
3. Builds up your Confidence on how to use the formulas on larger data sets.
4. This course helps you to get a firm base on the excel formulas and which help you to take on more advance course in excel.
5. Get all the required Data analysis skill by applying Excel Formulas.
6. Be faster at your work and impress other with your skills.
7. Build Business Intelligence excel dashboards in excel and extract Insights from them.
Now what makes me eligible to teach this course?
1. All the members of the team have experiences in leading MNC’s in Retail, Supply Chain & Logistics.
2. All the team members have the knowledge on Excel as to what all Functions are used in Day to Day activities within the company to make your life easy within the work environment.
3. The formulas taught in the course are the exactly the once that are used in office world wide.
Regards,
Logistics and supply Chain world