Real Life Examples
Task
Consolidating Order and Inventory Spreadsheets
Time Spent
4 hours
Cost
$140
A long term client of mine was using two separate spreadsheets to track orders and inventory: one to record order details and quantities, which would automatically fill out paperwork, and another to track inventory levels. After reviewing the process, I realized there had to be a way to streamline everything into a single sheet.
After making a backup copy to preserve the original, I spent some time researching and experimenting to figure out the right formula for tracking inventory within the same document. The solution came when I found a way to calculate the total quantity of items ordered within a given month by simply copying and pasting dates into the right column, allowing the formula in a separate tab to update the inventory automatically.
This cut my client’s workload in half. Once I updated past orders and verified the inventory numbers, the spreadsheet was ready to be used moving forward. The entire process took 4 hours, costing my client $140, but the time saved from now on is priceless.
Task
Bulk Card Creation with Canva and CSV Automation
Time Spent
2.5 hours
Cost
$87.50
My client wanted to create over 300 bench cards for their plant products, each featuring details like the common name, botanical name, top features, height, spread, and sunlight requirements. She asked if there was a way to speed up the process using Canva and a CSV file. I wasn’t sure, but I told her I’d find out. After a quick search, I learned it was possible and jotted down the steps for future reference.
Next, I designed a Canva template where the CSV file could automatically fill in the text blocks for each card. Once the layout was finalized, I created a spreadsheet: each row became a new design, and each column represented a specific detail to populate (like the common name or sunlight). It took a few tweaks to get everything aligned, but I made it work.
The entire process—from research to creating the template and spreadsheet—took about 2.5 hours, costing my client $87.50. Once the setup was complete, all they had to do was provide the product details, and the cards were ready for printing.
Task
Website Creation
Time Spent
8 hours
Cost
$280
A client needed a website that would effectively communicate their offerings, ensuring potential clients could learn about their services before reaching out. The goal was to create a persuasive, structured platform that covered all key points—eliminating the risk of missing crucial details when explaining services in person.
I designed a website using Squarespace with 5 key pages: The Home Page, Services Page, Portfolio, FAQ and About Me. Once the layout was planned, I drafted the website content in a Google Doc, testing different headlines and refining the wording to match the client’s voice. I added images from their work to showcase their services and make the site more visually appealing. I chose fonts and adjusted the layout, focusing on a strong first impression with the home page. In the FAQ, I answered common client questions in advance. The About Me page introduced the client’s background to build trust, while the Portfolio page highlighted past work to show credibility. Finally, I optimized the site for a smooth experience on mobile devices.
Task
Inventory Data Entry and Updates
Time Spent
90 minutes
Cost
$52.50
My client needed help updating their inventory. They sent over photos of their product tags—they’d spread out several tags at a time, each one showing the product name and the stock quantity written directly on it. Using these photos, along with their supply orders, I updated the inventory numbers in their system. In total, I updated 179 products. The process took 90 minutes to complete, costing $52.50.
More Success Stories