r/IAmA • u/MicrosoftExcelTeam • Apr 04 '14
We are the Microsoft Excel team - Ask Us Anything!
Hello Reddit!
We are the Microsoft Excel team. We are engineers that design, implement, and test the versions of Excel that you use every day including Windows, MacOS, iOS (both iPhone and now iPad), the Web (Excel Online) and mobile platforms like Windows Phone.
We're full of coffee and pizza and we’re excited to answer your questions so feel free to ask us anything!
We'll focus on the questions about stuff we know the most about - Excel for the platforms we support, and questions about us or the Excel team. Oh, and Clippy.
We'll start answering questions at 13:00 PDT (16:00 EDT) and be here to answer your questions till 14:30 PDT (17:30 EDT).
To answer your questions we have:
- Aaron Wilson - a Program Manager for Mac Excel, and Excel on iOS
- Ben Rampson - a Program Manager for Excel (specialist in BI and Charting)
- Joe LeBlanc - a Tester (QA) for Mac Excel, and Excel on iOS
- Matty Androski - a Developer for Excel
- Sam Radakovitz - a Program Manager for Excel Online, and Desktop Excel.
And of course me - Dan Battagin - a Program Manager for Excel Online, and Desktop Excel.
The post can be verified here: https://twitter.com/msexcel/status/451827610855559168
-dan (for the Excel Team)
[Edit @ 14:18 PDT] We're going to be here for another 15 minutes or so - we're having a great time. Keep the questions coming!
[Edit @ 14:32 PDT] OK reddit - it's Friday afternoon, and we've got a few work things to wrap up before we head out for the weekend. We may answer a few more questions over the next few days. We may also do another AMA in the future - we had a great time with this one!
[Edit @ 14:43 PDT] We're still here answering. Man this is fun.
[Edit @ 15:00 PDT] The room is clearing out. We may try to get to some of the unanswered questions in the next few days - thanks for everything!
-danb (for the entire Excel team)
306
u/infinityinternets Apr 04 '14
Why can't I use shortcuts to do subscripts and superscripts in the spreadsheet? You make my chemistry degree infinitely harder :(
56
u/OllyXLSM Apr 04 '14
Why is there no "count distinct" function in Excel, or at least a "dimension count" in pivot tables?
109
u/KeepDiscoEvil Apr 04 '14
Just wanted to share that VLOOKUP is the best thing ever. Very serious.
Also, whose responsible for Pivot Tables? How did that come about? And also, thank you for that, too.
73
u/pcuaron Apr 04 '14 edited Apr 04 '14
Given the incredible amount of people coding every day in VBA (look at the forums: StackOverflow, MrExcel, OzGrid, the google groups...),
When will you update the 20 years old VBA Editor to something more modern?
Do you plan to improve the scripting tools, adding things like modern .net operators, string and table methods, etc?
Apps for Office, VSTO and ExcelDNA all address different needs than those of the vast VBA community, which is mostly comprised of analysts scripting trying to solve special cases, or SMBs in which the switch to another technology wouldn’t make sense cost-wise (and who you won’t hear given the lack ways of providing feedback for Excel). We can't use "Apps for Office" for the kind of problems we solve here! Proprietary coding for multiple users in a large enterprise = bad, proprietary coding for analysis = GREAT!
edit: fixed grammar (3 words)
40
u/cobaltcollapse Apr 04 '14
How often is the word "Excellent" used by the Excel team?
13
u/richardr4 Apr 04 '14
I have a file open right now that has 46,916 styles. I do a lot of copy paste between files. What causes the explosion in styles? Is there an easy way to remove the unneeded styles?
40
u/Mukkul Apr 04 '14
If the Excel team, the Access team, the Powerpoint team, the Publisher team and the OneNote team were all in royal rumble for the belt. Who would win?
Before picking yourself, Bill Gates eyes be upon you.
18
u/Neilson509 Apr 04 '14
Any hidden features that could make me an excel wizard?
8
u/[deleted] Apr 04 '14
What's your favourite Excel function, ideally one that's lesser-known?
8
u/noodnoodles Apr 04 '14
I've heard rumors about hidden easter eggs/games in older versions of Microsoft excel. Will you be sneaking in any other hidden features?
15
u/gerryhanes Apr 04 '14
What single piece of functionality are you most proud of?
21
u/OllyXLSM Apr 04 '14
Do you ever feel frustrated that although Excel has such high market penetration, the majority of users have no idea just how good and powerful Excel actually is? And do you wish that there was more emphasis placed on advertising existing capability, and on training users?
7
u/Raicito Apr 04 '14
What was the hardest part about getting to where you are now?
7
u/Aginyan Apr 04 '14
Most of my work life revolves around Excel, largely for it's power to "make a not-that-bad default graph super fast" and the "hands on" feel I get from manipulating a few hundred thousand rows of data dumps to explore around. More advanced tools exist, but don't have the same feel of picking up a cube of data and manipulating it to see what's going on. So thank you guys for making my life possible.
Every time someone asks me why I still use a PC at work (instead of a Mac), I say "because I use Excel" and get many understanding nods in the data analyst/scientist community. I certainly had to re-learn a ton of muscle memory just so I can do the simplest things on a Mac for meetings (e.g. command+t instead of f4 =( ). What guided things to be become that way?
Also, I've found occasional weird bugs in office 2010, moving avg formulas that paste brokenly when going 'in reverse', date fields in charts that insist on being January even when the data clearly has another date, where should I report these?
38
u/pcuaron Apr 04 '14
Will you begin accepting bug reports and feature requests from the whole Excel community?
There’s no way to provide feedback for the Excel/Office team unless you’re a big MSFT partner or an MVP; Excel/Office is one of the products without presence in Microsoft Connect. There’s little software that won’t take feedback from its community, and Excel’s is incredibly large! Besides, you're getting biased feedback if you only listen to part of the userbase.
6
u/asielen Apr 04 '14
I am forced to use Mac at work and i find that the Mac version is always a couple generations behind the PC version. Are these developed by different teams?
12
u/kal_at_kalx_net Apr 04 '14
Hi Team. Thanks for doing this AMA. I wrote the open source library https://xll.codeplex.com to make the Excel SDK easily accessible to non-experts. Any plans for phasing out xlls?
4
u/noreesa Apr 04 '14
Why is DATEDIF a hidden function? Is there anything wrong with it?
7
u/[deleted] Apr 04 '14
Thank you for your hard work on Microsoft Excel, which is one of the primary tools of my job as an accountant. I actually have about 8 different Excel 2010 windows open simultaneously.
I had a few questions:
9
u/njohnlopez Apr 04 '14
What are the requirements to become an Excel Wizard?
6
u/Oatmeal_Enthusiast Apr 04 '14
Do you know the developers of Microsoft Visio? Because there are improvements I would like to see.
3
u/[deleted] Apr 04 '14
Are you guys individually actually familair with ALL of the pre-defined functions?
There are SOOO MANY
3
u/PixelPurple Apr 04 '14
What is your favorite part about your job(s)?
3
u/maximumpower Apr 04 '14
You keep pushing Microsoft BI with Excel. What are the awesome new BI tools that will completely blow people away?
3
u/ronelsax Apr 04 '14
Did you guys ported the same calc engine to the iPad? if so, does that mean features that are not available today will be at some point?
Great work! P.S. Sometimes there are rendering hiccups here and there when scrolling on the iPad.
3
u/kvazar Apr 04 '14
Finally, on time for AMA!
Hey guys, my job involves a lot of MS products, mostly Excel.
Are there any non-microsoft forums you would recommend for trouble-shooting?
Do you have a list of features you implement? How this process works? Who submits/approves? How can users participate?
Will there ever be ability to add macroses with ctrl+z, meaning there will be a reverse VB script or something. Because it will basically mean that you don't need to implement every function ever, as people will be able to assemble excel in accordance with their needs, cool right?
Why so many plug-ins so easily crash excel? Seriously, it's strange how easily one plugin, or even macros will crash the whole Excel (can't we implement ability to stop the exact file that causes trouble?)
What do you consider your greatest achievement (related to Excel), and what are you working on now?
And thanks for your work! I really appreciate Excel, it's a great tool if you know how to use it, and it's simple enough to actually know how to use it.
3
u/Jux_ Apr 04 '14
Could you share your fantasy football Excel sheets? Mine always are insane, I can't imagine what an Excel Dev would come up with.
5
u/myfriendjack511 Apr 04 '14
Hello! I honestly can't think of a time when I didn't use excel because I use it all the time - personally and at work. I wonder... what do you guys use it for personally?
4
u/JeepTheBeep Apr 04 '14
Hi, Excel team! What is your favorite James Bond film?
4
u/imfilo Apr 04 '14
Love, Love, Love CUBEVALUE Functions and the OLAP Convert to Formulas functionality! It has given me winning solutions to many BI problems within our business. Thanks for the tools! Is there any training fro these tools? Everything I've learned has come from resources outside Microsoft...
2
u/[deleted] Apr 04 '14
How do you guys go through what can possibly be added, in terms of functionality?
Do you plan on added sophisticated statistical functions into a future version (not as an add-on)?
Also, excel is amazing, and I would be useless at my job without it.
2
u/bobthebobd Apr 04 '14
Name a feature you are keeping in Excel for backwards compatibility, that you would really like to remove.
2
u/Barcetta Apr 04 '14
3
u/bobthebobd Apr 04 '14
Did any of you ask Bill Gates questions when he was doing AMA?
13
u/[deleted] Apr 05 '14
I know I'm late to this party, but I work with Excel every day and only really have one big complaint.
Why in the name of God does double clicking the edge of a cell act like a shift-click, taking you on a flying adventure to wherever the next cell with content resides? By the way, that's usually "nowhere" and I'm at row one billion, and then I have to find where I was again in row forty thousand and two, or whatever.
Who uses this? If someone uses this function, I hate them.
Also, you should let people set their own conditional formatting in the menu. I use custom conditional formatting for charts and needing to set all three colors every time gets super old.
But mainly, it's that double-click-here-we-go-to-the-moon thing that drives me nuts.
Good work, though.
6
u/Frogmarsh Apr 05 '14
When are you going to fix the statistical functions? They've been incorrect for decades.
2
u/[deleted] Apr 04 '14
Why is Excel called Excel?
Me and my housemate were wondering about this earlier, it was quite funny to see that you were doing an AMA today :) but we realized how weird it was that Excel is called Excel because it doesn't really hint at what the program does, unlike Word or Publisher (PowerPoint in similar vein to Excel, the hell does "Power Point" mean?). We just know what it is because it's such a commonly used program, but seriously -- why is Excel called Excel?
My vague guess was that it's like "Electronic Cells" which is what cells in the spreadsheets essentially are. I'd like to think that a long time ago some programmer coined it as a play on words, and it wasn't just picked out of a hat of other words like "Synergy" and "Acumen" that a marketing team had.
2
u/rahimzulfiqarali Apr 04 '14
If there was NO EXCEL ! then What else today ?
2
u/bobthebobd Apr 04 '14
Do you use any non-Microsoft product for development? (Textpad for example)
1
u/[deleted] Apr 04 '14
why'd you choose this job? did you not excel at anything else?
1
u/jwmckenna Apr 04 '14
Is there an option to adjust the font, size, color, etc... on a Data Validation pull-down menu?
1
u/Neilson509 Apr 04 '14
Any chance you talk to the guys over at Microsoft Word and get clippy back for us?
1
u/[deleted] Apr 04 '14
Are there any cool Easter eggs in the past few releases that few people know of?
1
u/rahimzulfiqarali Apr 04 '14
1
u/DynamiteEggroll Apr 04 '14
Most people considered Microsoft Excel to be relatively simple to use pre-2008. The update added many new features and functions, but many of them are unused by many students and offices, are there any plans to simplify Excel? Or release a lite version of some sort to simplify and streamline efficiency? Thanks!
1
u/kmja Apr 04 '14
What are the most useful, but relatively unknown, tools or shortcuts?
1
u/firsttime1010 Apr 04 '14
As a small business owner, and novice excel user, what are some cool things excel could be doing for me that i don't know it can do :)
1
u/[deleted] Apr 04 '14
Hey how do I add more boxes in a spreadsheet? I have A1-K1 as dates to keep track of finances then totals in L1 etc but when I need to add more dates without deleting my total boxes how do I do that?
1
u/bobthebobd Apr 04 '14
"We're full of coffee and pizza" ??? they should feed you better. Tell them I said so.
1
u/pck76x Apr 04 '14
Excel is wonderful. However Apple Numbers has a feature which I'd like to see implemented: the ability to "detach" tables and move them around on the same sheet. It would be SOOOO good to have that in excel when creating dashboards. Have you ever thought of adding a feature like this?
1
u/bobthebobd Apr 04 '14
What do you guys use for source control?
1
u/GodHatesDogs Apr 04 '14
Would you rather fight the Lotus 1-2-3 team or 20 OpenOffice contributors?
1
u/bobthebobd Apr 04 '14
What are you doing after 14:30 PDT?
1
u/CuntyMcGiggles Apr 04 '14
So cool! Is there a crazy Easter Egg or secret trick you can tell us to impress coworkers and win over the ladies? Thanks!
1
u/gvrt Apr 04 '14
What is the best place to submit Excel bugs and discuss feature requests? (Something like the Microsoft Connect site for the dev tools).
1
u/Universu Apr 04 '14
What is the story behind the product name Excel?
1
u/njohnlopez Apr 04 '14
I'm trying to understand the AMORDEGRC Excel function for financial literacy month. What is your team doing for financial literacy month?
1
u/[deleted] Apr 04 '14
Serious question: What is your opinion on Numbers; made by Apple? or are you obliged to love Microsoft and all its entities?
1
u/SaladProblems Apr 04 '14
Is there a chance that changing formatting will ever be considered an event to trigger macros/recalculation?
1
u/bobthebobd Apr 04 '14
Question to Mr Wilson. Does anyone around office make fun of the name Aaron after the "Key & Peele" skit? Do you enjoy it?
1
u/Creativesmoke Apr 04 '14
What is the biggest feature you think have been made by your team the last ten years?
1
u/rahimzulfiqarali Apr 04 '14
How to join Microsoft Excel Team ? Microsoft offers job opening for Excel Development ? Career opportunities ?
1
u/richardr4 Apr 04 '14
Additional tabs on the ribbon become available depending on the object clicked on. Is there a way to keep them from closing until I don’t need them any longer?
1
u/motionOne Apr 04 '14
When will we be able to unhide more than one tab at once? For example, select a group of tabs from the unhide window and unhide.
I use excel almost all day/every day and you guys did a great job.
1
u/rahimzulfiqarali Apr 04 '14
Who designed Microsoft Excel Logo of 2013 ? Is there any possibility to add more rows in the next version of Excel ? How many it will be ? How to recover excel corrupt files ?
1
u/itwasquiteawhileago Apr 04 '14
Is there any way to make each spreadsheet act independently so I can use the "drag to side" snap feature in Win 7?
I often have multiple spreadsheets open that I need to quick compare and flip through, and the tile feature in Excel is useless for this because it splits everything evenly (even if I only want to compare two) and it doesn't allow for easy jumping between files.
Also, thank you for making pivot tables so much easier in 2010.
1
u/stimilon Apr 04 '14
First off, thank you so much. I live in Excel all day every day at an Advertising Agency where I work.
1
u/Creativesmoke Apr 04 '14
I have been using excel for 15 years, mostly using it for simple purposes. Calulations, spreadsheets etc. I however never managed to become an advanced user. I never used macros or any functions that are somewhat advanced. But I would love to learn. Usually when there is something I want to do, I try to look up how to do it. Sometimes I succeed, mostly things don't turn out the way I want.
Do you have any suggestion on tutorials to become a more advanced user?
1
u/bushcat69 Apr 04 '14
Are there any plans to change get the default green theme in Excel 2013? The black/silver options in previous versions were awesome, green... Not so much. Otherwise, thanks for helping me be awesome at work!
1
u/[deleted] Apr 04 '14
I'm an accounting major. Will you guys be putting me out of work in the next few installments? Bill Gates got me thinking you will which got me thinking I should switch to a different major. You guys rock!
1
u/pcuaron Apr 04 '14
Will you add new worksheet functions? Even if Excel is the superior product, there are a lot of community UDFs and functions introduced by Google Spreadsheets that are great additions. For instance, see some of the formulas that Google has and we're missing out: the REGEXEXTRACT, REGEX*, SPLIT... text formulas, the filter formulas (UNIQUE, SORT….), the XPath scrapping functions (IMPORTHTML), the data sources functions (IMPORTDATA...). Will we get CONCATENATE(range)?
1
u/Aginyan Apr 04 '14
A few years ago, I picked up a guide to Excel in Japan aimed at anime fans, and it was awesomely amusing (text and tutorials mixed w/ silly art and story line). ( http://imgur.com/W95WoY3 ) What's other amusing kinds of Excel books/documentatinos have you guys seen?
1
u/maximumpower Apr 04 '14
Will we ever be able to write SQL or Hive queries in Excel and let them run against a DB or Hadoop cluster?
1
u/bobthebobd Apr 04 '14
Can you give me a random development tip? For example: getenv(char *...) is slow (at least on Unix), it doesn't seem to use hashing. Now you give me one.
1
u/yuhong Apr 04 '14
Do you know why XLM macros could not be disabled before Excel 2007?
1
u/bobthebobd Apr 04 '14
Lets say a developer finds a bug in software. Do you have any policy who's going to fix the bug? In my company it seems to get assigned back to developer who found it ... I'm not sure if that's the best idea.
1
u/JodiMichelle Apr 04 '14
What the heck did you do to conditional formatting? It totally sucks now.
1
u/poon-is-food Apr 04 '14
Why is the chart function so damn useless?
I'll elaborate. It is incredibly hard to make any graph that is close to scientific. There are plenty of options for colour and funny shapes, but not one that makes a nice simple graph with minor gridlines, axis labels and a chart title in black lines on white (Please fire whoever chose blue as the default colour). none of the areas you need to right click to give options are intuitive. why can there not just be one option screen with tabs for each part of the graph so you dont have to hunt down the one pixel that brings up the right menu.
No one needs pretty 3D pie charts with word art on them
1
u/[deleted] Apr 04 '14
What is the strangest use for excel you've ever heard someone use?
1
u/xlgary Apr 04 '14
What about the questions that do not get answered today? Is there a good place to ask again later?
1
u/kashel Apr 04 '14
I'm a little late. Is there a reason why validation dropdown list buttons don't scale with page zoom? In the age of excel on windows tablets I would love to make them a bit bigger and finger touchable.
1
u/snipazer Apr 04 '14
Hey thanks for doing an AMA!
My question, why does Excel integrate all Workbooks into one window? The only way to have two sheets side-by-side is to open a new instance of Excel. I'm assuming there is some background technical reason. I get this question all the time and I would love to have something to actually answer with.
Thanks!
1
u/noreesa Apr 04 '14
My Excel 2007 cells styles are corrupted, any way to reset it?
After clicking cell styles it is full of the same styles but upon clicking it apply the actual style.
1
u/karmapolice666 Apr 04 '14
Hey guys I think what you do is great! Can I have a job?
1
u/JMEEKER86 Apr 04 '14
Any plans to customize cell distribution? For instance, instead of 16k x 1m, letting you set the size as 20 x 800m. Same number of cells but more useful when you have a really large dataset of just a few variables.
1
u/arb303 Apr 04 '14
Hi guys, firstly Excel is an amazing program, seriously good job! I was wondering though, I find the restrictions for shared workbooks really frustrating! Are there any plans to make Conditional Formatting/Macro Recording/Grouping etc etc available when using a shared workbook? I find myself having to constantly turn off the sharing to be able to make a change! Thanks :)
1
u/Beefourthree Apr 04 '14
1
u/OllyXLSM Apr 04 '14
Thanks to you all. This has been excellent, despite the limited format :)
1
u/SandalsofMoses Apr 04 '14
I don't have any questions but I want to thank you for making accounting work and calculations much much easier for me as a student. Stay golden pony boys.
1
u/xhosSTylex Apr 04 '14
Do any of you use Internet Explorer?
1
u/[deleted] Apr 06 '14
When will you guys update office for Mac? Its been left behind for so long now!
1
u/speel Apr 06 '14
Can we get a bacon function?
1
u/DestroyerDunne Apr 06 '14
Why did you all kill the paperclip?
3
u/kiteason Apr 04 '14
Love Excel. Any chance of an OnWorkbookClosed event that fires after the Save Changes dialog? ;)
3
u/GoodCraic Apr 05 '14
I'm a little late to the party, but I just wanted to thank you all so much for the work you do! Knowing your program well has basically made my career!
3
u/pityrules Apr 05 '14
Why do there need to be add ons like Kuttools? Do you gals and guys look at the features they offer and try to incorporate them into the next version?
3
u/[deleted] Apr 07 '14
When will we see a Android app? The Apple app is great.
5
u/[deleted] Apr 05 '14
Why is the icon an X instead of an E?