Excel

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

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.