One Thousand Days Transformed - The Campaign for Cedarville

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.

Convert Data Into a Table in Excel

  This page will show you how to convert Excel data into a table. Creating a Table within Excel Open the Excel spreadsheet. Use your mouse to select the cells that contain the information for the table.  Click the "Insert" tab > Locate the "Tables" group. Click "Table". A "Create Table" dialog box will open.  If you have column headings, check the box "My table has headers". Verify that the range is correct > Click [OK]. Resize your...
Continue reading »

How to Change the Default Font Setting in Word

Upon installation, Microsoft Word uses the Calibri font and 11 point font size as the default settings. You can change the default font by following the steps below. Keep in mind that this is a machine-specific setting, so you will need to repeat these steps for any new computer that you login to. To change the default font: Open a new or existing Microsoft Word document. Click the [Home] tab > Locate the "Font" group. From the lower-right corner of the "Font" group, click...
Continue reading »

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

In 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 (e.g., Last Name, First Name) by...
Continue reading »

Edit and Delete Labels in Google Mail

Labels are Google's versions of folders. They do everything that folders do, but you can apply more than one label to a message. After creating a label, you can edit the label name and color. You can also delete any label you create.


Continue reading »

Change Color of Calendar in Google Calendar

  In Google Calendar, you can change the color of any calendar you have access to, whether it is your default calendar, a calendar you created, or a calendar someone shared with you. Changing the color of a calendar will change the color of events on that calendar. Change Calendar Color Log in to your Google account and navigate to Google Calendar. In the list of calendars on the left side of the screen, hover your cursor over the desired calendar > Click the "Options" icon...
Continue reading »

How to Automate Animation and Slideshow Transitions in PowerPoint

You can set your existing PowerPoint animations to play automatically so that you don't have to click the slide area to make the next item appear. You can also set the slide transitions to progress automatically, so there is no need to click to proceed to the next slide in your show. These instructions are for PowerPoint 2016, 2013, and 2010. The tabs and section headings may vary slightly in appearance, but the terminology in these instructions will remain the same between each version of...
Continue reading »

What is a Pecha Kucha Presentation?

 A Pecha Kucha presentation is a format that uses 20 slides or images that are displayed for 20 seconds each. The slides will move automatically as the presenter is speaking. This format ensures that the speaker is concise, keeps the presentation moving, and gets through all of their content. Although it is an uncommon format, it is most often used for creative disciplines to share their work or for professionals to share a journey or story. Some college courses will ask students to use...
Continue reading »

Create and Manage Folders in Outlook

Microsoft Outlook organizes emails by folders, much like GroupWise did. Any labels that you created in Google Apps will be converted to folders in Outlook, and you can place emails in these folders or create new folders to organize your emails. If you place an email in a folder in Outlook and later open your email in Google Apps, that email will be archived with the Gmail label that matches the Outlook folder where you placed the email. Create a new folder In the "Folder" tab, click "New...
Continue reading »

How to Delete a Calendar in Google Calendar

In Google Calendar, you can delete or unsubscribe from calendars you no longer wish to use. Note: For shared calendars, it is important to know if you want to delete a calendar or simply unsubscribe to it. Deleting will permanently delete the calendar and no one who shares it with you will be able to access it anymore. Unsubscribing will only remove your access to the calendar; others will still be able to use it.   Delete a Calendar To delete a calendar from your calendar list: ...
Continue reading »

How to Create Contact Group From an Excel File

Google Mail allows you to import a contact group from an Excel file into Google Contacts. This process consists of two steps: saving the contact group Excel file as a .CSV file and then importing the .CSV file into your Google Contacts.


Continue reading »