Engineers-Excel.com

     
Engineering using Spreadsheets

Tips

Useful features in Excel

Data Tables

Using defined names

Conditional Formatting

Data Validation

Macros

How to learn macros

Macro Overdose

Tricks

Using Excel formulae to create long Excel Formulae

Sorting Data by Rows

Multiple formatting in the same cell

Getting data from the web into Excel

Distinguishing a blank cell from a cell containing zero

MS Office Drawing Tip - Use of Connectors

Colouring Alternate Rows

Engineering

Engineering Functions in Excel

Unit Conversion in Excel

Solving Boundary Value Problems using ODE solvers

Getting real time data in Excel