What email address or phone number would you like to use to sign in to Docs.com?
If you already have an account that you use with Office or other Microsoft services, enter it here.
Or sign in with:
Signing in allows you to download and like content, and it provides the authors analytical data about your interactions with their content.
Embed code for: Excel Keynote GTC 2015
Select a size
Excel is 30 ... let's celebrate the past and talk about the future ! Come hear interesting "behind the scenes" stories. Understand what separates Excel and plans for the future.
Excel Past and Future
Principle PM Manager, Excel
East Façade 1664
Laid down in 12th century (800+ years old)
Multi-use: fortress, hunting lodge, palace, 2nd home, artist commune, museum, educational institution
Dozens of architects
Thousands of construction workers
Coherency of design
One of most important buildings in France
Most visited building in the world
A Unique and Flexible Tool
Customers Do Amazing Things
Cancer, Excel, and Machine Learning
Games + Art
Pepperoni? Cheese? Or…
Customer Segments - Simplified
Now multiply these by 650+ million users
Just scan spreadsheets
Layout reports of data, printing
Lists / tables of data
Sorting, Filter, Fill
Simple formulas & aggregations (calculator)
Deeper data analysis
More than aggregations
Everything Excel can do
How Many Workbooks Have…
Any Freeze Panes?
Any Merged Cells?
Have No Sheets?
So, about the Louvre…
Excel was laid down 30 yrs ago, added to over time
Multi-use: spreadsheet, visual programming tool, platform, simulation tool, web application, business intelligence tool,
Many PMs, engineers
One of most important pieces of software in the world
Most visited spreadsheet/analytical tool/platform
Act I: Birth of Excel
VisiCalc - 1979
First VisiCalc software package, for Mac 1979
Cover of VisiCalc Model I manual for TRS-80, released September 1980
VisiCalc in Action
Multiplan 1.06 for DOS
Multiplan advertisement from May 1983 BYTE
Manual for Multiplan
Lotus 1-2-3 (1983)
Lotus 1-2-3 1.0 front of box
Lotus 1-2-3 v1A back of box
Lotus 1-2-3 3.0 for MS-DOS
Okay, we’ll let them dominate the DOS-character world. We are going after Mac and Windows. We are going to be a generation ahead.
Steve Jobs and Bill Gates at the Excel 1.0 announcement in 1985
Excel 1.0 for Mac
Excel 1.0 for Apple
Excel 2.1 for Windows
1988: Revenue Share of Spreadsheets
Lotus was the “Killer Spreadsheet”
Act II: The 90’s – Win at Spreadsheets
graphical user interface
Fast Auto Recalc – only the cells that needed it
Ease of use + tight integration between features
Pivot tables in the box
Automation and extension: macro record and add-ins.
Lotus 1-2-3 vs. Excel
I asked him what this program was, and he said it was Excel, a spreadsheet product from Microsoft that was a direct competitor to Lotus. I watched him work for about a minute, maybe less, and the first thought that came to my mind was: “Lotus is toast.” It was as if I’d been chiseling a message into a rock and someone walked over with a sketch pad and a fancy rollerball pen.
There are plenty of lessons here for software companies. Lotus got complacent. They stopped innovating, or fiddled while Rome burned, or made stupid decisions … This is one of relatively few cases where a software product with essentially no competition simply vaporized. Amazing.
GUI Platform Shift
Deep Feature Integration
Ease of Use
Built in Pivots and Charts
Fun “Firsts” in Excel
Act III: The 2000’s – BI
Better conditional formatting
Core BI: OLAP, Pivots, Slicers, Timeline, Power*
More spreadsheet features (CF, Big Grid, Easier Pivots, etc)
#2 in measured by BI revenue
MSFT BI most likely stack to be deployed
Leader in Gartner Magic Quadrant
As of 2015…
Act IV: The Modern Era…
Data is everywhere…
1251 Unread emails
Work Anywhere, On Any device…
…with Seamless Collaboration
Coauthoring and Collaboration
How do we decide what’s next?
Ongoing Site Visits + Research
Events and Conferences
Direct Feedback Channels
In Product Surveys
Excel User Voice
In Product Comments
Hypothesis Driven Development
Is a unique and important software tool
Customers build creative and inspiring solutions
Help us continue that story into the modern era…
© 2014 Microsoft Corporation. All rights reserved. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.
Began life as a fortress in the 12th century
Charles the V converted it into a residence.
Renovated in the French renaissance style
Louis XIV chose Versailles as his residence in 1682, the move permitted the Louvre to be used as a residence for artists.
Paris was too stinky!
By mid 18th century there were public calls to use it as a gallery.
Using it as a museum/art display became policy during mid 18th century.
During the revolution it truly became a public museum. In 1792 King Louis was imprisoned and his art collection became national property. Eventually his head was cut off.
Eventually the finance ministry would be housed there as well.
It’s a beautiful mix of embracing change and the future while integrating it into its core/roots
From Nick a past ModelOff attendee (sent to Johann in email – Johann guaranteed Nick gave permission to use this)
This is based on win32 data for early O16 deployments
30 days of books opened, representing about 17 million distinct and unique workbooks – only a small subset of some of the early adopters with a mix of many users/verticles. These are just counts of #of items in the workbook on workbook open where each unique workbook is counted only once. These aren’t counts of users or total books opened.
Back in 1985, I vividly remember visiting my sister while she was busy at work for a luxury car dealer as an accountant. Prior to them using computers, all accounting-related functions were done manually using pen, calculator, and large sheets of ledger paper. As I approached her office, I could see several rows of accounts clerks heads down, writing and punching away on their oversized calculators. Fast forward one year, and when I visited my sister they had several shared computers loaded with some program called Excel.
Wasn’t Excel, it was actually multiplan….
Visicalc– founded by Harvard MBA, quickly taken over by Lotus. Changed accounting and analysis completely– summing a column of numbers was once an issue, now people could do dramatically different things with what if analysis. Also had a GOTO feature.
255 rows by 63 columns, could reference multiple worksheets!
Visicalc" by User:Gortu - apple2history.org. Licensed under Public Domain via Commons - https://commons.wikimedia.org/wiki/File:Visicalc.png#/media/File:Visicalc.png
Quote from gates:
“Multiplan, targeting the 8-bit machines instead of just relying on the next generation to come, the IBM PC generation, that was a huge error. When we talk about, “Are we aiming too low, in terms of system requirements, we often think, is this another case like Multiplan?”
256 X 16384
$395 + $100 for MS Chart
Excel 2 under 600k
Analysis & Pivot tables were a factor. Lotus decided not to put them in the box with Lotus 1-2-3.
Innovation, we can be on the other side of this story if we stop.
Here, Excel began to differentiate with new features targeted at Business Intelligence– organizing, analyzing and generally making sense of large amounts of business data.
Big grid– 1,000,000 rows
Excel services– can share visualization and BI dashboards on the web
These images are fake – new functions won’t have those names
New Functions, new connectors, deeper integration with Power BI, new data visualizations
We’re thinking deeply about emerging trends and platforms….VR and AR is one example
Surface Hub is another example – we’re looking at both long term and short term needs/trends
We’ve only scratched the surface with phones. Services are a rich opportunity too – Machine Learning, Natural Language, Digital assistants are just a few examples of interesting areas
© 2014 Microsoft Corporation. All rights reserved. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.come, the IBM PC generation, that was a huge error. When we talk about, “Are we aiming too low, in terms of system requirements, we often think, is this another case like Multiplan?”
© 2014 Microsoft Corporation. All rights reserved. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, A