|Buy Today, send us your order ID, and claim over $70.00 worth of FREE software|
Excel Smart Tools improves and Adds new commands and functions to Microsoft Excel. Some of new commands are: File Print Preview Selection, Convert Formulas to Value, Sheet Index, Change Cases. New functions retrieve sheet name, workbook name and properties, like author name.
Excel Smart Tools 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.
Excel Smart Tools Forecasting Tools 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 powerful tool
This Add-In adds and enhances Microsoft Excel commands and functions. Many improvements are great time-savings features for tedious and repetitive tasks.
Excel Smart Tools main feature is Spelling Numbers, a tool that spells numbers in four different languages: English, French, Spanish and Portuguese.
Commands and Functions Available:
- 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)
- Excel Smart Tools 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 Frequencies
Commands and Functions available only on registered users
- The Gantt Chart Spreadsheet
ExcelSmartTool Premium Edition is a general purpose tool written for all Microsoft Excel users, from beginners to advanced users.
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. Excel Smart Tools Auditor works either on a cell-by-cell basis or group-by-group basis.
Forecasting Tools Graph provides the most Known and commonly used Forecasting methods for Marketing, Economics, Accounting, Operations Management. A simple and powerful management tool on any desktop, indispensable for those who need to perform forecasting's.
Forecasting Tools Graph Features
1 - 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.
2 - 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.
3 - Double Exponential Smoothing: This tool allows you to apply this advanced Forecasting model. You can define the two smoothing factors (Alpha and Beta) or use the Optimizer Function that returns the combination of smoothing factors (between 0 and 1) that minimizes the Mean Square Error. Only available if Correlation > 50%.
4 - Exponential Growth : This tools allows you to calculate the curve that best fits the Time Series. Extremely useful for Internet Statistics Forecasting. Only available if Correlation > 90%.
5 - Linear Growth : This tools allows you to calculate the line that best fits the Time Series. Only available if Correlation > 75%.
6 - What's The Best model?: This tool performs simultaneous Time Series analyses and presents the Mean Square Errors sorted and the available methods.
7 - Calculate Seasonal Indexes: In many situations (e.g. ice cream sales) the Time Series values vary from period to period according a similar pattern. This tools allows you to calculate the Seasonal Indexes to complete your Forecast.
8 - Winters model for seasonal Time Series: a powerful procedure is provided to analyze highly seasonal Time Series.
9 - Time Series Decomposition: powerful procedures to decompose Time Series in basic components (Trend, Cyclical, Seasonal and Random).
10 - Forecasting Periods: Forecasting Tools Graph can forecast any number of future periods.
11 - High-Low-Chart: HLC module was designed to analyze stock market data and generates a simulation of future values, incorporating past errors.
Instant Download and Money Back Guarantee on Most Software
Excel Trader Package Technical Analysis in Excel With $139.00 of FREE software!
Microsoft ® and Microsoft Excel ® are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft
GIVE YOURSELF OR YOUR COMPANY 24/7 MICROSOFT EXCEL SUPPORT & QUESTIONS