Presentation - uses the output from the logic sheet to create charts, tables and visual presentation Understanding how to build sales spreadsheets better
Logic sheets - only contains formulas and gets its data from the "Data Sheet"ģ. It uses the output from the formulas.Īgain, the three basic and best practices to make your spreadsheet life simple. Use the presentation sheet to create charts, tables, graphs and so on. Presentation is self-explanatory and there is a section of Do’s and Don’ts in the upcoming section.
It just updates automatically based on what the data sheet says as you update it with Amazon sales. Make it so that the tab with the formulas will be 100% hands-off. Make it so that one sheet has all the data, and another has all the formulas and logic so that the sheet with the formulas do not have to be updated again. Likewise, don’t mix the data with the logic (formulas) on the same sheet, otherwise, it becomes extremely messy to separate. The reason why trackers and spreadsheets you first built enthusiastically ultimately fizzle out, is because the work required to update with data is a major hurdle. If you are doing it manually, save yourself the headache and hassle of manually downloading reports by automating the work.
In order to track sales data, you need – sales data. The basics to creating an effective Amazon sales tracker
Free Amazon Sales Tracker with Google Sheets.Advanced techniques to boost your visual spreadsheet presentation.12 Simple do’s and don’ts of spreadsheet presentation.Get monthly sales into the spreadsheet tracker.Automatic method to get daily Amazon sales data.