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. […]
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 […]
Last week a friend of mine was doing some data entry into a large spreadsheet that had a lot of columns to it. She found it a bit cumbersome to enter the data going across in the spreadsheet. Her question to me was: “Is there a way to enter data going down a list (in […]
This is the third blog in a series about creating macros in Excel, Word and other applications within the Microsoft Office. This article is about Understanding Macro Code. Understanding Macro Code VBA is a Language Many people, after learning how to record a macro, take a look at the code and then they panic. “How […]
Recently, I was asked by one of my Excel students if there was a way to insert a date on their spreadsheet that doesn’t automatically update. The answer is “yes”. They were already familiar with the date function =TODAY(). Here is a short lesson on how to enter both types of dates and times into […]
This is the second blog post in a series about creating Excel macros, Word macros, and other macros for applications in the Microsoft Office. The big lie: Many people have been told that creating a macro is easy. They are told just turn on the recorder, do your actions, and stop the recording. While those […]
Would you like to reduce the time it takes you to create a presentation in PowerPoint 2010? The solution is to use the PowerPoint Outline feature. One of my friends travels extensively giving presentations across the country. She feels as if she is always in presentation creation mode. To help her save time during her […]
©2014 Snippet Training, all rights reserved.
Home | Sitemap | Contact us
