Summary
Keywords
Full Transcript
Download files: https://people.highline.edu/mgirvin/AllClasses/348/348/AllFilesBI348Analytics.htm 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.
Continue this lesson in the app
Install CourseHive on Android or iOS to keep learning while you move.
