Joyagoo spreadsheet tutorial begins with one truth: you do not need to be a data analyst to track orders like a professional. Whether you are a first-time reseller or a seasoned buyer who still relies on memory, this step-by-step guide will take you from blank sheet to fully functional tracker in under thirty minutes. Every click, formula, and formatting choice is explained in plain language.
Step 1: Open Your First Joyagoo Spreadsheet
Start by opening Google Sheets in your browser. Click Blank to create a new document. Rename it to "Joyagoo Order Tracker" so you can find it quickly later. The beauty of starting here is that Google Sheets autosaves every keystroke. You will never lose progress, even if your laptop battery dies mid-session.
In cell A1, type "Date." In B1, type "Item Name." In C1, type "Supplier." In D1, type "Buy Price." In E1, type "Sell Price." In F1, type "Profit." These six columns form the skeleton of every joyagoo spreadsheet we build. Do not worry about formatting yet. Raw data comes first, beauty comes second.
Step 2: Add Your First Formula
Click cell F2. This is where your joyagoo spreadsheet earns its keep. Type the formula =E2-D2 and press Enter. The cell will display the difference between your sell price and buy price. That single line is your profit calculator. Drag the small square at the bottom-right corner of F2 down to row 10. Google Sheets automatically copies the formula, adjusting row numbers as it goes. This is called relative referencing, and it is the most important concept in any joyagoo spreadsheet.
| Step | Action | Time | Result |
|---|---|---|---|
| 1 | Open Google Sheets | 1 min | Blank document ready |
| 2 | Add 6 column headers | 2 min | Skeleton structure complete |
| 3 | Type profit formula | 2 min | Auto-calculates profit |
| 4 | Apply conditional formatting | 5 min | Color-coded status |
| 5 | Add data validation | 3 min | Dropdown menus active |
Step 3: Color Code with Conditional Formatting
A joyagoo spreadsheet without visual cues is just a wall of numbers. Select the entire Status column. Go to Format → Conditional formatting. Set a rule: if the text contains "Delivered," make the background light green. If it contains "Problem," make it light red. If it contains "Shipped," make it light blue. Now you can scan 100 rows in 3 seconds and instantly spot trouble.
Step 4: Lock in Data Validation
Typos destroy spreadsheets. In your Status column, click Data → Data validation. Choose List of items and enter: Ordered, Shipped, Delivered, Problem, Returned. Now every cell in that column has a dropdown arrow. Users can not accidentally type "Shippd" and break your filters. This tiny step saves hours of cleanup later.
Step 5: Build a Summary Dashboard
Create a new sheet tab at the bottom and name it "Dashboard." In A1, type "Total Orders." In B1, type =COUNTA(Sheet1!A2:A). In A2, type "Total Profit." In B2, type =SUM(Sheet1!F2:F). In A3, type "Average Margin." In B3, type =AVERAGE(Sheet1!F2:F). Your joyagoo spreadsheet now gives you executive-level insight in three numbers.
Want the Template Instead?
If you prefer to skip the setup and start tracking immediately, download our pre-built joyagoo spreadsheet templates. They include all formulas, formatting, and validation rules already configured.
joyagoo spreadsheetStep 6: Save and Share Securely
Your joyagoo spreadsheet lives in Google Drive. Click Share and set permissions to "Anyone with the link can view" if you want collaborators to see but not edit. For solo use, keep it private. Remember, your financial data is valuable. Never grant edit access to public links.
Congratulations. You now have a fully functional joyagoo spreadsheet that tracks dates, items, suppliers, costs, sales, profits, and order status. The entire process took roughly 25 minutes. From here, you can add supplier rating columns, shipping fee trackers, or monthly pivot tables. The foundation is solid. Everything else is an upgrade.