Video

Thank you for showing interest in our template. Following is the template download link for quick reference: indzara.com/free-excel-template-for-recruitment-tracker/ Best wishes.

Thank you for showing interest in our template. We can add helper columns to convert the currency to a single currency. For example We can add two new columns. 1 - Transaction Amount 2. Conversion rate In the existing transaction amount column, you can enter a formula that multiplies transaction amount with conversion rate. Best wishes.

@@indzara Thank you for you quick reply.

Thank you for watching our video and sharing your valuable feedback. We regret the inconvenience caused. 1. You need to ensure you are selecting from cell B5 and the cell B5 has formulas. 2. Then you need to enter edit mode by pressing F2 key (Some keyboards required Fn key + F2 Key) 3. Then you need to press CTRL+Enter. You can also use CTRL+D and CTR+R separately after selecting the cell range B5 to H10 to duplicate the formula present in cell B5. Best wishes.

Thank you for showing interest in our template and sharing your valuable feedback. Currently, the template is designed to show one ticker symbol at a time. The chart is populated from the data present in the hidden sheet. We have premium version of Stock Screener template where you can get 25 technical indicators signal and value for multiple ticker symbols: indzara.com/product/stock-market-excel-templates/stock-screener-excel-template/ Best wishes.

Yes, we can use a Macro to automatically change the ticker symbol from the list in the template to get the RSI value and update it in the symbols table. We have done the same in our premium version of the technical indicator template that provides 25 technical indicator values along with RSI. Following is the link to the template for quick reference: indzara.com/product/stock-market-excel-templates/stock-screener-excel-template/ Best wishes.

Thank you for showing interest in our template. Adding additional stage involves lot of steps and formula level changes. We can take it as a customization project for a fee. Please reach out to us at the below link for estimation: support.indzara.com/support/tickets/new Best wishes.

Thank you for sharing your requirement. No, we use Excel stock datatype to get stock data from Microsoft Database and currently Option trading data such as option chains, strike prices, expiration dates, implied volatility, or other specific options metrics are not available with Microsoft Stock Datatype. Best wishes.

@@indzara thanks can you specific strike ATM the last 5 minuets

@@openmindjustdoit1306 No, currently we do not have the dataset to calculate and get the last 5 minutes strike ATM. We take customization projects for a fee. If you have the dataset, please share the same at the below link for estimation: support.indzara.com/support/tickets/new Best wishes.

I’m glad you found it helpful. Thanks for the kind words. It means a lot to hear that. Best wishes.

You are welcome. We are glad our video was helpful. Best wishes.

No, currently we are not available in TikTok platform. Best wishes.

@@indzara ok i found the channel that i have question about on youtube i will put the link below My question do you think he make the chart on excel or maybe he just use trading tool? czcams.com/video/Yxcb0TsSjZI/video.htmlsi=KnGHWhfjYpLSP58P

Thank you for sharing your valuable feedback. You are welcome. Best wishes.

You are welcome. Best wishes.

Thank you. The template works for all exchanges supported by Microsoft including NSE. If there are any issues, please let us know and we will be happy to address. Best wishes.

my order sheet doesn't work properly, it seems that doesn't recognize other tabs, what should I do?

Thank you for showing interest in our template. We regret the inconvenience caused. I am unable to replicate an issue on the orders page from my end. Hence, please share your copy of the template with sample data and some screenshots highlighting your concern at the below link to replicate check further from our end: support.indzara.com/support/tickets/new Best wishes.

Thank you for showing interest in our template. Yes our premium version of the template will have option to generate a invoice from the orders sheet. You can change the title invoice to quotation to print it as a quotation. Following is the link to the template for quick reference: indzara.com/product/inventory-management-excel-templates/rental-inventory-sales-manager-excel-template/ Best wishes.

@@indzara thank you, Does this usable on cellphone?

@@Frsz-Sifiso_Xulu Yes, we use simple excel formulas to populate the reports, hence it will be functional on Mobile Phone Excel applications as well. You can also upload the template to Microsoft OneDrive and use the template from Mobile or any Browser. Best wishes.

Thank you for purchasing the template. Following support article contains the details on how the Retention Rate and Turnover rate is calculated in our Template: support.indzara.com/support/solutions/articles/62000214232-how-the-retention-rate-and-the-turnover-rate-is-calculated-on-the-retention-dashboard- Best wishes.

Thank you for showing interest in our template and sharing your valuable feedback. Please share your copy of the template with sample data and some screenshots highlighting your concern at the below link and we will be glad to assist you: support.indzara.com/support/tickets/new Best wishes.

Thank you for sharing your requirements. We have made a note of your requirements and will update you when we create a video solving your requirements. In the meantime, we have multiple stock market template that supports NSE. You will have full access to the template. The password to unprotect the sheet is indzara. Following is the link to the template for quick reference: indzara.com/stock-market-excel-templates/ Best wishes.

@@indzara czcams.com/video/5svR6e97OCQ/video.htmlsi=rTf5dUWaXtMUA-pD pls make a detailed video help of this idea

Thank you for sharing your valuable feedback. Best wishes.

@@indzara Thanks

Thank you for showing interest in our template. Currently, we do not have a tutorial video on how to build the template. We will update you once we release a tutorial video on how to build the template. In the mean time you can also purchase the template at the below link and go through the calculations. You will have full access to the template on purchasing the template: indzara.com/product/small-business-excel-templates/sales-pipeline-manager-excel-template/ Best wishes.

If you are referring to event links, you will need to use HYPERLINK function to pas the event values in a different cell. If this is not your query, please share more details about your query to assist further. Best wishes.

Thank you for showing interest in our template. If you do not have Excel 365 subscription, you can use our Google Sheets version of the template. Following is the link to the template for quick reference: indzara.com/stock-portfolio-tracker-google-sheets-template/ Note: Make a copy of the template to your Google Drive to gain Edit access. Best wishes.

We regret the inconvenience caused. The template requires an Excel 365 subscription to get the stock data from Microsoft Server. If you do not have an Excel 365 subscription, you can use our Google Sheets version of the template available at the below link: indzara.com/stock-portfolio-tracker-google-sheets-template/ Best wishes.

Thank you for showing interest in our template. We are glad that you like our template. You are welcome. Best wishes.

Yes, you are correct. Thank you very much for your valuable feedback and input shared. We have noted it down and we will update the description in the next version of the template.

Thank you for showing interest in our template. We are glad our template was useful. You are welcome. Best wishes.

Thank you for reaching out to us. The following are the steps to solve your requirements. 1. Create 2 sheets, 1 HELP and another sheet named DATA 2. The DATA Sheet has Data Table with Column A Branch, Column B Score %, Column C has Score % converted to a number and rounded to 1 digit decimal (=ROUND([@[Score %]]*100,1)), Column D Rank 3. In the HELP sheet, paste the below formula on the respective cells: On Cell A1 =ROUND(LET(min, MIN(DATA!$C$2:$C$15), SEQUENCE((97 - min)*10,,min,0.1)),1) On cell B1: =ROUND(SEQUENCE(COUNTA(A1#),,1,2/(COUNTA(A1#))),1) On cell C1: =ROUND(SEQUENCE(15,,97,0.1),1) On cell D1: =ROUND(SEQUENCE(15,,3,1/16),1) On cell E1: =ROUND(SEQUENCE((MAX(DATA!$C$2:$C$15)-98.5)*10+1,,98.5,0.1),1) On cell F1: =ROUND(SEQUENCE(COUNTA(E1#),,4,1/(COUNTA(E1#)-1)),1) On cell G1: =VSTACK(A1#,C1#,E1#) On cell H1: =VSTACK(B1#,D1#,F1#) 4. After this rank column D in the DATA sheet: =XLOOKUP([@Score],HELP!$G$1#,HELP!$H$1#,"") The minimum score will have rank 1 and the max score will have rank 5 with the mentioned condition. Hope this answers your requirements. Best wishes.

Thank you for showing interest in our template. You will have access to modify the settings sheet as per your company policy on our free templates. If you are facing any difficulties, please write to us at the below link and we will be glad to assist you: support.indzara.com/support/tickets/new Best wishes.

Following is the direct download link to the template file: indzara.com/wp-content/uploads/2016/08/Rental_Inventory_Tracker_V1.xlsx You will have full access to the template to explore the formulas used. The password to unprotect the sheet is indzara. Best wishes.

Thank you for showing interest in our template. Currently, we do not have a tutorial video on how to build the template. We will update you when we release tutorial videos. You can download the template from the below link: indzara.com/free-excel-template-for-rental-business-inventory/ Best wishes.

Thanks for downloading. Please email file or screenshots to us at support@indzara.com. we will review and get back to you as soon as possible. Thanks.

Our step by step guide is available here support.indzara.com/support/solutions/articles/62000152528-employee-retention-dashboard-excel-step-by-step-user-guide

@@indzara hello I submitted ticket through the website with the spreadsheet attached

Thanks. I have replied to the email. The reason is the 'date columns' which should be in date format that Excel expects. Otherwise, Excel treats it as text and all the calculations do not work as intended. Please review and let us know if any questions. Thanks. Best wishes.

You are welcome. Thank you for sharing your valuable feedback. We are glad that our video was helpful. Best wishes.

If you are referring to a chart, we will have three columns, 1 for neutral, 1 for 52 wk high and 1 for 52 wk low. When the price hits any of the mark, we will mark other two as NA in the formula. If you are referring to highlighting the value with the color, we use conditional formatting with a helper column that indicates, its neutral or 52wk high or 52 wk low. You can reach us with sample data at the below link to assist further: support.indzara.com/support/tickets/new Best wishes.

Thank you for sharing your valuable feedback. You are welcome. Best wishes.

Thank you for showing interest in our template. Yes, our premium version of the template has the requested feature. Following is the link to the same for quick reference: indzara.com/product/inventory-management-excel-templates/manufacturing-inventory-sales-manager-excel-template/ Best wishes.

You are welcome. We are glad that our video was helpful. Thank you for sharing your valuable feedback. Best wishes.

You are welcome. Thank you for sharing your valuable feedback. Currently, different series of data cannot be added to the chart dynamically. Hence it has to be manually done for 50 different categories. However the same could be possible using Macros but currently we do not have a ready-made solution for the same. Best wishes.

Thank you for showing interest in our template. You can purchase the template from the below link: indzara.com/product/hr-templates/retention-dashboard/ Best wishes.

Thank you. Please send sample data to support@indzara.com. We can provide a video solution. Thanks. Best wishes.

Thank you for sharing your valuable feedback. Best wishes.

I am glad that our video was useful. If the skill and training data is already available in the database we can use power query to import the data directly to Power BI or Excel. So that you do not have to enter data manually into the template. We take customization projects for a fee. You can reach out to us at the below link for free estimation: support.indzara.com/support/tickets/new Best wishes.

Daily average volume typically calculated over a period such as 30 days, 50 days, 90 days, or 200 days. For example, the 30-day average volume is the average daily volume over the past 30 trading days. Best wishes.

Currently, we have Kanban board incorporated with our Task Manager template. We have not yet integrated with Sales Pipeline Manager template. Following is the link to the templates for quick reference: 1. Free Kanban Board Template: indzara.com/kanban-board-task-tracker-excel-template/ 2. Task Manager Premium template with Kanban Board: indzara.com/product/project-management-excel-templates/task-manager-advanced/ Best wishes.

Thank you for showing interest in our template and sharing your valuable feedback. You can purchase the template from the below link and we also have Excel and Google Sheets version of the template available. You can look at the Excel and Google Sheet version of the template from the same link: indzara.com/product/hr-templates/performance-dashboard-power-bi-template/ But currently, we do not have a tutorial videos on developing Power BI templates. We will update you once we publish new videos on Power BI. Best wishes.

In excel, you can enter Russell and select Stock Datatype from Data ribbon to get the list of Russell stock ETF ticker symbols. You can select the appropriate ticker symbol to get the data. If this is not your concern, please share more details about your concern at the below link to assist further: support.indzara.com/support/tickets/new Best wishes.

I want the index data. The etf data is not matching the index returns and my indicators dont signal when etf are used. I saw that you had index data on your spreadsheet but i am now assuming you were usin

We regret the inconvenience caused. Can you share some screenshots highlighting your concern at the below link to check further from our end? support.indzara.com/support/tickets/new Best wishes.

Thank you for sharing your valuable feedback. Best wishes.

Thank you for showing interest in our template. You can download the Excel template for free of cost from the below link: indzara.com/free-excel-template-for-rsi-technical-indicator/ We also take customization projects for a fee. You can write to us at the below link for free estimation: support.indzara.com/support/tickets/new Best wishes.

Thank you for reaching out to us. You can write to us at the below link and we will get back to you within 1 business days: support.indzara.com/support/tickets/new Best wishes.