We are pleased to hear that there is new update to Power Query (PQ) in Excel for Mac – the ability to import data from local files, coming on the back of being able to refresh data from, er, about this time, last year. Tempus fugit indeed!
This month’s updates include a new Preview of visual ToolTips, an ability to quickly create reports from SharePoint lists and an update on sensitivity labels so that they are now inherited “downstream”.
Microsoft Office now displays a list of recommended files on the File tab, or start page, of Word, Excel, or PowerPoint on Windows. This list allows you to keep track of work around you and quickly access files with activity you value most such as edits, mentions, comments by people you interact with.
Talk about stirring up a hornet’s nest! After a gazillion years of asking Microsoft to do this, finally, the software giant has made Excel users lives just a little easier with the ability to unhide multiple hidden sheets at the same time.
What!? Not Excel or Power BI!? I have to mention this piece of news, because this – if it works (caveat, caveat) – will be brilliant. With Office Insiders, you can now transform Word documents into PowerPoint presentations.
If you have grown up with Excel, you may have become mentally scarred over the years with Excel’s past (in)ability to share workbooks. Recently, Microsoft has revamped this in line with its priorities to emphasise accessibility and collaboration.