Report Wizard & Tools

Allows easy creation of pivot tables basing on Excel list or external database (MS Access, Visual FoxPro and so on). Besides, allows easy adding subtotals to your Excel list. How does it work? This Excel add-in allows you to create the form for any your Excel list. If you will need to create pivot table or add subtotals to your list, you run Report Wizard and choose a form for a list you clicked or selected before run. Report wizard automatically adds all row and column fields, page fields, calculated items, data fields into pivot table, and more. Your work is only click on OK. Additionally, Report Wizard can check all list before report creation. For example, you entered the value of wrong type or entered the value in special column which defined a list of available values for, but you entered unavailable value. In this case Report Wizard adds new worksheet and selects all wrong values by red color. You can edit wrong values and rerun Report Wizard. Move over, if you use Input Wizard (please see below) and entered wrong value, then you will receive a message, and you can correct it during data input instead of during report creation. Besides, Report Wizard & Tools contains Input Wizard that work by the same work, but in this case in helps with data entry into Excel list. You click on a cell which you want to enter in and run Input Wizard. Then you choose a form that contains all grouping columns and links to special tables containing some limitations for values in some columns. After this Input Wizard asks you for values for some columns offering a list of available values, and if you set some columns as dependent or enter formulas for them, Input Wizard fills these columns automatically. Allows also exporting Excel list to external database and more.

Get Report Wizard & Tools now:

Purchase the full version for unlimited use

Latest posts by FinExcelSoft (see all)

You may also be interested in:

  • Lists To Table Add-in As regular Excel users know, Excel works best when data is laid out in a classic table format. When set-up like a table we can take […]
  • Complete Excel Course CURRENT SPECIAL Was $99.00 Now $49.95 Buying the lessons in this bundle saves you over 50% off the normal price! These lessons have […]
  • Categorizing Data for Excel If your problem consists in categorizing or stratifying specific data of your Excel spreadsheet information, then Categorizing Data for […]
  • Consolidator Enterprise for Excel Consolidator Enterprise for Excel is a Microsoft Excel complement especially created to consolidate a large volume of data in just a few […]
  • Excel Duplication Manager Add-in This very handy add-in will make your management of lists a breeze. It is designed to assist you when you have duplicates in 1 or more […]
  • Ozgrid List Manager 3 Excel add-ins in one. 1) Fill Blanks will fill your blank cells in your list with the cell above 2) Lists to Table will tranform your […]
  • Excel Cube Formula Reporting with Microsoft Analysis Services If you use Microsoft Excel to analyze data from: Microsoft Analysis Services Multidimensional Microsoft Analysis Services […]
  • PowerPivot Formula Reporting Made Easy If you use Excel 2010 or 2013 to analyze data from: PowerPivot models, using the free PowerPivot add-in Microsoft Analysis […]
  • Excel-Tool Split Excel Sheet The software can split a sheet into multiple sub sheets by the field in columns. You may have to split a very large worksheet into sub […]
  • Excel Download Package This package includes 33 fully accessible Workbook examples that cover topics like, Vlookup,Match,Index,Dfuntions,Advanced […]

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>