Excel Custom Lists

Learn about Excel Custom Lists — 1) Creating Custom Lists using the Options Feature; 2) Creating Custom Lists Using a Range of Cells; 3) Deleting Custom Lists; 4) Using Custom Lists within Spreadsheets

Excel custom lists can be used to fill or sort data within the defined order.  By default, Excel provides s few built-in lists – Day of the Week and Day of the Month.  You can also create your own custom lists. Excel Custom Lists

Below are the step by step instructions for working with Excel Custom Lists, including Creating. Deleting and Using Custom Lists. Continue reading “Excel Custom Lists”

Using PowerPoint 2016 to Record Your Computer Screen

Learn the process for using PowerPoint 2016 to record your computer screen as part of your slide presentation or as an independent media file. Also learn how to trim the recorded video.

There may be times when you need to record steps or processes you are taking on your computer for a stand-alone demonstration or to incorporate into a Presentation.  Instead of purchasing expensive screen recording software, you have the option of using PowerPoint 2016 to record your computer screen.  Below are the step by step instructions for Using PowerPoint 2016 to Record your Computer Screen. Continue reading “Using PowerPoint 2016 to Record Your Computer Screen”

OneNote Pages and Subpages

Learn how to work with OneNote Pages and Subpages.

In OneNote 2016, you can add as much content as you want to a page.  However, to stay more organized and for easier reviewing, you can create additional OneNote Pages and Subpages.  Below are the step by step instructions for Adding, Deleting and Moving Pages, Creating Subpages as well as Expanding and Collapsing Subpages. Continue reading “OneNote Pages and Subpages”

Word Quick Keys

Learn various Word Quick Keys to save time when working in Word.

For this post, I want to give you various Word Quick Keys that have helped me work more efficiently and quickly.  These commands come in handy for those of you who prefer quick mouse or keyboard commands over mouse drags and tab/ribbon commands.  Below are the Word Quick Keys for Selecting Text, Creating Automatic Borders, Repeating your Last Command, Clearing Font Formats and Clearing Paragraph Formats.

Word Quick Keys for Selecting Text

  • Double-click a word to select the word
  • Triple-click a word to select the paragraph containing that word
  • Click in the left margin to select a line of text
  • Drag in the left margin to select multiple lines of text
  • Double-click in the left margin to select a paragraph
  • Triple-click in the left margin to select the entire document
  • Press Ctrl-A to select the entire document
  • To select multiple blocks of text, select the first block, hold down the Ctrl key and select the additional blocks of text

Create Automatic Borders

Type the following characters and press Enter to insert the specified borders quickly –

— (3 hyphens) will insert –Word Quick Keys Image 1

=== (3 equal signs) will insert –Word Quick Keys Image 2

___ (3 underscores) will insert –Word Quick Keys Image 3

*** (3 asterisks) will insert –Word Quick Keys Image 4

Repeat Your Last Command

To repeat the last action taken, whether inserting a symbol, formatting text or paragraphs, etc., press the F4 key.

Clear Font Formats

To clear any font formats (for example, font size, bold, underline or font color) that have been applied to text, select the text and press CTRL+Spacebar.

Clear Paragraph Formats

To clear any paragraph formats (for example, bullets or numbering, borders and shading or indenting) that have been applied to text, select that text and press CTRL+Q.

Working with Page Breaks

Learn about Working with Page Breaks and the options available.

Page Breaks allow you to control how and where you data breaks across pages, whether you are setting manual breaks or setting options for pagination.  Below are the step by step instructions for working with page breaks. Continue reading “Working with Page Breaks”

Creating a Table of Contents in Nuance Power PDF Advanced

Learn the steps necessary for Creating a Table of Contents in Nuance Power PDF Advanced.

Nuance Power PDF Advanced makes it easy to assemble multiple files into one PDF file and to create an expandable table of contents.  Below are the step by step instructions for Creating a Table of Contents In Nuance Power PDF Advanced. Continue reading “Creating a Table of Contents in Nuance Power PDF Advanced”

Excel Formulas and Functions

Learn how to use Excel Formulas and Functions.

A formula can contain any or all the following – functions, references, operators, and constants.  Constants are values that are not calculated as they always remain the same.  Below are the step by step instructions for using various Excel Formulas and Functions Features. Continue reading “Excel Formulas and Functions”