Category: Web Excel
-
Data Filtering and Subtotals
Analyzing part of the data We have been working with various tables of data. We learned how to sort data alphabetically and from largest to smallest. This is all very useful and helpful. But what if you want to know the total or some other fact about a portion of the list? Spreadsheets are a…
-
Data Sorting
People have worked with lists and tables of data for centuries. Until the last few decades the only option was a hand written list. You can imagine that a hand written list of information is not easily rearranged! Let’s say you wrote down a list of names of people to invite to a reunion. You…
-
Data Storage and Manipulation with Spreadsheets
A world full of data The world is full of data. It always has been. For millennium people have needed to organize and record information. That information was then used in many different ways. The Bible is a very interesting source of examples of early data collection and manipulation. In current times the amount of…
-
VLOOKUP() Function
VLOOKUP stands for “Vertical Lookup”. It is a function that makes Excel search for a certain value in a column, the “table array”, in order to return a value from a different column in the same row. Download File VLOOKUP() False Worksheet Start by entering a VLOOKUP() function in G2. The VLOOKUP() function has 4…
-
Intermediate Functions
In this lesson we will work with some more functions. LEFT() and RIGHT() are some useful functions for separating out a part text that exists inside of a larger string of text. We can also use CONCAT() to join multiple cells into one string of text. If we want to check for multiple things to…
-
Cell References
Many times it is needed to use values from other cells to calculate totals, averages, or other useful information. This is a basic feature of all spreadsheets. In this lesson you will learn how to work with reference that change as formulas are copied to new cells, references that don’t change when they are copied…
-
Conditional Formatting
Conditional formatting is a wonderful way to draw attention to specific data. It also if very effective at highlighting differences in cell values. You will find other great uses for conditional formatting as you continue to use Excel. Download File Data Bars Worksheet Add data bars to the month columns. This is a really easy…