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) […]
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 […]
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 […]
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 […]
This blog post begins a series of articles about Microsoft Office macros. Today’s article discusses what a macro is and how to run a macro. What is a macro? The following definition and description of macros comes from our “Excel VBA Macro Programming” book. A macro is a series of commands that can be executed […]
Vlookup is a powerful function that can help you lookup information from a table or list of data. Suppose you have a list of 5000+ movies like the one shown below. The VLookup function will allow Excel to lookup an ID number and return the corresponding title, year, category, rating, etc. The following slides, used […]
Every so often, for no apparent reason, Microsoft Outlook doesn’t quite start the way it should. Or worse maybe it doesn’t start at all. This may be caused by an Outlook add-in that for some reason isn’t working. Thankfully there is a way to fix this. It’s called “Safe Mode”. To start Outlook in Safe […]
Before creating a database you should have some blueprints that will guide its creation. In part one of this series we talked about having sketches of input forms and reports. Part two was about creating a list of fields in a “Field List Worksheet” document. Now we are going to talk about creating an ER […]
In part one of this series we said you should start planning your Access or FileMaker Pro database by using paper and pencils to draw the input forms and reports that your users will need. Now we are going to talk about using those mockups to create a “Field List Worksheet.” A “Field List Worksheet” […]
©2014 Snippet Training, all rights reserved.
Home | Sitemap | Contact us
