In partnership with Experts Exchange. If you need random numbers quickly, maybe to test a new worksheet or to create example Excel files, there are three functions you can use in both the Windows and Mac versions: RAND, RANDBETWEEN and RANDARRAY. We look at each of them in this episode.
In partnership with Experts Exchange. Excel has three new functions that will be available soon – they are currently in beta test – that make short work of rearranging columns and rows of data. In this episode, we see how the TOCOL, VSTACK and WRAPROWS functions work.
In partnership with Experts Exchange. There is an edition of Excel that runs online inside your web browser. Chances are you already have access to it, and if not, you can even use a limited version of it for free. In this episode, we give it a quick look.
In partnership with Experts Exchange. One of Excel’s coolest data visualization features is the ability to plot data on a 3D map. Also known as Power Maps, this is an ad-in that comes with the Windows version of Excel. And the maps aren’t just static! You can show data changing
In partnership with Experts Exchange. There are several ways you can insert the date and time, including having it be constant or letting it update to the current date or time. Excel also has some efficient ways of formatting the date and time. In this episode, we will insert the
