Tag Archives: Microsoft 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.”

Lifehacker: Make AI Do the Hard Parts of Spreadsheets for You

Posted on by

Lifehacker: Make AI Do the Hard Parts of Spreadsheets for You. “AI is coming to your spreadsheet apps from the top-down: Microsoft is currently testing Copilot, its AI-integration assistant, in all of its Microsoft 365 apps. Google is working on integrating AI tool to Sheets, starting with Workspace accounts over the next few months. However, these tools aren’t here yet, so we currently need to rely on third-party creations to add a little artificial intelligence to our workflow.”

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.”

MakeUseOf: How to Input Data Into Excel Spreadsheets Using Your Phone’s Camera

Posted on by

MakeUseOf: How to Input Data Into Excel Spreadsheets Using Your Phone’s Camera. “Your phone camera can do much more than just take and edit selfies. You can use it to scan QR codes, search for photos on Pinterest, or identify anything using advanced image recognition technology. But did you also know that you can use your phone camera to input data into your Excel spreadsheets? This simple but powerful technique can save you time and improve your productivity with sheets.”

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.”

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.”

BetaNews: Millions of Microsoft Excel users vulnerable to remote DDE attack as new exploit is discovered

Posted on by

BetaNews: Millions of Microsoft Excel users vulnerable to remote DDE attack as new exploit is discovered. “Security researchers from Mimecast Threat Center have discovered an Excel exploit that could leave 120 million users vulnerable to attack. The security flaw means that it is possible to use Excel’s Power Query tool to dynamically launch a remote Dynamic Data Exchange (DDE) attack on a spreadsheet and actively control the payload.”

Search Engine Journal: 11 Places You Can Learn Microsoft Excel for Free

Posted on by

Search Engine Journal: 11 Places You Can Learn Microsoft Excel for Free . “You don’t have to attend formal classes at a university to get a grip on Excel. There are numerous free resources available that let you learn the program from the comfort of your home. So, put on your favorite ‘Netflix and chill’ outfit, grab a snack or a tasty beverage, and prepare to understand Excel like you never have before thanks to these 11 places where you can learn Microsoft Excel for free.”

MakeUseOf: How to Convert Delimited Text Files to Excel Spreadsheets

Posted on by

MakeUseOf: How to Convert Delimited Text Files to Excel Spreadsheets. “You don’t want to be the guy in the office who has to type everything into Microsoft Excel time and time again. So, there will come a time when you must deal with all sorts of information stored in other kinds of files and bring it into Excel. You cannot run away from an ever-present text file.”

NoCode Webscraping: How to extract Twitter tweets data and followers to Excel

Posted on by

From NoCode Webscraping: How to extract Twitter tweets data and followers to Excel. “In this tutorial,I will show you how to extract or scrape Twitter data such as tweets and followers to excel using ready made Python scripts.I will also show you how to download photos and videos by a #hashtag or search query.I will use both the REST API and the streaming API.Lastly,I will use Quintly to download tweets to Excel (no programming involved).”

Excel Blamed for Errors in Gene Studies

Posted on by

Microsoft is being blamed for errors in gene studies. “Microsoft’s Excel has been blamed for errors in academic papers on genomics. Researchers trying to raise awareness of the issue claim that the spreadsheet software automatically converts the names of certain genes into dates.” I wonder if Gnumeric does this? It is my spreadsheet of choice.