Create Rich Visualized and Interactive Dashboards for Analyzing Your Data

ANALYSISTABS is a FREE Excel Add-in for Data Analysis and Dashboard Creation, Power-Packed with Innovative Utilities. Our objective of developing ANALYSISTABS Add-in is to help you to quickly create rich visualized Dashboards, Reports, Charts and Tools to fasten your tasks. And we provide practical examples and real time dashboards to make you Awesome in Analytics and its relevant tools (such as MS Excel, SQL, SAS…).




50+ Project Management Templates Pack
Excel PowerPoint Word


Advanced Project Plan & Portfolio Template
Excel Template


Ultimate Project Management Template
Excel Template


20+ Excel Project Management Pack
Excel Templates


20+ PowerPoint Project Management Pack
PowerPoint Templates


10+ MS Word Project Management Pack
Word Templates


analysistsbas V5



ANALYSISTABS is absolutely a FREE Excel® Add-in with no executable files. You can download and install easily on any computer, at office or home.

Download Addin & Demo File

Download ANALYSISTABS Add-in for Excel 2007/2010/2013.

////Sorry! Currently not available for download!

We are re working on the add-in and planning to release in September 2016. Thanks for your support!

Download Example Dashboard created using ANALYSISTABS

////Sorry! Currently not available for download!

We are re working on the add-in and will be available in couple of weeks. Thanks for your support!

Example Dashboard is prepared using Excel 2010, Install our add-in and then open this example dashboard to check the add-in functionality.

  Terms of UsePrivacy Policy


Please leave your comment or feedback or ask any questions and post issues related to Our Add-in here.

Workbook Optimizer

Now you can test your Excel Workbooks and create optimized workbook. Now your Excel File size will be minimal with Workbook Optimizer and Suggestions. Many of our friends have been requesting me something like this from last two years. And I thought, it will be useful to every one to build optimized Workbooks.

Excel Workbook Optimizer

Dashboard Builder

Create interactive dashboards in just few minutes with no knowledge of VBA. Dashboard builder is provided for creating rich visualized dashboards.

It will help you to create summarized Pivot table with linked chart. You can select desired table and set as a data source. There are three options provided to set a data filter, set row labels, to set data values with chart option.

You can choose from the different chart options and chart axes. And you can also set the units to display in the chart and summary table.

analysistabs Dashboard creator

Slider Creator

Can you believe this! Now you can create beautiful sliders in Excel Worksheets. Sliders help you to present your data from different worksheets of the workbook in one place without duplicating or copying the data. Our Slider creator is very powerful and easy to create sliders with One Single Click. We have provided option to show Excerpts. And comes with a slideshow option and navigation option. Give a try, you will definitely like this idea.

analysistabs Slider creator

Widget Creator

Make your Worksheet look like a webpage. Our Widget Creating Utility helps you to create beautiful Widgets in any where in your Worksheets.

It is very useful for showing insights or message to the user while presenting the dashboards in executive meetings. It is very useful to show more information in less screen-space.

User can expand or collapse one or all Widgets in the worksheet. You can customize the look and feel of Widget by using built-in formatting tools in Excel. Give a try, you will like this idea too.

analysistabs Widget creator

TOC Creator

TOC (Table of Contents) helps users to navigate form Index worksheet to any other worksheet in workbook. Now you can create a Table of Contents with our TOC Creator with a button click.

We have provided many options to customize the look and feel of TOC. And you can provide back to Index page from each worksheet. And you can also choose the range for back link.

analysistabs TOC creator

Export to PowerPoint

Presenting the data is crucial after performing the data analysis. Export to PPT utility will help you to qickly export all charts in a worksheet or workbook to PowerPoint Presentation. We will add many more options to customize the export options.

analysistabs Export PPT

List Files and Folders

You can check your folders quickly for a particular type of file using List Files and Folders utility. It will populate complete information about the files and folder. It will be easy to analyse your files and folders using this tool.

analysistabs List Files and Folders

Many More Tools and Knowledge Base

There are many other useful tools to deal with your workbooks and worksheet. And Knowledge Base is created to help you to learn Data Analysis Concepts and its relevant tools to deal with your data. There are many tutorials in our blog and you can directly access our blog and tutorials from ANALYSISTABS add-in.

And many more utilities and functions

I will keep on working on this tool to add more and more utilities to best suit daily excel user needs. You can directly update our tool with single button click.

Advanced Project Plan Excel Template

Related Resource External VBA Reference


  1. jamilm July 8, 2013 at 4:02 PM - Reply

    Hi, This Add-in is not available. the download link is broken. can you fix it?

    • PNRao July 8, 2013 at 10:48 PM - Reply

      Sorry -I am fixing few issues and this will be available soon.

  2. PNRao August 1, 2013 at 4:39 AM - Reply

    Hi All,

    Version 2.0.0 is released today. You can install the latest version and let me know your feedback


  3. Chitanya August 18, 2013 at 10:40 AM - Reply


    Addin! is Awesome. Looking for more AddIn’s.


    • PNRao August 18, 2013 at 12:34 PM - Reply

      Thank You! – PNRao

    • Jeannette Blignaut August 20, 2015 at 5:00 PM - Reply

      I would really appreciate it if anyone has a copy of the old AnalysisTabs exe – I had it and unfortunately my PC crashed and never had a backup. I would really like to use the old version while the new version is still not available for download.

  4. Neel August 20, 2013 at 7:21 PM - Reply

    Cool, I like the approach. Thanks for giving a stunning dashboard creator!


  5. PNRao September 1, 2013 at 10:07 AM - Reply

    Thank You Neel!

  6. joe November 10, 2013 at 8:04 AM - Reply

    Absolutely excellent VBA Excel website I’ve ever seen!!!

    This page has one repeating word:

    rich visualized Dashboards, Reports, Charts and and simplify and fasten your tasks

    • PNRao November 10, 2013 at 11:10 AM - Reply

      Thanks Joe, changed it!


  7. joe November 16, 2013 at 7:52 AM - Reply

    I installed the Add-in today. It is a great add-in.
    Only few broken links: Error 404 – Not Found, if click on BLOG, and the first two links in Tutorials.
    Thank you.

    • PNRao November 16, 2013 at 1:02 PM - Reply

      Hi Joe,

      Thanks for trying our Excel Add-in.
      Yes, I changed lot of things in website. Tutorials and Blog links may not rout to the correct page. I am working on few more things and releasing with the next version very soon.


  8. Nick January 25, 2014 at 12:55 AM - Reply

    when I try to open it says there is an error (compile error in hidden module: moupdate)

    • PNRao January 27, 2014 at 11:05 PM - Reply

      Could you please let me know your operating system and MS office version installed in your system. so that I will test and fix it.


  9. Tom February 26, 2014 at 11:57 PM - Reply

    I am using Win 8.1 with Excel 2010 64bit and I get an error.
    “Compile error in hidden module: modUpdate…..”
    Looks like the same error as Nick is having…

    Would love to try this add-in, but can’t get it to work.


    • PNRao February 26, 2014 at 11:59 PM - Reply

      Hi Tom,
      I think it is having problem with Windows8+64bit. I will fix it and release as soon as possible.

  10. Chance May 15, 2014 at 2:08 PM - Reply

    Your program generates an error when trying to install in excel 2013 64bit.. The error says it can not compile your code in my excel version!

  11. Butch Barker June 28, 2014 at 9:55 PM - Reply

    What happened to fixing the addin for win 8.1

    • PNRao June 28, 2014 at 10:45 PM - Reply

      Hi Butch Barker, I am planning to release the next version by 1st August with few more useful tools.


      • Butch BArker September 5, 2014 at 8:49 AM - Reply

        its September first, when will it be ready?

  12. Krishna July 1, 2014 at 8:12 AM - Reply

    Please tell me how to use your dashboard application…it is not working

  13. Sebastian July 23, 2014 at 8:19 PM - Reply

    Hi, I have Win7 and Excel 2010 in Spanish. Could that be the reason why this add-in is not working for me?

    • PNRao July 23, 2014 at 10:32 PM - Reply

      Hi Sebastian,
      That should not be the case, I am updating the add-in and releasing in couple of weeks. Hopefully, the updated version works for you.


      • Sebastian July 24, 2014 at 9:43 PM - Reply

        Thank you!

      • Sebastian July 24, 2014 at 9:46 PM - Reply

        For further info, the error is: “Compile error in hidden module: modUpdate. This error commonly occurs when code is incompatible with the version, platform, or architecture of this application.”. Regards.

        • PNRao July 25, 2014 at 3:28 AM - Reply

          Thank you Sebastian – I will make sure to test in all version before releasing the next versions.


  14. VK August 23, 2014 at 6:26 PM - Reply

    I stumbled upon your website while googling for Excel VBA. When I explored your website i couldn’t leave before commenting and appreciating your work here. This add-in is awesome. Tools you have given in there is totally worth it. Dashboard creator is superb. I am curious to know the code behind it after using the add-in. (Magicians don’t reveal thier tricks, I know! :D) May be i can learn that in your online course on VBA.
    Again want to thank you for awesome content and information here. Keep up the good work. Hope will see more great stuff from you.

  15. Ken August 25, 2014 at 1:20 AM - Reply

    I am anxious to try the Excel add-in, but it will not download. I have tried removing popup blockers, IE, Chrome and Fire Fox. Still no luck. Is the link broken?
    The demo’s download fine.

  16. Ken August 25, 2014 at 5:55 PM - Reply

    I believe the download ling to Analysistabs is not working. I have no popup blockers and tried IE, Chrome and Firefox and none work. The demo downloads do work.
    Can you assist?

  17. Katie September 2, 2014 at 6:55 AM - Reply

    I just downloaded the free add-in. I have Microsoft 2010 on a Macbook Pro. I can’t seem to figure out how to get the tab to show up in my excel worksheets. The download was successful, but there nothing happened after I clicked on the download.


  18. BUtch BArker September 4, 2014 at 11:01 AM - Reply

    this still does not work in windows 8.1 64 bit

  19. Fred September 10, 2014 at 11:41 PM - Reply

    have you been able to get it to work under Windows 8.1 and 64 bit excel (2010). I downloaded but get the error

    If you have been able to get it to operate in this environment please let me know where it can be downloaded. Thanks. Looks to be an awesome add in.

    • PNRao September 11, 2014 at 8:24 PM - Reply

      Hi Fred,

      Still working on the issue, may take couple of weeks.

      I have tested on my PC with Windows 8.1 and its working fine. But when I check it on my friends PC, it is not working.

      I am still working on it and update you soon.


  20. Laura September 18, 2014 at 7:46 PM - Reply

    Love this add-in, but when I close Excel it disappears and I have to download again. Why?

    • Rakesh October 7, 2014 at 11:38 AM - Reply

      place your addin on following path then problem will solved.

  21. Rakesh October 7, 2014 at 11:35 AM - Reply

    Dear Rao,

    Could you please guide me to how to use Dashboard Builder? How does it work?


  22. VIJAYKUMAR November 1, 2014 at 9:31 PM - Reply

    Iam using Excel 2013 64-Bit Version.The addin and related Macros are not working. The error is “Compile error in hidden module: modUpdate. The PtrSafe function should be used whenever Functions are declared to make them compatible with 32 and 64 Bit Excel 2010 and 2013 Versions.Hope you correct the code and provide the fresh add-in for everyone’s use and benefit.

    Thanks a ton for all the knowledge sharing.

  23. Mihir Mehta December 31, 2014 at 2:47 PM - Reply

    Hi PNRao,

    I am using Excel 2013 on Windows 8.1 64-bit and as has been mentioned above, the add-in shows a compile error. Since it is a protected module, there is no way for me to change the VBA code as well.

    Could you kindly fix this problem by any chance?

    Highly appreciate your effort!

  24. Yvonne January 7, 2015 at 1:10 AM - Reply

    I don’t have a clue how to use it. I keep trying to type in the fields and nothing works – beautiful demo – but how do I get the add-in to work for ME?

    • PNRao January 12, 2015 at 9:27 PM - Reply

      Hi Yvonne,

      Sorry for that, we are working on next version and we will provide a video tutorial while releasing the next version.


  25. Subrahmanyam January 21, 2015 at 8:14 AM - Reply

    I am using MS Office 2007 and I am anxious to try the Excel add-in, but it will not download. I have tried removing popup blockers, IE, Chrome and Fire Fox. Still no luck. Is the link broken?
    The demo’s download fine.

    • PNRao January 23, 2015 at 10:49 AM - Reply

      Hi Subrahmanyam,

      Add-in will be available by 25th for downloading.


  26. Engineer February 1, 2015 at 5:30 PM - Reply

    Excel 2013 – 64 bits. Compile error in hidden module: modUpdate.
    Regards !

    • PNRao February 3, 2015 at 10:15 PM - Reply


      Could you please download the latest version and try one more time.


      • Engineer February 7, 2015 at 4:40 PM - Reply

        The same error: “Compile error in hidden module: modUpdate. This error usually occurs when the code is incompatible with the version, platform or architecture of this application.”
        I look forward to using this addin. Thanks!

  27. Mike February 4, 2015 at 5:02 AM - Reply

    I keep getting an error while trying to run the Excel add-in “Microsoft Excel: Cannot run the macro ‘asbPnraoCreateDashboard’. The macro may not be available in this workbook or all macros may be disabled” I tried to enable them but still get the same error

  28. Raman Goel February 11, 2015 at 11:42 PM - Reply

    Thanks Buddy,
    Analysis Tab is awesome, however it is not resolving my purpose completely. The tab is pulling the file names from the folder but I still need to check the names manually to find if anything missing.
    We save some same set of files each day in particular folder, so what I am asking is if we will save one template with all the file names and run this macro, then through formula is it possible to check if file exist or not and will revert with “Yes” or “No” then it will be great.
    I am not very good at excel so it is difficult for me to frame the formula. Can you please assist me if possible?
    Raman Goel

  29. Sadhana February 18, 2015 at 8:53 PM - Reply

    Hi, I really liked your add-in. I appreciate your hard work. Keep it up.

  30. BobN February 21, 2015 at 1:00 AM - Reply

    I’ve downloaded Analysistabs. I figured out how to keep it installed. But so far I can’t seem to get it to do anything. Specifically. Clicking the Dashboard Builder opens the form and nothing else happens. None of the dropdowns populate. I’m using Windows 7 Enterprise Service Pack 1. 32-bit OS.

    • PNRao March 2, 2015 at 7:39 PM - Reply

      Hi BobN,

      Your data should be a Table. You can select a range of data and goto insert tab and click on the Table command to change to a Table.
      now you can see the drop downs with the worksheet name.

      You can download the demo file and practice withe sample data.

  31. Akrish February 24, 2015 at 7:18 AM - Reply

    I am using excel 2010 addin is not working. It says not compatible.

    Pls do let me know how can I get this enabled.

    • PNRao March 2, 2015 at 7:47 PM - Reply

      I tested on Excel 2010+32 bit. It is working fine.

      It is not properly working with 64 bit. I amy trying to fix this issue. I will update once it is done!


  32. Dan February 27, 2015 at 6:35 PM - Reply

    How about getting that Video Tutorial out. Would sure make this more usable for us novices.

    • PNRao March 2, 2015 at 7:33 PM - Reply

      Hi Dan,
      Sorry about that, Lots of work at office.

      I am trying my level best to preparing the demos. Please give me some more time.

      Thanks for your patience! PNRao!

  33. Yasser March 16, 2015 at 2:01 AM - Reply

    How to download these addins ?? I need Workbook Optimizer and I didn’t find any link

    • PNRao March 21, 2015 at 2:54 PM - Reply

      Hi Yasser,
      Please click on the ‘Download ANALYSYSISTABS Version 5’ link and it will download the add in. You can then add to your excel. And you can see a new ribbon tab added to your excel application.


  34. Ravi March 31, 2015 at 4:01 PM - Reply

    Hi Rao,

    Great job buddy..very good site to explore and learn….regarding add-in I am unable to use dashborad builder and slide creator. Rest is working fine!! Is there some problem or process that I need to follow.
    Thanks in advance!!

    • PNRao April 1, 2015 at 7:31 PM - Reply

      Hi Ravi,
      Thanks for the feedback.
      The current version of Add in is not properly working for some of the users with 64 bit version, I am fixing those issues and releasing the next version ASAP.

      You can use this add-in and no need to follow any process.


      • Hamad April 21, 2015 at 5:47 PM - Reply

        Dear PNRao,

        Its also not working on my 64 bit system. Previously on my old laptop it was working fine. Kindly fix the issue asap.



        • PNRao April 21, 2015 at 10:09 PM - Reply

          Hi Hamad,
          Yes, it is not working on some of the 64bit machines.
          We are changing the entire code and release the next version with the additional tools (we make sure that version will work for all the PC both 32&64 bit).

          I am trying by best to release ASAP.


  35. Abhishek June 7, 2015 at 12:34 AM - Reply

    Dear PNRao,

    Please add examples of Advance excel which use by MIS analyst. so that i can learn.

    Thanks & Regards.

    • PNRao June 8, 2015 at 9:38 AM - Reply

      Hi Abhishek,
      Thanks for your suggestions. It would be great if you can provide most frequent requirements in MIS. So that we can prepare the tutorials with the solutions here.


      • Abhishek June 23, 2015 at 1:10 PM - Reply

        Use of all the ribbon tools code with example home toolbar, insert, page layout, formulas, data, Review, view it will be greatful if u explain.

        • PNRao June 23, 2015 at 11:14 PM - Reply

          Hi Abhishek,
          Exactly! we both are thinking on the same line. Yes, it is getting ready!
          Currently we are focusing on VBA Code Explorer, and we are going to add macros for most useful ribbon commands in couple of weeks.

          Your comment is important and definitely motivates me to implement that faster.
          Thanks -PNRao!

  36. Milind June 23, 2015 at 2:35 PM - Reply

    Request to send file

  37. widiastra June 28, 2015 at 5:52 PM - Reply


  38. simon karios July 4, 2015 at 8:13 PM - Reply

    Please could you notify me or send me the dashboard creator once available?
    Many thanks

    • PNRao July 5, 2015 at 12:54 AM - Reply

      Hi Simon,

      Sorry for the inconvenience. We are bit busy in working on our new project. We will definitely inform you once we activate the add-in.


  39. Boondirek July 18, 2015 at 1:38 PM - Reply

    Dear PNRao

    I can’t download from link (V5.0.0)
    Pls. send e-mail


  40. Arzan July 22, 2015 at 9:57 AM - Reply

    Hi PNRao
    Please send me a link for this software – It looks like it’ll fit the bill

    • PNRao July 23, 2015 at 1:33 PM - Reply

      Hi Arzan,

      Thanks for the feedback. Currently, we are investing our time for new tools, we will definitely launch this in couple of weeks.


  41. Emma Sousa September 22, 2015 at 2:31 AM - Reply

    if you use this plugin can the dashboards be shared with users who do not have the plugin installed so they can see the dashboard results?


  42. Edgar September 30, 2015 at 12:00 AM - Reply

    ETA on when this will be available for download?

  43. Serge October 26, 2015 at 10:38 PM - Reply

    when your Dashboard add-in will be available…..?
    I am looking to upgrade but unable to do so, since you are in some kind of development mode…!
    Feedback appreciated.

    • PNRao November 3, 2015 at 4:22 PM - Reply

      Hi Serge,

      Thanks for showing interest on add-in to upgrade. We are currently working on VBA Online classes. We will inform you when we launch our next version of add-in.


  44. Alwin November 26, 2015 at 5:09 PM - Reply

    PNRAo, I understand you are currently working on the add-in, has anybody got copy of this old file. thanks for your help and support.

    • PNRao November 27, 2015 at 4:08 PM - Reply

      HI Alwin,

      There are some bugs in the old add-in. We are working on it. It will be available in couple of weeks.


  45. VENKATESH May 4, 2016 at 7:52 PM - Reply

    please upload the add in i couldnt find the link

  46. Isaias May 13, 2016 at 1:15 AM - Reply

    When add-in will be available?

  47. Mohammad Naveed June 8, 2016 at 5:09 PM - Reply

    Hi PNRao,

    its showing Download Not available, could you please fix.

    looking for your response.

    Mohammad Naveed.

  48. Fasasi June 8, 2016 at 8:29 PM - Reply

    Hello! I have been trying to download the Excel Add-in but to no avail. Rather, I am having the information below:

    “Download Addin & Demo File

    Download ANALYSISTABS Add-in for Excel 2007/2010/2013.



    Can someone help me with the link to the updated add-in. Thanks

  49. rajasekar July 14, 2016 at 1:24 AM - Reply

    Dear rap,

    I am not able to download the add ins please help to me for download

  50. Leon October 10, 2018 at 5:26 PM - Reply

    Hi is this feature going to be available?

    Slider Creator

Leave A Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.