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)”

Working with Word Table of Authoritites

Learn how to work with Word Table of Authorities and Citations — Marking Citations, Creating the Table of Authorities, Updating the Table of Authorities, Editing/Formatting Table of Authorities Entries and Adding or Changing a Citation Category for a Table of Authorities Entry.

A Table of Authorities lists the references in a legal document, along with the numbers of the pages on which the references appear.  In order to create a Table of Authorities, you must first mark the citations.  When you mark your citations, Word inserts a special TA (Table of Authorities Entry) field in the document.  You can then search the document for the next long or short citation to mark, or you automatically mark each subsequent occurrence of the citation.  NOTE:  You have the ability to change or add categories of citations if you do not want to use the existing categories. Below are the step-by-step instructions for working with Word Table of Authorities – Marking Citations, Creating the Table of Authorities, Updating the Table of Authorities, Editing/Formatting Table of Authorities Entries and Adding or Changing a Citation Category for a Table of Authorities Entry. Continue reading “Working with Word Table of Authoritites”

Using OneNote for Document Management

Learn how to Use OneNote for Document Management to easily locate documents stored across multiple mediums. The step-by-step instructions will show you how to set up the management of your documents and directories using links. You’ll also learn how to keep the links current.

Let’s continue on with our organization theme.  This time, we’re going to focus on document organization or managing our documents.  OneNote can be a great tool for organizing and tracking your documents, whether they’re located locally, on external drives or OneDrive.  Below are the step-by-step instructions for using OneNote for document management. Continue reading “Using OneNote for Document Management”

Quick Ways to Organize OneNote Notes

Learn how to Organize OneNote Notes with subpages and table of contents for easier navigation.

OneNote Notes are a great tool for collection your thoughts and information for various work projects and personal plans.  However, it can become very cumbersome if the vast amounts of data collected are not kept organized.  I’ve collected a few quick ways to you can organize your notes to ensure you can quickly and easily find your information when needed.  Below are the step-by-step instructions for various quick ways to organize OneNote Notes. Continue reading “Quick Ways to Organize OneNote Notes”

Creating Outlook Groups

In this entry, you will learn the process for creating Outlook groups, allowing for easy collaboration with team members.

Groups come in handy when you need to collaborate with individuals within your organization on projects.  They give you an extra layer of cohesiveness that just sending emails and documents do not.  But before we get started, let’s make sure you understand what a group is compared to a contact group.  Please remember, groups are not the same as contact groups.  Contact groups were previously known as distribution lists and are used for distributing information to lists of recipients.  Whereas, groups have a shared workspace for e-mail, conversations, files and calendar events where group members can collaborate and access information.  Below are the step-by-step instructions for creating Outlook groups. Continue reading “Creating Outlook Groups”