Using Excel! Week 11

The task for this week required me to try out Excel, in doing so I was asked to complete several minni tasks.

Myself, not a fan of excel having had to use it in High school, I never got formulas correct, no idea how, but I always managed to muck up something!

As a result of my lack of skills when using excel, I did find simple things easy (like entering data) but when I got to entering formulas i.e =IF(F2>0,$Gain$,$Loss$), thats' when it all went down hill, nothing went my way what was meant to come up didn't - it was horrible. You could see it now teeth clenched and hands in a fist ready to punch out the computer. But I kept my cool and continued the tasks required.

When I was aksed to make graphs, I nailed it as I have had to make graphs in excel on numerous prior occasions, and I find them fun and easy enough to use - it's pretty straight forward really.

MACROS, MACROS MACROS.. How I love Macros.. eww not..

I had major difficulties in the section asking me to:

"Create another Macro called 'GainsandLosses'. When recording select rows 1-5, right-click and select Unhide. Click Stop.
Now create another Macro called 'Losses'. When recording select rows 2 and 3 (which have a Gain) right-click on the mouse and select Hide. Click Stop. "

Yeah okay, is that all? I did all that, however did I come up with the right outcome - well what do you think? NOOOOO! Somehow it all went out of whack, my losses didn't add up or anything at that matter!


Excel.. Not for everyone!