All articles in 'Excel Howtos' Category

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 »

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 »

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 »

Create a Combination Chart, Add Secondary Axis in Excel [15 Second Tutorial]

Published on Jul 2, 2009 { 4 Comments }
Create a Combination Chart, Add Secondary Axis in Excel [15 Second Tutorial]
Continue »

Create a number sequence for each change in a column in excel [Quick Tip]

Published on Jun 29, 2009 { 4 Comments }
Create a number sequence for each change in a column in excel [Quick Tip]
Continue »

Remove Duplicates [Quick Video Tip]

Published on Jun 22, 2009 { 2 Comments }
Remove Duplicates [Quick Video Tip]
Continue »

Do you know these Double-click Tricks in Excel?

Published on Jun 12, 2009 { 73 Comments }
Do you know these Double-click Tricks in Excel?
Continue »

Networkingdays() an improved version of networkdays formula

Published on Jun 9, 2009 { 8 Comments }
Networkingdays() an improved version of networkdays formula
Continue »

How to Hide a Cell’s Contents in Excel? [Quick Tip]

Published on Jun 5, 2009 { 17 Comments }
How to Hide a Cell’s Contents in Excel? [Quick Tip]
Continue »

Converting Excel to PDF – Everything you need to know

Published on Jun 4, 2009 { 39 Comments }
Converting Excel to PDF – Everything you need to know
Continue »

Hide Formula Errors While Printing [Quick tip]

Published on May 27, 2009 { 1 Comment }
Hide Formula Errors While Printing [Quick tip]
Continue »

Do you know these Excel 2007 Productivity Secrets (Hint: Coffee is not one of them)

Published on May 26, 2009 { 16 Comments }
Do you know these Excel 2007 Productivity Secrets (Hint: Coffee is not one of them)
Continue »
Page 3 of 512[3]45