The Analysis Collection consists of three downloadable books and over 40 time saving add-ins. Buy as a collection and save over 70% savings off of the individual prices.
All the add-ins come with exercise files with to provide hands on practice
All the add-ins have Windows help files
All the add-ins are menu driven for ease of use.
GET THREE DOWNLOADABLE BOOKS ON EXCEL AND MACROS::
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 examples, 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.
GET OVER 40 TIME SAVING EXCEL ADD-INS:
Cell Color Assistant - Create your own toolbar of color buttons
Cascade Chart Creator - Create cascade charts that help you explain change
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
Data Assistant - Convert data into a form usable by pivot tables
Data Cleaner - Eliminate tedious manually 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 200 files you have opened!
Filter Assistant - Easily filter your data
Histogram Creator - Turn your data into a histogram instantly
Link Finder - Find and remove links to any workbook easily
Loan Assistant - Determine the cost and cash flows of loans
Macro Button Assistant - Choose from over 1700 buttons for your macro buttons
Macro Remover - Remove macros from any workbook
Multi-Cell Goal Seeker - Do goal seek on multiple cells automatically
Name Splitter - Easily split names into individual cell entries
Pivot Table Assistant - Make using pivot tables easier
Print Assistant - Automatically add print footers
Quick Charts - 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 - Print multiple Excel reports automatically
Report To Data Assistant - Convert text reports to Excel databases
Risk Analyzer - Do decision and risk analysis the easy way
Row Assistant - Easily re-arrange rows
Sensitivity Analyzer - Do many what if and sensitivity analysis cases in seconds
Sheet Navigator - Move from sheet to sheet with great ease
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
Only a few of the Analysis Collection programs are loaded each time Excel opens. To open the other add-ins in the Analysis Collection, simply select Tools, Macro Systems Add-ins, and select the add-in you wish to open from the list box that appears. A description of the add-in is displayed in the right hand window when you click on the add-in. This helps you quickly identify the add-in you want to open.
For example, if you wanted to open the Chart Assistant, you would highlight it and click on the Open /Redisplay toolbar button. If you wanted to see the add-in's help file to find out more about the add-in or how to use it, then you would click on the Display add-in's Help File button.
