Office Technology

3 questions about time and dates in Excel

January 6, 2020 Categorized in: Excel

Time zone math … Workday calculations … Time math overnight
Press the Windows button and just start typing the name of the file or app you want.
Quickly clean up your email with these three simple techniques.

Excel: 3 ways to get formulas copied down

January 6, 2020 Categorized in: Excel

There are three ways to get formulas copied down.

Microsoft Word: Get the picture?

January 6, 2020 Categorized in: Word

Diagrams, pictures, charts and graphs can clarify your message, support your case and help visual learners to understand the information. Here is how to get them in there, make them look crisp and clear, and get them to stay put.

PowerPoint: Clean up layouts in a template

December 3, 2019 Categorized in: PowerPoint

If you’re working with a “template” that seems to have every type of layout under the sun, but you only use a handful of them, click on the View tab in the Master Views group and choose Slide Master.

Turn text into speech in Word

December 3, 2019 Categorized in: Word

Sometimes, it’s just easier to catch an error when you read aloud. If that’s not practical where you work, put on a pair of headphones, and click the Read Aloud button.

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.

PowerPoint tips for live presentations

December 3, 2019 Categorized in: PowerPoint

PowerPoint has some clever built-in tools to help you deal with inevitable out-of-sync moments with grace and style.

3 Outlook conundrums, solved

October 7, 2019 Categorized in: Outlook

What kind of access do I need to manage someone else’s calendar? … My IT folks won’t let me set up a meeting with no end date. How can I override or work around this? … Can I export a task list from Outlook to Planner?

Keyboard Shortcuts: Excel

October 7, 2019 Categorized in: Excel

3 shortcuts for named ranges.

Word: Manage, restore and compare document versions

September 3, 2019 Categorized in: Word

Each time a document is changed and saved in either OneDrive or SharePoint, either by using the Save action or allowing AutoSave to do the job, another version of the document is created.

Embedding workbooks in PowerPoint

September 3, 2019 Categorized in: PowerPoint

If you just copy data from Excel to PowerPoint, it will simply paste a table into PowerPoint that neither links it to the original data nor pastes an Excel object.