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?

Excel: Shape up your data

July 2, 2018 Categorized in: Excel

There are many tools to help you squeeze information out of your data, but it needs to be in the right shape.

Connecting datasets in Excel

May 7, 2018 Categorized in: Excel

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.

Microsoft Office Notes: May ’16

May 1, 2016 Categorized in: Excel

Keeping minutes; find/replace; formatting

Excel: Spot duplicate rows

December 6, 2015 Categorized in: Excel

The Conditional Formatting tool on the Home tab, Cell Styles group offers something called Highlight Dupli­­cate Values. Before you start jumping for joy, it really means values, not rows.