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
In partnership with Experts Exchange. Microsoft hasn’t yet released the Textsplit function out of beta testing in the 365 edition of Excel. So until you have that function available but you want to use a function to split text on the fly, you can momentarily convert the text into XML
