All articles with 'Microsoft Excel Formulas' Tag

Calculate Elapsed Time in Excel [Quick Tips]

Published on Sep 22, 2009 { 9 Comments }
Calculate Elapsed Time in Excel [Quick Tips]
Continue »

Want to become a Data God? Learn Excel Data Tables

Published on Sep 10, 2009 { 15 Comments }
Want to become a Data God? Learn Excel Data Tables
Continue »

Get cell comments using Excel Formula

Published on Sep 3, 2009 { 12 Comments }
Get cell comments using Excel Formula
Continue »

29 Excel Formula Tips for all Occasions [and proof that PHD readers truly rock]

Published on Aug 24, 2009 { 7 Comments }
29 Excel Formula Tips for all Occasions [and proof that PHD readers truly rock]
Continue »

50 Best Cities for Finding a Job [Incell Dashboard using Excel]

Published on Aug 20, 2009 { 7 Comments }
50 Best Cities for Finding a Job [Incell Dashboard using Excel]
Continue »

Use ROWS() and COLUMNS() formulas to generate numbers in a sequence [quick tip]

Published on Aug 17, 2009 { 2 Comments }
Use ROWS() and COLUMNS() formulas to generate numbers in a sequence [quick tip]
Continue »

Count the number of unique values in a range [Quick Tip]

Published on Aug 6, 2009 { 14 Comments }
Count the number of unique values in a range [Quick Tip]
Continue »

The funnest way to learn excel formulas

Published on Aug 3, 2009 { 4 Comments }
The funnest way to learn excel formulas
Continue »

Twitter Formula Contest – We are 5000 strong now

Published on Aug 3, 2009 { 15 Comments }
Twitter Formula Contest – We are 5000 strong now
Continue »

Build a Retirement Calculator using Excel (learn how to use Goal Seek as a bonus)

Published on Jul 29, 2009 { 18 Comments }
Build a Retirement Calculator using Excel (learn how to use Goal Seek as a bonus)
Continue »

Sumif with multiple conditions [quick tip]

Published on Jul 22, 2009 { 27 Comments }
Sumif with multiple conditions [quick tip]
Continue »

Use burn down Charts in your project management reports [bonus post]

Published on Jul 21, 2009 { 13 Comments }
Use burn down Charts in your project management reports [bonus post]
Continue »

Generating invoice numbers using excel [reader questions]

Published on Jul 20, 2009 { 12 Comments }
Generating invoice numbers using excel [reader questions]
Continue »

Formula 1 Style Sorting of Times (Durations) in Excel

Published on Jul 15, 2009 { 13 Comments }
Formula 1 Style Sorting of Times (Durations) in Excel
Continue »

How to Round and Sort Data using Excel Formulas?

Published on Jul 6, 2009 { 20 Comments }
How to Round and Sort Data using Excel Formulas?
Continue »
Page 3 of 712[3]456...Last »