ShaunWhite wrote: ↑Fri Apr 10, 2020 6:09 pm
jamesg46 wrote: ↑Fri Apr 10, 2020 5:02 pm
it may take me some time to figure it out but I guess it's worth while long term.
If you're not using vba/macros/functions etc then you're only skimming the surface of Excel.. Even if you only spend an hour a day looking at it, by the end of the month you'll already be well on the way because even though it's a big scary topic you only actually need about 10% of everything in the User Guides. You'll go from doing what you can with front end features to doing anything you can conceive of.
Tbf you only need to learn very little, read a cell from a given place into a variable, do some sums, write a variable back to a cell in a given place. Then understand loops and the slight difference in the syntax of IF, and that's about it really. Like Lego it's not what fancy bricks you've got but how you put the simple ones together.
Absolutely! A Kaizen approach... I've never been very computer savvy & I only started using Excel in the last 12 months, I've been very slow to the party but I've slowly realised that there is a whole other dimension to things inside of Excel, its been a very exciting journey so far, that's something I never thought I would of said 12 months back.
