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!

• #people_blogs
• #excel
• #indexmatchfunction
• #accountingcycle
• #datavalidation
• #specialized_journal