My Brain Hurts!

Yesterday I attended an advanced session on Excel. I have worked with Excel before, so I don’t consider myself a beginner but I was hoping that the advanced session would not be too advanced. Well, what I found was a fast paced session introducing many concepts that I had; a) never used before and b) never heard of! I was able to keep up for the most part, but alas, did not have a chance to make notes along the way as I was following along with the demonstration.
From what I can remember, we learned how to do the following [formulas included in the brackets]:

a) How to create a random list of numbers [=RANDBETWEEN(10000,99999)]

b) How to move the list of numbers to another section, using the right click function and then copy here as values only

c) Move or copy a tab to create a duplicate of a worksheet

d) Use the shift key to grab multiple tabs so that the formula or formatting appears on multiple sheets

e) Press the control key and drag a worksheet on your desktop, which is an easy way to create duplicate copies

f) Sum If statements [=SUMIF(E4:E20,"aqua",F4:F20)], which is useful when categories are assigned.  You can add all items within a particular category.  A similar formula is [=COUNTIF(C3:O19,E4)] that allows you to count how many times the entity appears within the worksheet. In our example, we were counting the number of times the word yellow appeared within the worksheet.

g) If/Then Statements [=IF(F5>300000,5000,0)]

h) More complicated If/Then Statements such as [=IF(F5>300000,5000, IF(F5>275000,3000, IF(F5>250000,2000,0)))], which allows you to apply multiple criteria in one formula. In our example, we were assigning bonuses based on YTD sales

i) Summaries, Pivot Tables and Animation of a bar graph from a pivot table in PowerPoint were then discussed.

I cannot get over how smart Excel is. I want to attend the session next year so that I can absorb all of the stuff that I missed yesterday, or at least have a chance to practice it once more. It is hard to retain information when you do not use the tool very often.