If know a little and what to learn more. Here are a few tips
Step 1
- Autofilter
- Conditional Formatting
- VLOOKUP
- Charts
- COUNTIF
- Pivottable basics
Step 2 would be to learn about Index and Match
Step 3 would be to learn about Arrays and Array formulas, SUMPRODUCT
This site can teach all of the above:
http://www.datapigtechnologies.com/ExcelMain.htm
+
http://personal-computer-tutor.com/excel.htm
Ola Sandström
--
olasa
------------------------------------------------------------------------
olasa's Profile:
http://www.excelforum.com/member.php...o&userid=17760
View this thread:
http://www.excelforum.com/showthread...hreadid=376454