![quick analysis button on excel 2013 quick analysis button on excel 2013](https://www.excel-easy.com/smi/examples/quick-analysis.png)
Excel does some back office decision making and displays a list of charts to choose from. Click the Insert tab – select Recommended Charts. The first step to amazing chart creating is to select the data you need chartified. Put your hand down, because you will need it for this. Scrolling through about a bazillion charts trying to determine the right one, well, let’s just say -that isn’t your job anymore. The daunting and time wasting task of choosing a chart is finally over. Raise your hand if you wish Excel was a little more intuitive when it comes to charts. One, two, three cells, or more it doesn’t matter. The same process applies when combining cells as well. Sit back, take a sip of your coffee and bask in the glow from the monitor while Excel 2013 does the rest of the work – creating a new column with the data you need. Then click the Home tab – Fill – Flash Fill. Simply type in the information you want to pull in the adjacent column, first row.
#QUICK ANALYSIS BUTTON ON EXCEL 2013 FULL#
Extracting data like first or last names from a column of full names just went full throttle. Whatever the case may be, Microsoft took Excel 2013 to a whole new level and the world will never go back.įlash Fill is a magical predictive tool that gives you what you want. Maybe they grew tired of our tears shorting out the keyboards. Someone over at Microsoft must have heard our moans haunting them at night. Remember the formula headache when you need to extract data from one cell to another? Combine information from 2 or more columns or rows? How about formula on top of formula just to capture only the results you need? One of the most amazing and useful features is Flash Fill. Complex workarounds for data management is a thing of the past, and it is a no brainer to make the new features work for you.
![quick analysis button on excel 2013 quick analysis button on excel 2013](https://i.ytimg.com/vi/SA1NIexXhP4/maxresdefault.jpg)
Microsoft’s Excel 2013 just became a functional asset for data crunchers.