In partnership with Experts Exchange. Excel’s Offset function, available in the last couple of versions for Windows and Mac, lets you create ranges that change location and size dynamically. In this video, we look at a few examples, then use the function to change the size of a print area
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 cooperation with Experts Exchange. If you want to generate a numbered list, there are two ways of doing it: as a one-shot deal using the AutoFill feature or dynamically and with several options, using the Sequence function introduced in the 365 editions for Windows and Mac. In this episode,
