Learn How To Create This Mini ERP Application With Invoicing, Purchasing & Dashboard In Excel

In this week’s training, I will show you how to create a Mini ERP Application from scratch

⬇DOWNLOAD THIS WEEKS WORKBOOK FREE:

EXCEL COURSES:

EXCEL PRODUCTS:

TIMESTAMPS:
0:00 – Introduction
0:38 – Overview
5:56 – Worksheet Design
34:26 – Hide All Menu
36:47 – Home Menu
38:06 – Income Expenses Menu
38:37 – Invoice Menu
39:06 – Purchase Menu
39:15 – Reports Menu
47:35 – Save Transaction
54:02 – Change Event Worksheet
1:00:16 – Save Invoice
1:09:47 – Save Purchase
1:20:31 – Selection Change Event
1:21:56 – Refresh Report
1:27:19 – Report 1
1:37:56 – Report 2
1:43:34 – Report 3

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
#ERP #InvoicingSystem #BusinessManagement #ExcelVBAforBusiness

[mylittlerockstar]

I appreciate you for the service you have done. You are providing the workbook for free where you have invested your time and energy. As a gesture of gratitude, i have liked and subscribed to your channel. Keep going with your good work.

[seshaniranjan]

It's our luck to have you on this platform

Please do continue your research and development we will support you through out

[aryaman]

Lots of love and respect from India....i shared this video with all my friends....this is next level excel👌🏻👍🏻🙏🏻

[wateenafzal]

*In Reports & Graphs*
1:54:37 TOTAL EXPENSES FORMULA NOT RIGHT

your content is amazing...

[ukonkomarasari]

Can not say enough thank you ... what a compact and super comprehensive tutorial. Again Thank you so much

[mahnoorsaba]

All your videos are great and great ... You have worked hard for us.
May Allah give you more strength. You teach very well. Your method is very good. Many more people will benefit from you. Keep up the good work. Our prayers are with you.

[shiningstars]

The nice thing about this person is that he answers every comment made by us, he is not like other YouTubers, love you sir.

[bonez]

Genius...is rarely used but manaaan you are one thanks 🙏 for sharing your knowledge...I would defo keep an eye on all future videos and will view your website...thanks again great work

[jeromeh]

Valuable piece of information I will try to find the time to adapt this in Calc (Libre Office).

[shabbiraziz]

Great work
Jazaka Allah.
Allah will will give u best reward.Ameen
Dua from karachi

[vrfenterprisesllp]

Thank you so much Randy for taking through step by step to create this useful application. I learnt a lot from this session. I have created a sales invoicing macro for our small business. I am working through to enhance it further to create ledger accounts, p&l and BS. This training and the workbook are helping me achieve what I was planning to do. I will leverage this to try and integrate. Will keep you posted on the outcome. Was lucky enough to reach this place. You are incredible. God bless. 🙏

[joemanflyer]

Yes … excel and web development can work together!

[usmankabeerbutt]

Its very good. but with some mistakes in it ...

1. When i make an invoice it must not exceed the quantity of purchase. E.g if i purchase 20 items and i make invoice of 21 items it must give warning of ... "OUT OF STOCK" msg instead it saves the purchases.
2. After saving the invoice, the invoice must show a preview. So if any one wants to print it he/she can take a print out of it.
3. There must be a menu to add Customers, Vendors, like Inventory and Purchase.
4. There must be separate sections for INCOME and EXPENSE to be added.
5. There must be separate section for INCOME and EXPENSE reports like REPORTS AND GRAPH.

These are the few things that i have noticed in the application to be added to make it more easy for use.
Hoping you will like these suggestions to be consider.
Thanks.

[yusuf]

answer of my pray Mr.Randy.. thank you..

[czechyorker]

30 minutes until the premiere and it already has over 300 likes. That’s not a surprise. We can be sure it’s going to be amazing.

[bestscenes]

Thanks Randy. I think It will be awesome

[hewadsapai]

This is awesome, but i face some problems in this part - Sub Report1()
'Sales By Customer
Dim LastInvRow As Long, lastResultRow As Long
With Sheet3
LastInvRow =
If LastInvRow < 3 Then Exit Sub
'Clear Previous Result
.Range("B2:C" & LastInvRow).AdvancedFilter xlFilterCopy CriteriaRange:=.Range("H2:I3"), CopyToRange:=.Range("J2").Value, Unique:=True
lastResultRow =
Sheet1.Range("AC4:AD" & lastResultRow + 2).Value = Range("J2:K" & lastResultRow).Value
End With

[Emma-tgcu]

I can't explain how much this work is valuable! Thank you so much! I even let all the ads play to the end just to appreciate :-)

[amrutchitragar]

Your Creativity Level in Development of Application in Excel Awesome . I am waiting for this amazing training video

[teyay]

Great Job. Thank you for share the video.