OTS Blog

AutoSum Multiple Rows and Columns

AutoSum Multiple Rows and Columns

Work smarter, not harder! Excel Tip – AutoSum Multiple Rows and Columns Many Excel users are familiar with the AutoSum feature but may not realize the power behind the button! Use this tip to sum multiple rows and columns with a…

Copy and Paste using Drag and Drop

Copy and Paste using Drag and Drop

Office Tip – Copy and Paste Using Drag and Drop When you want to copy data from one place to another, we often use the Windows Clipboard or the Office Clipboard. The Windows clipboard is unseen but can be utilized…

Repeat the Last Action in Word

Repeat the Last Action in Word

Work smarter, not harder! Word tip – Microsoft offers a repeat last action command that works in many Word scenarios. It’s especially helpful with common commands like applying formatting, but can also be used for actions such as inserting page breaks. For…

Create a PowerPoint Handout in Word

Create a PowerPoint Handout in Word

Work smarter, not harder! PowerPoint tip – Create a PowerPoint handout in Word. As a PowerPoint presenter, we often distribute handouts to our audience to use during the presentation for reading or note-taking. PowerPoint offers some options for printing the handouts…

Create a Quick Excel Chart

Create a Quick Excel Chart

Work smarter, not harder! Excel tip – Create a chart on a separate worksheet with a simple keystroke! Example: You have data in Excel you would like to illustrate in a chart. Charts are great, but sometimes take a long time to…

Create a Contact From an E-Mail

Create a Contact From an E-Mail

Work smarter, not harder! Outlook tip – Quickly add the sender of a message to your Contacts list! Example: You have received an e-mail from someone you would like to contact in the future and you want to add them to your…