Adding chemical intelligence to Excel
Company:
PerkinElmer Informatics
Duration:
3 min
Issue:
19.3
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.
VIEW FEATURE CLIP
To view the complete feature clip, 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.
Choose File Format
File Size