eiffel_71: The Big Match opening title (Default)
[personal profile] eiffel_71
Did my Using The Computer & Managing Files exam tonight. Seemed to go OK. Went for a coffee and bumped into Mark, a friend of the parents who's a teacher at the school and was helping out at a Careers Fair that was just coming to the end. Spent the rest of class doing Spreadsheets - much of it's familiar from the CLAIT but I'm also learning some new stuff like MIN, MAX and IF functions. So far it's a breeze...

(no subject)

Date: 2007-11-06 10:15 pm (UTC)
From: [identity profile] amysarah.livejournal.com
Excel is fun. You can get some really neat things going in it. Conditional formatting is always good

(no subject)

Date: 2007-11-06 10:20 pm (UTC)
From: [identity profile] moonhot97.livejournal.com
Conditional formatting is always good

Is that the =IF(B2>250, "Brilliant", "Shite") function? I learned that tonight.

(no subject)

Date: 2007-11-06 10:24 pm (UTC)
From: [identity profile] amysarah.livejournal.com
Yup! There is also one you can do that extends it to make the cells change colour which is always neat.

Format > conditional formatting

(no subject)

Date: 2007-11-06 10:34 pm (UTC)
From: [identity profile] moonhot97.livejournal.com
There is also one you can do that extends it to make the cells change colour

Ran out of time just as I was reading the intro to that bit, so those delights await me next week.

(no subject)

Date: 2007-11-06 10:35 pm (UTC)
From: [identity profile] amysarah.livejournal.com
Its fun (and yes I am a geek :o) )I have spreadsheets with funky ass colour issues!

(no subject)

Date: 2007-11-06 11:10 pm (UTC)
From: [identity profile] nice-guy-but.livejournal.com
Is there any other reason for using Excel other than conditional formatting? :-)

(no subject)

Date: 2007-11-06 11:23 pm (UTC)
From: [identity profile] nice-guy-but.livejournal.com
What a fool I was for forgetting that!

(no subject)

Date: 2007-11-06 11:25 pm (UTC)
From: [identity profile] amysarah.livejournal.com
Also funny shaped line graphs, but they harder - super advanced excel!

Profile

eiffel_71: The Big Match opening title (Default)
The Man Who Loves Laura Bassett

August 2025

S M T W T F S
     12
345 6789
10111213141516
17181920212223
24252627282930
31      

Style Credit

Expand Cut Tags

No cut tags