top of page
Writer's pictureCaitlin Baird

ITC: video demo for Excel case study 1 -Inventory (intermediate skill)

Updated: Nov 30, 2021

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:


Related Posts

See All

access to Pearson ebooks

Click here and choose the book for your course (MSE, MSP, MSW, BCA). If you want to download and save the ebook, you must first install...

welcome to Excel

Have you used the Pearson platform before? yes: access the platform and move on to step 2 no: begin with the Pearson success resources...

Comentários


bottom of page