Excel

Excel: Try conditional formatting

June 1, 2020 Categorized in: Excel

Conditional formatting can be useful with out-of-range conditions, allowing an alert as data entry is happening.

Fixing combined data in Excel

April 8, 2020 Categorized in: Excel

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.

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.