Keyboard Shortcuts: Excel
3 shortcuts for named ranges.
Category: Excel
Excel: Organize dates the way you want
Sometimes Excel tries to help us when we wish it wouldn’t.
Office 365: 3 questions about Excel, desktop apps and Track Changes
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?
Import a list of holidays into Excel
If you use NETWORKDAYS or the WORKDAY function, it’s useful to import a list of holidays from TimeandDate.com.
Keyboard Shortcuts: Excel
3 shortcuts for dates and times.
Foolproof project planning in Excel
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.
Excel web queries have changed
Data stored in defined web page tables is now more accessible directly.
Cleaning up dates in Excel
It might take some maneuvering, but you can probably disassemble a file with funky dates, then reassemble it with text functions.
4 ways to string cell contents together in Excel
Two of them are new.
Creating maps in Excel
Did you know that you can create maps from geographically recognizable data in Excel using standard country/region, state/province, county or postal code?