It looks like you're using Internet Explorer 11 or older. This website works best with modern browsers such as the latest versions of Chrome, Firefox, Safari, and Edge. If you continue with this browser, you may see unexpected results.
Review the resources listed below to prepare for this week's assignment. Before reviewing these resources, read through the assignment instructions so you know what you will be expected to do with this material.
Girvin, M. (2018). Trade discounts, series discounts, net cost equivalents & wholesale cost. ExcelisFun. YouTube. Retrieved from: https://youtu.be/a-hy-_tIifU
In this video, you will learn how to calculate Trade Discounts (Single and Series) in order to calculate a Wholesale Cost. You will learn about business terms, VLOOKUP, and IF Functions to automate calculations.
Girvin, M. (2009). Summarize monthly sales with daily transactional dates - 5 method. ExcelisFun. YouTube. Retrieved from: https://youtu.be/Gq_-UTSEwOE
In this video, you will learn about Pivot Tables, the SUMIF, COUNTIF, SUMPRODUCT functions. Also, how SUMIF and COUNTIF cannot handle arrays and so the solution means that we must add an extra column and use the MONTH, YEAR, and TEXT functions. How to construct a SUMPRODUCT formula that requires two dates from only one date.
Girvin, M. (2009). March end quarterly comparative report - pivot table. ExcelisFun. YouTube. Retrieved from: https://youtu.be/nVXicRtV9JU
In this video, you will learn how to use a Pivot Table to create a Report that shows the differences in Sales between Quarters and how to create quarters in a Pivot Table that has a year-end March 31. Pivot Table trick on Group Dates by Quarter and Year.