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 […]
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 […]
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 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 […]
What is a PivotTable? A PivotTable is a useful tool for creating summary reports from Excel data. And the cool thing is you can “Pivot” or move the fields of the report. For example all of the following screen shots are from PivotTables that were created from an Excel list of 5406 movies. Figure 1: […]
©2014 Snippet Training, all rights reserved.
Home | Sitemap | Contact us
