Excel Add-in for Dashboards Creation and Data Analysis ANALYSISTABS!

Excel Add-ins ANALYSISTABS!PNRao2022-07-16T06:29:02+00:00

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…).

ANALYSISTABS v5.0.0

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.

Support

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.

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.

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.

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.

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.

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.

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.

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.

84 Comments

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.
Thanks!
PNRao
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

Thanks
PNRao
Chitanya August 18, 2013 at 10:40 AM - Reply

HI PNRAO,

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

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

Thank You! – PNRao
Neel August 20, 2013 at 7:21 PM - Reply

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

Regards,
Neel
PNRao September 1, 2013 at 10:07 AM - Reply

Thank You Neel!
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!

Regards-PNRao!
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.

Thanks-PNRao
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.

Thanks-PNRao.
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.

Thanks,
Tom
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.
Thanks-PNRao!
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!
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.

Thanks-PNRao!
Krishna July 1, 2014 at 8:12 AM - Reply

Please tell me how to use your dashboard application…it is not working
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.

Thanks-PNRao!
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.

Thanks-PNRao!
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.
Ken August 25, 2014 at 1:20 AM - Reply

Hello,
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.
Thanks,
Ken
Ken August 25, 2014 at 5:55 PM - Reply

Hello,
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?
Thanks,
Ken
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.

Thanks,
Katie
BUtch BArker September 4, 2014 at 11:01 AM - Reply

this still does not work in windows 8.1 64 bit
Butch BArker September 5, 2014 at 8:49 AM - Reply

its September first, when will it be ready?
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

http://prntscr.com/4ljyes

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.

Thanks-PNRao!
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:35 AM - Reply

Dear Rao,

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

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

place your addin on following path then problem will solved.
C:UsersusernameAppDataRoamingMicrosoftAddIns
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.
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!
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.

Thanks-PNRao!
Subrahmanyam January 21, 2015 at 8:14 AM - Reply

Hello,
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.
Thanks,
Subrahmanyam
PNRao January 23, 2015 at 10:49 AM - Reply

Hi Subrahmanyam,

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

Thanks-PNRao!
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

Hi,

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

Thanks-PNRo!
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
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!
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
Sadhana February 18, 2015 at 8:53 PM - Reply

Hi, I really liked your add-in. I appreciate your hard work. Keep it up.
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.
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.
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!
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.
Thanks-PNRao!
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!

Thanks-PNRao!
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.

Thanks-PNRao!
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.

Thanks
PNRao!
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.

Thanks,

Hamad
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.

Thanks-PNRao!
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.

Thanks-PNRao!
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.
Milind June 23, 2015 at 2:35 PM - Reply

Request to send file
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!
widiastra June 28, 2015 at 5:52 PM - Reply

GOOD FOR JOB
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
Simon
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.

Thanks-PNRao!
Boondirek July 18, 2015 at 1:38 PM - Reply

Dear PNRao

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

Thanks.
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.

Thanks-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.
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?

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

ETA on when this will be available for download?
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.

Thanks-PNRao!
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.

Regards-PNRao
VENKATESH May 4, 2016 at 7:52 PM - Reply

please upload the add in i couldnt find the link
Isaias May 13, 2016 at 1:15 AM - Reply

Hi,
When add-in will be available?
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.

Regards
Mohammad Naveed.
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.

×
////SORRY! CURRENTLY NOT AVAILABLE FOR DOWNLOAD!

WE ARE RE WORKING ON THE ADD-IN AND WILL BE AVAILABLE IN BY MARCH 2016. THANKS FOR YOUR SUPPORT!”

Can someone help me with the link to the updated add-in. Thanks
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
Leon October 10, 2018 at 5:26 PM - Reply

Hi is this feature going to be available?

Slider Creator
Jon September 23, 2019 at 6:50 PM - Reply

Hi, please tell me when the addin becomes available again,; thanks in advance

Create Rich Visualized and Interactive Dashboards for Analyzing Your Data

ANALYSISTABS v5.0.0

Download Addin & Demo File

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

Download Example Dashboard created using ANALYSISTABS

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

Support

Workbook Optimizer

Dashboard Builder

Slider Creator

Widget Creator

TOC Creator

Export to PowerPoint

List Files and Folders

Many More Tools and Knowledge Base

And many more utilities and functions

84 Comments

Leave A Comment Cancel reply