This blog is part 2 of a series that looks at the amazing functionality of some of the most popular Office 365 Excel functions. In part 1 the focus was on the FILTER function. Building on this, we will explore how useful the SORT function is in arranging data more efficiently. What is the SORT […]
How often have you found when you filter Excel data, problems arise in getting it to work? This can happen when you are sharing workbooks or the source data changes frequently. The solution lies in Office 365’s FILTER function. This blog is part 1 of a series that explores the amazing functionality of some of […]
Refine your filter options with the Advanced Filter in Excel For most filtering of data Excel AutoFilter is perfectly adequate. Here we’ll look at some benefits for moving beyond the AutoFilter by using the advanced filter in Excel. A Recap of AutoFilter Benefits For ease of use, it’s hard to beat the Excel AutoFilter feature. Just click […]
What is the difference between Autofilter and Sort in Excel? Why use one and not the other? I found out the difference when I was trying to sort through an enormous worksheet and a colleague asked me why I wasn’t using the Autofilter. I didn’t really want to admit that I didn’t know what it […]