In the previous article "Sharing practical Excel skills: Quickly create two-color charts", we learned an Excel skill and learned how to quickly create two-color charts. The following article will introduce to you how to use Excel Pivot Table and VLOOKUP function to analyze accounts receivable. Come and collect it and learn it!
Summary of content: Excel accounts receivable aging analysis will use pivot tables for analysis. Before analysis, use the VLOOKUP function to organize the data.
Aging refers to the length of time a company has outstanding accounts receivable. Aging is the most important information when analyzing accounts receivable. All accounts receivable that are aged more than a reasonable number of days will have a negative impact on company operations. The higher the age, the lower the capital efficiency and the risk of bad debts. The bigger it is, the higher the financial cost.
The following is the accounts receivable table. Now the leader requires us to count the amounts of each aging level (accounts receivable aging analysis).
Final effect:
##Solution:
1. First solve the number of days that have passed so far: the formula in cell C2 is: =TODAY()-A2, the current date minus the receivable date.
The above is the detailed content of Practical Excel skills sharing: Use pivot tables and VLOOKUP functions to analyze accounts receivable. For more information, please follow other related articles on the PHP Chinese website!
