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”
Learn how to organize your OneNote Notebooks using Section Groups.
OneNote Section Groups is a great feature to assist you with organizing OneNote Notebooks. It allows you to group similar sections under a section heading so you can display more sections across the screen. You can create as many section groups as you want, holding any number of sections. Within several of my notebooks, I’ve created so many sections that they don’t fit across the screen properly. This makes it cumbersome to navigate through the information within my notebook. Continue reading “Organizing OneNote 2016 – Creating Section Groups within your Notebooks”
Learn the various PowerPoint 2016 shortcut keys for the Tabs/Ribbons and Backstage.
Shortcut keys allow you to maneuver through PowerPoint’s tabs and ribbons using the keyboard instead of the mouse. To assist you, I’ve compiled a listing of the PowerPoint 2016 shortcut keys for the Tabs/Ribbons and Backstage. Continue reading “PowerPoint 2016 Tabs/Ribbons Shortcut Keys”
Learn how to use the various Word diagnostic tools to troubleshoot formatting and style problems within your documents.
Creating documents from multiple sources and collaborators can become cumbersome and problematic very quickly. This can become even more difficult if each source and collaborator is using their own styles and formatting options. Many issues can arise when trying to meld all the different pieces into one cohesive and stylized document. Styles may not appear to be loading properly and formatting may look different between paragraphs. Continue reading “Word 2016 Formatting Diagnostics”
Learn the various Word 2016 commands (shortcut keys) for the Tab/Ribbons and Backstage.
Many people prefer to use shortcut keys or commands instead of always having to use the mouse to navigate the tabs and ribbons within the Microsoft office programs. To assist you, I’ve compiled a listing of the Tab/Ribbon and backstage command for Word 2016. Continue reading “Word 2016 Tab/Ribbon and Backstage Commands (Shortcut Keys)”
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”