These are the stocks posting the largest moves before the bell.Market Insiderread more
The Fed cut interest rates by a quarter point, but it also reaffirmed its rate cut was meant to serve as insurance for the economy.Market Insiderread more
Investors are asking how the world's third-largest defense spender could have left itself so vulnerable and what that means for the future.Politicsread more
The presidential campaign is "going to be very tough," the former chief White House strategist.Politicsread more
Gelson's, an upscale grocery store chain with 27 locations across Southern California, will sell 12-ounce packages of the Impossible Burger.Food & Beverageread more
"The market all of the sudden has broken out into a behavior that seems much more rational in September than it did in August," National Securities' Art Hogan says.Trading Nationread more
Huawei launched a new 5G flagship smartphone lineup Thursday without pre-installed Google-licensed apps as the Chinese tech giant faces fallout from a U.S. blacklist earlier...Technologyread more
The Candytopia and Toys R Us partnership will open in late October in Chicago and Atlanta. The exhibits will stay open through the 2019 holidays, before moving on to different...Retailread more
Initially introduced in March 2018, the "Worker Dividend Act" requires firms to distribute the value of its stock buybacks dollar-for-dollar.2020 Electionsread more
A spokesperson for Sen. Mark Warner, D-Va., said he helped organize the dinner in D.C. at the request of Facebook.Technologyread more
No matter what changes Microsoft makes to its software or how much fresh competition it faces across its suite of products, one thing remains true: spreadsheet junkies use Excel.
Shipped for the first time 34 years ago, Excel is the default product used for entering data and performing calculations, and it's continued to be a key piece of Microsoft Office, which is still a huge revenue driver at the company.
So when Microsoft announces one of its biggest Excel updates in years, no matter how wonky, power users start chattering. On Wednesday, Microsoft introduced a feature called XLOOKUP, which was designed to address some of the shortcomings of one of Excel's most popular features, VLOOKUP.
Since releasing version 1.0 of Excel for Macintosh in 1985, the software included VLOOKUP to help users carry over information from one part of a spreadsheet to another. According to a Microsoft blog post on Wednesday, it was the third most-used function, after SUM and AVERAGE. The V stands for vertical, a reference to the function's ability to retrieve information in vertical columns. A similar function called HLOOKUP works with data that's in horizontal rows.
VLOOKUP had some notable limitations. Results defaulted to an approximate match of what the user was looking for, instead of the exact match. XLOOKUP fixes that.
Also, VLOOKUP could only spit out data that's to the right, and not to the left, of the reference column, so users would often have to rearrange their data to use the function. With XLOOKUP, users can draw on data that's to the left or right, and it combines VLOOKUP and HLOOKUP into a single function.
Joe McDaid, Excel's senior program manager, told CNBC by email that to get around VLOOKUP's constraints, advanced users would turn to a combination of other functions, INDEX/MATCH, but they can be complex for most people to use.
XLOOKUP is "more powerful than INDEX/MATCH and more approachable than VLOOKUP," McDaid wrote.
The change received some praise on Twitter.
Rhett Weller, a senior finance manager at Cisco, uses Excel to help predict revenue. He's looking forward to using XLOOKUP. It's currently only in beta with limited access for some people in the Microsoft Office 365 Insider program. Microsoft will release it more widely in the next few weeks.
"It's just a simple formula with a simple array lookup that anybody can use," Weller said in an interview after the update was announced. "It's pretty exciting."
Correction: A previous version of this story had a typo in the date of Excel's initial release. It was 1985.