One of the most commonly asked questions I get in my Excel classes is how do I navigate to the bottom of a column of data more efficiently. Here’s the tip… To quickly navigate to the bottom of a column of continuous data, hold down the [CTRL] key and press the down arrow key once […]
Recently, in one of my computer training classes, a student asked me if there was a way to surf the web using your keyboard. Here are some keyboard shortcuts I shared with him. While browsing the internet, you can use the following keyboard shortcuts: Press and hold the [ALT] key in conjunction with the “Left […]
Need to create an instant graph or chart in Excel on your PC? Highlight your data including the column and row header info; then press the [F11] button. Voila! To spruce up the look of the default chart design, apply one of the various chart themes from the Chart Tools | Design (Ribbon tab) > […]
Using keyboard shortcuts to perform routine tasks will save you time. Here are some wonderful Word Text Alignment shortcuts: [CTRL] L – Left Align text on the page [CTRL] R – Right Align text on the page [CTRL] E – Center Align text on the page [CTRL] J – Justify text on the page
In a prior post, you learned about how to use the Quick Step feature in Outlook 2010 to organize your emails. Since that post, I have been asked if there is a way to organize or alphabetize the Quick Step gallery list and the answer is “Yes”. Snippet™ Training Lesson: 1. Open Outlook 2010. 2. […]
Did you know that you can create just “one” presentation and then present variations of that “one” presentation to different audiences by including, omitting or rearranging certain slides from that “one” presentation? Yes, you can! The average PowerPoint user would have one master PowerPoint presentation file and then do a File > Save As (Keyboard […]
Have you ever had a long list of items and you need to quickly identify which ones are duplicates? Thankfully, Excel’s Conditional Formatting feature makes it easy to quickly find duplicates in Excel. Open your Excel file and highlight the data that may have duplicates. From the ribbon, select Home (tab), Styles (group), Conditional Formatting […]
Microsoft Excel has many templates that you can download for free from Office.com. In this blog post we demonstrate how to produce a family calendar in Excel 2010 using one of these templates. Start Excel Choose File (tab), New Click Calendars Double click a folder such as 2012 Calendars Click Family calendar (any year, Sun-Sat) […]
I love to share knowledge because I believe knowledge is power. Recently, I shared on my Facebook page a tip about how to delete emails permanently from your Inbox. This led to some discussion on the topic, which I want to share with you in this week’s post. To Delete an Item There are three […]
Have you ever had someone tell you they know Excel? Of course, one might ask, “What does it really mean to say you know Excel?” It is true that the program has so many features that it is almost impossible to know all there is to know about Excel. Even so, perhaps you can use […]
©2014 Snippet Training, all rights reserved.
Home | Sitemap | Contact us
