We have launched a tutorial video series about the most common questions that come up while using JChem for Office. JChem for Office is a ChemAxon add-in, that equips your Office with robust chemistry handling. All episodes start with the tab in your Excel ribbon, called JChem, showing some basic tips and tricks, along with thorough explanation of some more complicated use cases, we hope to ease your work and save time while handling your chemical data in Microsoft Office environment. Watch the JChem for Office Tutorials in a playlist on YouTube:
In the first step of the tutorial series, you learn to log in, choose the right MS Office bit version, install the software, choose the right components, and make it available for users on your computer. You will figure out how to make sure JChem for Office doesn't clash with other add-ins, and a quick overview of the functions in Excel.
In this episode, add new structures to Excel cells and change a few structure display settings. An overview of the "JChem" tab in Excel, adding new structures to Excel cells with the embedded Marvin sketch application and changing a few structure display settings.
In this episode, import multiple chemical structures into an Excel spreadsheet - with the help of JChem for Office. Finding the "Import" function in the "JChem" tab, step-by-step process of the file import (with Data Placement, Append and Header creation). How to select the fields to be imported within the file, default options and how to change them. We also preview a finished import.
In this episode, insert different JChem functions to a worksheet in Microsoft Excel. Adding a structure object by name, and by drawing. Calculating monoisotopic mass, finding the insert functions field, morphology of functions. We navigate the list of functions available and test the autocomplete feature.
In this episode, do calculations based on different input values; IUPAC name, CAS Registry Number, SMILES strings, and a traditional name, inserted into a LogD-pH chart. Using the JCLogD function to calcualte for individual cells and table range. Creating scatter plot graph for table.
In this episode, learn to use structure based filters. It includes an overview of the filter feature, substructure search steps with structural specifications (import, name based or MarvinSketch for instance), and applicable rules. It shows how to highlight matching and non-matching substructures, as well as rotating for better alignment and cleaning them.
In this episode, export from Excel to a number of filetypes relevant in most cheminformatic workflows. Share data outside of Excel, or submit it to another application, with a variety of filetypes as an input. It includes instructions on how to export different data sets, the entire worksheet or particulr tab into a variety of destination formats, including ChemAxon MRV format, Daylight Smiles, and Structure Data File, with V3000 format supported.
Enumerate the products of a two-component reaction within JChem for Excel.
In this episode you will learn to check whether your molecules contain certain substructural units, to make sure, for example, that your compounds are free of any structural alerts, which may indicate toxic behavior.