3 ms·
Becoming an advanced photoshop user is difficult too. But I can still fire it up and doing basic image editing with about 2 minutes worth of figuring-out. Excel
by AmericanChopper 6y ago
Becoming an advanced photoshop user is difficult too. But I can still fire it up and doing basic image editing with about 2 minutes worth of figuring-out. Excel is almost a full RDBMS, but the basics don’t really need any training.
- swiley 6y agoI don’t think excel can do joins which is a big part of the “R” in RDBMS but I don’t use excel often so I could be wrong.
- AmericanChopper 6y agoExcel merge supports joins, and you can do ordinary SQL joins using Power Query. I don't know if it full complies with all of Codd's 12 rules, I suspect it probably doesn't fully meet the schema definition or non-subversion bits, but I haven't looked into it closely enough, the Excel Data Model functionality looks like it might actually do that.
- LyndsySimon 6y agoI'm fairly sure it can. It's been years - almost a decade, now! - since I've had to use Excel for anything productive, but I vividly recall using VLOOKUP to create what were effectively views from a SQL perspective.