Software Listing of Author : "Mgmoreira.com"
- Excel Level 3 & Excel VBA & Excel UserForm Courses
- License: Shareware
- Price: $49.95


These lessons have been written by OzGrid Business Applications who develop Excel spreadsheets on a professional basis. Each lesson is drawn from 'real world' experience and not made up class room scenarios. There are 30 lessons, each between 5 and 10 Word Document pages long, and 15 Workbook examples.Excel level comes with an Online Pivot Table tutorial.Lesson 10 of Excel VBA has Time Saving Microsoft Excel Solutions. It is a downloadable book in Windows help file format that contains hundreds of solutions to Microsoft Excel problems. You do not need to purchase and it does not expire - it is freeware. Download and use whenever you have the time or need. It is a great way to improve your Excel skills and find time saving Excel solutions. No special software is needed to use - just download, run ,and open Excel. Access from the Excel...
- Publisher: mgmoreira.com
- Date Released: 28-08-2009
- Download
- Platform: Win2000, WinOther
- ExcelSmartTools Auditor
- License: Shareware
- Price: $35.00


ExcelSmartTools Auditor ExcelSmartTools Auditor, was developed to help Microsoft Excel users audit and check spreadsheets models. Many studies reports that spreadsheet errors are the rule, and for many spreadsheet models, Microsoft Excel Audit tools are not enough. Auditing a spreadsheet can be made on a Cell-by-Cell basis or Group-by-Group Basis. The first requires users to check every cell, a lengthy and fault process. The later requires users to analyze a group of colored cells indicating different type of data. Microsoft Excel Audit tools works on a cell-by-cell basis. ExcelSmartTools Auditor works either on a cell-by-cell basis or group-by-group basis. ExcelSmartTools Auditor Auditor Quick Info provides users information about workbook properties, active worksheet size and complexity and potential problems and tips. Auditor Check...
- Publisher: mgmoreira.com
- Date Released: 16-9-2009
- Download Size: 669 KB
- Download
- Platform: Win2000, WinOther
- ExcelSmartTools DataClean
- License: Shareware
- Price: $35.00


ExcelSmartTools DataClean ExcelSmartTools DataClean was developed for helping users to edit, to correct and to clean spreadsheets, lists and reports importers from ERP (for instance AS400), web sites, and from other software packages. For the Microsoft Excel normal user, the major commands available allows to: Correct formulas that return errors, as for instance the division for zero Verify that all the cells are of the same type of data (for instance, dates, formulas, labels) Convert text for upper letters, lower cases For users that work with imported reports from ERP ( like AS400) , the most important commands allow, besides mentioned previously: To eliminate spaces in excess, To correct negative values (125 -) for the correct value in Microsoft Excel -125 To convert Numeric Text for numbers, that can be used by mathematical...
- Publisher: mgmoreira.com
- Date Released: 10-10-2009
- Download Size: 556 KB
- Download
- Platform: Win2000, WinOther
- ExcelSmartTools Premium Edition
- License: Shareware
- Price: $50.00


This Add-In adds and enhances Microsoft Excel commands and functions. Many improvements are great time-savings features for tedious and repetitive tasks.ExcelSmartTools main feature is Spelling Numbers, a tool that spells numbers in four different languages: English, French, Spanish and Portuguese.ExcelSmartTools Premium Edition Main Functions:File Print Preview Selection File Print Labels ( a powerful tool for labels and mail merge) Edit Copy Selection As Printed Edit Convert Formula To Value Insert Function Map Format Change Case Format Numbering Workbook properties functions (book name, sheet name, etc) ExcelSmartTools Toolbar SumIf Bold functions Purchasing Functions Random Number functions Production Functions Area and Volume Functions File Save All Open Workbooks Hide and Unhide Sheets / Workbooks Smart Statistics Smart...
- Publisher: mgmoreira.com
- Date Released: 27-9-2009
- Download Size: 847 KB
- Download
- Platform: Win2000, WinOther
- ForecastingTools Graph
- License: Shareware
- Price: $75.00


ForecastingTools Graph This Microsoft Excel Add-In provides the most Known and commonly used Forecasting Tools, as Moving Average, Simple Exponential Smoothing and Winters models. It performs simultaneous Time Series analyses, Seasonal Indexes Calculation and Time Series Decomposition. New Graphical Interface makes forecasting Tools a simple and powerfull tool. ForecastingTools Graph provides Moving Average: Similar to Microsoft Excel Analysis ToolPack, this tool adds the Optimizer Function that returns the number of periods (between 2 and 6) that minimizes the Mean Square Error. Exponential Smoothing: Similar to Microsoft Excel Analysis ToolPack, this tool adds the Optimizer Function that returns the Damping Factor (between 0 and 1) that minimizes the Mean Square Error. Double Exponential Smoothing: This tool allows you to apply this...
- Publisher: mgmoreira.com
- Date Released: 22-9-2009
- Download Size: 1699 KB
- Download
- Platform: Win2000, WinOther
- Text Manager
- License: Shareware
- Price: $29.95


The Text Manager will make working with text in your spreadsheet very easy. It is particularly useful for text which has been imported into Excel. You specify the range to affect, this can be specified cells or the entire sheet.The Change Case lets you instantly change the case of your text. You can nominate to change your text to:upper case lower caseproper case.The Remove Character or Text can save you many hours of manually removing specific characters, or text, from specified text. You can even copy the characters to remove directly from the Windows Character Map. If the character or text you wish to remove is not available, simply check the Specify Character or Text option.One very common problem with text (particularly imported text) is the unavoidable importing of spaces. Not only does this make your text unsightly and hard to...
- Publisher: mgmoreira.com
- Date Released: 26-08-2009
- Download
- Platform: Win2000, WinOther