![]() ![]() Common chart customizations are a click away (screenshots 1, 2 & 3).A screen where you can change the chart type for each series easily.Recommended charts feature that tells you which charts go well with your data.Microsoft revamped the default formats too so that when you make a chart from data, it is ready for presentation (with out too many tweaks). Now you can create combination charts, add secondary axis, set up smart data labels, format the chart or switch styles with ease. In Excel 2013, there are massive changes in charting. Logical – XOR(), IFNA(), BITXOR(), BITOR(), BITAND() etc.Information formulas – ISFORMULA(), FORMULATEXT(), SHEET() and SHEETS().Web formulas – WEBSERVICE(), FILTERXML() and ENCODEURL() ( an example on these formulas).In Excel 2013, there are many new formulas and improvements. No extra formulas or no arrays or no VBA. That is right, using Excel 2013 pivot reports, you can find out distinct counts. If you are really quiet, you can hear an analyst in your company screaming with joy once they realize that in Excel 2013, you can get distinct count of values in pivot reports!!! Now, if you insert a default chart (or table, pivot etc.) from your data, you need to do very little clean up work. It is a far cry from Excel 2003’s color scheme (which is boring, glaring & poorly contrasted). The default color scheme of Excel 2013 is bold, creative and well contrasted. 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. 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. Use one or both of the following procedures:įor more information on Paste Options, see How to use the Paste Options button in Excel.As you may new, the newest version of Excel is out for a while.Microsoft Office Excel 2003 and earlier versions of Excel To turn off Insert Options, click to clear the Show Insert Options buttons check box.To turn off Paste Options and Auto Fill Options, click to clear the Show Paste Options buttons check box.Under Cut, copy, and paste, use one or both of the following procedures:.Click the Microsoft Office Button, and then click Excel Options. ![]() To prevent the paste options, the auto fill options, and the insert options from appearing, follow these steps, as appropriate for the version of Excel that you are running. These conditions also apply to the Auto Fill Options and the Insert Options that appear in Excel. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |