Blog

Microsoft Excel Adding Useful Features For Developers

Nov 17, 2021 | Blog

There’s great news in your immediate future if you’re one of the legions of Excel users. Recently Microsoft made some behind the scenes changes to the venerable spreadsheet application that allows developers to code their own custom data types for use inside the program. The upgrade isn’t aimed at business executives but rather at developers who need to incorporate metadata into Excel cells.

Excel is very good at organizing text and numeric values and since the earliest days of the application that has always been enough. As time has passed and technology has advanced needs began changing. These days users need to be able to do more than just sort, parse, and organize text and numbers.

During the 2020 Ignite Conference the company showed off how the expanded capabilities could be used. It can be used by introducing dynamic arrays and array formulae along with support for Geography and Stock data types via the search engine Bing.

Not long after the company expanded their number by incorporating Wolfram data types. If you’re unfamiliar with them, Wolfram data types are a science-focused search engine.

The company had this to say about Excel’s expanded capabilities:

“Countless solutions have been built with Excel. Many of these solutions are powered by cells that most often contain (or evaluate to) just text or numbers.

With the addition of data types, Excel has evolved to a world where cells can contain something much richer. Linked data types (Stocks, Geography, Wolfram and Power BI) entity values, dynamic arrays, improved errors, images in cells, lambdas, and formatted number values are all new types that have delivered on this promise and back many of the experiences you have seen introduced in the product today.”

That humble spreadsheet application you’ve come to rely on is capable of doing a lot more than you may have realized. It has additional capabilities well worth exploring that could add tremendous value to your company whatever business you’re in.

FBI Program Tasked with Infrastructure Security Compromised

FBI Program Tasked with Infrastructure Security Compromised

The FBI program tasked with ensuring critical infrastructure security has been compromised by hackers, who now offer access to the program's data on the dark web. The breach was initially disclosed by Brian Krebs of Krebs on Security, who claims that the data was for...

Streamline Your Business with the Latest Smart Home Technology

Streamline Your Business with the Latest Smart Home Technology

Are you a business owner looking to get the most out of your Google smart home devices? If so, you're in luck! Google has enabled its Nest products and Android OS with the initial rollout of the Matter smart home standard. This means that businesses now have the...

Data Breach at Sequoia One Exposes Sensitive Customer Information

Data Breach at Sequoia One Exposes Sensitive Customer Information

What do you do when your most personal information has been compromised? This is likely the question that customers of Sequoia One asked themselves earlier this month as they were informed that the company had been hacked. Sequoia One specializes in the management of...

Cisco Reports Critical IP Phone Vulnerability

Cisco Reports Critical IP Phone Vulnerability

As a business owner, it's important to stay informed about potential vulnerabilities that could impact your organization. Recently, Cisco reported a critical vulnerability, tracked as CVE-2022-20968, affecting its IP Phone 7800 and 8800 Series. This new vulnerability...

Google Chrome Releases Two New Features

Google Chrome Releases Two New Features

Google Chrome is one of the more commonly used web browsers. Over the years, though, Chrome has gained a reputation for utilizing a large portion of a computer's memory. This can be a problem if you're running other resource-intensive tasks and don't want to slow...

Get a Free Consultation

 

Fill out the form below to receive a free consultation and learn how we can make your technology worry-free!

 

Contact Information

  • 39301 Badger Street, Suite 500
    Palm Desert, CA 9221
  • (760) 333-8523
  • info@icn.tech