In partnership with Experts Exchange. Among the new functions currently in beta and soon to be released in the 365 editions of Excel are TAKE and DROP, which dynamically duplicate a range of cells. The TAKE function specifies which rows and columns to get and the DROP function specifies which
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
