Excel Basics for Using Our Spreadsheets (Tutorial)

The Jewellery Business Bootcamp

Hello and Welcome: Key Course Info

Hello & Welcome: How to Use This Course :-) (2:38)
Your Business Today in a Snapshot (Questionnaire)
My Story: Running a Successful Jewellery Business: You Can Do it! (8:18)
Creating Your Jewellery Business Growth Plan (3:49)
Creating Your Jewellery Business Growth Plan Outline (Notes)
Jewellery Business Growth Plan Template (Powerpoint Document)
Setting Your Vision, Mission & Value Proposition (7:11)

Module 1: Dreams of the Future: Vision, Mission & Growth Goals

Module 1: Course Workbook (Notes)
You Are Now A Jewellery Entrepreneur (6:06)
Setting Your Growth Goals: What Are Your Growth Opportunities? (5:58)
One Page Business Plan: The Orbit Tool (11:47)
Who Are Your Customers? (8:18)
Creating Your Customer Persona's Exercise (9:14)
INTERVIEW: Life as a Jeweller with Natasha Lisa (Part 1) (28:12)
INTERVIEW: Life as a Jeweller with Natasha Lisa (Part 2) (23:26)

Module 2: Building Your Killer Brand

Module 2: Course Workbook (Notes)
Building Your Killer Brand (5:38)
Creating Your Branding Document (Video) (15:37)
Creating Your Branding Document (Notes)
What is Your USP? (Unique Selling Point) (6:00)
Photography For Your Jewellery Business: My Setup (8:44)
What's in the Box? Packaging Design and Postage Options (7:50)
INTERVIEW: Jess Van Den - Building a Brand on Etsy (53:48)

Module 3: Products, Collections, Copyright & IP

Module 3: Course Workbook (Notes)
Collections for Your Jewellery Business (8:39)
The Collection Builder (31:20)
Commissions and Bespoke Designing for Your Jewellery Business (12:00)
Protecting Your Designs: Intellectual Property and Copyright For Your Jewellery Business (9:07)

Module 4: Pricing Your Jewellery For Profit

Module 4: Course Workbook (Notes)
Pricing Your Jewellery For Profit (45:53)
Defining Your Costs Pricing Spreadsheet (Notes)
Discounting & Sales in Your Jewellery Business (2:17)
Pricing For International Sales (6:46)
Get Those Sales In: Selling Strategies For Your Jewellery Business (11:49)
Generating Sales: The Sales Funnel & Customer Journeys (20:49)
Creating Your Business KPI's (12:08)
INTERVIEW: Hayley Kruger On Pricing and Sales For you Growing Jewellery Business Part 2 (22:05)
INTERVIEW: Hayley Kruger On Pricing and Sales For you Growing Jewellery Business Part 1 (19:45)

Module 5: Online Marketing: Social Media and Paid Advertising

Module 5: Course Workbook (Notes)
What Can Social Media Do For Your Jewellery Business? (4:46)
NEW: Updates for Social Media 2018 (31:57)
Facebook For your Jewellery Business With Karen Young (40:00)
Twitter Tour: Setting up & Managing an Account for Your Jewellery Business (with Karen Young) (28:01)
Instagram For Your Jewellery Business with Karen Young (33:30)
Facebook Adverts For Your Jewellery Business (28:43)
Google Ads For Your Jewellery Business Part 1 (36:16)
Google Ads For Your Jewellery Business Part 2 (12:45)
Creating Your Social Media Strategy (13:28)
INTERVIEW: Melissa Camilleri on Building a Community and Generating Sales Through Instagram (Part 1) (33:02)
INTERVIEW: Melissa Camilleri on Building a Community and Generating Sales Through Instagram (Part 2) (25:25)
INTERVIEW: With Hilary Pullen - How to Sell Online: SEO, Social Media & Paid Advertising (49:09)

Module 6: Online Marketing: SEO and Websites

Module 6: Course Workbook (Notes)
Where to Sell: Overview of selling platforms and your own website (8:22)
SEO and Getting Your Business Seen on Google (13:35)
Etsy Part 1: Top Tips for Getting Sales on Etsy (22:01)
Etsy Part 2: Behind the Scenes Tour of My Etsy Shop (20:52)
1 : How to Build a Squarespace Website For Your Jewellery Business: Intro Pros & Cons (6:51)
2 : How to Build a Squarespace Website For Your Jewellery Business : Practical Part 1 (22:39)
3 : How to Build a Squarespace Website For Your Jewellery Business: Practical Part 2 (35:26)
Building a Wordpress Website: An Overview (21:18)
WORKSHEET: Creating Terms & Conditions, Refunds Policy & Privacy (Notes)
We are half way through - how's the jewellery business growth plan going? (1:42)
INTERVIEW: Anna Campbell: Building a Website For Your Jewellery Business (63:24)

Module 7: Online Marketing: Blogs, Emails & Mailing Lists

Module 7: Course Workbook (Notes)
Blogging and Working With Bloggers in Your Business (7:36)
Engaging your customers and increasing sales with Email Marketing (11:37)
Master Mailchimp for Your Email Marketing (36:17)
INTERVIEW: With Karen Young: Online and Email Marketing For Your Jewellery Business (Part 1) (36:35)
INTERVIEW: With Karen Young: Online and Email Marketing For Your Jewellery Business (Part 2) (28:41)

Module 8: Offline Marketing: PR and Sales

Module 8: Course Workbook (Notes)
Your Business Is Interesting: Engaging the Press (10:44)
Working With External PR Agencies (6:25)
Handling Difficult Customers and Complaints In Your Business (5:41)
Gaining Awards and Recognition For Your Jewellery Business (3:41)
The Power of Networking (5:09)

Module 9: Wholesale - Working with Retailers & Managing Sales

Module 9: Course Workbook (Notes)
How to work with Shop Owners (Retailers) and Build Those Relationships (16:39)
Common Pitfalls To Avoid When Working With Retailers (4:09)
Line Sheet Example Document & Order Form (Notes)
Developing a Wholesale Strategy For Your Jewellery Business (5:00)
INTERVIEW: How to Sell To Shops & Grow Your Wholesale Business with Clare Yuille (Part 1) (26:37)
INTERVIEW: How to Sell To Shops & Grow Your Wholesale Business with Clare Yuille (Part 2) (27:48)

Module 10: The Business Nitty Gritty: Understanding Business & Legal Matters

Module 10: Course Workbook (Notes)
Let's Get Legal: What Business Structure Are You? (6:46)
Understanding Insurance For Your Jewellery Business (6:26)
Do I Need a Business Bank Account? (3:46)
Hallmarking 101: For Your Jewellery Business (37:12)
Employing People to Help Grow Your Business (7:59)
Operations and Managing Processes in Your Growing Jewellery Business (15:51)
Info Sheet: Setting up as a Sole Trader (Notes)
Info Sheet: Completing your tax return, record keeping and expenses (Notes)
Info Sheet: VAT Value Added Tax (Notes)
Info Sheet: How to set up a Limited Company (Notes)
INTERVIEW: Staying Organised & Motivated in Your Growing Jewellery Business With Julia Rai (Part 1) (21:12)
INTERVIEW: Staying Organised & Motivated in Your Growing Jewellery Business With Julia Rai (Part 2) (17:01)
INTERVIEW: Staying Organised & Motivated in Your Growing Jewellery Business With Julia Rai (Part 3) (26:39)
GDPR and Tax Updates for 2018 (19:32)

Module 11: Show Me the Money: Finance Management, Forecasts & Cash Flow

Module 11: Course Workbook (Notes)
Intro: Understanding The Numbers in Your Jewellery Business (4:45)
Managing Finances in Your Jewellery Business (AUDIO ONLY LESSON) (10:32)
Excel Basics for Using Our Spreadsheets (Tutorial) (8:54)
SPREADSHEET: Creating A Cash Flow Forecast and Budget For Your Jewellery Business
Creating a Cash Flow Forecast & Financial Modelling For Your Jewellery Business (Tutorial) (23:27)
Creating a Budget For Your Jewellery Business (Tutorial) (9:55)
SPREADSHEET: Basic Book Keeping For Your Jewellery Business
Basic Book Keeping For Your Jewellery Business (Tutorial) (6:36)
Outro: Keeping On Top of It - Make it Routine (1:21)

Module 12: Putting it All Together - Thoughts, Ideas and Inspiration for the Future

Module 12: Course Workbook (Notes)
What To Do When Things Go Wrong :-( (9:08)
Staying Motivated To Grow & Thrive in Business (7:00)
Congratulations on Completing the Bootcamp - Final Details :-) (3:20)
Creating your jewellery business growth plan (notes)
Social media and website details for bootcamp interviewees
INTERVIEW: Press, Projects & Book Writing For Jewellers With Sian Leeper-Hamilton (Part 1) (23:15)
INTERVIEW: Press, Projects & Book Writing For Jewellers With Sian Leeper-Hamilton (Part 2) (20:50)
INTERVIEW: Press, Projects & Book Writing For Jewellers With Sian Leeper-Hamilton (Part 3) (15:12)
End Of Course Feedback: We Would Love To Know Your Views :-)

Excel Basics for Using Our Spreadsheets (Tutorial)

Lesson contents locked

If you're already enrolled, you'll need to login.

Enroll in Course to Unlock