Office Technology

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.

Getting calendar data to talk using Export

September 8, 2020 Categorized in: Outlook

Getting control of your precious time begins with understanding how you’re using it now. If you are a G Suite user, you have the ability to take the actual data associated with meetings and appointments and bring it into Sheets (or Excel) to assess 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.

OneNote, three questions

June 1, 2020 Categorized in: InternetOutlook

Which OneNote? … Tags in Windows 10 … Outlook and OneNote
If you like Quick Steps in Outlook for getting multiple steps done in a single click, you can set up buttons other than the ones it sets up for you by default.

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.
Can I save an arrangement of windows to open multiple calendars in Outlook? … What is the multiple desktops feature used for in Windows 10? … Any ideas for quick desktop clean-up?

Windows 10 tricks for small screens

May 4, 2020 Categorized in: Internet

Working with small screens is made so much easier with a few Windows 10 tricks.
From your Outlook 365 calendar, click the New Teams Meetings button in the Ribbon or toggle the Teams meeting switch to the right to schedule an online teleconference or videoconference.

PowerPoint: Give animation a try

May 4, 2020 Categorized in: PowerPoint

Presenting online (without a webcam on you) can be daunting if you’ve only ever presented in person or in print.
Online v. in-person presentations … How does the morph transition actually work?