News

This online workshop will show you how to turn your excel data into professional charts. A WebEx link will be emailed to everyone who registers for the event. If you would like to receive a badge for ...
To extract and sort non-adjacent arrays in your data, nest the CHOOSECOLS or CHOOSEROWS functions inside your SORT or SORTBY formula. Alternatively, to extract, filter, and sort columns from a dataset ...
The same actions that were performed to clean and join data using Alteryx can be performed using Excel’s Power Query. It is not necessary to use complicated Excel formulas to do these tasks, and the ...