You can add timelines for any date column in a pivot table / pivot chart. Thanks to Timelines, filtering for dates is a breeze. Of course, you can use auto-filter and select all the dates. We are always filtering data for latest quarter, 6 months starting Mother’s day or 8 weeks from November 1st etc. But almost no one needs all the data at same time. These days everybody boasts of a massive spreadsheet. Now you have more time to search for flight simulator. Using Excel 2013 data model, you can link multiple tables with each other (one to one or one to many relationships) and generate powerful Pivot reports & charts with few clicks. Trying to link up multiple tables of data using VLOOKUP, Copy Paste and black magic.įortunately Excel 2013 makes #3 a breeze, thanks to built-in data model.Searching for that mysterious flight simulator Easter egg (#).The top 3 reasons why analysts & managers spend so much time with Excel: See this demo.īonus Tip: Press CTRL+E to activate flash fill. It looks at what you are typing and sees if there is any pattern in it (based on adjacent columns etc.) and then suggests a fill down option. So, obviously he would use Flash Fill.įlash Fill works almost like magic. But he is too busy running around & saving earth. Now, flash being flash, do you think he will slowly type out the middle names one at a time? Of course, he can learn Excel formulas and do it in one stroke. Imagine Flash (the super hero, not browser add-in) is using Excel to extract the middle names of all his villains. Today, lets understand 10 things in 2013 that wowed me (and probably you too). I have been using it since last 6 months and enjoying it. As you may new, the newest version of Excel is out for a while.

Ms excel 2013