Microsoft Excel

« Back to Glossary Index

Microsoft Excel Features and Functions
– Developed by Microsoft for Windows, macOS, Android, iOS, and iPadOS
– Offers calculation and computation capabilities
– Includes graphing tools
– Supports pivot tables
– Features a macro programming language called Visual Basic for Applications (VBA)
– Excel 2016 has 484 functions
– 360 functions existed prior to Excel 2010
– Functions are classified into 14 categories by Microsoft
– 386 functions can be called from VBA as methods of the object WorksheetFunction
– 44 functions have the same names as VBA functions

Macro Programming with VBA
– VBA programming allows spreadsheet manipulation that is awkward or impossible with standard techniques
– VBA code is written using the Visual Basic Editor (VBE)
– VBA code can automate tasks like formatting and data organization
– VBA code interacts with the spreadsheet through the Excel Object Model
– VBA was removed from Mac Excel 2008 but restored in Mac Excel 2011

Charts and Graphs
– Excel supports charts, graphs, and histograms generated from specified groups of cells
– Pivot Charts can be linked directly to a Pivot table for dynamic updates
– Charts can be embedded within the current sheet or added as separate objects
– Charts can assist in visualizing design requirements and selecting the best design
– Excel also supports the creation of dynamic and interactive charts

File Formats in Microsoft Excel
– Excel is backwards-compatible with traditional binary formats
– Most versions of Excel can read CSV, DBF, SYLK, DIF, and other legacy formats
– Support for some older file formats was removed in Excel 2007
– has created documentation of the Excel format
– Two epochs of the format exist: the 97-2003 OLE format and the older stream format
XML Spreadsheet format was introduced in Excel 2002
– It is a simple, XML-based format missing some advanced features like storage of VBA macros
– The intended file extension for this format is .xml, but it also handles .xls files correctly
– Excel 2007 introduced new file formats
– The default format is .xlsx, a ZIP compressed archive with XML text documents
– .xlsx is the primary replacement for the former binary .xls format
– .xlsm is an Excel Macro-enabled Workbook with macro support
– .xlsb is an Excel Binary Workbook that stores information in binary form for faster document handling
– .xls is the main spreadsheet format that holds data, charts, and macros
– .xla is an add-in (VBA) that adds custom functionality
– .xlb is the file extension for custom toolbar settings
– .xlc is a chart created with data from an Excel spreadsheet
– .xld is used in older versions of Excel

Using Excel with Other Applications and External Data
– Windows applications like Access, Word, and Excel can communicate and use each other’s capabilities
– Dynamic Data Exchange (DDE) is a common method to send data between applications on Windows
– OLE Object Linking and Embedding allows one application to control another for formatting or calculating data
– Financial markets often use DDE to connect to important financial data services
– Applications can be embedded in each other, like a PowerPoint presentation embedded in an Excel spreadsheet
– Excel users can access external data sources through Office features like .odc connections
– Excel can accept real-time data through programming interfaces and add-ins like Power Plus Pro
– Dynamic Data Exchange (DDE) allows data flow between Excel and other applications
– Network DDE extended the protocol to exchange data between spreadsheets on different computers
– Real Time Data (RTD) is technically superior to DDE but has been slow to gain acceptance
– APIs have been developed to open Excel spreadsheets in various applications and environments
– ActiveX controls and plugins like Adobe Flash Player can open Excel documents on the web
– The Apache POI project provides Java libraries for reading and writing Excel spreadsheet files.

Microsoft Excel (Wikipedia)

Microsoft Excel is a spreadsheet editor developed by Microsoft for Windows, macOS, Android, iOS and iPadOS. It features calculation or computation capabilities, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications (VBA). Excel forms part of the Microsoft 365 suite of software.

Microsoft Excel
Initial releaseNovember 19, 1987; 36 years ago (1987-11-19)
Stable release
2309 (16827.20130) / September 28, 2023; 3 months ago (2023-09-28)
Written inC++ (back-end)
Operating systemMicrosoft Windows
Microsoft Excel for Mac
Initial releaseSeptember 30, 1985; 38 years ago (1985-09-30)
Stable release
16.70 (Build 23021201) / February 14, 2023; 10 months ago (2023-02-14)
Written inC++ (back-end), Objective-C (API/UI)
Operating systemmacOS
LicenseProprietary commercial software
Microsoft Excel for Android
Developer(s)Microsoft Corporation
Stable release
16.0.16501.20160 / May 26, 2023; 7 months ago (2023-05-26)
Operating systemAndroid Pie or later
LicenseProprietary commercial software
Microsoft Excel for iOS and iPadOS
Developer(s)Microsoft Corporation
Stable release
2.73 / May 15, 2023; 7 months ago (2023-05-15)
Operating systemiOS 15 or later
iPadOS 15 or later
LicenseProprietary commercial software
« Back to Glossary Index

Submit your RFP

We can't wait to read about your project. Use the form below to submit your RFP!

Gabrielle Buff
Gabrielle Buff

Just left us a 5 star review

Great customer service and was able to walk us through the various options available to us in a way that made sense. Would definitely recommend!

Stoute Web Solutions has been a valuable resource for our business. Their attention to detail, expertise, and willingness to help at a moment's notice make them an essential support system for us.

Paul and the team are very professional, courteous, and efficient. They always respond immediately even to my minute concerns. Also, their SEO consultation is superb. These are good people!

Paul Stoute & his team are top notch! You will not find a more honest, hard working group whose focus is the success of your business. If you’re ready to work with the best to create the best for your business, go Stoute Web Solutions; you’ll definitely be glad you did!

Wonderful people that understand our needs and make it happen!

Paul is the absolute best! Always there with solutions in high pressure situations. A steady hand; always there when needed; I would recommend Paul to anyone!

Vince Fogliani

The team over at Stoute web solutions set my business up with a fantastic new website, could not be happier

Steve Sacre

If You are looking for Website design & creativity look no further. Paul & his team are the epitome of excellence.Don't take my word just refer to my website ""that Stoute Web Solutions created.This should convince anyone that You have finally found Your perfect fit

Jamie Hill

Paul and the team at Stoute Web are amazing. They are super fast to answer questions. Super easy to work with, and knows their stuff. 10,000 stars.

Paul and the team from Stoute Web solutions are awesome to work with. They're super intuitive on what best suits your needs and the end product is even better. We will be using them exclusively for our web design and hosting.

Dean Eardley

Beautifully functional websites from professional, knowledgeable team.

Along with hosting most of my url's Paul's business has helped me with website development, graphic design and even a really cool back end database app! I highly recommend him as your 360 solution to making your business more visible in today's social media driven marketplace.

I hate dealing with domain/site hosts. After terrible service for over a decade from Dreamhost, I was desperate to find a new one. I was lucky enough to win...

Paul Stoute has been extremely helpful in helping me choose the best package to suite my needs. Any time I had a technical issue he was there to help me through it. Superb customer service at a great value. I would recommend his services to anyone that wants a hassle free and quality experience for their website needs.

Paul is the BEST! I am a current customer and happy to say he has never let me down. Always responds quickly and if he cant fix the issue right away, if available, he provides you a temporary work around while researching the correct fix! Thanks for being an honest and great company!!

Paul Stoute is absolutely wonderful. Paul always responds to my calls and emails right away. He is truly the backbone of my business. From my fantastic website to popping right up on Google when people search for me and designing my business cards, Paul has been there every step of the way. I would recommend this company to anyone.

I can't say enough great things about Green Tie Hosting. Paul was wonderful in helping me get my website up and running quickly. I have stayed with Green...