Been using excel for a number of years...

JamieCropley

New Member
Joined
Apr 7, 2022
Messages
0
Office Version
  1. 365
Platform
  1. Windows
Been using excel for a number of years, recently graduated university, to get back into the job market I know I am going to have to improve my excel skills a lot more.
 

Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand
Welcome aboard and good luck with the job hunting! :)
 
Hi Jamie, Are you still trying to learn excel? I'm still learning - my story is that my skills in ixcel have stayed the same since I graduated more than 20 years ago - I'm learning quickly-ish again now though. I'm currently going through the Unmasking Excel book by Bill - how are you increasing your excel skills?
 
Hi both and Hi Rory long time no speak.

I started using Excel on version 2 in the early 90's. 30 years ago?

Most people use a small amount of Excel and then stop learning. I never stopped, after 30 years I'm still learning. It involves lots of frustration!

I picked up a book on VBA by John Walkenbach. I doubt it matters who wrote it just read a book. Learn VBA and you'll suddenly 'get' Excel.

But I have to say, once you've learnt a bit from a book, or if you haven't, the Excel questions forum here is the best teacher you'll ever have. It's real life problems and real life answers.

Don't look at RoryA's website until you're well-versed. Excel was a work of genius but it's the most complicated thing technically.

One tip, right click on the ribbon. There's one option unchecked, Developer. Tick it. Apart from VBA, the Insert menu is a lifechanger.
 
Hi Johnny
That was such an excellent introduction - thank you so much for me and anyone else feel really welcome in here.

I remember learning VBA about 10 years ago - I wanted to create something decent as I'd worked at my organisation for 10 years and I wanted something to show for it - kind of like a marker almost. I wrote a VBA tool in excel to connect to about 500 servers at once, then run some SQL to return any one row of data. This came in super handy as I was always being asked to connect to servers to check that customers had received an update. I could run almost any SQL SELECT statement and even UPDATE statements I wanted - at the touch of a button. The power was in my hands I guess and sometimes found myself with nothing to do lol !!

Then something unfortunate happened I guess - I ran out of ideas about what else I could use my hidden VBA talent on. I kept having to do the odd bit of maintenance on my VBA which was easy enough - but over time, my organisation seemed to not ask me to check servers less and less, so I basically lost all my VBA skills - I still have the tool I wrote of course.

I wonder if anyone else is like me and finds that they run out of ideas to do with VBA? So then, they forget what they've learn't.

This year I've just learned about pivot tables and power query but I'm also feeling a bit afraid that that I won't need those skills well in a year so.

Anyway thanks again for making me feel so welcome
Best regards
Matt
 
Hi Jamie, Are you still trying to learn excel? I'm still learning - my story is that my skills in ixcel have stayed the same since I graduated more than 20 years ago - I'm learning quickly-ish again now though. I'm currently going through the Unmasking Excel book by Bill - how are you increasing your excel skills?
Yeah I am still trying to learn it always.
 
I won't be using my Excel skills within a few months, as I've had enough of working so I'm going to retire.
 
I won't be using my Excel skills within a few months, as I've had enough of working so I'm going to retire.
Nice! If you have any work you want to get rid of feel free to send it my way lol
 

Forum statistics

Threads
1,216,503
Messages
6,131,020
Members
449,615
Latest member
Nic0la

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top