Archive for June, 2009

Networkingdays() an improved version of networkdays formula

Published on Jun 9, 2009 in Excel Howtos, Learn Excel, VBA Macros
Networkingdays() an improved version of networkdays formula

We all know that networkdays() an extremely powerful and simple excel formula can help you calculate no. of working days between 2 given dates.

But there is one problem with it. It assumes 5 day workweek starting with Monday to Friday. Not all countries have workweek from Monday to Friday.

This got me thinking and I ended up writing a user defined formula (UDF) to calculate working days between 2 given dates with any criteria. This will be good for calculating payrolls for temporary workers, offshore partners and of course people working countries where Saturday or Sunday or not usually holidays.

Continue »

Excel Formula 1 – Really Fast way to learn Excel Formulas

Published on Jun 8, 2009 in Learn Excel
Excel Formula 1 – Really Fast way to learn Excel Formulas

Okay, that may appear a bit too fast. But the new improved version of our excel formulas e-book, now called “Excel Formula 1” is out today. I have included 25 more formulas and improved the content and layout greatly. The book costs $10 and you can buy it from here. If you want to be […]

Continue »

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

Published on Jun 5, 2009 in Excel Howtos, Featured, Learn Excel

Here is a very quick tip if you ever want to hide a cell’s contents in excel

Just use the custom cell formatting (more here) code ;;;

Continue »

Converting Excel to PDF – Everything you need to know

Published on Jun 4, 2009 in Excel Howtos, Featured
Converting Excel to PDF – Everything you need to know

Ok, so you have that neat little excel report ready and now you want to share it with your boss or client in a PDF format. So how would you do that? Your best option is …

Continue »

Venn Diagrams in Excel

Published on Jun 3, 2009 in Charts and Graphs, excel apps
Venn Diagrams in Excel

This post is a testament that readers of this blog are way cooler and enterprising than I am. Justin, who I must say, has some really amazing excel skills, contacted me in April with a VBA Script he made that can draw two circle venn diagrams in excel.

Continue »

Tweetboard Implementations – Download and make your twitter style dashboard today

Published on Jun 2, 2009 in Charts and Graphs, Learn Excel
Tweetboard Implementations – Download and make your twitter style dashboard today

Check out two fabulous implementations of tweetboards in excel. Download the workbooks and play with them yourself. Thanks Fernando and Lee for sharing these workbooks with us.

Continue »

Statistical Distributions in Excel [spreadcheats]

Published on Jun 1, 2009 in Learn Excel
Statistical Distributions in Excel [spreadcheats]

Excel has very powerful formulas and add-ins for performing almost any kind of statistical analysis. Today we will learn how you can make a statistical distribution of test scores using excel. There is a downloadable workbook too, for you to take a look at the formulas and play with them.

Continue »