Barry University Online Sales Channels Distribution Worksheet
I’m working on a excel project and need support to help me learn.
DATA: CREATE Table(s) with minimum 8 columns and 50 rows (You are creating your own data). The columns and rows can be cumulative if you use multiple tables. (For example, if you use two tables A and B: Table A may have at 5 columns and 30 rows and Table B may have 3 columns and 20 rows)
FORMULAS: USING THE DATA (from Data sheet) USE MAX, MIN, AVERAGE, SUM, IF, AND, OR, COUNTA FUNCTIONS
CHARTS: USING THE DATA (from Data sheet) CREATE CLUSTERED COLUMN, 3D PIE CHARTS
TABLE: CONVERT THE DATA (from Data sheet) TO A TABLE, USE VLOOKUP, HLOOKUP, MATCH, DSUM, DOUNTA FUNCTIONS . You will need additional data here for your lookup tables. See Module 12 examples.
PIVOT TABLE: USING THE DATA (from Data sheet), CREATE TWO PIVOT TABLES AND ADD SLICERS TO BOTH
VARIABLE DATA TABLE: USING THE DATA (from Data sheet) CREATE A 1-VARIABLE AND A 2-VARIABLE DATA TABLE. If possible have some numerical metrics (example percentages) in your data to make this process simpler.
FORECAST: USING THE DATA (from Data sheet) SHOW EXAMPLES OF GOAL SEEK AND CREATE A SOLVER MODEL. The numerical metrics will be helpful here too.