|
|
Post by musik on Oct 1, 2021 10:52:29 GMT
I've had Excel for 5 years but never really used it. My PC needs a service first though.
What is Excel good for? What can it do?
Apart from reading the Tipping Competition 2021/2022 League table, that is. What's Excel's capacity?
I remember I used Excel at work once for a few minutes, writing numbers into boxes, cells, but when I said I had never used it before, they didn't believe me.
|
|
|
|
Post by mickeythemaestro on Oct 1, 2021 10:57:06 GMT
Its kind of like a complicated calculator that produces tables for you. I have been on 2 courses in my time at various jobs for it and still haven't got a clue. My missus is an accountant and seems to think its ace.
|
|
|
|
Post by stokeuk474 on Oct 1, 2021 10:59:53 GMT
I think it's Excellent
|
|
|
|
Post by spiderpuss on Oct 1, 2021 11:07:19 GMT
Fucking shit isn't it, lots of irritating features and overloaded with stuff. Why can't most of the stuff you don't use, just be moved to another program?
|
|
|
|
Post by stayingupfor Sexualchocolate on Oct 1, 2021 11:12:37 GMT
Absolutely nothing...say it again waaahhh
|
|
|
|
Post by foghornsgleghorn on Oct 1, 2021 11:24:35 GMT
Excel is excellent. Apart from using many hours a week at work it helps with home budgeting etc. Can be very frustrating at times and I always dread the next version going live as they cause confusion until you get used to changes.
At my previous employer we used it for the weekly weigh-in to see who would have to wear the fat bastard badge for the next week and who won the annual award.
|
|
|
|
Post by RichieBarkerOut! on Oct 1, 2021 11:27:57 GMT
I view Excel as a bloke's program, and Word is for birds.
|
|
|
|
Post by mickeythemaestro on Oct 1, 2021 11:29:32 GMT
Excel is excellent. Apart from using many hours a week at work it helps with home budgeting etc. Can be very frustrating at times and I always dread the next version going live as they cause confusion until you get used to changes. At my previous employer we used it for the weekly weigh-in to see who would have to wear the fat bastard badge for the next week and who won the annual award.That will not go down well with the permanently offended on someone else's behalf brigade. To be fair in my experience most of the permanently offended on someone else's behalf brigade are reet fat bastards. So here they can be directly offended  |
|
|
|
Post by ChesterStokie on Oct 1, 2021 11:42:01 GMT
Lists.
I love a good list 😀
|
|
|
|
Post by musik on Oct 1, 2021 12:08:24 GMT
Ok. Thanks for all these quick answers.
A direct Question.
Suppose we have a Tipping Competition.
Person A think it ends 2-1,
(1-1 at half time).
Person B think it ends 2-0,
(1-0 at half time).
Person C think it ends 1-1,
(0-0 at half time).
Person D think it ends 0-1.
(0-1 at half time).
The game ends 2-1 (0-1 at half time).
Q: Is it possible to instruct Excel how to calculate and distribute the correct points to the four contenders?
🤠
|
|
|
|
Post by hcstokie on Oct 1, 2021 12:25:02 GMT
Ok. Thanks for all these quick answers. A direct Question. Suppose we have a Tipping Competition. Person A think it ends 2-1, (1-1 at half time). Person B think it ends 2-0, (1-0 at half time). Person C think it ends 1-1, (0-0 at half time). Person D think it ends 0-1. (0-1 at half time). The game ends 2-1 (0-1 at half time). Q: Is it possible to instruct Excel how to calculate and distribute the correct points to the four contenders? 🤠 Yes, you’d need to add in a couple of formulas to assess against the HT and FT scores. I think it would be the IF function, so something like IF (cell number=Actual score) score cell = points you wanted to award. You’d probably need a HT cell, FT cell and total cell so that the points could be calculated. The total cell would just be a simple sum of HT and FT cell. You can do a shitload on excel so if it’s anything that involves calculations and displaying data then you can pretty much do it. YouTube IF function excel and you should be able to get what you need 👍🏻 |
|
|
|
Post by thehartshillbadger on Oct 1, 2021 12:28:39 GMT
Lists. I love a good list 😀 Hark at Oscar Schindler! |
|
|
|
Post by innocentbystander on Oct 1, 2021 12:32:21 GMT
I use it for my business accounts, put my own formulas in and everything .
I like the way it makes it look as if I'm running a profitable organised operation rather than the filthy chaos of reality.
I've also used it to tabulate pottery finds on an archaeological dig- the resulting graphs give a good indication of activity levels at the site decade by decade.
It's a brilliant tool, free if you use the Open Office version .
|
|
|
|
Post by prestwichpotter on Oct 1, 2021 12:36:04 GMT
As I've clambered my way up the greasy pole in my career I seem to have become a glorified spreadsheet monkey, so Excel is one of my very few talents in life depressingly...... |
|
|
|
Post by PotteringThrough on Oct 1, 2021 12:41:15 GMT
Ok. Thanks for all these quick answers. A direct Question. Suppose we have a Tipping Competition. Person A think it ends 2-1, (1-1 at half time). Person B think it ends 2-0, (1-0 at half time). Person C think it ends 1-1, (0-0 at half time). Person D think it ends 0-1. (0-1 at half time). The game ends 2-1 (0-1 at half time). Q: Is it possible to instruct Excel how to calculate and distribute the correct points to the four contenders? 🤠 Question: Do you think you should have more points in the tipping comp? Is that what this is all about? |
|
|
|
Post by chrisgal on Oct 1, 2021 12:45:09 GMT
I used it regularly many years ago and found it very useful for budgeting , skill index monitors, risk assessments etc. but things moved as more stand alone programmes became available. I doubt I could use it to good effect these days as I can not remember many of the commands that I used. @sum,hlookup,vlookup are probably the ones I remember without googleing it.
|
|
|
|
Post by thebet365 on Oct 1, 2021 13:03:18 GMT
I've used it for 20 years, I'd be lost without it although MTD is slowly taking away a lot of it's use now.
|
|
|
|
Post by thevoid on Oct 1, 2021 13:08:51 GMT
Lists. I love a good list 😀 Hark at Oscar Schindler! It's more like Schindler's Lifts now |
|
|
|
Post by lagwafis on Oct 1, 2021 13:17:22 GMT
|
|
|
|
Post by teenagefanclub on Oct 1, 2021 13:29:20 GMT
Very underrated B side to "Family affair"
|
|
|
|
Post by musik on Oct 1, 2021 13:31:06 GMT
Ok. Thanks for all these quick answers. A direct Question. Suppose we have a Tipping Competition. Person A think it ends 2-1, (1-1 at half time). Person B think it ends 2-0, (1-0 at half time). Person C think it ends 1-1, (0-0 at half time). Person D think it ends 0-1. (0-1 at half time). The game ends 2-1 (0-1 at half time). Q: Is it possible to instruct Excel how to calculate and distribute the correct points to the four contenders? 🤠 Question: Do you think you should have more points in the tipping comp? Is that what this is all about? I have no idea. If Excel has done the calculations correctly I suppose noone could get too many or too few points, right? |
|
|
|
Post by musik on Oct 1, 2021 13:34:00 GMT
I used it regularly many years ago and found it very useful for budgeting , skill index monitors, risk assessments etc. but things moved as more stand alone programmes became available. I doubt I could use it to good effect these days as I can not remember many of the commands that I used. @sum,hlookup,vlookup are probably the ones I remember without googleing it. It seems to be a very useful programme! How long would you say it will take to learn it completely? 4 hours, 10 hours, 40 hours? |
|
|
|
Post by musik on Oct 1, 2021 13:45:11 GMT
I use it for my business accounts, put my own formulas in and everything . I like the way it makes it look as if I'm running a profitable organised operation rather than the filthy chaos of reality. I've also used it to tabulate pottery finds on an archaeological dig- the resulting graphs give a good indication of activity levels at the site decade by decade. It's a brilliant tool, free if you use the Open Office version . Nice! 👍 I bought the Microsoft Office package where Excel was included, but I've basically only used Word. In an earlier Office version I also used Power Point and Publisher. Printing Houses nowadays though won't accept to print from Publisher files. Most people use Adobe In Design for that purpose, but another programme called Affinity Publisher is a much much cheaper alternative, and can make the files needed. |
|
|
|
Post by mickeythemaestro on Oct 1, 2021 13:45:14 GMT
I used it regularly many years ago and found it very useful for budgeting , skill index monitors, risk assessments etc. but things moved as more stand alone programmes became available. I doubt I could use it to good effect these days as I can not remember many of the commands that I used. @sum,hlookup,vlookup are probably the ones I remember without googleing it. It seems to be a very useful programme! How long would you say it will take to learn it completely? 4 hours, 10 hours, 40 hours? Depends. As I said I went on 2 full day courses and only really mastered the absolute basics. Then again I'm a bit of a thick twat so I am sure others could easily get quite proficient on it in hours. Ultimately it is about usage and if you spend time working on it regularly I guess you pick it up eventually. |
|
|
|
Post by dave1 on Oct 1, 2021 13:59:08 GMT
I use excel quite a bit. Find pivot tables, vlookups, conditional formatting, some of the formulas very handy
|
|
|
|
Post by lawrieleslie on Oct 1, 2021 14:25:47 GMT
I was Deputy Quality Manager in Devonport Dockyard in late 90s when ISO 9002 was being installed as a quality tool to make sure the Naval Base services were providing a good service to visiting ships or ships in repair/maintenance. Part of my job was to analyse feedback from ships and provide a monthly performance précis to the Naval Base Commander. I used Excel extensively to produce the analysis and found it an excellent tool. That would have been using early version of Windows and Excel so would imagine it is even more powerful now.
|
|
|
|
Post by chrisgal on Oct 1, 2021 14:38:52 GMT
I used it regularly many years ago and found it very useful for budgeting , skill index monitors, risk assessments etc. but things moved as more stand alone programmes became available. I doubt I could use it to good effect these days as I can not remember many of the commands that I used. @sum,hlookup,vlookup are probably the ones I remember without googleing it. It seems to be a very useful programme! How long would you say it will take to learn it completely? 4 hours, 10 hours, 40 hours? Basic stuff would probably take a day if you have not used it before. It can be a very powerful programme if you can write your own formulas etc. Try youtube for learning. |
|
|
|
Post by mrcoke on Oct 1, 2021 15:35:25 GMT
I found it an excellent tool when I was working.
Rarely now I'm retired, which means if I do dip back into it after a long time I find it hard to remember how to do some things.
|
|
|
|
Post by dutchstokie on Oct 2, 2021 8:31:43 GMT
It seems to be a very useful programme! How long would you say it will take to learn it completely? 4 hours, 10 hours, 40 hours? Basic stuff would probably take a day if you have not used it before. It can be a very powerful programme if you can write your own formulas etc. Try youtube for learning. This…. YouTube has a stack of films on how to use it in terms of the type of job you do and what you want to get out of it. I play around on it regularly, just messing around putting different formulas in. If it doesn’t work, just hit the arrow top left, and go back a step. ( I’ve had LOADS of “ aaahhhh THATS how it works” moments and plenty of “ oh BOLLOCKS” moments as well Enjoy playing around on it tbh |
|
|
|
Post by metalhead on Oct 2, 2021 17:37:28 GMT
An absolutely superb piece of software if used correctly. As people have mentioned, pivot tables and all that kind of stuff.
At work, I've created a High Level Overview which provides projections, dates, work that's not moving, work that's unlikely to finish on time etc, all from a raw dataset. The whole thing took a few days to create (on and off) but the time it has saved me over the few weeks I have had it is absolutely tenfold. By simply taking a dump of data from my issue management tool, I can copy the data into a new worksheet, copy the columns I need into a hidden section and within about 30 seconds, start to finish, I have an updated view of the world, with re-projected dates, things to watch, overruns etc.
The key is to get yourself a solid workbook that does all of your maths for you automatically and then finding the most sensible way to quickly transpose data. Invest the time at the start and get it as automated as possible. Historically, I had done this manually, probably because I didn't have the time to work out a quicker solution. Now that I have, I will never go back.
You can also use it to create simple Gantt charts.
|
|
