Don’t have a Mouse Available? Use Key Tips – Excel & Office

Have you ever had a mouse go bad, and IT can’t get a new one to you right away? Or maybe you are at home and don’t want to go to the store right after your dog chews through your mouse wire. The nice thing about computers is they do not require a mouse. Mice … Continue reading Don’t have a Mouse Available? Use Key Tips – Excel & Office

Career Paths: Project versus Functional Management

Project Management is proving attractive to many who formerly considered only traditional Functional Management. What is the difference, and what personality types are best suited to each? Project Management is purely Goal-oriented, whereas Functional Management is often oriented toward keeping operations running smoothly. Project Managers are often motivated by a desire to bring positive change, … Continue reading Career Paths: Project versus Functional Management

PowerPoint: Presentation looping in PowerPoint 2013

Have you ever needed an endlessly looping PowerPoint presentation, but were unable to make it loop? In PowerPoint 2013, it’s extremely easy: Just open the Slide Setup tab, click the Setup Slide Show command in the Set Up group T     hen select Loop Continuously Until Esc.               … Continue reading PowerPoint: Presentation looping in PowerPoint 2013

How to tell what version of Office you have

For more office techniques see our MS Office Tips.

Add a Watermark to a Document

Make your documents look professional and official by adding watermarks, instead of using rubber stamps. On the Design tab, in the Page Background group, click the dropdown menu for the Watermarkcommand. Click the watermark that you want to use, and it will appear in the background of your document. For more office techniques see our … Continue reading Add a Watermark to a Document

Create a Dropdown List in Excel

Ever wonder how somebody created a dropdown list in Excel? There are two ways to do this. 1. Create the list in Excel somewhere, or have your list handy, so you can type the choices in your list.         2. Select the cell where the dropdown list is needed, and click Data … Continue reading Create a Dropdown List in Excel

Use the same formulas & calculations as in Excel.

Did you know that you can use the same formulas in calculation columns for SharePoint, as you do in Excel? The trick is to remember that you are using fields, instead of cells, so fields must be surrounded by brackets ([ ]). Example: =IF(OR([My Number]<[My Total],[Your Number]<[My Total]),”Yes”,”No”) – Underlined areas are column names, surrounded … Continue reading Use the same formulas & calculations as in Excel.

Zoom your Word document

Zoom your Word document in and out with your mouse: Press the control button and use the page scrolling wheel on the mouse to make your Word document will zoom in and out. For more office techniques see our MS Office Tips.

Promoted Links

Spice up the “Useful Links” section of your SharePoint page by selecting a “Promoted Links” app. These apps are more eye-catching, adding life to your page.                 Don’t like the way regular hyperlinks look? Employ this app to use pictured links. When you click on the pictures, they … Continue reading Promoted Links

Creating an Excel template

Creating an Excel template allows a person to reuse a workbook setup over and over, without the need to reinvent the wheel every time. The workbook being used for the template needs to have old data cleared out (i.e., the data entry areas are cleared out in the template), which allows a fresh workbook to … Continue reading Creating an Excel template