Search

# Archive for June, 2009

## Networkingdays() an improved version of networkdays formula

Published on Jun 9, 2009 in Excel Howtos, Learn Excel, VBA Macros

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

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

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

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 »

Published on Jun 2, 2009 in Charts and Graphs, Learn Excel

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

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 »

### Get FREE Excel & Power-BI Newsletter

One email per week with Excel and Power BI goodness. Join 100,000+ others and get it free.