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 columns to...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 (3...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 »
How to Convert Email to Google Calendar Event
Navigate to cedarville.edu/google and click the “Mail” link. Log in to Google Mail. If you are already logged in to Google Apps, open Google Mail by clicking the [Mail] tab at the top of the screen. Open the email you wish to turn into an appointment. From across the top of the screen, click [More]. From the drop-down menu, click “Create event.” You will be taken to a Google Calendar edit event page. Edit the event details as desired. If necessary, remove the email...Continue reading »
How to Reverse Case of Text in Excel
When importing data from another source, often times the data is displayed in all uppercase or all lowercase text. If you want to change the case, follow these instructions for Excel 2016 and 2013. (Terms may vary between versions, but the steps should remain the same.) Next to the column or row that contains the text you would like to change, insert another column or row > Select the first cell in that column or row. Select the "Formulas" tab > Select the "Text" drop-down list...Continue reading »