•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How to manage vendor data?
I work in the Procurement Department, and our company has a total of eight manufacturing units. I need to create an Excel sheet that contains a database of different vendors for various raw materials. In Sheet 1, I would like to have a quick summary dashboard showing all open Purchase Orders along with a section to track and follow up on dispatch details. Please suggest ideas on how I can make the sheet well-structured, easy to use, and visually engaging, as I am a beginner in Excel.
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#Excel compatibility
#generative AI for data analysis
#rows.com
#natural language processing for spreadsheets
#financial modeling with spreadsheets
#big data management in spreadsheets
#conversational data analysis
#real-time data collaboration
#intelligent data visualization
#vendor data
#Procurement Department
#Excel sheet
#manufacturing units
#open Purchase Orders
#raw materials
#summary dashboard
#database
#dispatch details
#visually engaging