Insights - Computer Help

Cedarville Insights provides answers to your pressing questions about Microsoft Word, Excel, and Powerpoint, as well as college undergraduate and graduate programs, theological and philosophical questions, and general purpose information.

Find a Time Feature or Busy Search in Google Calendar

The "Find a Time" feature allows you to compare schedules of guests, whether you are scheduling a meeting or inviting friends to lunch, to pick a time that is free for everyone.

Excel: How to Parse Data (split column into multiple)

In local version of Excel 365 (or Excel 2016, 2013, 2010) it's possible to parse data from one column into two or more columns. And you can do it in a few simple steps. Suppose column A contains "Last Name, First Name". Follow these steps to split the data from column A into a "Last Name" column and a "First Name" column. No cutting and pasting necessary!Open the Excel spreadsheet containing the data you want to split, then:Highlight the column that contains the combined data by clicking the...
Continue reading »

Adjust Table Columns in Word (Auto Fit)

You can manually adjust the width of any table; however, the following tips may allow you to fine-tune your tables with less effort.To adjust table row and column size in Word:Click anywhere in the table.In "Table Tools" click the [Layout] tab > locate the "Cell Size" group and choose from of the following options: To fit the columns to the text (or page margins if cells are empty), click [AutoFit] > select "AutoFit Contents."To fit the table to the text, click [AutoFit] > select ...
Continue reading »

Adobe Acrobat Combine Multiple PDFs Into One File

Note:This functionality will not work in the free Adobe Acrobat Reader Program. However, you can install Adobe Acrobat Professional on your Cedarville University computer through Start > All Programs > _CedarNet > Graphics > Adobe Acrobat Pro 11 .Open Adobe Acrobat Professional 11.Go to "File" > "Create" (or choose [Create] on your toolbar).Choose "Combine Files into a Single PDF...."A "Combine Files" dialog box will open.Click [Add Files...] in the upper left of the...
Continue reading »

Arrange Items in Outlook

In Microsoft Outlook, you can arrange the items in your inbox and folders so that emails you want to be able to see are more easily accessible. Outlook gives you the option to sort items in each folder by specific criteria, such as when it was sent, who it was sent by, or how large it is. By default, all items in your inbox and folders are sorted by date with the most recent items on top.If you change how Outlook sorts items in one folder, it will not change how other folders are organized....
Continue reading »

Google Mail (Gmail) General Settings

There are several options available under the general settings menu for Google mail. These options allow you to change everything from how many emails appear on one screen to what stars you can use to label messages.

Convert Audio Files

You may need to convert an audio file to another format for various reasons (e.g., to use as voicemail message, to transfer to an MP3 player). Depending on the file types you are using, you can use either Audacity or Adobe Audition. Both are available from CedarNet. Audacity is located under Language & Literature, and Audition is located under Com Arts.Use AudacityAudacity is more streamlined with less features and will work well for simple file conversion. However, Audacity cannot work with...
Continue reading »

How to Format Email Messages in Outlook

Learn how to format emails in Outlook using HTML, Rich Text Format (RTF), or plain text.

Outlook View Delegated Email and Calendar

Viewing Delegated MailGo to the Mail section of Outlook in the navigation pane.In the navigation pane below the list of your folders, you should see a list of any delegated email addresses and folders.Click on the delegated folders to access those emails.Viewing Delegated CalendarGo to the Calendar section in the navigation pane.In the navigation pane, check the box next to the name of the calendar that has been delegated to you. It will display in the view pane. Posted in Computer Help
Continue reading »

How to Save and Send Documents from Office Programs in Outlook

If Microsoft Outlook is set up as the email client on your computer (the default program to handle mailto links), you can use the "Save & Send" feature in other Microsoft Office programs such as Word, Excel, and Powerpoint. The "Save & Send" option allows you to send a file as an email attachment directly from the Microsoft Office program that you create the document in.Note:You can only use the “Save & Send” feature if you have an email client, such as Microsoft Outlook, set up...
Continue reading »