• Browse By Topic

  • Videos and Demos

    • Adding chemical intelligence to Excel

    • Presenter: Jesse Gordon , Company: PerkinElmer Informatics
    • Duration: 3 min
      • Printer Friendly Bookmark
        • Average rating 5 from 1 users
        • Please Login to rate
  • ChemDraw includes an Excel add-in — but you have to tell Excel that you want to use it! This video provides a step-by-step demonstration of installing ChemDraw into MicroSoft Excel, including the following lessons:

    • On Excel's "Tools" menu, select "Add-ins" and turn on ChemOffice or ChemDraw.
    • In Excel, chemically-intelligent spreadsheets include a menu item like "ChemOffice11" right next to the "Window" menu.
    • To create chemical spreadsheets, use menu item "New ChemOffice Worksheet" instead of "File > New > Worksheet".
    • To identify chemical spreadsheets, the Excel worksheet name is "ChemOffice1" instead of "Sheet1".
    • When using chemical spreadsheets, molecular structures are embedded within cells, instead of "floating" above cells.
    • A new set of "ChemDraw Functions" appears on the "Insert Function" list, alongside "Financial" and "Statisitical" functions.
    • ChemDraw Functions include chemical analysis, property predictions, molecular topology, and SMILES conversions.

    View this Feature Clip and download a sample spreadsheet to learn more!

    Click here to update your profile.

    • Watch Full Video

      To watch the full video, choose from the available formats below, and simply click on the corresponding link. You must have the appropriate player to play the file. For more info on video players, here. You may also download the video file, depending on your OS & browser, by right clicking or alt-clicking and choosing save link as.

      • Download or stream in your favourite player

      • File Size


      To download a file, right click on the corresponding link and choose "Save Links As" or "Save Target As".

      • Choose file format

      • Sample ChemDraw / Excel spreadsheet: Sample ChemDraw / Excel spreadsheet

  • Next Steps