Home Software Archive for category "Microsoft Office"

Printing Sharepoint Calendars

In order to print a calendar from Sharepoint, you must first make sure that the calendar is connected to your Outlook account. If it is not already connected, you can follow these steps to connect the calendar to your Outlook account. In the O:\Program Shortcuts folder, scroll down until you find Print Sharepoint Calendar. Double-click that link.


Connecting a Sharepoint Calendar to Outlook

Some of the SJY calendars such as the Faculty Calendar and the Presider Schedule are able to be connected to a user’s personal Outlook account. This allows users to view the calendar from the Outlook program on their computers instead of signing in to the Office 365 Portal. On the SJY Portal Page, click the


Configuring Outlook 2013 to Office 365

When you open Microsoft Outlook 2013 for the first time, Outlook needs to create your profile and connect to Microsoft Office 365. Below are the steps needed to properly configure your Outlook profile. Open Microsoft Outlook 2013. The Welcome to Microsoft Outlook wizard will appear. Click Next at the wizard. Click Yes to let Outlook connect to an


Adding Controls such as Text Forms, Drop-Down Menus, and Checkboxes

Published on March 4, 2015 in Microsoft Word

Within Microsoft Word, you can use controls in order to make forms including text forms, drop-down form, and checkbox controls. This article will guide users in enabling the ability to add controls to a Microsoft Word document, how to actually add controls, and how to protect the document when finished creating/editing.   Enable the Developer Tab In order to


Split an Access Database

While in Access with the file that contains both front-end and back-end, open the Database Tools tab. Click Move Data and then click Access database. A wizard will appear. Click Split database and name the database (back-end) file. The original file will now just be a front-end and the file you named will be the back-end. Print


Making a navigation bar

To make a navigation bar Make a blank page and name the page Header Insert a table that is 1 Row x 1 Colum at the top of your selected page. For help with inserting tables see this Knowledge Base article   Click Insert > Interactive Buttons Scroll through the list to find a


Inserting Hyperlinks

Highlight and right-click on the text you would like to link. Click Hyperlink and a Pop up window will open. In the Address box at the bottom of the window, paste the web address to which you want to link. Click OK.     Print this entry


Table headings

Highlight the top row of cells and right click. Click on Modify > Merge Cells Enter the heading of your table into the merged cell. NOTE: You may also wish to format the title. In the example shown, this user is using an H3 heading and also has the text bold and center aligned. Print this


Inserting Tables

To insert a table: Click on Table > Insert Table. A pop up menu will appear. Here you can customize your table. Click OK.   Customizing your table Adding columns: a column is a group of cells going vertically within the table. Change the value of the Columns field to add or remove columns of


Install FrontPage Extensions to your Personal Website

Newly created personal websites need metadata (FrontPage Extensions) installed in hidden folders in order to take advantage of some of the features of SharePoint Designer. To install the metadata using SharePoint Designer 2007, go to Site > Site Settings. Check Manage the Website using hidden metedata files. Click OK. Confirm that SharePoint Designer can add information to


Configure a personal device to access Parish Email

This content is protected due to its sensitive nature.

However, if you are an employee or a volunteer with a St. Joseph Parish
network account, you can probably access the information. First, you need to
sign in. Look on the bottom-right corner of this screen. You'll see a Login
window requesting a username and password. Please enter your St. Joseph Parish
network account username and password and click Login. Then
navigate back to this article.


Copying and Restoring Outlook Items to a Windows Folder

Published on May 2, 2013 in Microsoft Outlook

Due to mailbox quotas, it may become necessary to archive Outlook items (such as messages, tasks, and appointments) to a location other than your Exchange mailbox.   Copying the Items to a New Location To do this, left-click and hold a message(s) you want to archive. While holding the left-mouse button, drag the message(s) to


Setting Your Calendar Work Week

Setting your official working hours and days assists Outlook/Outlook Web App to easily schedule appointments that fit everyone’s schedules.   Outlook 2013 To set your work week in Outlook 2013, Go to the File tab and click Options. Click Calendar. Check your typical “work hours”. Check what days are your “work days”. Set your preferred first day of the


Inviting Attendees to a Meeting

You can organize meetings by using the Exchange Calendar and inviting attendees.   As the Sender Outlook 2013 To invite attendees to a meeting, Click the New Meeting button. Add your attendees. You can type the email addresses of the attendees in the To field. You can click To, double-click the attendees, and click OK. Add information about your


Creating a Recurring Appointment

You can create recurring Calendar appointments, meetings, and events on a given frequency so that you do not have to constantly create the same appointment over and over again.   Outlook 2013 To create a recurring appointment, Go to the Calendar section of Outlook and click New Appointment. Enter the appointment information. In the Options pane, click Recurrence. On


Turn off Desktop Notification of New Email

By default, when you receive a new email message when Outlook is open, a Desktop notification will appear in the top-right corner of the screen. You can turn off this feature. To turn off the Desktop notification, Go to the File tab and click on Options. In the Mail category, go down to Message arrival.


Request a Receipt

Outlook 2013 To request a receipt from the recipient, While composing a message, click the Options tab. Check the box(es) for the kind of receipt you would like. Compose email as usual. Send email.   Outlook Web App To request a receipt from the recipient, While composing a message, click the Options button (three horizontal dots) and select


Setting up Voting Buttons

It is easy to create a poll in Microsoft Outlook by including voting buttons in an e-mail message. When recipients respond to the poll, you can automatically tabulate the results of the vote in Outlook.   As the Sender While composing a new message, click Options tab. Click Use Voting Buttons and choose the default


Set up Email Delivery Delay & Expiration

Delay Delivery To delay the delivery of an email, click Options tab while composing a message. Click Delay Delivery. check Do not deliver before: and complete info. Click OK. NOTE: Outlook must be open to send the message.   Set Message Expiration To set the email to expire after a given date, click Options tab while composing a message.


Enabling Bcc (Blind Carbon Copy)

In Outlook 2013 While composing a message, Click the Options tab. Click the Bcc button. In Outlook Web App While composing a message, Click the Bcc button on the far side of the To field. Print this entry


Attach an Item to an Email Message

You can attach items such as contacts, appointments, calendars, tasks, and even other emails to Messages.   At the Message Composition, click the Attach Item icon. Choose from Business Cards, Calendar, or Outlook Item. Choose the item you wish to attach. Click  OK. Item will appear in window. Print this entry


Reading Pane (Turn On/Off; Change Location)

Go to the View menu. Hover over the Reading Pane menu. Choose whether to move the Reading Pane to the bottom or right or turn it off completely. Print this entry


Compressing Images

Sometimes you may have images/pictures that need to be adjusted due to physical or file size due to constraints such as attachment size limits, download sizes, and more. You can do this with Microsoft Office Picture Manager, a free program that is included with Microsoft Office 2013.   Adjusting File Size To adjust the file


Creating Hyperlinks in PowerPoint

Create a hyperlink to a page or file on the Web In Normal view, select the text or the object that you want to use as a hyperlink. On the Insert tab, in the Links group, click Hyperlink. Under Link to, click Existing File or Web Page, and then click Browse the Web.  OR you


Delete Multiple Items within a Folder

While you can empty your Deleted Items with one command, deleting files in other folders requires more manual work. You need to select the items to delete them. You can select a group of consecutive items or items sporadically throughout the folder.   Delete a Group of Consecutive Items To delete a group of consecutive items within one folder,


Empty Deleted Items Folder

When you delete an item, it is automatically placed in the Deleted Items folder so that, if you deleted that file by mistake, you can retrieve it again. Typically, the items remain in the Deleted Items folder until you permanently delete the items or empty the Deleted Items folder. Microsoft Outlook 2013 Client To empty the Deleted Items folder,


Checking Your Mailbox Size

Checking your Exchange mailbox size can assist you in remaining within your space quota.   Using Microsoft Outlook 2013 client Right-click on your mailbox. This is at the very top of the folder tree on the left. For example, John Smith’s mailbox would say, Mailbox – Smith, John. Choose Data File Properties. The Outlook Today


Adding and Deleting Rows and Columns

Adding a Column Right click on the column header above the location where the new column is to be inserted. Choose Insert from the menu. The new column will be inserted to the left of the selected column.   Deleting a Column Right click on the column you wish to delete. Choose Delete.   Adding


Attach a File to an Email Message

Attachments are files or items that can be sent as part of an e-mail message. This article explains how to send attachments. Attaching Files in Outlook 2013 Begin creating a new message, reply to a message, or forward a message. On the Message tab, in the Include group, click Attach File. In the Insert File dialog box,


Adjusting Column Width and Row Height

In Excel 2013, you can change any column widths or row heights in your worksheets to improve the readability and appearance of data. For example, if your worksheet contains many numbers, you can widen the columns to make the worksheet less cluttered. You should always widen columns that contain cells with truncated text entries or


Disable AutoCorrect

Start Word. Click the Microsoft Office Button , and then click Word Options. Click Proofing, and then click AutoCorrect Options. Click the AutoFormat As You Type tab or the AutoFormat.     Select or clear the check boxes for the options that you want, and then click OK. Print this entry


Set Outlook Calendar Appointment to Private

While sharing your calendar with coworkers, you can set certain appointments to “private” so that coworkers view your appointment only as Private Appointment as opposed to the subject and/or notes you specifiy.   To set an appointment to private, Create or open the appointment or meeting that you want to make private. In the Tags pane


Embedding YouTube Videos in PowerPoint 2013

It is easy to include a link to a YouTube video to a PP slide, but a little more involved if you want to embed a video. The advantage of embedding is that it includes a video player on your slide instead of going directly to YouTube where students will see some of the suggested videos


Change the Default Font for the New Document Template of MS Word 2013

Published on May 7, 2012 in Microsoft Word

You can set a default font for all “new” documents that you create on that specific computer. To do this, Click on the pull-down button of the font section of the Home tab (or press CTRL + D on your keyboard). Select the font, font style, and font size you want to be your default. Click Set As


Insert or Delete a Drop-Down list in Excel

 Inserting a Drop-Down List To make data entry easier in Excel, or to limit entries to certain items that you define, you can create a drop-down list of valid entries that is compiled from cells elsewhere in the workbook. When you create a drop-down list for a cell, it displays an arrow in that cell.


Add Narration to a Slide

In Normal view, click the slide that you want to add a comment to. On the Insert tab, in the Media pane, click the Audio button and choose Record Audio. To record the comment, click Record, and start speaking. When you are finished recording, click Stop. In the Name box, type a name for the sound and


Use Mail Merge to Create and Print Letters and Other Documents

You use mail merge when you want to create a set of documents, such as a form letter that is sent to many customers. Each letter has the same kind of information, yet the content is unique. For example, in letters to your customers, each letter can be personalized to address each customer by name.


Stop Auto-Capitalizing the First Letter of the Line

To stop MS Word from automatically capitalizing the first letter of every new line, Click on the Microsoft Office button. Click Word Options. On the left, click Proofing and then click AutoCorrect Options on the right. Uncheck the box next to Capitalize first letter of sentences. Click OK. Click OK. Print this entry


Split Screen to View Documents Side by Side

You can have Microsoft Word split your screen up so that multiple documents can be viewed on the same screen. To do this, ensure that both Word documents are open. Click the View tab on the Ribbon. Click View Side by Side. NOTE: To restore windows to their normal width, simply maximize the window by


Select Page Orientation

You can choose either portrait (vertical) or landscape (horizontal) orientation for all or part of your document. When you change the orientation, the galleries of predesigned page and cover page options also change to offer pages that have the orientation that you choose. Change the orientation of your entire document On the Page Layout tab,


Printing Pages as Book Fold

Go to the Page Layout tab. Click on Margins and Custom Margins. In the middle of the window, next to the Pages section, choose Book Fold from the drop-down menu. Click OK. Print this entry


Look up Words in the MS Word Dictionary

First you must make the Research button available on the Quick Access toolbar (the bar at the top of the window that contains the Save button). Go to the File tab and click Options. Click Quick Access Toolbar. In the Choose commands from: list, choose All Commands. Scroll down until you find the Research command.


Inserting Page Breaks

You can insert a page break anywhere in your document, or you can specify where Microsoft Word positions automatic page breaks. If you insert manual page breaks in documents that are more than several pages in length, you might have to frequently rebreak pages as you edit the document. To avoid the difficulty of manually


Inserting a Symbol

Click on the Insert tab on the Ribbon. On the right-hand side, click on Symbol. Choose the symbol you wish to insert. If the symbol is not there, choose More Symbols. Find the symbol you want. Click Insert. Print this entry


Insert or Create a Table

In Microsoft Office Word 2013, you can insert a table by choosing from a selection of preformatted tables — complete with sample data — or by selecting the number of rows and columns that you want. You can insert a table into a document, or you can insert one table into another table to create


Eliminate the BLACK line at the bottom of a document

Sometimes when you are working in Microsoft Word and you are trying to underline something a more permanent line appears and is very difficult to eliminate. To do this, Highlight all of the text. Go to the Borders button at the top of the page (looks like a square at the right-hand side of the


Creating Columns

Format a document with newsletter columns On the Page Layout tab, in the Page Setup group, click Columns. Click the layout that you want. NOTE: To add a vertical line between the columns, click Columns again, click More Columns, and then select the Line between check box. You can also adjust the column width and


Creating a Header or Footer

Click on the Insert tab. In the Header and Footer section, click Header or Footer depending on which you wish to edit. A drop-down list will appear. You may choose from one of the pre-made headers or footers by clicking on it. If you wish to create your own, click Edit Header or Edit Footer.


Create a right-to-left folded booklet

Click here to watch how to Create a right-to-left folded booklet. Print this entry


Create a bulleted or numbered list

You can quickly add bullets or numbers to existing lines of text, or Word can automatically create lists as you type. By default, if you start a paragraph with an asterisk or a number 1., Word recognizes that you are trying to start a bulleted or numbered list. If you don’t want your text turned


Citations and Bibliographies

Managing Sources Click on References in the ribbon at the top of the screen. Click on Manage Sources. Click on New. Click the drop down arrow next Book if you want to choose another source. Fill in the fields that are showing for that source. Click on OK. Inserting an Inline Citation Click on References in the ribbon


Adjusting Tabs

To adjust a page tab, first you must make the ruler visible. Go to the View tab. Check the Ruler checkbox. Now that the ruler is visible, you can adjust the tabs. Click the Left Tab symbol at the far left of the horizontal ruler until it changes to the type of tab you want.


Add Borders to Documents and Pictures

In Microsoft Office Word 2013, borders can add interest and emphasis to various parts of your document. You can add borders to pages, text, tables and table cells, graphic objects, and pictures. You can add a border to any or all sides of each page in a document, to pages in a section, to the


Saving a Web Page

Go to File > Save As…. To name the page file, enter a name in the File name white text box. This is equivalent to a Word document’s or PowerPoint presentation’s file name. To change the page title, click Change title, enter a page title, and click OK. The page title appears at the top


Creating a Hyperlink

Highlight the text or image you want your visitors to click on to take to another file or page. Go to Insert > Hyperlink. Click on the page or file you want to link to. It should appear in the Address white text box. Click OK. Print this entry


Opening Your Website in MS SharePoint Designer

Go to the Start screen and click on the Microsoft Office SharePoint Designer 2007 icon, which is located in the Microsoft Office 2007 category. Once SharePoint Designer is open, go to File > Open Site. In the Site Name white text box, type T:\Website. Click Open. Print this entry


Creating PDF Newsletters for Personal Websites

Write your newsletter in Word, Publisher, etc. Print as a PDF. File > Print. Choose CutePDF Writer and click OK. Save this file in T:\Website where you want it. Give this PDF a name and click Save. Open SharePoint Designer. Open your website (T:\Website). Go to the page where your visitors will click to see


Linking to Photostory Projects

In Photostory Open your Photostory Project and click Next until you come to the screen where you are asked how you want to save your Photostory. Choose Save your Photostory for playback on your computer. Then look for Specify the location and file name of your story with a box below it. In the box,


Embedding Mixbooks

At Log in to and Publish your book. When your Mixbook is finished being published, scroll down the screen to find the embed code. It should be on the right hand side. Copy the embed code. At Your Web Site Open your web site in SharePoint Designer. Navigate to the page where you


Embedding Photostory

In Photostory Open your Photostory Project click Next until you come to the screen where you are asked how you want to save your Photostory. Choose Save your Photostory for playback on your computer. Click Specify the location and file name of your story with a box below it. In the box, type T:\website\[name of


Embedding Audio and Video

Before embeddding an audio or video file, you must have the file(s) saved in your T:\Website folder. Open SharePoint Designer. Go to Insert >Media > Windows Media Plyer. Browse the file you wish to embed. If you are in the folder that contains the file but cannot see it, choose the File Type for All


Add a Hit Counter

Go to Create your hit counter and register. When you get to the HTML code, highlight all of that and copy the code. Go to SharePoint Designer and open the page you want to add the counter too. Place your cursor in the location/position you want to the hit counter to be at. At


Run a Slide Show Continuously

To run a PowerPoint continuously, click on the Slideshow in the ribbon at the top of the screen. Click on Set up Slideshow in the middle section. A new window will open. Check the box next to Loop Continuously Until ESC. Click OK. Print this entry


Insert Slides from a Previous Presentation

Open the presentation that you want to add a slide to. In the pane that contains the Outline and Slides tabs, click Slides, and then click where you want to add a slide. On the Home tab, in the Slides group, click the down arrow next to New Slide, and then click Reuse Slides. In


Add a Speech Bubble

Adding the Speech Bubble Click on Insert tab in the Ribbon. Click on Shapes. Scroll down to Call Outs and choose a speech bubble. Then go to the slide where you want the speech bubble and click & drag to create your speech bubble. Adding Text to the Speech Bubble Right-click on the speech bubble.


Sharing your Outlook Calendar

What is calendar sharing? When you use Outlook with an Exchange account, calendars can be shared between people. Calendar sharing is not limited to the default Calendar folder that is created in all Outlook profiles. You can create additional calendar folders and choose which of those folders to share. For example, you can create a


Creating a Mailbox Rule for Out-of-Office Notifications

You can set up a mailbox rule in which, when a sender sends you an email, the sender will receive an automatic reply with a customized message.   Outlook 2013 Click on the File tab. Under Info, click Automatic Replies. If you want, select the Only send during this time range check box to schedule


Direct Email Replies to Another Email Address

In the Outlook client, senders can direct replies to another email address. For example, if a sender writes an email and wishes anyone who clicks Reply to have their email sent to another email address, he or she can use the following steps to have this occur. To direct replies to another email address, Compose


Creating an Email Composition Signature

Creating a Signature in Outlook 2013 Go to the File tab and click on Options. Go to the Mail category and click the Signatures button. When the Signatures and Stationary window opens, click New. Enter a name for your signature and click OK. Type your signature in the text box and click OK. Click OK


Create a New Distribution List (Group)

A distribution list allows you to send mail to multiple contacts by selecting only one recipient. There are different ways to create a list depending on whether you are using Outlook 2013 or the Outlook Web App to create the list. Creating a Distribution List in Outlook 2013 Enter the People section of Outlook. Click New


Create and Manage Folders in Outlook 2013 and Outlook Web App

Creating a new folder In Outlook Web App Click Inbox. Click the plus sign next to the Folders header (you will need to move your mouse cursor over this header for the plus sign to appear). Type the folder name in the text box that appears and press ENTER. In Outlook 2013 Click the Folder tab


Choose an Outlook Stationary for Composing Messages

If Microsoft Word is your e-mail editor, you can’t change the look of stationery from Word; however, changes you make to a stationery pattern in Microsoft Outlook will apply to the equivalent stationery in Word. Click on the File tab and select Options. In the Outlook Options window, select Mail. Click Stationary and Fonts. Use


Change the Default Contact List when Checking Contact Names

You can change the default list in which the Outlook client references contact names. For example, if there is a John Smith in the Global Address List (on the server) and a Carrie Smith in your Contacts, by default, if you enter Smith in the To: field of an email message, Outlook will automatically add


What and where is the Microsoft Office Button?

What is the Office Button? The user interface has been significantly redesigned in the following 2007 Microsoft Office system programs: Word, Excel, PowerPoint, Access, and Outlook (in the composing and reading windows). The Office Button replaces the File menu. When you click the Office Button , you see the same basic commands available on the File


Spelling and Grammar Check

Click on the Review tab of the Ribbon. Click Spelling & Grammar. Print this entry


Inserting Current Time and Date

Click on the Insert tab of the Ribbon. On the right-hand side, click on Date & Time. Choose the format of the date and/or time you wish to insert. If you want the date and/or time to automatically update, check the box Update automatically. If you do not, leave this box unchecked. Click OK. Print


Inserting Clip Art

In the Insert tab, in the Illustrations group, click Online Pictures. In the Insert Pictures window, type your search criteria in the Bing Image Search box. In the list of results, click the image you want to add and click Insert. Print this entry


Customizing the Quick Access Toolbar and Ribbon Toolbars

To customize the quick-access toolbar in MS Office 2013, Click on the File tab. Click Options. On the left, click Quick Access Toolbar. Select the command(s) you want and click the Add>> button. When you are finished, click OK. NOTE: The quick-access toolbar is next to the Microsoft Office button on the left-hand side at the


Copy and paste multiple items by using the Office Clipboard

The Microsoft Office Clipboard allows you to copy up to 24 multiple text and graphical items from Office documents or other programs and paste them into another Office document. For example, you can copy text from an e-mail message, data from a workbook or datasheet, and a graphic from a presentation and then paste them


Creating Rules to Manage/Organize Incoming Email

You may find that your Exchange inbox has become extremely unruly, especially if you are subscribed to many distribution lists. Microsoft Outlook 2013 provides a feature called Rules that organize your messages into various folders within your mailbox. You can learn how to do this by watching this video: Creating a Rule from Scratch Click the