excel how to

If you use Excel to calculate payment schedules in Excel, one of the most important calculations you do will involve computation of dats between dates. For this purpose you may want to exclude weekends, holidays and other specific days. Thankfully there’s a really useful function … [Read more...] about How to Calculate the Number of Work Days Between Two Dates in Excel

If you are someone who does a lot of Excel work, you probably have found yourself in a situation where you had to convert time to minutes or minutes to a time format. For instance, you may have wanted to change 3:45 to 180 minutes or convert 225 minutes to hours and minutes … [Read more...] about How to Convert Time to Minutes in Excel

When you work with large sets of data in Excel, one of the most common analysis you do involves counting cells in the worksheet. The Excel Count function makes it easy for you to count cells based on various criteria. In our Learn Excel Series, we'll be taking a look at the … [Read more...] about Learn Excel: How to Use the Excel Count Function

Decisions! Decisions! Life is filled with situations where you have to make decisions. Thankfully Excel is a pretty good tool to use to help you make better decisions, at least in some matters. In this Excel tutorial, I’ll show you how to use the IF logical function in Excel to … [Read more...] about Learn Excel : How to Use the IF Logical Function

Excel offers a number of handy tools to sum up the totals of all the numbers in a range of cells in your worksheet. But what about those times when you only want to sum up specific values in a range? In such situations, you can make use of the SUMIF and SUMIFS functions. In this … [Read more...] about How to Sum Up Specific Values in a Range in Excel