Sorry, your browser is not supported
To have the best experience using Skillshare, we recommend that you use one of these supported browsers.

Back Office Basics for Small Handmade Businesses - Setting up a Costing Spreadsheet

Detrina Kofroth, Jewelry Design and Small Business Basics

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
7 Videos (31m)
    • Back Office Basics for Small Handmade Businesses Setting up a Costing Spreadsheet Intro

      1:11
    • Back Office Basics for Small Handmade Businesses Creating the Workbook

      5:38
    • Back Office Basics for Small Handmade Businesses Creating Sheets for Categorization

      5:10
    • Back Office Basics for Small Handmade Businesses Column Headers

      5:48
    • Back Office Basics for Small Handmade Businesses Entering the Data and Formatting Cells

      7:02
    • Back Office Basics for Small Handmade Businesses Extra Tips

      3:06
    • Back Office Basics for Small Handmade Businesses Summary

      2:42

About This Class

In the series, I want to cover a few other back office essentials that I have found to be most valuable when starting a small home based craft business.

I am not a software expert by any means, I am a handmade business owner. I want to provide the basics for others and help them avoid the mistakes and problems I encountered along my journey so far.  

The topic of this video is "How to set up a basic costing spreadsheet" in Microsoft Excel or Google Sheets and the most important information to include for reference when pricing your handmade items and when you need to restock materials.

This is a beginner level class. It does not include using formulas for tracking inventory at this level. 

In this class you will Learn:

  1. How to create a workbook in Excel. This includes naming the workbook and saving it to a specified location on your computer for ease of access. 
  2. How to create separate sheets in your workbook to categorize the different types of materials you use in your business, in a way that makes it easier for you to find the information you need for the day to day operations of your small business. 
  3. What details are essential to include in your spreadsheet for optimizing your small business operation and how to create column headers for this information. 
  4. How to enter the specific information in each row that pertains to each particular material you use in the production of your craft items. 
  5. How to determine the cost per field and how that pertains to pricing your craft items for sale. 
  6. How to format cells for different types of data
  7. How to format fonts etc for emphasis and headers.
  8. How to use the find function 

Requirements for this Class:

Basic Computer and Typing skills

Access to Microsoft Excel or Google Sheets Spreadsheet Application

Deliverable for this Class:

Upload a copy of your spreadsheet for review.

1 of 1 students recommendSee All

A good basic introduction for those starting out who want to using spreadsheets for business.
Laura Whittington

Knitwear Designer, Crafter, Textile artist

1

Student

--

Projects

Detrina Kofroth

Jewelry Design and Small Business Basics

My channel is devoted to DIY Jewelry classes and Classes on Building a Home Based Craft Business.

As a new and growing business I have made a lot of changes in regards to where I want my business to go. I have recently recorded the video below, that explains my short term goals and all the changes I have been implementing to by business model and plan, my goals for Skillshare and YouTube and my website TheAlluringBeadBoutique.com as well.

Give it a look and follow along with my...

See full profile