Working with PowerPoint Comments

Learn how to work with PowerPoint comments — add, reply and delete.

Comments can be used in PowerPoint to “talk” with others collaborating on a presentation with you.  They can also be used to leave yourself notes or reminders as you are working on your presentation. Comments can only be seen when working in the Normal view so they cannot be seen within Presenter Mode if you forget to remove a comment.  Below are the step-by-step instructions for using PowerPoint Comments. Continue reading “Working with PowerPoint Comments”

Excel Headers and Footers

Learn how to create and work with Excel Headers and Footers.

It’s easy to add headers and footer to your Excel spreadsheets, similar to those added to Word documents.  The Excel headers and footers allow you to include document details, such as titles, dates, page numbers, locations, etc. while also making the spreadsheet more professional looking in appearance.  Below are the step-by-step instructions for working with Excel Headers and Footers. Continue reading “Excel Headers and Footers”

Excel Charts

Learn how to create and modify Excel charts.

Charts allow you to visually convey the complex data contained within your Excel spreadsheets and workbooks in an uncomplicated manner.  They allow you to pull together large amounts of data a pinpoint the most important aspects without lengthy explanations.  They are a great way to “sum up” the information held within your Excel files.  Below are the step-by-step instructions for creating a Pie Charts.  However, you can take the information you learn and use it to create any of the types of Excel charts. Continue reading “Excel Charts”

Working with Formulas in Word Tables

Learn how to easily add formulas within your Word tables.

Excel is great for creating complex spreadsheets and embedding into Word.  But, if you need to perform a few quick calculations  in a table, you can use Word’s formula feature. This allows you to work directly within your table without having to involve the use of Excel. Below are the step-by-step instructions for working with formulas in Word tables. Information:  The same steps apply whether you are using Word 2016 for Mac or Windows. Continue reading “Working with Formulas in Word Tables”

PowerPoint 2016 – Adding Background Audio

Learn about adding background audio to your PowerPoint Presentation.

PowerPoint gives you the ability to play music or other sound effects in the background of your presentation.  This is a great feature if you are looping your presentation for continuous play or creating videos of it for distribution.  Below are the step-by-step instructions for adding Background Audio. Continue reading “PowerPoint 2016 – Adding Background Audio”

Using Excel’s Flash Fill to Enter Data

Learn about Using Excel’s Flash Fill to Enter Data

Flash Fill is a great time saving feature that allows you to fill in data based on an example or existing pattern.  It usually starts working when it senses a pattern in your data.  It’s great when you need to combine columns of data or even change the formatting of data.  Below are the step-by-step instructions for using Excel’s Flash Fill to enter data. Continue reading “Using Excel’s Flash Fill to Enter Data”

Using PowerPoint 2016 Morph Transition Option

Learn about using
PowerPoint 2016 Morph Transition option.

PowerPoint 2016 morph transition option allows you to transform the data on one slide into your next slide.  This gives you the capability to show movement within your slides on text, images, charts, etc. This feature is great for emphasizing the change within your contents or to highlight specific data within the slide.  In order to use the option, you must have at least two items in common on the slides. Below are the step-by-step instruction for using PowerPoint 2016 morph transition option. Continue reading “Using PowerPoint 2016 Morph Transition Option”

Sharing Outlook Contacts as vCards

Learn how to share your Outlook contacts easily using vCards..

Outlook’s vCards makes it very easy to share your contact information as well as that of individuals within your contact list.  The vCards can be sent to both internal and external recipients.  A vCard is an electronic business card that contains the individual’s contact information.  When the recipient receives the email with the vCard, all they need to do is open it and save it to their contacts. Below are the step-by-step instructions for sharing Outlook contacts as vCards.
Continue reading “Sharing Outlook Contacts as vCards”

Word 2016 – Adding Borders to Pages

Learn how to add borders to pages within your Word 2016 documents.

Adding borders to pages can enhance and offset the page from the whole document.  You can easily use borders to emphasize the title page, section pages or even signature pages. Below are the step-by-step instructions for adding borders to pages in your Word 2016 document.  Information:  The same steps apply whether you are using Word 2016 for Mac or Windows. Continue reading “Word 2016 – Adding Borders to Pages”

Working with PowerPoints Slide Master to Create a Custom Template

Learn how to work with PowerPoint’s Slide Master – creating a custom template, adding a theme, setting the background, changing the overall font, changing various fonts throughout your presentations, adding placeholders to specific layouts, adding page numbers, changing page number locations, adding footers, and saving your custom template.

PowerPoint’s Slide Master is like a “set it and forget it” feature.  It allows you to create a completely customized and unique template that you can use over and over for all your new presentations. So, whether you are doing just a couple or many presentations, it’s worth taking the time to set up the template. Because, once you’ve set it up you can use it for all new presentations allowing you to have the customized look as well as consistency throughout your presentations. Below are the step-by-step instructions for work with PowerPoints slide master to create a custom template. Continue reading “Working with PowerPoints Slide Master to Create a Custom Template”