Tag Archives: Excel

The Verge: Microsoft fixes the Excel feature that was wrecking scientific data

Posted on by
Reply

The Verge: Microsoft fixes the Excel feature that was wrecking scientific data. “In 2020, scientists decided just to rework the alphanumeric symbols they used to represent genes rather than try to deal with an Excel feature that was interpreting their names as dates and (un)helpfully reformatting them automatically. Yesterday, a member of the Excel team posted that the company is rolling out an update on Windows and macOS to fix that.”

Wolfram CloudConnector: Excel’s Data Science Superpower (Wolfram Blog)

Posted on by

Wolfram Blog: Wolfram CloudConnector: Excel’s Data Science Superpower. “Wolfram CloudConnector for Excel can transform Excel into a data science powerhouse by injecting Wolfram Language functions straight into your spreadsheets. It does this by providing a connection between Excel and Wolfram Language, extending the computational power of your spreadsheets.”

Ars Technica: Excel esports on ESPN show world the pain of format errors

Posted on by

Ars Technica: Excel esports on ESPN show world the pain of format errors. “The Financial Modeling World Cup (FMWC) hosts regular international competitions, both invitational and open to anyone, in which Excel pros strive to solve as many questions as possible from a complex task. You can download all three of the tasks used in last weekend’s battle for free. ESPN showed a 30-minute edited version of the full two-hour-and-48-minute all-star battle between previous champions.”

Gene Updater: a web tool that autocorrects and updates for Excel misidentified gene names (Scientific Reports)

Posted on by

Scientific Reports: Gene Updater: a web tool that autocorrects and updates for Excel misidentified gene names. “…we developed a web tool with Streamlit that can convert old gene names and dates back into the new gene names recommended by [HUGO Gene Nomenclature Committee]. The web app is named Gene Updater, which is open source…”

ZDNet: Microsoft makes sharing Excel workbooks in Teams happen in real-time with ‘Excel Live’

Posted on by

ZDNet: Microsoft makes sharing Excel workbooks in Teams happen in real-time with ‘Excel Live’. “Microsoft is continuing to make real-time collaboration actually work inside Teams. Its latest effort in this space is called Excel Live. This feature will be available in public preview at the end of August. Microsoft officials announced Excel Live on Day 1 of the company’s annual Inspire partner conference on July 19.”

How-To Geek: Microsoft Is Shutting Down “Money in Excel” (and More)

Posted on by

How-To Geek: Microsoft Is Shutting Down “Money in Excel” (and More). “Microsoft introduced ‘Money in Excel’ back in 2020, which allowed people to connect their financial data to Excel sheets. Now the functionality is being discontinued, alongside a few other Microsoft 365 features.”

PC World: Top Excel experts will battle it out in an esports-like competition this weekend

Posted on by

PC World: Top Excel experts will battle it out in an esports-like competition this weekend. “No, this isn’t a joke. The Financial Modeling World Cup will be held this weekend entirely in Microsoft Excel. And the finals (the quarterfinals, semifinals, and the final match) will all be broadcast live as they happen at 9 AM PT. Everyone’s playing for a total prize of $10,000 — funded by Microsoft, of course.”

How-To Geek: How to Create and Customize a Waterfall Chart in Microsoft Excel

Posted on by

How-To Geek: How to Create and Customize a Waterfall Chart in Microsoft Excel. “If you want to create a visual that shows how positives and negatives affect totals, you can use a waterfall chart, also called a bridge or cascade chart. You can easily create and customize a waterfall chart in Microsoft Excel.”

The Conversation: Excel autocorrect errors still plague genetic research, raising concerns over scientific rigour

Posted on by

The Conversation: Excel autocorrect errors still plague genetic research, raising concerns over scientific rigour. “Autocorrection, or predictive text, is a common feature of many modern tech tools, from internet searches to messaging apps and word processors. Autocorrection can be a blessing, but when the algorithm makes mistakes it can change the message in dramatic and sometimes hilarious ways. Our research shows autocorrect errors, particularly in Excel spreadsheets, can also make a mess of gene names in genetic research.”

MakeUseOf: How to Make a 3D Map in Excel

Posted on by

MakeUseOf: How to Make a 3D Map in Excel. “When visualizing and exploring geographic data, you can use Microsoft 3D Maps in Excel to project and analyze the data in a more meaningful way. Excel includes the Microsoft 3D Maps, a brand new tool to plot 3D charts using geographical data. This tool is available to Excel users from the 2016 version of Microsoft Office. Microsoft 3D Maps tool enables you to explore geodata in a new and effective approach.” You might see the first three numbered paragraphs and think, “Ugh, shallow overview article with no how-to.” Keep going; Tamal Das gets to the good Excel stuff pretty quick.

Neowin: Microsoft Excel on the web is getting version history, multiple range selection, and more

Posted on by

Neowin: Microsoft Excel on the web is getting version history, multiple range selection, and more. “Microsoft announced a bunch of new that are coming to Excel on the web. First up is easier navigation. There’s a new All Sheets button that can take you directly to the worksheet you want in a multiple-worksheet workbook.”

The nightmare is real: ‘Excel formulas are the world’s most widely used programming language,’ says Microsoft (The Register)

Posted on by

The Register: The nightmare is real: ‘Excel formulas are the world’s most widely used programming language,’ says Microsoft. “Microsoft will let users create custom functions in Excel using the number wrangler’s own formula language….Dubbed LAMBDA, the feature (currently rolling out to beta customers) will be a lifesaver for anyone charged with maintaining herds of increasingly complicated spreadsheets, who have doubtlessly been wondering how it could be that Excel was missing such a seemingly obvious ability for so many decades.”

The Verge: Scientists rename human genes to stop Microsoft Excel from misreading them as dates

Posted on by

The Verge: Scientists rename human genes to stop Microsoft Excel from misreading them as dates. “There are tens of thousands of genes in the human genome: minuscule twists of DNA and RNA that combine to express all of the traits and characteristics that make each of us unique. Each gene is given a name and alphanumeric code, known as a symbol, which scientists use to coordinate research. But over the past year or so, some 27 human genes have been renamed, all because Microsoft Excel kept misreading their symbols as dates.”

Analytics Vidhya: 10+ Simple Yet Powerful Excel Tricks for Data Analysis

Posted on by

Analytics Vidhya: 10+ Simple Yet Powerful Excel Tricks for Data Analysis. “I’ve always admired the immense power of Excel. This software is not only capable of doing basic data computations, but you can also perform data analysis using it. It is widely used for many purposes including the likes of financial modeling and business planning. It can become a good stepping stone for people who are new to the world of business analytics.”