3 questions about time and dates in Excel

January 6, 2020 Categorized in: Excel

Time zone math … Workday calculations … Time math overnight

Excel: 3 ways to get formulas copied down

January 6, 2020 Categorized in: Excel

There are three ways to get formulas copied down.

Compare two spreadsheets in Excel

December 3, 2019 Categorized in: Excel

Have two spreadsheets that should be identical, but you want to make sure? Use the Inquire add-in in Excel.

Keyboard Shortcuts: Excel

October 7, 2019 Categorized in: Excel

3 shortcuts for named ranges.

Excel: Organize dates the way you want

July 2, 2019 Categorized in: Excel

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?

Import a list of holidays into Excel

May 6, 2019 Categorized in: Excel

If you use NETWORKDAYS or the WORKDAY function, it’s useful to import a list of holidays from TimeandDate.com.

Keyboard Shortcuts: Excel

April 1, 2019 Categorized in: Excel

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.

Excel web queries have changed

March 4, 2019 Categorized in: Excel

Data stored in defined web page tables is now more accessible directly.

Cleaning up dates in Excel

February 5, 2019 Categorized 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

December 3, 2018 Categorized in: Excel

Two of them are new.

Creating maps in Excel

September 4, 2018 Categorized 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?