Excel
Why are some Excel features greyed out in Office 365? … I miss my desktop apps … Is there a way to keep people from turning off Track Changes?
If you use NETWORKDAYS or the WORKDAY function, it’s useful to import a list of holidays from TimeandDate.com.
3 shortcuts for dates and times.
One of the things that great project management apps do is calculate project and task start and due dates based on a project start date and task durations. You can also do this in good old Excel or Google Sheets.
Data stored in defined web page tables is now more accessible directly.
It might take some maneuvering, but you can probably disassemble a file with funky dates, then reassemble it with text functions.
Two of them are new.
Did you know that you can create maps from geographically recognizable data in Excel using standard country/region, state/province, county or postal code?
There are many tools to help you squeeze information out of your data, but it needs to be in the right shape.
In the newest version of Excel, you may have noticed the “data model.” This allows you to connect multiple datasets and analyze them as one.
Keeping minutes; find/replace; formatting
The Conditional Formatting tool on the Home tab, Cell Styles group offers something called Highlight Duplicate Values. Before you start jumping for joy, it really means values, not rows.
Q. Is there an easier way to create a formula across work sheets than clicking on each cell you want to add to the formula?
