Basic Excel Business Analytics #08: Total Revenue Calculation: VLOOKUP or LOOKUP/SUMPRODUCT?
75.8 هزار بار بازدید -
9 سال پیش
-
Download files:
Download files: https://people.highline.edu/mgirvin/A...
Learn about the functions: VLOOKUP, LOOKUP, SUMPRODUT, COUNTIFS. Learn how to use various functions to calculate Total Revenue and Total Number of Transactions in each Sales Category using either a Helper Column Solution or a Single Cell Solution:
1) (00:13) Intro to what we will do this this video.
2) (02:20) Learn the basics of how the VLOOKUP function Approximate Match works.
3) (03:49) VLOOKUP function Retrieve a Price from a Price lookup table in order to create a price “Helper Column”.
4) (06:06) Calculate “Helper Column” for Transactional Revenue.
5) (07:29) SUM function to add to get Total Revenue.
6) (07:48) Learn Basics of the LOOKUP function.
7) (10:50) LOOKUP and SUMPRODUCT functions to create a Single Cell Array Formula to calculate Total Revenue.
8) (14:58) COUNTIFS to count total number of transactions in each Sales Category using a Helper Column.
9) (16:28) COUNTIFS to count total number of transactions in each Sales Category NOT using a Helper Column.
Download Excel File Not: After clicking on link, Use Ctrl + F (Find) and search for “Highline BI 348 Class” or for the file name as seen at the beginning of the video.
Learn about the functions: VLOOKUP, LOOKUP, SUMPRODUT, COUNTIFS. Learn how to use various functions to calculate Total Revenue and Total Number of Transactions in each Sales Category using either a Helper Column Solution or a Single Cell Solution:
1) (00:13) Intro to what we will do this this video.
2) (02:20) Learn the basics of how the VLOOKUP function Approximate Match works.
3) (03:49) VLOOKUP function Retrieve a Price from a Price lookup table in order to create a price “Helper Column”.
4) (06:06) Calculate “Helper Column” for Transactional Revenue.
5) (07:29) SUM function to add to get Total Revenue.
6) (07:48) Learn Basics of the LOOKUP function.
7) (10:50) LOOKUP and SUMPRODUCT functions to create a Single Cell Array Formula to calculate Total Revenue.
8) (14:58) COUNTIFS to count total number of transactions in each Sales Category using a Helper Column.
9) (16:28) COUNTIFS to count total number of transactions in each Sales Category NOT using a Helper Column.
Download Excel File Not: After clicking on link, Use Ctrl + F (Find) and search for “Highline BI 348 Class” or for the file name as seen at the beginning of the video.
9 سال پیش
در تاریخ 1394/07/02 منتشر شده
است.
75,837
بـار بازدید شده