Okebiz Video Search



Title:Excel Video 194 RANDBETWEEN
Duration:03:42
Viewed:2,758
Published:23-07-2012
Source:Youtube

If your compliance efforts need to be a little more random, watch Excel Video 194. I'll start with a quick reminder that I've already covered some statistical functions relating to forecasting in Excel Videos 100-103. I won't cover those function again in this series on Excel functions, so if you want some help with forecasting, please refer back to Excel Videos 100-103.

RANDBETWEEN is an easy function to use. Simply give Excel a bottom and a top range and Excel will calculate a random integer between the top and bottom values. Every time something changes and Excel recalculates the spreadsheet, RANDBETWEEN will generate a new random number. Use copy and paste special like I do in the video to convert the random numbers to set values.

One place RANDBETWEEN might help you is in compliance testing. I'll show you how to generate a random set of charts to audit and a random set of days to test. Simply copy your RANDBETWEEN formula to as many cells as you need to generate the amount of claims, charts, or whatever else you need to test. RANDBETWEEN won't make your audits any faster or easier, but it certainly can make the process of choosing an audit sample easier.

SHARE TO YOUR FRIENDS


Download Server 1


DOWNLOAD MP4

Download Server 2


DOWNLOAD MP4

Alternative Download :



SPONSORED
Loading...
RELATED VIDEOS
How to Generate Random Numbers and Characters using RAND and RANDBETWEEN functions in Excel 2016 How to Generate Random Numbers and Characters u...
04:43 | 462
How to generate random numbers in Excel Both decimals and the other How to generate random numbers in Excel Both de...
03:50 | 523
Excel Date Calculations, How To Insert Date and Time in Excel 2020  📝 (Mathematical Method) Excel Date Calculations, How To Insert Date and...
12:26 | 886
RANDOM SAMPLE WITHOUT REPLACEMENT - EXCEL 2016 RANDOM SAMPLE WITHOUT REPLACEMENT - EXCEL 2016
04:40 | 530
RAND and RANDBETWEEN Functions in Excel RAND and RANDBETWEEN Functions in Excel
10:17 | 896
How I Made an Excel Spreadsheet that could PREDICT WINNING LOTTERY NUMBERS: How to tutorial How I Made an Excel Spreadsheet that could PRED...
14:35 | 29,752
Excel Video 512 Multiple Datasets in 3D Maps Excel Video 512 Multiple Datasets in 3D Maps
04:44 | 966
How to take a random sample using Excel How to take a random sample using Excel
03:28 | 910