Custom Dictionary

Learn how to edit the Custom Dictionary within the Office Products.

The spell check feature compares the words within your documents with the words within the main Office dictionary.  This dictionary contains most of common words but it may not contain some proper names, technical terms, acronyms and capitalizations.  To combat this issue, you can add words and capitalizations to a custom dictionary to prevent the spell check feature from flagging them as misspelled.  The custom dictionary applies to Office 2016 – Word, Excel, Outlook and PowerPoint, however the steps may differ slightly.  Below are the step by step instructions for editing a Custom Dictionary in Word. Continue reading “Custom Dictionary”

Word Save Options

Learn how to set the various Word Save Options. The skills learned here can also be utilized in Excel and PowerPoint.

The Word Options dialog box is where you can add and change Word settings used within your documents, set your personal information (metadata) stored with the document and any preferences you wish to set.  The Word Save Options specifically work with the variables used when saving your documents, such as the format to use when saving, how often to save AutoRecover, AutoRecover file locations, Default local file location, etc.  Similar Save Options are available in Excel and PowerPoint as well.

Below are the step by step instructions for accessing and change the Word Save Options. Continue reading “Word Save Options”

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”

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”

Utilizing the Excel Watch Window

Learn how to Utilize the Excel Watch Window to monitor changes within cells on large worksheets.

When working with a large worksheet or a collection of related worksheets, the data may frequently change.  The Excel Watch window allows you to save time by monitoring the results of selected cells in a separate window.  Below are the step by step instructions for utilizing the Excel Watch Window. Continue reading “Utilizing the Excel Watch Window”

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”

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”

Excel 2016 Tabs/Ribbons Shortcut Keys

Learn to navigate Excel’s tabs, ribbons, and backstage using shortcut keys.

In previous blogs, I’ve given you the shortcut keys to both Word and PowerPoint.  So, to add to your collection here are the Excel 2016 tabs/ribbons shortcut keys.  Remember, shortcut keys allow you to navigate the tabs and ribbons without having to use the mouse.  This means you don’t have to keep going back and forth from the keyboard to the mouse! Continue reading “Excel 2016 Tabs/Ribbons Shortcut Keys”

Freezing Panes in Excel

Learn how to freeze panes in Excel – Columns, Rows, and both columns and rows.

Freezing Panes

Working with large spreadsheets can become unmanageable very quickly.  Trying to enter data in rows or columns is impossible when the headings disappear off the screen as you can easily enter data into the wrong cells.  Event trying to review the data can become very cumbersome.  The ability to freeze rows and/or columns allows you to efficiently enter data into large spreadsheets without having to continually scroll to the headings to ensure you are in the right cells.  It also allows you to hone into specific data quickly.  Below are the step-by-step instructions for freezing rows, columns, and both rows and columns. Continue reading “Freezing Panes in Excel”