1) Create defined names for every column on the DAA3 Data worksheet.
2) Use Data Validation to restrict values for the entire Date column (excluding the header row) on the DAA3 Data worksheet to have to be less than or equal to today's date (so that dates which have not occurred yet cannot be entered).
3) Analyzing data from the DAA3 Data worksheet, use reference/lookup formulas to find the following information about the sale where SalesRep5 sold to Cust10 in Region4:
3a) How much was the sale in sales $?
3b) On what date this transaction occur?
3c) Which product was sold?
4) Create two MACROs, one each that captures all of the steps required to answer the questions 4a) and 4b) respectively. Please name your MACROs some variant of "Question 4a" and "Question 4b" so that I know which MACRO replicates the answer to which part of the question.
4a) Create a new column called Gross Profit into the DAA3 Data worksheet. In that column, calculate Gross Profit for each row as Sales - COGS for that row.
4b) Use SUMIFS to populate the B2:E6 array in the cross-sectional table on the DAA3 Table worksheet with total sales by region and product, analzying the data from the DAA3 Data worksheet.
7 freelances font une offre moyenne de 70 $ pour ce travail
Hi, Greetings! ✅checked your project details: Macro, data validation ✅Completed Time: In project deadline We have worked on 600 + Projects. I have 6 + years of the experience in same kind of projects. If you ar Plus
hello sir... how are you??? i can start this job as you asked in porject details.. please talk to me... regards
Hello. I have skimmed through the file and this is something i can help you with. Let me introduce myself. I am a Chartered Accountant and I have over 5 years of experience using MS Office tools. When it comes to MS E Plus
Hi Sir I am interrested in this project. My name is Faiz and im a statistician and a professional data scientist, a combination that provides me with the full suite of tools to do data analysis, data modelling and dat Plus