How to Figure Out Lottery Probability in Excel
Are the lottery odds ever in your favor? If you know the top prize, you can use Excel to figure out the lottery probability and see if it’s …
Continue ReadingShowing items from business
Learn How to Measure the Accuracy of a Sales Forecast: Excel Forecast Accuracy Calculation and Formula
There are several different ways that you can use to develop a sales forecast, but how do you measure how accurate that sales forecast is? Mr. Excel …
Continue ReadingLearn How To Raise A Number To A Fraction To Find The Square Or Third Root With This Microsoft Excel Tutorial
Problem: Excel offers a SQRT function to find the square root of a number. What if you need to figure out the third root or the fourth root?
Continue ReadingLearn How To Total Minutes That Exceed An Hour With This Microsoft Excel Tutorial
Problem: You have a series of cells with minutes and seconds from a number of experiments. The times are in the format of 123:45, meaning 123 minutes …
Continue ReadingMicrosoft Excel Help: Before Deleting A Cell, Find Out If Other Cells Rely On It
Problem: Before deleting a section of the worksheet you believe is no longer needed know that if you delete the cell and some other far-off range …
Continue ReadingMicrosoft Excel Help: Calculate A Trendline Forecast
Having a little trouble calculating an Excel trendline? Try this approach.
Continue ReadingMicrosoft Excel Help: Convert Text To Minutes And Seconds
Problem: Someone in another department set up a spreadsheet with hundreds of time values. However, instead of using Excel time formats, they entered …
Continue ReadingMicrosoft Excel Help: Round Prices To Next Highest $5
Need to round numerical values in a non-standard manner in Excel? Read on to learn how.
Continue ReadingMultiple Regression in Microsoft Excel: How to Build A Model for Predicting Sales
Problem: You run an ice cream stand. After 10 days of sales, you discover that you either make a lot of money or nearly go broke. As you analyze …
Continue ReadingRead Excel Tips Such As How To Convert Text To Hours, Minutes, And Seconds At BrightHub.com
Someone in another department set up a spreadsheet with 100’s of time values. Instead of using Excel time formats, they entered each cell as text with …
Continue ReadingRead Excel Tips Such As How To Find The Area Of A Circle At BrightHub.com
Problem: You need to order pizza for the department staff meeting. The pizza joint has two deals. You can buy three Medium (12”) pizzas for $15 or two …
Continue ReadingClaiming Home Office Space Deductions on Your Taxes
The IRS allows a reasonable number of deductions for expenses associated with maintaining a home office. Learn about which deductions are allowed and …
Continue Reading