Wednesday, March 29, 2023

It's all about technology

Do you struggle with formulating Excel spreadsheet equations?.. Microsoft’s new features will help you

Microsoft has announced that it will make Excel’s autocomplete feature smarter, at least in the web version that comes with Microsoft 365 – formerly known as Office 365.

Last week, the company revealed new suggestions for formulating equations that may help automate some of the things the user had to do manually.

To explain the formula suggestions feature we take this example:

If you type the equal sign (=) in a cell, Excel will try to intelligently suggest what type of formula you should use, given the data in the cells around it.

For clarity, let’s take a practical example:

If you have a whole number of quarterly sales figures and a column at the end labeled “Total,” Excel might suggest summing up and summarizing the cells in the column labeled “Total.”

According to a blog post from Microsoft, the feature currently only works in English and will suggest equations for sum, average, number, minimum number, and maximum.

Microsoft is certainly not the first to introduce this feature, as Google Sheets has had a similar feature for a while.

There is an equation fill-in-by-example given feature, and it can detect patterns in the data automatically and fill in the rest of the column.

It is difficult to explain the feature briefly, but this video from Microsoft gives you an idea about this feature. The feature detects the formula’s formatting pattern by collecting information from the cells and then automatically generates the formula’s formula.

The blog notes that the features have been rolled out, however, it is possible that they have not reached all users.

The Microsoft blog post also includes several other feature announcements. There’s a function for adding images with alt text to your tables. Another potentially useful (and easy to understand) feature coming to the web version of Excel is Suggested Links, which will help you fix outdated links. in tables automatically.

Get notified whenever we post something new!

Continue reading

German Regulator Launches Antitrust Review of Microsoft’s Market Power

The German regulator responsible for enforcing antitrust laws is investigating Microsoft's market power, a move that may result in an examination of the tech giant's business practices and potential bans if they are deemed to damage competition

Europol Warns of Criminal Misuse of ChatGPT’s AI Capabilities for Phishing and Disinformation

Europol, the European police force, has expressed concerns about the potential misuse of the chatbot ChatGPT, which is powered by artificial intelligence (AI)

Nvidia’s CTO Claims Cryptocurrencies Are Useless for Society, Advocates for AI Chatbots Instead

According to the chief technology officer of US chip-maker Nvidia, Michael Kagan, cryptocurrencies do not add any value to society. Despite selling a large number of powerful processors to the sector, Kagan said that the development of artificial intelligence chatbots, such as Nvidia's ChatGPT,