How To Create Your Own Collectibles Tracking Application In Excel [Masterclass + Free Template]

In this incredible masterclass, we will create one of the best Collectible Tracking applications ever built in Excel. Complete with custom fields, custom tags, dynamic filtering & unlimited picture & document attachments. Don’t miss this training.

GET AN UPDATED TRAINING AND TEMPLATE WITH THE FOLLOWING FEATURES:
⭐️Print Displayed Items
⭐️Filter By Selected Tag
⭐️Complete Dashboard

EXCEL COURSES:

EXCEL PRODUCTS:


TIMESTAMPS:
0:00 – Introduction
0:41 – Overview
7:49 – Designing Main Screen
42:57 – List Items
55:17 – Change Event Worksheet
56:19 – List Items
58:12 – Clear Filter
59:13 – Item Select
1:01:15 – Refresh Attach
1:01:58 – Item Load
1:04:12 – Add Tag
1:08:46 – Load Tags
1:15:48 – Remove Tag
1:20:38 – New Item
1:21:42 – Add Picture
1:22:35 – Browse for Picture Folder
1:22:53 – Add Picture Item
1:25:51 – Display Picture Item
1:27:12 – Save and Update Item
1:28:43 – Delete Item
1:33:08 – Change Event Worksheet
1:36:29 – Selection Change Event
1:38:05 – Add Attachment
1:43:49 – Cancel and Save Button
1:44:03 – Save Attachment
1:47:21 – Refresh Attachment
1:49:11 – Display Picture Attachment
1:51:31 – Open Attachment
1:52:13 – Delete Attachment

Follow me on my Social Media Accounts:

About Us:
I help Microsoft Excel enthusiasts turn their passion into profits so they can earn passive income using their skills without having to trade time for money.
I love making these videos for you each and every week. A great way of supporting Excel For Freelancers to keep this training free each and every week is by supporting us through one of the amazing products offered that will help you skyrocket your Excel Skills and reach your dreams.

Get Alerted IMMEDIATELY with new Free Training Videos & Workbook by subscribing here:

New Training Video Uploaded Every Tuesday And Saturday!

Thank you very much for your continued support,
Randy Austin

#microsoftexcel #Collectibles #Collectors #SportsMemorabilia #CollectingCoins #CollectiblesTracker

[joemanflyer]

This is great for those crazy memorabilia collectors!

[nerenlakhraj]

WOW Randy ... You always seem to outdo yourself and set new bar limits. This seems like a really fantastic application. Thank you for sharing your skills with us. Greatly appreciate it.

[schnullertroll]

Great lesson and great teacher. Thank you so much! I found an issue when attach a picture to an item. It has the wrong aspect ratio. Also it would be very nice to show the image with its original size when click on it.

[shadowbear]

Thanks for the trading you do! Looking forward to this one.

[anthonymccarter]

Hello, I enjoy your videos… I even bought the 300 excel spreadsheet and pdf’s… I am just learning how to do this… I know you are looking for ideals.
On the collection tracker Is there a way that you can select individual items in the collections to create a set? Also is there a way to take that information and add financial information to track profit or loss on things you buy and sell?
Thank you….
Have a blessed Day!!!

[keitamoussa]

You make Tuesdays amazing with your incredible training .

Please could you include not only the sample but the zip file so as to follow along with you?

[bzypeach]

How do you customize the folder where pictures are located? I keep getting an error when pasting new location on the admin page

[papasnake]

Hi Randy,

First of all, thank you - this is amazing.

I noted, on Remove Tag, you should not delete the comma if its the last tag. There is no comma at that point left!

And when creating a new Item - this replaces the existing one? Am I missing something? How would I amend the code to instead create a new entry based on the next item row (B4) - then clear everything?

[rickykrk-]

I've been looking for something like this for close to 2 years now. So glad I found your channel! Thank you for the downloadable copy of the file. It looks great! I opened it, but keep getting the message about Microsoft blocking its macros from running as it deems the source of the file as untrusted. I know how to disable it so that the file can run macros, but I was wondering if this is something you've been asked about before (in other words -- am I allowed/authorized to edit the sheet for my own personal use -- safely)?

Thank you again for your great work! Looking forward to more of your content.

[Rose-xcwz]

I am thinking of using a variation of this for my library and / or my yarn stash...

[sanukawaravita]

Is it possible to actually replicate this entire thing into Access? 🤔

[hadjchaibaek]

tous vous sujet son tres interesson mes jai du male a vous suivez cars vous parler tres rapidement et en plus je suis nule en anglais