To be frank, I find this a bit of annoyance as my analysis work is never quick!īut I am sure there are tons of people who would find this very useful. Using this, you can do a lot of quick analysis tasks like adding conditional formatting, charts, sparklines or turning your data in to tables (or pivots). Quick analysis is a new button that appears when you select a bunch of data. I am sure your clients & bosses will love it.ĭepending on your work, you may love or hate it.
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.
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. Value = "popCalendar" Thenĭ) Click cell A5 will show the calendar like below:Īs Object, ByVal Target As Range ) If Target. Private Sub Workbook_SheetSelectionChange ( ByVal ShĪs Object, ByVal Target As Range ) If Target.
Private Sub MonthView1_DateClick ( ByVal DateClickedĪs Date ) On Error Resume Next 'replace your code here for set cell valueĪpplication. Microsoft Windows Common Controls-2 6.0 includes the following ActiveX controls:Įxtract mscomct2.ocx from MSCOMCT2.CAB to C:\windows\system32 (windows 32 OS)Īfter registering you can use Microsoft MonthView Control like below:ī) Add MonthView1_DateClick by double click the calendar control:
In excel 2013 you need to install date and time picker manually, and there is no compatibility problem among excel 2007, excel 2010 and excel 2013.(NOTE:This Active-X control works only on 32-bit systems)ĭownload Windows Common Controls-2 6.0 from link below: