please rate my excel project work for Sales
at first i made two columns for the unique values of region and years, so i can add them as data validation list for my dsum function, i just knew recently that dsum is outdated and most use sumif, i just used it becuase the course i am taking used it, then i made a color conditional formatting for the sales column to make it more insightful
i made two pivot tables both for sales, one with months and one with region, the one with the months, i added the percentage of the sales difference with the previous month, i also add a slicer for region and month to connect the two pivot tables together
and then i made a pie and column chart for the region pivot table, and thats it
what else could i have done to learn more here? is this a good start?
[link] [comments]
Want to read more?
Check out the full article on the original site