Office Technology

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?
Before you show how to do a screen operation, click the Screen Recording button.
Whether or not it should work this way, it does.

Handling paste problems in Word

April 7, 2021 Categorized in: Word

Collaboration is great! But you may end up with 10 documents to combine into one, while everyone has approached formatting differently.

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.

2 questions about videos in PowerPoint

March 3, 2021 Categorized in: PowerPoint

How can I get rid of the screen recording toolbar from videos I record in PowerPoint? … Can I use YouTube videos in my PPT presentations?

3 quick tips for Outlook users

February 3, 2021 Categorized in: Outlook

Staying on track with email … Goal-minding with Tasks … Creating contacts from email

Animating diagrams in PowerPoint

January 6, 2021 Categorized in: PowerPoint

If you’ve created a SmartArt diagram in your PowerPoint presentation, you can animate it. The process requires a little patience to see the end result.

Why are my pages breaking in Word?

January 6, 2021 Categorized in: The Office Tech ProWord

Q. Pages are breaking after a topic title, leaving its text on the next page. What am I doing wrong?
Instead of using signatures to create email “templates” in Outlook, use Quick Steps.