Using the Get Data Feature in Excel 2016

Excel has a great feature for importing data directly into your Excel worksheet.  You can import data from files (Excel, CSV, HTML), databases (Access, SQL), tables, Web, ODBC, etc., making it quicker and easier to share information.  Below are the step by step instructions for using the Get Data feature in Excel 2016. Continue reading “Using the Get Data Feature in Excel 2016”

Customize Word 2016 Status Bar

The Word status bar is displayed at the bottom of your document window.Customize Word 2016 Status Bar

It can be customized by you to display various pertinent information about your document.  To customize the status bar, right-click within the status bar.  Once you do so, the Customize Status bar dialog box will display.  In the example, I have turned on all the features. Customize Word 2016 Status Bar

Below is the information on how to Customize Word 2016 Status Bar and an explanation of the customizations available. Continue reading “Customize Word 2016 Status Bar”

Word 2016 Word Count

There are times you need to count the words within your document, whether legal briefs, school assignments or reports.  Word’s built-in Word Count feature is a great way to keep track of the number of words.  The feature allows you to determine whether you wish to include textboxes, footnotes and endnotes in the totals as well.  And, in addition to counting the words, it can also count the number of pages, paragraphs, lines and characters.  Below are the step by step instructions to show and use the Word 2016 word count. Continue reading “Word 2016 Word Count”

Utilizing the Find and Replace Features

Word gives you a vast array of options for finding and/or replacing content within your documents – Text, Pictures, Captions, Bookmarks and Formatting.  As examples, you can search for graphics within your document, you can search for specific words and change the font as well as search for specific formatting such as bold and change it.  Below are the step by step instructions for Utilizing the Find and Replace Features —

  • Find Text
  • Find and Replace Text
  • Find Images, Tables, Comments and Objects
  • Find and Replace Formatting

Continue reading “Utilizing the Find and Replace Features”

Excel Printing Options

Learn how to utilize the Excel Printing Options to customize your printing.

Excel gives you a vast amount of options for printing spreadsheets, worksheets and specific print areas.  For example, you can set repeating rows for each page printed or even set a specific area within a worksheet to print.  NOTE:  Prior to printing, it is a good idea to preview the worksheet to make sure it’s going to look the way you want it to.  Below are the step by step instructions for Excel Printing. Continue reading “Excel Printing Options”

Sharing Your Outlook Calendar via Email

Learn the steps necessary for Sharing Your Outlook Calendar via Email.

Outlook allows you to share your calendar with users via email.  This feature makes it quick and easy to schedule meetings with others.  NOTE:  Any items marked as private will not be shared on the calendar.  Below are the step by step instructions for sharing your Outlook calendar via email.

  1. Make sure any appointments you do not wish to share are marked as private.
  2. Access your calendar by clicking the Calendar icon.Sharing Your Outlook Calendar via Email
  3. Click the Home tab and click E-Mail Calendar in the Share group.Sharing Your Outlook Calendar via Email
  4. The Send a Calendar via Email dialog box will open along with a blank email message.Sharing Your Outlook Calendar via Email
  5. Click the Calendar down arrow to select the appropriate Calendar from your list of calendars.Sharing Your Outlook Calendar via Email
  6. Click the Date Range down arrow to select the appropriate date range. NOTE:  Click Specify dates to choose a specific date range.Sharing Your Outlook Calendar via Email
  7. Click the Detail down arrow to select the amount of details to show –
    1. Availability only – No details will be shown, only the type of availability.
    2. Limited details – Includes the availability and subjects of calendar items only.
    3. Full details – Includes the availability and full details of calendar items.Sharing Your Outlook Calendar via Email
  8. Click the Show button to set advanced features.Sharing Your Outlook Calendar via Email
  9. Check the Include details of items marked private box to include private items.
  10. Check the Include attachments within calendar items to include any attachments.Sharing Your Outlook Calendar via Email
  11. Click the Email Layout down arrow to select either the Daily schedule or List of events.Sharing Your Outlook Calendar via Email
  12. Once you have set the needed options, click the OK button.Sharing Your Outlook Calendar via Email
  13. The calendar is added as an .ics attachment as well as added to the email body.
  14. Fill in the remaining email items and click Send.

Exporting PowerPoint Presentation as PDF

Learn the steps for Exporting PowerPoint Presentation as a PDF

The Export feature in PowerPoint gives you the ability to quickly and easily create PDF documents of your PowerPoint Presentations.  Below are the step by step instructions on exporting PowerPoint presentation as PDF. Continue reading “Exporting PowerPoint Presentation as PDF”

Utilizing Color Categories to Organize Outlook

Learn the steps for utilizing color categories to organize Outlook – creating, assigning, renaming, deleting, setting a color category as a quick click and assigning a quick click color category to an item.

Color categories are used to group like items for quick viewing.  Color category organization can be used across all Outlook applications – Email, Calendar, Contacts, Notes and tasks.  NOTE:  Outlook allows the assignment of more than one color category to an item for additional levels of organization.  For example, you can assign one color category to all Acme Projects and assign color categories to each subproject of Acme.  This will allow you to quickly see everything for Acme as a whole, plus delve down to the subproject level.  Below are the step by step instructions for utilizing color categories to organize Outlook – creating, assigning, renaming, deleting, setting a color category as a quick click and assigning a quick click color category to an item. Continue reading “Utilizing Color Categories to Organize Outlook”

Outlook Email Printing Options

Learn how to customize the printing of emails and attachments using the Outlook email printing options.

The Outlook email printing function allows you to quickly print emails using the default options or to customize the printing of emails and their attachments.  Below are the step by step instructions for using the Outlook email printing options. Continue reading “Outlook Email Printing Options”

PowerPoint Printing Options for Presentations, Notes, Handouts and Outlines

Learn how to utilize PowerPoints Print options to customize the printing of your presentations, notes, handouts and outlines.

PowerPoint’s Printing options give you the ability to choose printing not only your presentation, but also your notes, handouts and the presentation outline quickly and easily.  Below are the step by step instructions for utilizing the PowerPoint printing options for presentations, notes, handouts and outlines. Continue reading “PowerPoint Printing Options for Presentations, Notes, Handouts and Outlines”