Excel

Pivot tables: count vs. sum

August 4, 2021 Categorized in: Excel

One frustrating problem with pivot tables comes when you add a field to the Values layout area expecting a sum, and it gives you a count instead.

Using Excel charts in PowerPoint

August 4, 2021 Categorized in: ExcelPowerPoint

There is no one right way to paste Excel charts into PowerPoint. It depends upon who has access and what they may need to do.
Can you collect information in a single worksheet, and collect all sheets to summarize and analyze without creating two files? … Can a whole worksheet row change font color if I change just one cell?
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.