strick206
Member
Registered: 12th Apr 07
Location: Wigan Drives:Integra DC5
User status: Offline
|
Hello everyone, looking for some advice, i am quite good on excel, formulae and lookups etc, have built spreadsheets in the past to keep track of my betting and showing my profit etc. So can use excel quite well.
I want to push that to the next level, and become advanced on excel, i want to be able to use excel to work websites and search for things in conjunction with other equipment. I also want to become good with macros, i eventually hope to be in a position where being advanced in excel could be a big asset.
Is it Sam on here that is a whizz on MS Excel?
Any advice is appreciated, i don't mind enrolling to home learning or the like
|
A2H GO
Member
Registered: 14th Sep 04
Location: Stoke
User status: Offline
|
Dom and Pow are spot on with Excel. 
|
pow
Premium Member
Registered: 11th Sep 06
Location: Hazlemere, Buckinghamshire
User status: Offline
|
The thing is, people try and replace what should be done by databases (Access, MySQL, SQL Server). If you're pretty good with Excel as it is, move on to start to learn Access. With that you can learn more about databases/handling information etc.
|
strick206
Member
Registered: 12th Apr 07
Location: Wigan Drives:Integra DC5
User status: Offline
|
I'm 'decent' on excel, but i have no idea when it comes to macros, and that is something i would like to learn, i have used access in the past but only briefly so have a slight understanding of it.
Macros is the main thing as i want to progress into the operating of a bot type system with excel taking live data from the net
|
Robbo
Member
Registered: 6th Aug 02
Location: London
User status: Offline
|
learn vbasic
|
pow
Premium Member
Registered: 11th Sep 06
Location: Hazlemere, Buckinghamshire
User status: Offline
|
Time to learn VB then  
|
Dom
Member
Registered: 13th Sep 03
User status: Offline
|
VBA is the next step for Excel but i'd really thinking about scraping Excel and design your own app (.NET, Realbasic etc).
|
pow
Premium Member
Registered: 11th Sep 06
Location: Hazlemere, Buckinghamshire
User status: Offline
|
TBH learning VB isn't a bad skill to have
|
Dom
Member
Registered: 13th Sep 03
User status: Offline
|
quote:
Originally posted by pow
TBH learning VB isn't a bad skill to have
True, knowing anyform of basic is useful (enviroments like Realbasic can compile to Win/nix/OSX) and it's pretty straight forward; could get the basics in a few days. But i still think it's worth scrapping Excel and develope a proper app.
|
strick206
Member
Registered: 12th Apr 07
Location: Wigan Drives:Integra DC5
User status: Offline
|
What do you mean by a proper app Dom?
so vbasic is the thing to learn, what is it, could you elaborate for me?
|
Sam
Moderator
Premium Member
Registered: 24th Dec 99
Location: West Midlands
User status: Offline
|
The macros in Excel use VBA - VBA being Visual Basic for Applications.
Dom means making an actual standalone application instead of just coding a macro in an Excel file.
But you would need to install Visual Basic on your PC to "develop" the application in.
I'd probably just stick with an Excel macro if you are happy enough with Excel.
[Edited on 06-07-2011 by Sam]
|
