Software Listing of Author : "Mgmoreira.com"

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

  • Platform: Win2000, WinOther

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

  • Platform: Win2000, WinOther

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

  • Platform: Win2000, WinOther

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

  • Platform: Win2000, WinOther

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

  • Platform: Win2000, WinOther

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

  • Platform: Win2000, WinOther
New Reviews

Print Inspector

Whether you are using a printer connected to your local desktop computer or a print server sometimes you need to see whats going on in your printer by having a close look at the print jobs sent by the users. Print Inspector is such type software ...


Disk Genius

Disk Genius was formerly known as Partition Guru which is an all-in-one solution for disk partition management, data recovery and disk repairing. It can recover lost files from partition, backup and restore partition table, clone partition or clone ...


Safe In Cloud

It is quite difficult to find any computer users nowadays who do not need to use the web, for any purpose. Whether it is for education or entertainment, the web is your best resource. You also need to use various online services for banking, ...


PictBear

Nowadays, a majority of PC users resort to digital image editing once in a while. It may be required for retouching image captured in smart phones or for creating an album in Facebook. For some people, tinkering with digital images is a pastime too. ...


Panda Cloud Cleaner

PC security has become a tricky and complicated subject both for home users and network supervisors, with complexity and risk factors multiplying over the years. Using a single antivirus app may not be enough anymore. That explains why many users ...


SnapCrab

Nearly every PC users need to take screenshots from time to time, whether it is for personal or professional needs. While using the basic Windows screenshot capture method is available, it is not adequate for everyone. When you want to capture ...


BitKiller

Dealing with various types of data efficiently holds the key to success in any computing task. Apart from generating new data and modifying existing files, it becomes necessary to delete existing files at times. While most users resort to using ...


New Downloads

PWMinder Desktop

PWMinder is a Password Manager
that is used to store
passwords and other sensitive
data in a secure encrypted
file. ...

GlassWire Firewall

GlassWire\'s free firewall
software helps protect your
computer, privacy, and data by
monitoring your network
activity. ...

ChequeSystem Cheque
Printing Software

ChequeSystem provides a
complete cheque printing and
management solution. You are
no need to write any, just
print and ...

Devart ODBC Driver for
PostgreSQL

Devart ODBC Driver for
PostgreSQL is a
high-performance connectivity
tool with enterprise-level
features for accessing ...

IP Tools for Excel

NEW - IP Tools for Excel -
Add-in / Plug-in for Microsoft
Excel. Instant Productivity -
Instant Results in Microsoft
...

Lodgit Desk Hotel Software
for Windows

Booking software for all kinds
of lodging establishments
incl. reservation schedule,
booking and guest list,
cleaning ...

Pixillion Image Converter
Software Free

Pixillion Image Converter
Software Free is perfect for
converting your image files
for posting on the web,
emailing to ...

Devart ODBC Driver for
MongoDB

Devart ODBC Driver for MongoDB
is a high-performance
connectivity tool with
enterprise-level features for
accessing ...

RationalPlan Project Viewer

RationalPlan Project Viewer is
a free project planning
software viewer, the perfect
solution for anyone (from
project ...

BestCrypt Container
Encryption

To protect your privacy,
comply with regulations and
prevent data breaches,
BestCrypt delivers
\'on-the-fly\' data ...