dot_clear.gif (42 bytes)

Data Analysis in Excel, and other Add-Ins

 dot_clear.gif (42 bytes)
In Excel, Several items under the "Tools" menu are called "Add-Ins".
(It means that instead of being automatically loaded every time Excel starts, they are loaded when the user requests them, or "adds them in".)
  • Often used are:
    • the "Data Analysis" add-in.
    • the "Solver" add-in
      •
    • (there are lots more)
  • Steps to activate one:
    • click "Tools" on the menu bar
    • come down and click "Add-Ins" on the drop-down menu
    • find the desired Add-In in the list and put a check in the box beside it
    • click OK
    • This will activate the add-in, so that it now shows as available under the "Tools" menu
  • Example, using the Data Analysis Add-In
    • click "Tools" on the menu bar
    • come down and click "Add-Ins" on the drop-down menu
    • put a check in the box beside "Analysis ToolPak"
    • click Ok
    • now, when they click "Tools", they will have "Data Analysis" available in the list
  • This "goes away" when you log off. It must be done again each time you log on.
    •