Accounting in Excel: Part II The Sales Journal

Hi guys, here's the Part II Tutorial Series: Full Accounting Cycle Explained.
In this video you will learn: (Click the TimeStamp for shortcuts)

a. The different types of Specialized Journals. 0:33
b. How to increment an alphanumeric numbers in a row in excel 2:12
c. How to use data validation list on tables in excel 3:28
d. How to use the combo function INDEX MATCH as a substitue of the VLOOKUP Function 4:46
e. How to SUMIFS a date criteria range (ex. between 1/1/2019 - 31/1/2019) 7:46

I hope you will find this video helpful on your accounting / bookkeeping task.

Enjoy!

[thebestclassicalmusic]

p-l-e-a-s-e continue the videos. Seriously, yours are the best on youtube!

[haythambhalo]

Hi Melrose. I've been foraging through YouTube and persevered through countless videos to finally find your channel, I got super excited and subscribed immediately, only to find out you made only 2 videos and stopped. I don't know why that is and I'm wishing you the very best but please find a way to continue with the tutorials. I am confident you will in no time be the best (and biggest) YT channel on Excel!

Thank you!

[naufalhassan]

video is very helpful .. one in million video .. please continue the course ..

[noweleencristeedomingo]

Your videos are really helpful. Hope you could make the next video tutorials and I also hope that all is well. Thank you!

[emmanuelokyere]

Nice tutorials
We cant wait for the next series😁👍

[aloloh]

So helpful. I am waiting for more of your Videos. Thanks.🙂

[eloisajoydecastro]

Thank you for your video its so helpful, informative and clear. Hoping for more videos.
Thank you. God bless.

[daphneteo]

Hi pls continue the video, yours are the best among so many. Thank you!

[kimberlybacon]

I found your video and followed though the first 2 but found the rest are not here 😭 I was so excited to find something I could finally use with confidence... then... dun dun dun... 😫 please please please complete the series!! 🙏

[TheGpatters]

Very good tut vids. Really hope you have the opportunity to continue this top quality work.

[fernandoortiz]

Hope you continue with the videos. Thanks

[sanaullahnazir]

Your tutorials are really helpful,
Could you perhaps make more?

[aftabalamkhan]

Thanks. Very helpful video. Please upload next.

[linnhtetaung]

Where are you Miss? We miss your lectures . Please make Part III if you see our comments . :'))

[abelinogomez]

When will you continue this very informative tutorial? I love it

[umranshahid]

Dear Melrose! I have watched Part 1 and part 2. Please share other parts also

[appci]

hey, you need to continue these videos

[htlconsultores]

Where is part III?
Your tuts are GREAT!

[pmegpempowerretreat]

Accounting in excel (financial analysis) is the best for us.
Thanking You Kindly do the needful.
Please guide on project proposal/ business plan
Capital Budgeting - business chart of accounts design(report)
For report of Techno-Economically viable feasibility studies presentation.

[TamerRagheb]

That was great. waiting for next you are doing a great videos here, did you try integrating invoicing module, and Cash received from Cr Sales to it.