Excel Resources
colored beakers
Blank Excel file with macro that formats chemical equations
(Dr. Jeffrey Anderson)

Click on cell with equation text then CNTL-z

Formatting for equation text:
'">" = forward reaction arrow
'"<" = equilibrium arrow
'"+" or "-" after character is assumed charge   on ion eg. S-2 (-2 superscripted")
' asterisk character above now replaced with bold centered dot
' "DH" or "DG" or "DS" ... "D" converted to delta
' "hn" converted to h neu
' 0 after E,G,H,S superscripted
' f after 0 subscripted
' 0 before C,F superscripted


*****Check back later and there will be a file posted that will contain a similar macro for Word files*******

Adding Custom Macros to an Excel Toolbar

Before adding these custom buttons, you should create your own personal add-in. Don't worry, this is a piece of cake.

  1. Open up a new workbook.
  2. Start up VBA. (Press Alt+F11)
  3. Insert a new module. (Insert > Module)
  4. Copy and paste the VBA code into the module.
  5. (Take note of what the macro is called).
  6. Get out of VBA. (Press Alt+Q)
  7. Save your workbook as an addin (.xla) file, calling it something like My_Addin.xla
  8. Exit out of Excel, then start it up again.
  9. Enable your new addin (Go to Tools -> Add-Ins and select your new addin).

Creating a new macro button in a toolbar.

  1. Go to Tools -> Customize
  2. In the Commands tab, click on the Macros category.
  3. Copy (drag and drop) the Custom Button to one of your toolbars.
  4. Right-click on the button and select Default Style to display only the image.
  5. Copy and paste the button image as described above.
  6. Right-click on the button and select Assign Macro ...
  7. Type the exact name of the macro and select OK


How to do just about anything with Excel
(Tushar Mehta Consulting - business analysis focus, however I have used many of the methods for science applications)
    
 Excel Tutorials and add-ins
       Charts
       Excel and VBA Case Studies
       VBA Tutorials

Unit Converter Add-in

List of Excel Functions (pdf)  (xls)

Display cell formulas as equations

Excel file for graphing an equation

Handy Toolbar (neat feature for creating new sheets with names)

SIMTOOLS (statistics add-in)

Interactive guide for finding Excel 2003 commands in Excel 2007

Calendar Templates

Monte Carlo Simulations add-in