NO. You can not exchange the products once you downloaded the files. As these are the digital downloadable products. We can not cancel / refund / exchange the product with any other products. Instead you can upgrade to the bundle product which contains the both downloaded product and new product which you wants to replace with.
It is a one time payment. You can use them forever after subscription period. There is no subscription or recurring payment required.
No, the prices that are quoted on our website are one time payment. Purchased templates you can use them forever without paying any additional amount. There is no subscription or recurring payment.
We accept payments through PayPal or by credit or debit card. Upon successful payment you will receive an email which contains a download link to download purchased product. Payments are made in U.S. Dollars. Your card details are never stored in our database.
Paying by Credit card or Debit card:
You can place your order by using your debit/card. You will be redirected to a secure 2Checkout page , Enter your card details to complete your purchase, and then returned to our website to complete your order. Currently, we accept Visa and MasterCard.
Paying by PayPal:
You can place your order by using PayPal, You will be directed to a secure PayPal page to make your payment through your PayPal account. Enter your PayPal credentials to complete your purchase, and then returned to our website to complete your order. PayPal accepts Visa, MasterCard, and American Express.
Note: Only for Indian Customers
Our current payment gateways are not accepting cards from India. Please write an email us at “info@analysistabs.com” with the following details.
Name, Billing details, GST Number if available, Email address(you will receive download links), and Contact number.
And also let us know which product you want to purchase.
Please note that we have no refund policy. Please check the product details before placing the order.
No. As these are digital downloadable files, as soon as you download our templates, you get the access to use the files. We can not revert back. We strongly recommend you to watch the previews before placing the order.
- You can add to cart an item and you will be redirected to the Checkout Page.
- You can review your order and fill the required details.
- Read the our terms and conditions and Click on the ‘Proceed to PayPal’ button to make Secure Payment using PayPal.
- You can use Credit/ Debit Cards if you don’t have PayPal Account.
My order has been expired and I cannot log in to my account. How can I download the templates again?
When the subscription period expires, the full package will not be renewed automatically. You therefore need to place an order again if you want to continue to stay connected to the latest versions of the templates. We provide a discount price for our existing customers who want to stay connected to the templates. Please write an email to use using same email which is used for the previous order to avail discount.
Reach us: info@analysistabs.org
Sales Inquiries: sales@analysistabs.com
You can upgrade to complete pack. You can write an email to us at info@analysistabs.org
We mostly put our templates in .ZIP files for faster downloads. Once you download files, save it on your personal computer. Right click on the zip file and then click on the Extract all from the available list to unzip the files.
Upon successful payment, you will receive an email with download links and complete order details to the registered email which is provided while placing the order. You can download the templates using those links provided in the email.
- You can download the files up-to 10 times within 30 days from the date of purchase. Download links (Access to the downloadable files) will expire automatically after 30 days (expiry date).
- You can download the files and save in a secured local folder. We do not grant the access to the expired orders/links.
Method 1: Upon successful payment, you will receive complete order email with download link(s). Click on download link to download files instantly.
Method 2: Up on successful payment, you will receive an email with download link, you can click on the link to download the file instantly. The delivery process of our products is completely automated.
Microsoft is blocking the Macro Enabled downloaded files by default. To remove, right-click on the file, choose Properties, and then select the Unblock checkbox on the General tab.
- Go to the folder where the file is located
- Right Click on the file and check on the Unblock.
- And Click on the Apply
Don’t Worry. Please have a check following points.
1. Make sure the payment was successful.
2. Ensured you have correct mentioned correct email while placing the order. If the email entered wrongly, Please write an email with correct email and purchase order number to info@analysistabs.org
2. Please check your inbox folder in your email, Otherwise check spam folder.
- You can add to cart an item and you will be redirected to the Checkout Page.
- You can review your order and fill the required details.
- Read the our terms and conditions and Click on the ‘Proceed to PayPal’ button to make Secure Payment using PayPal.
- You can use Credit/ Debit Cards if you don’t have PayPal Account.
Method 1: Upon successful payment, you will receive complete order email with download link(s). Click on download link to download files instantly.
Method 2: Up on successful payment, you will receive an email with download link, you can click on the link to download the file instantly. The delivery process of our products is completely automated.
You can change the currency symbols in the Data sheet using built-in formatting tools. You can select the required field to change and format it.
Let us see an example: We will change the Budget filed in Project Management sheet.
You can select the Filed Data Range and format using the Number formatting tool (You can right click and click on the Format Cells … command to view the number formatting tool.
We are creating most of our Data Entry Tables using Excel Tables (List Objects) for better management and performance. Here are the key advantages of using Excel Tables (List Objects) for our data tables:
- It is easy to manage the data, fields and records
- Easy to manage formulas, Filtering Data
- Reduce the files size
- Improves the performance
Let us learn most useful tips to deal with Excel Tables.
Adding New Records:
We have several methods to add new records in Excel Tables. Please follow the below steps to add new rows in Excel Tables:
Method 1: Using Insert Table Row … command in the Home Tab -> Cells Group
- Select a Cell in the Table
- Go to Home Tab in the ribbon menu and View the Insert commands in the Cells Group
- And Click on the Insert Table Row … Command
Method 2: Using Insert Command in the Right Click Menu
- Right Click on a Table Cell
- Click on Table Row … Command from Insert Commands
Method 3: Using Excel Shortcut Keys
We can use Excel Short cut to Insert Records. We need to select a Table Row then use the short cut key to insert new Rows:
Windows:
- Select Table Row: Use [Shift]+[Space bar]
- Insert Record: Press [Ctrl] and [+]
Mac:
- Select Table Row: Use [UP ARROW]+[Space bar]
- Insert Record: Press [^] and [I]
Deleting Records:
We have several methods to Delete records in Excel Tables. Please follow the below steps to add new rows in Excel Tables:
Method 1: Using Delete Table Rows … command in the Home Tab -> Cells Group
- Select a Cell in the Table
- Go to Home Tab in the ribbon menu and View Delete commands in the Cells Group
- And Click on the Delete Table Rows … Command
Method 2: Using Delete Command in the Right Click Menu
- Right Click on a Table Cell
- Click on Table Row … Command from Delete Commands
Method 3: Using Excel Shortcut Keys
We can use Excel Short cut to Delete Records. We need to select a Table Row then use the short cut key to Delete Rows:
Windows:
- Select Table Row: Use [Shift]+[Space bar]
- Insert Record: Press [Ctrl] and [-]
Mac:
- Select Table Row: Use [UP ARROW]+[Space bar]
- Insert Record: Press [^] and [-]
Adding / Deleting Rows in Ultimate Project Management Template -Advanced Version
We have provided easy to use interface to add/delete rows in Data Sheet Table:
These controls are disabled by default, you can enable from settings:
Now you can click on any task/milestone to add/delete records:
You can toggle the Side menu from Templates Settings. Please follow the below steps to hide the side menus in the worksheets.
- Goto Settings
- Goto Navigation Options
- Select the Navigation Type as Index(Home)
- And Apply the settings
Please see the below screen-shot for pictorial representation of the above settings:
Now , you can see the index page to navigate sheets. And Back to Mainsheet /Index sheet in all worksheets.
All Popou controls have been desabled by default. You can enable it from Settings. Please follow the below steps to enable/disable all popup controls (calenders, Task, Baseline controls) in Data sheets.
Pleasse note, Undo command will not work in the data sheets when this option is ENABLED.
- Goto Settings
- Goto Advanced Options
- Select the Popup Controls in Datasheets option as ENABLE
- And Apply the settings
Please see the below screen-shot for pictorial representation of the above settings:
We have protected the sheets with password to avoid the mistakes by chance. You can unlock the sheets using the password provided in your complete order email.
Password in your order Complete email:
Use the password to unlock sheets:
You can also unlock the dashboard sheets from the settings. Please follow the below steps to unlock the sheets.
- Goto Settings
- Goto Dashboards Options
- Change Protect Dashboards option as OFF
- And Apply the settings
You can unhide the calculation sheets form settings. Please follow the below steps to hide/unhode sheets.
- Goto Settings
- Goto Navigation Options
- Choose Hide Calculation sheets option as NO
- And Apply the settings
Alternatively, you can unhide calculation sheets as shown below:
- Right Click on the Sheet tabs
- click on the Unhide command
- Choose choose the sheet to unhide
- And press OK
You can Hide or Unhide Objects in Excel WorkSheet. Please follow the below steps to Hide or Unhide Objects in Excel WorkSheet.
- Goto Review tab from Excel menu.
- Unprotect sheet from protect group.
- Go to Page Layout from menu.
- Click on selection pane from Arrange group
- Select the object which you want to hide or unhide
- There is a eye icon on the right side of the object
- Click on the selected object eye icon to hide object
- Click on the selected object dash icon to Unhide object
‘or
Here is the following screen shot for your reference.
We mostly put our templates in .ZIP files for faster downloads. Once you download files, save it on your personal computer. Right click on the zip file and then click on the Extract all from the available list to unzip the files.
You can insert new Slicer to the PivotTable based Dashboards. Please follow the below instruction to insert new Slicer:
- Select the PivotTable to insert New Slicer
- Go to PivotTable Analyze Tab in the Excl Ribbon Menu and Click on Insert Slicer Command from Filter Group
- Choose the Required Field/Dimension from the Insert Slicer Dialog
- Now, You can see the new Slicer on Your Worksheet, You can place it at the required place in the Worksheet.
Example:
Dashboard in ‘PMD02 Project Management Dashboard – Multiple Projects’ Templates is created based on the PivotTable in the ‘Dashboard’ Sheet. You can add new Slicer to filter the dashboard based on a new Dimension.
Microsoft is blocking the Macro Enabled downloaded files by default. To remove, right-click on the file, choose Properties, and then select the Unblock checkbox on the General tab.
- Go to the folder where the file is located
- Right Click on the file and check on the Unblock.
- And Click on the Apply
NO. You can not exchange the products once you downloaded the files. As these are the digital downloadable products. We can not cancel / refund / exchange the product with any other products. Instead you can upgrade to the bundle product which contains the both downloaded product and new product which you wants to replace with.
Removing columns in the template effects the calculations in the template. Instead, you can hide columns.
You can add at the end of after last column in the table.
All templates are individual templates. There is no connection between templates and their data tables. You have to input data manually or copy from one template to another templates.
We don’t offer free trails of any premium templates. We have created video tutorials to have a look and feel of our premium templates.
Link: Video Previews
You will have full access to the templates to make necessary changes to the templates to suit as per your requirements.
No, You can download purchased product and use them forever.
We built our templates for Desktop Use. We have not tested our templates on mobile devices or tablets.
It does not required any installation.
All our templates are macro free templates except the one (Ultimate Excel Project Management Template – Advanced ) Template.
We have provided this Ultimate Excel Project Management Template with and without macros, based on the user’s request.
- Ultimate Excel Project Management Template – Standard is the Standard Excel Files (Macro free template)
- Ultimate Excel Project Management Template – Advanced is the Macro Enabled File, we have added few tools based on user’s request
Yes! You can change the calculations to modify the templates to suit your needs. We have hidden the calculation sheets, you can unhide the sheets and modify if required.
Yes! You can edit all the Sheets and Customize to suit your needs.
Please Note: There are some sheets we have protected to avoid unwanted issues by mistake. You can unlock sheets from ‘Review’ Tab and Edit the Sheets.
We have provide Standard Excel Files (.xlsx files), you can open them in Office 2010 and Above versions.
We are creating most of our Data Entry Tables using Excel Tables (List Objects) for better management and performance. Here are the key advantages of using Excel Tables (List Objects) for our data tables:
- It is easy to manage the data, fields and records
- Easy to manage formulas, Filtering Data
- Reduce the files size
- Improves the performance
Let us learn most useful tips to deal with Excel Tables.
Adding New Records:
We have several methods to add new records in Excel Tables. Please follow the below steps to add new rows in Excel Tables:
Method 1: Using Insert Table Row … command in the Home Tab -> Cells Group
- Select a Cell in the Table
- Go to Home Tab in the ribbon menu and View the Insert commands in the Cells Group
- And Click on the Insert Table Row … Command
Method 2: Using Insert Command in the Right Click Menu
- Right Click on a Table Cell
- Click on Table Row … Command from Insert Commands
Method 3: Using Excel Shortcut Keys
We can use Excel Short cut to Insert Records. We need to select a Table Row then use the short cut key to insert new Rows:
Windows:
- Select Table Row: Use [Shift]+[Space bar]
- Insert Record: Press [Ctrl] and [+]
Mac:
- Select Table Row: Use [UP ARROW]+[Space bar]
- Insert Record: Press [^] and [I]
Deleting Records:
We have several methods to Delete records in Excel Tables. Please follow the below steps to add new rows in Excel Tables:
Method 1: Using Delete Table Rows … command in the Home Tab -> Cells Group
- Select a Cell in the Table
- Go to Home Tab in the ribbon menu and View Delete commands in the Cells Group
- And Click on the Delete Table Rows … Command
Method 2: Using Delete Command in the Right Click Menu
- Right Click on a Table Cell
- Click on Table Row … Command from Delete Commands
Method 3: Using Excel Shortcut Keys
We can use Excel Short cut to Delete Records. We need to select a Table Row then use the short cut key to Delete Rows:
Windows:
- Select Table Row: Use [Shift]+[Space bar]
- Insert Record: Press [Ctrl] and [-]
Mac:
- Select Table Row: Use [UP ARROW]+[Space bar]
- Insert Record: Press [^] and [-]
Adding / Deleting Rows in Ultimate Project Management Template -Advanced Version
We have provided easy to use interface to add/delete rows in Data Sheet Table:
These controls are disabled by default, you can enable from settings:
Now you can click on any task/milestone to add/delete records:
The default currency of our PM templates fields is set to USD ($). You can change this by using built-in Excel formatting Tools. You need to format the actual range in the calculation sheets.
Let us see few examples:
Changing the currency symbol of Budget in Executive Dashboard worksheet:
We can change the currency of the Budget figure. Currency is formatted as USD by default, let us change to UK pound.
To change the currency, we need to format the actual range in the calculations sheet. In this case wee need to format the currency range in the Dashboard Calculations sheet. Go to the Executive Dashboard_Calc sheet. Un-hide the sheet if it is hidden (you can right click on the sheet tabs and unhide the sheet).
Now select the Budget value range/cell. And format the cell using built-in Currency Tools.
Alternatively, you can right click on the range and change the currency from number formatting tool:
Now, you can observe that the the currency is symbol is changed to UK Pound.
Changing the currency symbols in Project Dashboard worksheet:
Here we can see that the default currency of the Project budget, Invoiced and Remaining is in USD. We can change this currency from the calculation sheet.
Go to Project Dashboard_Calc worksheet and format the currency range using built-in tools (as explained above)
Now you can observe that the currency symbols in Project Dashboard sheets changed to UK Pound.
No, You can download purchased product and use them forever.
Analysistabs offers three types of licenses: Standard, Extended and Enterprise. Default comes with a Standard License.
1. Standard license to use the template to create end Products for yourself (Allows 1 user).
2. An Extended License gives to use the template to create end Products for yourself or for your team of 2-50 members.
3. An Enterprise License gives to to use the template to create end Products for yourself or for your team members.
Here is the License Agreement
Click here to see premium templates all license details: Premium Templates All Licenses
We (NIRUKA TECHNOLOGIES LLP) know our work is about starting the conversations that matter to you and your business. If you have any queries or If you’d like to find out how we can help, please email us:
Sales/Support Inquiries: info@analysistabs.org
BLOG: ANALYSISTABS.COM