I still suggest you complete case study 2 (Reproduce a Worksheet) if you are new to Excel as it teaches data entry, basic formatting, formulas, and simple functions.
If you choose the Inventory, I expect at least one formula or function as well as correct spelling and sense. This quick demo shows you just one example of how you could format your Inventory list. Be creative and complete. Let me know if you'd like demos for creating other formulas (eg, PMT, VLOOKUP, HLOOKUP...) or using further formatting.
I didn't use any conditional formatting rules here, but I could have applied one to the Reorder? column (eg, green for "yes" and red for "no"). I also could have used Data Bars to visualize the percentage of needed items.
I also could have added a Total Row value at the bottom of Total Reorder Cost (ie, H18=SUM(H3:H17).
What else could I have included?
Download a copy of my example + some extra formatting I added after the demo:
Comentários