You can filter, sort, and single out data without writing a bunch of custom formulas. If you struggle to filter data to find actionable insights, Dynamic Arrays will make you feel like a data-slicing pro.

Dynamic Arrays-This one is a little complex, but it takes something that was really complex before and makes it much easier.

To get Ideas, click the lightning bolt icon in the top right corner of the ribbon under the Home tab.

Ideas-Identify trends, patterns, and outliers in a data set and understand your numbers in seconds with Ideas, which is basically like having a data guru look at your numbers and provide suggestions as to what it could indicate-all without having to have the guru! Ideas also helps you graphically display your data in the best chart or graph format for the data type.

My friends at Microsoft told me there will be more data types rolled out in the future, so keep an eye on this one to see what it will do next. I can easily see a range of data on all my positions with a simple click, letting me identify trends and (hopefully) make better investing decisions. in almost no time (seriously, I embarrassed my brother with this one), I’ve been using it lately to track my stock investments. While you can see me use it to add the capitals, population, and largest cities for all 50 states in the U.S.

Data types in Excel-This is a super cool research tool.

Here are some of my favorite time-savers: Since that time, I’ve been using Excel for Office 365 in new ways and thought it would be a shame to keep all these newfound skills I’ve learned from Microsoft to myself. Neither of us even knew there were different versions of Excel, much less how one would compete against the other.Īs it turns out, I smoked Nathan at all the tasks, thanks to the help of artificial intelligence (AI) and a feature called Data Types in Excel for Office 365. Nathan had Excel for Office 2019 and I had Excel for Office 365. We were given a handful of tasks to complete using two different versions of Excel. Always up for a challenge, we took the offer and, when we got there, found out we’d be competing against each other, but not in a way we ever had before.

They told us it would be fun and all we had to do was be ourselves. When Microsoft invited me and my twin brother Nathan to come to Redmond to its film studios to participate in a “challenge,” we had no idea what we were getting into. Today’s post was written by Jeremy, one of the twins who took part in The Twins Challenge: Office 365 versus Office 2019.

What is phstat in excel