Create Rich Visualized and Interactive Dashboards for Analyzing Your Data

mongopono.ru is a FREE Excel Add-in for Data Analysis and Dashboard Creation, Power-Packed with Innovative Utilities. Our objective of developing mongopono.ru 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…).

analysistsbas V5


ANALYSISTABSFW

mongopono.ru v5.0.0

mongopono.ru 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 mongopono.ru Add-in for Excel 2007/2010/2013.

/ 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 mongopono.ru

/ 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 Use| Privacy Policy

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.

mongopono.ru 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.

mongopono.ru 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.

mongopono.ru 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.

mongopono.ru 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.

mongopono.ru 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.

mongopono.ru 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 mongopono.ru 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.

82 Comments

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

  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

    Thanks
    PNRao

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

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

      I would really appreciate it if anyone has a copy of the old mongopono.ru 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!

    Regards,
    Neel

  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!

      Regards-PNRao!

  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.

      Thanks-PNRao

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

  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.

    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!

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

      Thanks-PNRao!

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

      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!

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

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

    Hello,
    I believe the download ling to mongopono.ru 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

  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.

    Thanks,
    Katie

  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.

      Thanks-PNRao!

  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.
      C:\Users\username\AppData\Roaming\Microsoft\AddIns

  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?

    Regards,
    Rakesh

  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.

      Thanks-PNRao!

  25. 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!

  26. 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!

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

  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!

      Thanks-PNRao!

  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.

      Thanks-PNRao!

  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.

      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!

  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.

      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.

        • 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

    GOOD FOR JOB

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

  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

    Thanks.

  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.

      Thanks-PNRao!

  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?

    Emma

  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.

      Thanks-PNRao!

  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.

      Regards-PNRao

  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

    Hi,
    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.

    Regards
    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 mongopono.ru Add-in for Excel 2007/2010/2013.

    ×
    / 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

  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

Leave A Comment


Related pages


excel vba thisworkbookexcel construction templateswriting vba code in excel 2010vba conditionsvba savevba unprotect all sheetshow to calculate difference between dates in excelproject management timeline excelvba programming for excelrename files using excelvba modellingsumif function in exceltimeline template in excelvba convertexcel vba open pdf filelearn to write macros in excelformula match excelformula for hlookuphow to use sumifs function in excel 2010vb6 copy fileuseful excel macrosexcel formulas shortcuts keyexcel isnumberprotect excel worksheetvba check file existsexcel forms comboboxsql query practice questions answers pdfexcel chart title from cellteradata macro exampleautofit row height not workingvba select workbookexcel vba divisiondelete duplicate columns in excelexcel macro developerwhat is use of pivot table in excelopen file using vbaworkbook and worksheetexcel vba call formvba vlookup exampledynamic graph excelvba filedialogvba code examplesadvance filter in excelexcel timelines templateexcel shortcut edit formulaexcel blank cell ifexcel vlookup functionsvba indentvariable types vbahow to merge cells in excel 2007excel vba application formulaoffset formula in excel with examplevba macros in exceltrim formula excelexcel logical and operatorexcel activeworkbook.saveasproject milestone template excelcountif function in excel 2007definition of filtering in excelddl dmlindex formula in excel 2007excel months between two datesautofit excel 2010redim array vbaadding developer tab in excel 2007hloookupprotect columns in excel 2007filesystemobject referencehow to pivot table in excel 2010excel macro to open filedcl queriesexcel chart add inshow to use vlookup excel 2013excel practice filesexcel calculate difference between datesvba listbox columnremove duplicate rows in excel