HI all
I have good command over Excel but still unsatisfied with my knowledge.
I want to do something to learn more about Excel.
I need to find some challenging assignments of Excel and also I want to have some jobs on Excel to earn some extra money.
Any suggestion
max v
Favorite Answer
it sounds to me like you should get started with a database system like Access and move on to SQL when you understand the relationships between tables:
- what is a table. what is a record ( and its data types like text/numeric/date/null/etc )
- what is: primary key, foreign key ( the Access relationships diagram is nice here )
- one-to-many relationship
- many-many relationship ( resolved by 2 one-to-many relationships and a new table )
- one-to-one relationship ( resolve by merging the tables into one )
- what cascade on update and cascade on delete do
a spreadsheet has it's limits. think about trying to create a spreadsheet where you want to find a line among millions. or how many lines contain the same information. databases have a nice way of handling this redundancy free without stuffing everything into one huge table. by splitting things into tables and only allowing the use of existing things through relationships it makes a very sane system. ( maybe i'm just rambling on now )
but databases are more interesting than spreadsheets and you sound ready for it. you can earn big bucks doing databases (database administrator) it's everywhere as you probably know (like this site).
just a suggestion ^_^