<

Using the new Analyze Data button in Excel

Posted on
6,013 Points
13 Views
Last Modified:
Published
Experience Level: Intermediate
10:43
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.
0
Author:Bob Flisser
0 Comments
Depending on the things you do with Microsoft Office, you can sometimes inadvertently lose your recent document lists in apps such as Microsoft Word and Excel. This article shows you how to back up and restore those lists when necessary. Enjoy...
When adding new VBA features to a workbook, some parts may be difficult but you struggle through it because it's important to you or to someone you're helping. During that struggle you may say to yourself that "I wish I could find an easier way". Ho…

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month