|
|
|
|
Tutorial by
excelbuddy.com
Pivot tables are one of the most versatile and powerful tools available in Excel. They allow you to display data in a table format with multiple filters, and the ability to easily add or remove rows and columns.
|
|
Added on:
8/4/2010
|
Rating:
|
Viewed
2 Times
|
|
|
|
|
|
Tutorial by
www.excelbuddy.com
Learn the difference between relative and absolute cell referencing in Excel.The following tutorial will go over the difference between relative and absolute cell referencing in Excel.
|
|
Added on:
3/1/2010
|
Rating:
|
Viewed
28 Times
|
|
|
|
|
|
Tutorial by
functionx.com
A new worksheet is primarily made of cells that are patiently waiting for you to enter data. There are different types of values that can be entered in a cell.
|
|
Added on:
1/13/2010
|
Rating:
|
Viewed
22 Times
|
|
|
|
|
|
Tutorial by
functionx.com
Besides the strings as we have seen in the previous lesson, a cell can also use a numeric value. Microsoft Excel supports different types of numbers, including integers, decimal values, and currencies, positives and negatives.
|
|
Added on:
1/13/2010
|
Rating:
|
Viewed
19 Times
|
|
|
|
|
|
Tutorial by
functionx.com
An expression is a combination of values and symbols used to produce a new value. There are different types of values involved in an expression.
|
|
Added on:
1/13/2010
|
Rating:
|
Viewed
15 Times
|
|
|
|
|
|
Tutorial by
barrelofcrafts.com
How to Easily use the Autofilter and Advanced Filter Functions in Excel
|
|
Added on:
1/13/2010
|
Rating:
|
Viewed
17 Times
|
|
|
|
|
|
Tutorial by
mstipsandtricks.com
In this tutorial, you will apply connect with another data source to obtain data.
|
|
Added on:
1/13/2010
|
Rating:
|
Viewed
15 Times
|
|
|
|
|
|
Tutorial by
nicetutz.blogspot.com
The concept of "protection" gets a lot of attention in the Excel newsgroups and forums. It seems that many users want to learn how to protect their workbooks from being copied or modified. Excel has several protectionrelated features.
|
|
Added on:
1/13/2010
|
Rating:
|
Viewed
15 Times
|
|
|
|
|
|
Tutorial by
excelbuddy.com
This tutorial will show you how to create a dependent list on Excel. This technique is extremely useful when categorizing data. In the example below, the user will select the State in cell A3. Cell B3 (City) will pull a city based off of the users selection.
|
|
Added on:
1/13/2010
|
Rating:
|
Viewed
15 Times
|
|
|
|
|
|
Tutorial by
tutorials-expert.com
The IF statement is excel is very useful, but can become a little complicated. The following explanation will explain how to easily and properly use this function.
|
|
Added on:
1/13/2010
|
Rating:
|
Viewed
18 Times
|
|
|
|
|
|
Tutorial by
anypdftools.com
There are many files such income statements and balance sheets in PDF format, you may copy and paste to Excel for further calculation work. Now with PDF to Excel Converter, you can let it do the whole job for you. Now I would like to show you how to save a PDF file as an Excel file.
|
|
Added on:
1/13/2010
|
Rating:
|
Viewed
14 Times
|
|
|
|
|
|
Tutorial by
excelbuddy.com
VLOOKUP in excel stands for vertical lookup. This simple function is extremely useful if you have large lists of data. With this function, you can easily search through a list of data and match specific criteria. In the example below, we will use this function to match a batting average with a specific player.
|
|
Added on:
1/13/2010
|
Rating:
|
Viewed
16 Times
|
|
|
|
|
|
Tutorial by
excelbuddy.com
Excels concatenate function is used to combine character strings from multiple cells. This function can be extremely useful if you need to perform a manual task on a large list of data.
|
|
Added on:
1/13/2010
|
Rating:
|
Viewed
24 Times
|
|
|
|
|
|
Tutorial by
excelbuddy.com
HLOOKUP stands for horizontal lookup. The difference between HLOOKUP and VLOOKUP is that HLOOKUP searches for data in rows instead of columns.
|
|
Added on:
1/13/2010
|
Rating:
|
Viewed
20 Times
|
|
|
|
|
|
Tutorial by
excelbuddy.com
The SUMIF function adds cells specified in range by a certain condition or criteria.
|
|
Added on:
1/13/2010
|
Rating:
|
Viewed
18 Times
|
|
|
|
|
|
Tutorial by
excelbuddy.com
The AutoSum Function is by far one of the most useful features in all of Excel. Just about every spreadsheet can benefit from incorporating the AutoSum function.
|
|
Added on:
1/13/2010
|
Rating:
|
Viewed
19 Times
|
|
|
|
|
|
Tutorial by
functionx.com
In Lesson 3, we saw that a list could be described as a series of categories called columns. In Lesson 4, we saw that a list organized the values of columns in horizontals sections called rows.
|
|
Added on:
1/11/2010
|
Rating:
|
Viewed
15 Times
|
|
|
|
|
|
Tutorial by
anypdftools.com
How to convert my PDF file to Excel spreadsheet?
|
|
Added on:
1/11/2010
|
Rating:
|
Viewed
18 Times
|
|
|
|
|
|
Tutorial by
functionx.com
In the expressions we have created so far, we were using operators, constants, and values we knew already. In some complex expressions, just the known operators and the values in cells will not be enough. An alternative is to use a function.
|
|
Added on:
1/11/2010
|
Rating:
|
Viewed
27 Times
|
|
|
|
|
|
Tutorial by
barrelofcrafts.com
How to Create Simple Pivot Tables and Reports in Excel
|
|
Added on:
1/11/2010
|
Rating:
|
Viewed
18 Times
|
|
|
|