Using the new Analyze Data button in Excel

Posted on
6,013 Points
Last Modified:
Experience Level: Intermediate
Bob Flisser
Bob Flisser has authored many courses and books about Microsoft, Adobe and Apple products, and has been a computer trainer since the 1980s.
Excel has so many features and options for data analysis, it can be overwhelming. You might not always know how best to present your data. So the 365 editions introduced the Analyze Data button. When you click it, it analyzes your worksheet and shows ways to present information – like a table, Pivot Table or chart – that you can insert with one click and modify however you want. Even better, it has a natural language option, so you can ask it questions, like “Show Java beans sold in January, sorted by state.” In this episode, we’ll take a thorough look at this great, new tool.
Author:Bob Flisser
Windows Explorer lets you open archive (tar and tgz) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating archive files takes a little more - and that you'll find here.
Often times what you may consider better indicators of various items, others do not.  It is always a good idea to have a way to turn off conditional formatting in whatever program is displaying it.  The most obvious I will use here - MS Excel.

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month