Here you can download Excel and Google Sheets practice workbook files to follow along with YouTube video tutorial. To download the file simply click on the workbook name below. To watch the video tutorial, click on the button next to “watch now”.
Note: The workbooks that contain macro codes (Macro – Enabled Workbook) will be downloaded in compressed zip folder and are in macro blocked state. Before using these files, you have to unzip and unblock the file. See below video guideline to learn how to do it.
Above video guideline is not applicable in case of normal (macro – free) workbooks.
- Stock In Out and Balance Tracker with Auto Reorder Suggestion Watch Now📺
- Calculate SUM of Values from Every Alternative Cells Watch Now 📺
- SUMPRODUCT Function in Excel Watch Now 📺
- Dynamic To Do List or Task Tracker Watch Now 📺
- Goal Seek in Excel Watch Now 📺
- Auto Calculate L3M Average (AVERAGE + OFFSET + COUNTA) Watch Now 📺
- VLOOKUP Exact Match Function Watch Now 📺
- Dependent Drop-Down List in Excel Watch Now 📺
- Stock In Out Balance Tracking Template Watch Now 📺
- Advance Search Bar in Excel (All Column Search) Watch Now 📺
- Convert Numeric Currency Value to Word Watch Now 📺
- Calculate Average of Numbers from Every Alternative Cells Watch Now 📺
- Conditional Counting in Filtered Data Watch Now 📺
- Single and Double XLOOKUP Function in Excel Watch Now 📺
- SUMIF Function Tutorial Watch Now 📺
- SUMIFS Function in Excel Watch Now 📺
- Automatic Allocation of Payment to Invoice Watch Now 📺
- VLOOKUP and MATCH Combination Watch Now 📺
- Calculate SUM of Numbers from Every N Sequence of Columns Watch Now 📺
- Calculate SUM of Values from Every N Sequence of Rows Watch Now 📺
- GROUPBY Function Tutorial Watch Now 📺
- 9 SUM Functions in Excel Watch Now 📺
- LAMBDA Function Tutorial in Excel Watch Now 📺
- Make Loan Amortization Table in Excel Watch Now 📺
- Index and MATCH Function in Excel Watch Now 📺
- Auto Highlight Active Cell’s Row and Column in Excel Watch Now 📺
- Auto Highlight Row Based on Cell Value in Excel Watch Now 📺
- Automatic Purchase Order Generation in Excel Watch Now 📺
- PIVOT Table Tutorial in Excel Watch Now 📺
- Automatic Invoicing Software in Excel Watch Now 📺
- Auto Expiry Date Alert System in Excel Watch Now 📺
- Calculate Sales Team Incentive in Excel Watch Now 📺
- Conditional Formatting in Excel Watch Now 📺
- Aging and Outstanding Report in Excel Watch Now 📺
- IF and AND Function Combination in Excel Watch Now 📺
- Auto Highlight Active Cell in Excel Watch Now 📺
- Calculate Time Worked and Total Wage in Excel Watch Now 📺
- Make the Dynamic Chart in Excel Watch Now 📺
- Solve the LPP Equation in Excel Watch Now 📺
- Employee Attendance Tracker Sheet with Checkbox Watch Now 📺
- Customer Invoice and Payment Tracker Template in Excel Watch Now 📺
- COUNTIF and COUNTIFS Function Tutorial Watch Now 📺
- Paste Special Tool in Excel Watch Now 📺
- Auto Highlight MIN and MAX Values Watch Now 📺
- Calculate Full Age in Year Month and Days Format Watch Now 📺
- How to Make Gantt Chart in Excel Watch Now 📺
- Sales Data Analysis in Excel Watch Now 📺
- VLOOKUP and COLUMNS Function Combination Watch Now 📺
- HLOOKUP Function Tutorial Watch Now 📺
- HLOOKUP and MATCH Function Combination Watch Now 📺
- Conditional Formatting in Data Label of Charts Watch Now 📺
- Reorder Level (ROL) Calculation in Excel Watch Now 📺
- Make Speedometer Chart in Excel Watch Now 📺
- Find Out the Most Repeated Item in a List Watch Now 📺
- How to Calculate Standard Deviation and Coefficient of Variation in Excel Watch Now 📺
- Calculate Value of Order Quotation in Excel Watch Now 📺
- Calculate Order Value Based on Multiple Pricing Watch Now 📺
- Make Running Analog Clock in Excel Watch Now 📺
- Employee Performance Review Dashboard Watch Now 📺
- Make Scrollable Table in Excel Watch Now 📺
- 8 New Excel Functions Watch Now 📺
- Make Scrollable Table in Excel V.2 (With Auto Fetch New Data) Watch Now 📺
- Using Slicers to Filter the Data Watch Now 📺
- Make Monthly Product Wise Sales Report in Excel Watch Now 📺
- Sales Analysis Multi Criteria with SUMIFS Function Watch Now 📺
- VLOOKUP vs HLOOKUP Function Watch Now 📺
- PIVOTBY Function in Excel Watch Now 📺
- VBA and Macro Tutorial Watch Now 📺
- Do Calculations in the Filtered Data in Excel Watch Now 📺
- VLOOKUP Approximate Match with 2 Examples Watch Now📺
- Aggregate Function in Excel Watch Now 📺
- Error Handling in XLOOKUP function Watch Now 📺
- Rand, Randbetween and Randarray Function Watch Now 📺
- REGEXTEST Function in Excel Watch Now 📺
- Male – Female Infographics in Excel Watch Now 📺
- Sort Data in Custom Order Watch Now 📺
- IF Function in Excel Watch Now 📺
where can i download the file ?
Click on the file name from the list to download it.
Just click on the file name.
Could you please write out the file name from the list? I looked for stock in out balance and re order, but could not find it from the list.
Thank you for your time.
It should be the first one. Number 1
Reference video – https://www.youtube.com/watch?v=mqF7-qhan9M
Very informative video and simple to understand.
I’m looking excel formula for below listed scenario.
It’d be great if both the below scenarios can be coupled in a single formula
Scenario 1:
Payments are partially paid on different dates against an invoice.
Is there an excel formula or Macros to allocate paid date and paid amount to an Invoice.
Scenario 2:
Multiple Payments are made on different dates against multiple invoices.
Is there an excel formula or Macros to allocate paid date and paid amount to multiple Invoices.
Minimum Stock report for Finished Goods