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”

Using Outlook Out of Office Assistant (Automatic Replies)

Learn how to utilize the Outlook Out of Office Assistant to keep people informed while you are out of the office or away from your test for extended periods or time. Also, learn how to add rules to your Out of Office Assistant to stay on top of incoming message while you are away.

The Outlook Out of office Assistant is a great way to keep your clients and teams in the loop when you are out of the office or away from your desk for extended periods of time.  Using rules with the Out of Office Assistant can also help you stay organized while out. It can be used to respond to emails you received (internal and external) as well as take additional actions such as forwarding, tagging and moved to folders.  Below are the step-by-step instructions for using the Outlook Out of Office Assistant. Continue reading “Using Outlook Out of Office Assistant (Automatic Replies)”