Tips

Useful Excel features

Data Tables

Using defined names

Conditional Formatting

Data Validation

Macros

How to learn macros

Macro Overdose

Learning Macros: Examples on this site

Engineering

Engineering Drawings in Excel

Solving Boundary Value Problems using ODE solvers

Managing Excel Lists for Engineering

Accessing External Data

Function to Look Up against external database

Getting real time data in Excel

Tricks

Using Excel formulae to create long Excel Formulae

Multiple formatting in the same cell

Distinguishing a blank cell from a cell containing zero

Colouring Alternate Rows

Find and Replace Colours in Cells

Custom User Defined Function for Reverse Lookup in Excel

Guest Articles

This section contains tips shared by readers. If you wish you contribute, please send an email to mehta.nitin@gmail.com

Flow Sheet Modelling - Guest article by Dr. Stephen Gay

Converting PDF files to Excel and other Office formats

PDF Converter

PDF Converter (Elite)

Able2Extract PDF Converter