Excel

Excel dates: Just add 1

March 2, 2020 Categorized in: Excel

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.

Admins’ favorite keyboard shortcuts

February 3, 2020 Categorized in: ExcelWord

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:

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.