1 / 11

Excel in M.E. –Using add-ins

Jesse Huguet Mechanical Engineering University of Alabama. Excel in M.E. –Using add-ins.

bo-hartman
Télécharger la présentation

Excel in M.E. –Using add-ins

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Jesse HuguetMechanical EngineeringUniversity of Alabama Excel in M.E. –Using add-ins

  2. All 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: Introduction

  3. From 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. 1. DOWnloadingthe files

  4. DOWnloading the files

  5. Activating 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. 2. Activating the Add-in

  6. Activating the Add-in

  7. Select the “Add-Ins” tab on the left menu and click the “Go…” button at the bottom. Activating the Add-in

  8. 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.

  9. Find the location of the Add-In that you saved previously, highlight it, and click the OK button. Activating the Add-in

  10. You 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. Activating the Add-in

  11. The 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. Activating the Add-in

More Related