Excel

Whether or not it should work this way, it does.

Learning formulas from formulas

March 3, 2021 Categorized in: Excel

Studying books and help text is one way to learn formulas. Another: Ask the formula!

Instead of copy/paste in Excel, try this

March 3, 2021 Categorized in: Excel

Copying and pasting doesn’t always produce the results we need and can take a lot of clicking and dragging.
The error could be the result of a number of circumstances.

Keyboard Shortcuts: Excel

October 11, 2020 Categorized in: Excel

3 shortcuts for selecting cells, working in multiple workbooks and activating Quick Analysis options.
If the Excel icon appears in the Windows taskbar, right-click it.

Simple ways to ensure accuracy in Excel

September 8, 2020 Categorized in: Excel

Accuracy is the responsibility of each person producing reports to support business decisions. Now that there is a sense of accountability, it’s knowing the tools that can help.

Excel: This makes no sense!

August 4, 2020 Categorized in: Excel

Troubleshooting 3 problems in 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