Resources
How to Create a Homeowners Insurance Quoting Application from an Excel Spreadsheet
To insurance professionals like actuaries or underwriters, creating a homeowners insurance quoting application in Excel is not difficult. If you have a list of base rates and rate factor, and know how to write formulas in Excel, it doesn't take too long to...
How to convert a number to time units
If you want to convert a number to time values, you need some additional operations, multiplying and dividing between days, hours, minutes, and seconds. Here, we're going to take a look at a simpler approach by using Excel's TEXT function. Syntax...
How to highlight a column
To highlight a column may be tricky because there is no built-in option in Excel's Conditional Formatting feature. Here, you can find out how you can do this dynamically using Excel formulas. Steps Begin by selecting rows by clicking on column letters Open...
How to highlight a row
To highlight a row may be tricky because there is no built-in option to in Excel's Conditional Formatting feature. Here, you can find out how you can do this dynamically using Excel formulas. Steps Begin by selecting rows by clicking on row numbers Open...
Blood Alcohol Content (BAC) Calculator
What is your Blood Alcohol Content (BAC) level? Are you too drunk to drive? How many hours before you can drive? This blood alcohol calculator estimates blood alcohol level based on your weight, gender, and number of drinks you've consumed. It also estimates the time...
Time Lost Due to Smoking Calculator
How do you calculate time lost due to smoking? How long does a cigarette reduce your life? <br /> Each cigarette reduces your life by an estimated 11 minutes according to an article entitled "Time for a smoke? One...
How to highlight duplicate values in a data set dynamically
It’s often a good idea to highlight duplicate values in a data set to help easily identify the outliers. Here, you can find out how you can do this dynamically using Excel formulas. Syntax =COUNTIF(absolute data range reference, relative cell reference)...
How to return an entire row
To return an entire row you need to use array returning functions like INDEX or OFFSET. Both of these functions can return arrays, as well as single values, which can be used in other functions like SUM, AVERAGE or even another INDEX or OFFSET. How to...
How to return an entire column
To return an entire column you need array returning functions like INDEX or OFFSET. Both of these functions can return arrays, as well as single values, which can be used in other functions like SUM, AVERAGE or even another INDEX or OFFSET. How to return...