Office Technology – Page 8 – Administrative Professional Today

Use OneNote for calls to action

November 3, 2021 Categorized in: Outlook

If you’ve got OneNote Windows 10 or OneNote Desktop (2016), you should see a OneNote icon in Outlook, on the Home tab, in the Move group in the ribbon. Click it to select the notebook, section and page on which you want it to appear.

Using different currencies in Excel

November 3, 2021 Categorized in: Excel

Q. My settings in Excel always give me $ signs for currency, but I often have to work in £ and €. Is there an easy one-click way to change the currency symbols?

Managing Outlook for an executive

October 6, 2021 Categorized in: Outlook

How can I keep people from scheduling directly on my executive’s calendar? … How can I keep my executive’s email messages pinned to the top of my list?

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: Excel, PowerPoint

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.

Excel worksheets: Collecting and highlighting data

July 7, 2021 Categorized in: Excel

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?