Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

HOW TO USE THE "DATA ANALYSIS TOOL"

0

Please tell me how to use the Data Analysis Tool in Excel?

Answer
Discuss

Answers

0
Selected Answer

The Analysis ToolPak is an Excel add-in program that provides data analysis tools for financial, statistical and engineering data analysis.

To install it, follow the instructions you find here.

Discuss

Discussion

Thanks !!
I have already activated the Data Analysis add-in. Just wanted to know how to use the various component on it. Hope to get an overview from the link provided by you. 
Surendera (rep: 2) Dec 11, '19 at 7:56 am
Hello Surendera, There are detailed, sometimes quite long instructions for the use of each of the tools published by Microsoft and available on the Internet. Google for something like "Solver msdn" which will call up instructions for the Solver tool, including those my MS. There is more support within Excel's own Help.
Because these tools are quite complex it's best to first read the instructions and then look for help pertaining to a specific problem once you have grown out of the basics.
Variatus (rep: 4889) Dec 11, '19 at 9:36 pm
Thanks Variatus for guidance!!
Surendera (rep: 2) Dec 13, '19 at 6:19 am
Add to Discussion


Answer the Question

You must create an account to use the forum. Create an Account or Login