How To Create A CRM In Excel

[@ProperProjectManagement]

🚀 Get the pre-built CRM 👉 sowl.co/s/bgUTFy

[@nwakanmavictoria6712]

@properprojectmanagement

[@Greg_Chase]

Excellent how-to. We are just starting up, we surveyed the entry level CRMs, and just want something for our early days that will have a dashboard and data entry, easy for everyone to come up to speed on quickly. The learning curve and features of many (most?) CRM packages is not needed for early days in the business. Thank you!

[@Channayah]

You know what … I really appreciate this video. Me and my husband have a construction company and needed some kind of organized CRM software because the season is getting busy. I didn’t really want to pay for a software company that I count quite navigate. So for you to take the time to do this video, saved a lot of time and unnecessary subscriptions. From us to you, we thank you.

[@ProperProjectManagement]

Amazing to hear. Thanks and all the best with your construction company!

[@notmyname2081]

While cloud based systems are great, I still believe a low tech excel CRM is a good idea. Thanks for sharing.

[@ProperProjectManagement]

I agree. You're welcome!

[@TeamMidstate]

great video. Do you have a spreadsheet that will also keep track of all notes, contacts and activities with a specific person or company so that I could see a history of the relationship? Thanks in advance!

[@ProperProjectManagement]

Not at the moment, sorry!

[@teikahunter6317]

This video has helped me greatly

[@ProperProjectManagement]

Great to hear it :)

[@christomkins5561]

Watched it then bought it. Thanks

[@ProperProjectManagement]

Enjoy! Thank you.

[@arabic_fes]

Thanks for the effort.

[@ProperProjectManagement]

You're very welcome

[@imogencleo]

This saved me thank you! X

[@ProperProjectManagement]

You're welcome!!

[@BigFredsTrike101]

Hi, interested in buying this spreadsheet but not sure if the link is safe as it directs to US dollars, can you advise please, thanks in advance, Andy

[@ProperProjectManagement]

Hi Andy. I use SendOwl which is one of the safest digital file providers out there. You'll pay in your local currency but the checkout is set up for dollars. You can also pay via PayPal if that makes things easier.

[@PhillipWinters]

What formula do I use in excel to add a percentage of the number. Not sure if I'm asking this right so here's what I want it to calculate Example: 4000+20%=4800 Cell b1 4000 Cell b2 20% Cell b3 4800 What formula should I use in Cell b3 to get this to work?

[@ProperProjectManagement]

Hi Phil. You would need to do: =B1*(1+B2)

[@PhillipWinters]

@@ProperProjectManagement Thank you

[@msemilia007]

Very helpful... Thank you

[@ProperProjectManagement]

You're welcome!

[@chasreymom2032]

thanks for sharing

[@ProperProjectManagement]

My pleasure

[@evanrobinson9051]

Very useful video! Thank you for sharing!

[@ProperProjectManagement]

My pleasure!

[@evapalacios9420]

Good video

[@ProperProjectManagement]

Glad to hear it!

[@matnice5045]

Why not use pivot tables for the dashboard tab?

[@ProperProjectManagement]

A useful solution for sure...

[@vladad2109]

Thanks for the video! Even if I tried to use Excel as a CRM app, it was never as good as CRM software. I am currently switching to Flowlu, and it boosts my business so much. I mean, I can easily access any information about my leads and clients, observe personal changelogs, integrate email, and even use telephony. BTW, what I like the most is that there is sales pipeline automation. Excel is good, but it won't boost your business as needed.

[@ProperProjectManagement]

Thank you, and appreciate your feedback here. Useful for other viewers! I guess it depends on your needs and business.

[@Queenolarinrin]

i need this template,kindly share with me

[@JohnDoe-qj7mu]

so many damn ads for such a short video... dude's maxing out that ad revenue lol

[@ProperProjectManagement]

Hey John. YT ultimately dictates the # of ads to show per video. Still, its a small price to pay for free content.