excel in m.e. –using add-ins
DESCRIPTION
Jesse Huguet Mechanical Engineering University of Alabama. Excel in M.E. –Using add-ins . - PowerPoint PPT PresentationTRANSCRIPT
![Page 1: Excel in M.E. –Using add-ins](https://reader033.vdocuments.us/reader033/viewer/2022050806/56816008550346895dcf0a2d/html5/thumbnails/1.jpg)
EXCEL IN M.E. –USING ADD-INS
Jesse HuguetMechanical EngineeringUniversity of Alabama
![Page 2: Excel in M.E. –Using add-ins](https://reader033.vdocuments.us/reader033/viewer/2022050806/56816008550346895dcf0a2d/html5/thumbnails/2.jpg)
INTRODUCTIONAll of the files linked on the Excel in M.E. Website are Add-Ins. The files for Excel 97-2003 have the file extension .xla and the Excel 2007 files are .xlam. Using Add-Ins is convenient because once they are applied to your version of Excel they can be used in any spreadsheet you open without extra work. The following steps should be taken to implement the Add-In file of your choice:
![Page 3: Excel in M.E. –Using add-ins](https://reader033.vdocuments.us/reader033/viewer/2022050806/56816008550346895dcf0a2d/html5/thumbnails/3.jpg)
1. DOWNLOADING THE FILESFrom the website, right click the hyperlink of the file and select “Save Target As…” from the menu. The picture on the next slide illustrates this step. Choose a location for the file that you will remember, as you will have to relocate it from Excel later.
![Page 4: Excel in M.E. –Using add-ins](https://reader033.vdocuments.us/reader033/viewer/2022050806/56816008550346895dcf0a2d/html5/thumbnails/4.jpg)
DOWNLOADING THE FILES
![Page 5: Excel in M.E. –Using add-ins](https://reader033.vdocuments.us/reader033/viewer/2022050806/56816008550346895dcf0a2d/html5/thumbnails/5.jpg)
2. ACTIVATING THE ADD-INActivating the Add-In is a one-time step. Start by opening Microsoft Excel 2007. Click on the Office Icon button in the top left corner of the program window. Select the “Excel Options” button at the bottom of the menu. See the next slide for a picture of these steps.
![Page 6: Excel in M.E. –Using add-ins](https://reader033.vdocuments.us/reader033/viewer/2022050806/56816008550346895dcf0a2d/html5/thumbnails/6.jpg)
ACTIVATING THE ADD-IN
![Page 7: Excel in M.E. –Using add-ins](https://reader033.vdocuments.us/reader033/viewer/2022050806/56816008550346895dcf0a2d/html5/thumbnails/7.jpg)
ACTIVATING THE ADD-IN
Select the “Add-Ins” tab on the left menu and click the “Go…” button at the bottom.
![Page 8: Excel in M.E. –Using add-ins](https://reader033.vdocuments.us/reader033/viewer/2022050806/56816008550346895dcf0a2d/html5/thumbnails/8.jpg)
ACTIVATING THE ADD-IN
The Add-Ins menu shown here will appear. Click Browse to apply your Add-In.
Aside: For engineering work, it is always useful to have the Analysis Toolpak and Solver loaded. If they are not, click the box next to their names to check them and select OK to activate.
![Page 9: Excel in M.E. –Using add-ins](https://reader033.vdocuments.us/reader033/viewer/2022050806/56816008550346895dcf0a2d/html5/thumbnails/9.jpg)
ACTIVATING THE ADD-IN
Find the location of the Add-In that you saved previously, highlight it, and click the OK button.
![Page 10: Excel in M.E. –Using add-ins](https://reader033.vdocuments.us/reader033/viewer/2022050806/56816008550346895dcf0a2d/html5/thumbnails/10.jpg)
ACTIVATING THE ADD-INYou will notice the name of your Add-In joining the previously listed items. Make sure the box beside the Add-In you loaded is checked and click the OK button.
![Page 11: Excel in M.E. –Using add-ins](https://reader033.vdocuments.us/reader033/viewer/2022050806/56816008550346895dcf0a2d/html5/thumbnails/11.jpg)
ACTIVATING THE ADD-INThe Add-In is now loaded and will be loaded for every spreadsheet you open. Its functions and macros will be available to any sheet or graph you would like to use them on.