How Can We Help You?

Support
Video Previews

FAQs

FAQs2022-06-22T07:26:58+00:00
Can We Exchange the Purchased Products?2021-05-26T15:10:08+00:00

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.

Is this price a one time payment or recurring payment?2021-05-10T10:52:03+00:00

It is a one time payment. You can use them forever after subscription period. There is no subscription or recurring payment required.

Are there any extra charges?2021-05-10T10:47:36+00:00

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.

Which payment options are available?2022-05-09T12:31:29+00:00

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.

Can we get refunds if we do not like the Templates?2021-05-10T09:47:08+00:00

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.

How do I purchase an item?2022-06-22T07:44:49+00:00
  • 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?2022-06-22T07:38:19+00:00

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 from our <a href=”/support/”>Support Page</a>.

Sales Inquiries: sales@analysistabs.com

I purchased a product from you. I want to buy complete pack. How to upgrade to complete pack?2021-05-10T09:56:31+00:00

You can upgrade to complete pack. You can write an email to us at info@analysistabs.com

 

How do I open the downloaded zip file?2022-06-22T07:33:13+00:00

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.

When will be able to download the templates that I purchased?2022-06-16T13:58:18+00:00

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.

How long can I download my purchased template?2022-06-16T13:47:48+00:00
  •  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.
How to download files instantly?2022-06-22T07:44:37+00:00

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.

How to Unblock the Macro Enabled Files?2022-09-01T15:19:50+00:00

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
Please see the complete details here:
I purchased the template but didn’t receive an email to download product. What should I do now?2021-05-10T11:23:56+00:00

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.com
2. Please check your inbox folder in your email, Otherwise check spam folder.

How do I purchase an item?2022-06-22T07:44:49+00:00
  • 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.
How to download files instantly?2022-06-22T07:44:37+00:00

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.

How to change Currency Symbol in Data Sheets?2022-06-22T07:30:45+00:00

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.

 

 

How to Add/ Delete Records in Excel Tables2022-06-22T07:22:03+00:00

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:

 

How to Toggle Side Menu in Ultimate PM Advanced Template?2022-06-22T07:42:54+00:00

You can toggle the Side menu from Templates Settings. Please follow the below steps to hide the side menus in the worksheets.

  1. Goto Settings
  2. Goto Navigation Options
  3. Select the Navigation Type as Index(Home)
  4. 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.

 

How to Enable Calendar and Other Popup Controls in Data Sheets in Ultimate PM Advanced Template?2022-06-22T07:42:41+00:00

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.

  1. Goto Settings
  2. Goto Advanced Options
  3. Select the Popup Controls in Datasheets option as ENABLE
  4. And Apply the settings

Please see the below screen-shot for pictorial representation of the above settings:

How to Unlock the worksheets?2022-06-22T07:21:38+00:00

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.

  1. Goto Settings
  2. Goto Dashboards Options
  3. Change Protect Dashboards option as OFF
  4. And Apply the settings

 

Unhide or Hide Calculation Sheets2022-06-22T07:20:38+00:00

You can unhide the calculation sheets form settings. Please follow the below steps to hide/unhode sheets.

  1. Goto Settings
  2. Goto Navigation Options
  3. Choose Hide Calculation sheets option as  NO
  4. And Apply the settings

 

 

Alternatively, you can unhide calculation sheets as shown below:

  1. Right Click on the Sheet tabs
  2. click on the Unhide command
  3. Choose choose the sheet to unhide
  4. And press OK

Hide or Unhide Objects in Excel WorkSheet2022-06-22T07:20:20+00:00

You can Hide or Unhide Objects in Excel WorkSheet. Please follow the below steps to Hide or Unhide Objects in Excel WorkSheet.

  1. Goto Review tab from Excel menu.
  2. Unprotect sheet from protect group.
  3. Go to Page Layout from menu.
  4. Click on selection pane from Arrange group
  5. Select the object which you want to hide or unhide
  6. There is a eye icon on the right side of the object
  7. Click on the selected object eye icon to hide object
  8. ‘or

  9. Click on the selected object dash icon to Unhide object

Here is the following screen shot for your reference.
Hide or unhide Objects

How do I open the downloaded zip file?2022-06-22T07:33:13+00:00

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.

How to Unlock the Sheets?2022-06-22T07:19:28+00:00
We have locked a few sheets to avoid unwanted mistakes by chance.  You can unlock the sheets from the Review Tab in the Excel Ribbon by clicking on the Unprotect Sheet command. Here is the following screenshot for your reference.

unprotect sheet

How to Insert New Slicer2022-06-22T07:19:05+00:00

You can insert new Slicer to the PivotTable based Dashboards. Please follow the below instruction to insert new Slicer:

 

  1. Select the PivotTable to insert New Slicer
  2. Go to PivotTable Analyze Tab in the Excl Ribbon Menu and Click on Insert Slicer Command from Filter Group
  3. Choose the Required Field/Dimension from the Insert Slicer Dialog
  4. 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.

Inserting New Slicer

 

How to Unblock the Macro Enabled Files?2022-09-01T15:19:50+00:00

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
Please see the complete details here:
Can We Exchange the Purchased Products?2021-05-26T15:10:08+00:00

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.

Can we remove unused columns in the template?2021-05-14T16:43:52+00:00

Removing columns in the template effects the calculations in the template. Instead, you can hide columns.

Can we add new columns to the existing template?2021-05-14T16:41:36+00:00

You can add at the end of after last column in the table.

Can we link the data tables in other templates?2021-05-14T16:40:18+00:00

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.

Do you offer free trials of your premium templates?2021-05-10T11:13:23+00:00

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

Can I make changes to the templates?2021-05-10T10:43:51+00:00

You will have full access to the templates to make necessary changes to the templates to suit as per your requirements.

Is there a time limit to use purchased templates?2022-06-22T07:34:17+00:00

No, You can download purchased product and use them forever.

Can I use your templates on my tablet or mobile phone?2021-05-10T09:49:36+00:00

We built our templates for Desktop Use. We have not tested our templates on mobile devices or tablets.

Any installation required to use templates?2021-05-10T09:49:12+00:00

It does not required any installation.

Do any of the Excel templates contain macros?2022-06-22T07:39:47+00:00

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.

Can we change the calculations?2021-05-10T10:22:06+00:00

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.

Can we edit the Sheets?2021-05-10T10:22:17+00:00

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.

What are the file types included in this pack?2021-05-10T10:24:22+00:00

We have provide Standard Excel Files (.xlsx files), you can open them in Office 2010 and Above versions.

How to Add/ Delete Records in Excel Tables2022-06-22T07:22:03+00:00

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:

 

How to change Currency Symbol in Dashboard Worksheets?2021-05-10T10:23:20+00:00

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.

 

Is there a time limit to use purchased templates?2022-06-22T07:34:17+00:00

No, You can download purchased product and use them forever.

What type of licenses do you offer?2022-04-11T07:37:50+00:00

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:

Support: support@analysistabs.com
Sales Inquiries: sales@analysistabs.com
BLOG: ANALYSISTABS.COM

Title

Go to Top