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”