Now you can unhide multiple sheets at once, thanks to the latest Excel software update.
Unhide multiple worksheets at once
News Sheet
Introducing the LAMBDA function
Now you can define your own re-usable functions with LAMBDA
XLOOKUP and XMATCH: a new lookup to rule them all (almost)
Tired of arguing the relative merits of VLOOKUP or INDEX/MATCH? Well, now there's a new one to add. XLOOKUP is here to be a quicker, smarter VLOOKUP and XMATCH overhauls MATCH. Read on for details!
New Excel function LET
LET lets you name parts of your formulas! This is one of those features that has more power than we might first realize; chances are its use will increase dramatically over time as its utility becomes more obvious.
STOCKHISTORY function
Use the STOCKHISTORY function to easily pull stock price data and history.
Create Visio diagrams
Create Visio diagrams using the new Data Visualizer add-in for Excel.