The
Analysis Collection consists of all of our downloadable books and time saving add-ins. We sell it as a collection to provide you with over 70% savings off of the individual prices.
To make learning and using the Analysis Collection's add -ins easy:
All the add-ins come with exercise files with step by step instructions to provide hands on practice in using their features.
All the add-ins have Windows help files which provide additional detailed instruction.
The exercise files and help files are easily accessed from the opening dialogs.
All the add-ins are menu driven for ease of use.
Downloadable books on macros and Excel:
Microsoft Excel Visual Basic Macros Made Easy - A downloadable book (Windows help file format) on how to write Microsoft Excel macros
Microsoft Excel Visual Basic Macro Examples - Get over 1200 Excel macro examples in a downloadable book (Windows help file format). These examples are new, and not a repeat of the ones in Visual Basic Macros Made Easy.
Time Saving Microsoft Excel Solutions - Great "how to" solutions in a downloadable, easily accessed book.
A wide range of time saving add-ins:
Backup Assistant - Be automatically prompted to backup files when you open them and before you modify them (or back them up at your convenience).
Cascade Chart Creator - Create cascade charts that help you explain change
Cell Color Assistant - Create your own toolbar of color buttons
Chart Assistant - Create hundreds of charts quickly and easily
Chart Labeler - Easily label and re-arrange your chart points
Chart Viewer - View your embedded charts' full screen in the Chart Viewer's slide show
Conditional Format Assistant - Easily format cells based on multiple tests
Consolidation Assistant - Consolidate worksheets from multiple workbooks. Extract data easily.
CSV File Creator - Create CSV files the easy way
Data Assistant - Convert data into a form usable by pivot tables
Data Cleaner - Eliminate tedious manual cleaning of data
Data Loader - Make Excel data loading easier
Directory Lister - Windows Explorer in an Excel worksheet
Duplicate Finder - Quickly find and remove duplicates
File Assistant - See a list of the past 100 files you have opened. Easily re-open or E-mail any file.
Filter Assistant - Easily filter your data
Histogram Creator - Turn your data into a histogram instantly
Link Finder - Easily find and remove links to any workbook
List Assistant - Effortlessly re -arrange rows and cells
Loan Assistant - Determine the cost and cash flows of loans
Lookup Assistant - Match data from one list to another the easy way
Macro Button Assistant - Choose from over 1700 buttons for your macro buttons
Macro Remover - Remove macros from any workbook
Merge Assistant - Merge (concatenate) multiple cells many different ways.
Multi -Cell Goal Seeker - Do goal seek on multiple cells automatically
Name Splitter - Easily split names into individual cell entries
Password Assistant - Easily lock and unlock worksheets
Pivot Table Assistant - Make using pivot tables easier
Print Assistant - Automatically add print footers
Quick Chart Creator - Use just one chart for many rows of data
Random Number Generator - Random numbers the easy way
Random Sampler - Easily select a random sample of your data
Report Runner - Automatically print multiple Excel reports
Report To Data Assistant - Convert text reports to Excel databases
Risk Analyzer - Do decision and risk analysis the easy way
Sensitivity Analyzer - Do numerous "what if" and sensitivity analysis cases in seconds
Sheet Navigator - Move from sheet to sheet with great ease
Significant Digit Assistant - Add a key feature Microsoft forgot!
Spreadsheet Assistant - Add over 200 time saving features to Excel
To Do Assistant - Manage your "To Do" lists from within Excel
Waterfall Chart Creator - Create charts that allow you to view the effect of what you plot
Y Value Estimator - Estimate values for missing data points