![]() ![]() One often overlooked feature of Excel is the What-If Analysis tool that allows you to explore different scenarios without changing the values in your spreadsheet. Some of them are intended to save you time by extracting or joining data and others perform complex calculations. What are data tools in Excel?ĭata Tools in Microsoft Excel are simply tools that make it easy to manipulate data. ![]() ![]() In the Add-Ins box, check the Analysis ToolPak check box, and then click OK. If you're using Excel 2007, click the Microsoft Office Button, and then click Excel Options In the Manage box, select Excel Add-ins and then click Go. Load the Analysis ToolPak in Excel Click the File tab, click Options, and then click the Add-Ins category.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |