All articles with 'Microsoft Excel Formulas' Tag

Relative vs. Absolute References in Formulas [spreadcheats]

Published on Nov 4, 2008 { 9 Comments }
Relative vs. Absolute References in Formulas [spreadcheats]
Continue »

Excel Links of the Week [Nov 3]

Published on Nov 3, 2008 { 1 Comment }
Excel Links of the Week [Nov 3]
Continue »

Adding Box Plots to Show Data Distribution in Dashboards [Part 6 of 6]

Published on Oct 29, 2008 { 10 Comments }
Adding Box Plots to Show Data Distribution in Dashboards [Part 6 of 6]
Continue »

Sorting Text in Excel using Formulas

Published on Oct 22, 2008 { 19 Comments }
Sorting Text in Excel using Formulas
Continue »

SQL Queries from Excel

Published on Sep 22, 2008 { 6 Comments }
SQL Queries from Excel
Continue »

Calculating Paydays in a calendar year using Excel

Published on Sep 17, 2008 { 2 Comments }
Calculating Paydays in a calendar year using Excel
Continue »

Power Outage & 99 Excel Tips to keep you Busy

Published on Sep 16, 2008 { 1 Comment }
Power Outage & 99 Excel Tips to keep you Busy
Continue »

Splitting text in excel using formulas

Published on Sep 8, 2008 { 11 Comments }
Splitting text in excel using formulas
Continue »

Initials from Names using Excel Formulas

Published on Sep 2, 2008 { 44 Comments }
Initials from Names using Excel Formulas
Continue »

Quickly process text using split() spreadsheet function in google docs

Published on Aug 25, 2008 { 4 Comments }
Quickly process text using split() spreadsheet function in google docs
Continue »

Simulating Dice throws – the correct way to do it in excel

Published on Aug 13, 2008 { 11 Comments }
Simulating Dice throws – the correct way to do it in excel
Continue »

Beyond If and Sum, 15 really useful excel formulas for everyone

Published on Aug 13, 2008 { 49 Comments }
Beyond If and Sum, 15 really useful excel formulas for everyone
Continue »

Excel can be Exciting – 15 fun things you can do with your spreadsheet in less than 5 seconds

Published on Aug 1, 2008 { 56 Comments }
Excel can be Exciting – 15 fun things you can do with your spreadsheet in less than 5 seconds
Continue »

How to count words in a cell using excel functions

Published on Jul 8, 2008 { 5 Comments }
How to count words in a cell using excel functions
Continue »

Learn Excel IF Formula – 5 Tricks you Didnt know

Published on Jun 9, 2008 { 41 Comments }
Learn Excel IF Formula – 5 Tricks you Didnt know
Continue »
Page 6 of 7« First...2345[6]7