Excel
Conditional formatting can be useful with out-of-range conditions, allowing an alert as data entry is happening.
While there are many ways to fix combined data like “Chicago, IL, 60660,” many are fragile and not suited to connected data sources in a workbook.
If you need the day number within the year for a particular date, subtract 1/1/2020 or the first day of the current year with which you’re concerned. Then add 1.
Whether it’s a speedy way to create a bar chart or a trick for switching from one window to the next, keyboard shortcuts can help even the experienced admin knock out work faster. Here are a few of our readers’ faves:
Time zone math … Workday calculations … Time math overnight
There are three ways to get formulas copied down.
Have two spreadsheets that should be identical, but you want to make sure? Use the Inquire add-in in Excel.
3 shortcuts for named ranges.
Sometimes Excel tries to help us when we wish it wouldn’t.
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.
