Learn how to freeze panes in Excel – Columns, Rows, and both columns and rows.
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”
Learn how to use KeyTips to access Office Ribbon commands via the keyboard.
KeyTips / Access Keys
Access keys are shortcut keys that give you access to the ribbon commands without using your mouse. Once you press the ALT key, KeyTips appear over each command available in the current view, including the Quick Access Toolbar. Depending on which letter you press, you may be shown additional KeyTips. Continue reading “KeyTips – Using the Keyboard to Access the Office Ribbons”
Learn how to create an Outlook 2016 task from an e-mail message.
You can quickly and easily create an Outlook task from an e-mail message you have received, without having to retype the information and leaving the original message intact. Below are the step-by-step instructions for the creating the task. Continue reading “Creating a Task from an Outlook E-Mail Message”
Learn how to keep Outlook 2016 Tasks and Calendar always in view by using the Dock the Peek feature.
Outlook 2016 has a “Dock the Peek” feature for keeping your tasks and calendar always in view. This can come in handy as you are working on emails, setting other tasks and setting up meetings. It is also great for the fast glance at your day view. Below are the step-by-step instructions for setting your Tasks and Calendar in a sidebar on the left of your Reading Pane. Continue reading “Outlook 2016 Dock the Peek Feature”
Learn how to create and update a Table of Contents in Word.
Many Word documents require a table of contents be added to them. Word allows you to add a table of contents (TOC) by either using the Heading Styles or by marking selected text to be added to the TOC. The easiest way to create a TOC is to use the heading styles. This feature allows you to quickly update the TOC anytime with just a few key strokes. Below are the step-by-step instructions for creating and updating a TOC using the Heading Styles. Continue reading “Creating and Updating a Table of Contents in Word”
Learn how to create and print a blank Outlook 2016 Calendar.
There are times when you quickly need a clean calendar for a specific period of time and you don’t want to use your Outlook calendar with all your meetings and appointments listed. The quickest and easiest way to get a blank calendar to to set it up in Outlook. Once you’ve set it up, it’s always available and gives you the flexibility to choose the period for which you need it. Below are the step-by-step instructions of creating and printing a blank Outlook 2016 calendar. Continue reading “Creating & Printing a Blank Outlook 2016 Calendar”
Learn how to create a footnote continuation notice for footnotes that extend onto a second page.
If a footnote is too long to fit on a page, a footnote continuation notice can be created to let readers know that it is continued on the next page. Below are the step-by-step instruction for creating a continuation notice. NOTE: The steps can also be applied to creating a continuation notice for endnotes. Continue reading “Creating a Footnote Continuation Notice in Word”
Learn how to create an e-mail signature.
Creating an E-Mail Signature
Outlook gives you the capability to create signatures to add to your e-mail messages. With this capability, comes the flexibility to create multiple signatures to be used for specific types of messages — business, client specific, casual, replies, etc. Below are the step-by-step instructions for creating an e-mail signature. Continue reading “Creating an E-mail Signature in Outlook 2016”
Learn how to reuse slides from a previous PowerPoint presentation in your new PowerPoint presentation.
PowerPoint has a great feature for reusing slides from previous presentations, incorporating the selected slides into the new presentation. The feature also gives you the option of either using the source formatting or applying the formatting from the destination presentation. This is a great time saver as it eliminates the need to retype or reformat slides. Continue reading “Reusing Slides from Previous Presentation in New Presentation”
Learn how to add and remove Word watermarks as well as create and save custom ones.
How to Add, Remove and Customize Word Watermarks
When you collaborate on Word documents with others or are routing drafts of documents, you may want to mark the document as draft or private with a watermark. This allows the recipient to see at a glance the type of document it is. Word automatically applies the watermark to every page except a designated cover page. Continue reading “How to Add, Remove and Customize Word Watermarks”