Tips
Useful Excel features
Data TablesUsing defined names
Conditional Formatting
Data Validation

Macros
How to learn macrosMacro Overdose
Learning Macros: Examples on this site
Engineering
Engineering Drawings in ExcelSolving Boundary Value Problems using ODE solvers
Managing Excel Lists for Engineering
Accessing External Data
Function to Look Up against external databaseGetting 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.comFlow 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