Pages

Excel Inspiration

Cell Technology

Posted by Excel Inspiration at 1:25 pm

Labels: My Works

Powered by Blogger.

First-In, First-Out (FIFO) Method Calculation

Download Link
AUTOMATIC QUOTATION FORMAT

Download Link
Diffuser Size Calculator

Download Link
Insert the rows in between the name list:

1. Add new "helper column" 2. Type "A"&"B" in helper columns cells 3. Select both cells & Drag it ...
Useful Excel Websites

Microsoft (MS) Excel is a powerful spreadsheet that is easy to use and allows you to store, manipulate, analyse, and visualize data. Ther...
Highlight Duplicates

Sub ColorDuplicates ( ) 'Color duplicate items between Sheet1 . columns A and Sheet2.Column A For i = 1 To Sheets ( "Sheet1&...
Number to Text Convert Formula for 0 to 99

For Example: 2 - Two 22 - Two Two 58 - Five Eight 79 - Seven Nine 96 - Nine Six Formula: =IF(LEN...
Microsoft Excel Function Reference

Database Functions DAVERAGE(database,field,criteria) Averages the values in a column in a list or database that match conditions you spe...
Staff Training Programme

Download Link
Numbers to Text Converting Formula

=TRIM(IF(A1<1000,"",IF(MOD(A1,1000000)>=100000,INDEX({"";"One";"Two";"Three";"...