Overview

Hi,

This spreadsheet is consisted of the following 11 (eleven) worksheets:

1 - Cover

2 - Chart

3 - Rates

4 - Assumptions

5 - Set_Up_Process

6 - Suppliers

7 - Products

8 - Customers

9 - Transactions

10 - Cash

11 - Reports

 

  • Chart sheet gives you brief information about Sausage Casings Types.

 

  • Rates worksheet gets daily rates using Power Query. Depending on National Bank of Azerbaijan's web site, user must manually enter date in source step of Power Query to refresh the rates.  Please look at attached photo.
    You may find assumptions in the assumptions worksheet
  • Chart of Setup Process step by step can be found in the form of Organizational Chart in Set_Up_Process worksheet
  • Casings Suppliers with their contact information in Suppliers Worksheet
  • Products information in Products Worksheet
  • Customers in Azerbaijan in Customers Worksheet
  • Import, Sale, Return Transactions are done in Transactions Worksheet.
  • Cash based transactions can be found in Cash Worksheet
  • Three reports (Suppliers Based, Customers Based and Products Based) are shown in Reports Worksheet.

    Unique drop-down lists like Investors, Customers, Suppliers gathered using Power Query.  Some excel functions including Sumifs, Xlookup, If, etc. used in this spreadsheet.
    Wish you good luck in your business.

Reviews Add a review
Qafur

I found this template very useful. It can be used for small-size companies to follow and control their inventory.
However, some points are subject to improvement.

More From Ilgar Zarbaliyev

Browse our top rated business templates. See All
Row, Column, Index, Match, Offset Functions. Excel Tutorial
1,869
213
 “It's Excel's world, we just live in it.” “To be an accountant in the age of spreadsheet program is —…
New Dynamic Functions. Excel Tutorial
1,716
188
In September, 2018, we released dynamic array formulas for Excel for Microsoft 365. The differences between dynamic arrays and legacy…
Fill Series. Data Validation. Excel Tutorial
1,755
178
 If you have inherited workbooks from someone else or if you have imported data from external data sources, you have…
HR INSIGHTS DASHBOARD
4,650
129
 This report includes the necessary analyzes according to some characteristics of the people who made and participated in the job…
Supplier_Insights
4,771
113
 Hello, This report is consisted of four pages. 1-Supplier Quality Metrics 2-Supplier Quality Regional 3-Top - Bottom Analysis 4-Downtime Analysis…
Sales_Analysis_Reportin Power BI
5,141
180
Hello, After participating in Enterprise DNA programs, I prepared reports on three topics in Power BI. The first report I…
See All