News for hackers. Stuff that matters.

A comment on Ask HN: Best way/resources to learn Excel?.

Re:Ask HN: Best way/resources to learn Excel? by garyclarke27 on Sunday January 14, 2018 @06:38PM (#16147250)
Search for ExcelIsFun You Tube Channel. This guy is a truly incredible teacher, thousands of videos from basic to guru level. I suggest you learn: Excel Tables, Index Function (lookup and reference versions) Match Function, SumIfs, CountIfs - inside out - better than Pivot Tables - plus how to write UDFs and Macros in VBA - then maybe PowerBI now part of data tab in Excel 2016.
[ Parent | on HN ]
Re:Ask HN: Best way/resources to learn Excel? by tjt on Tuesday January 16, 2018 @08:22PM (#16164663)
ExcelIsFun helped me so much! Working with Excel and trying to make more complicated solutions is what got me interested in programming and led to the job I have now.

I've also really enjoyed "Excel 2013: Power Programming with VBA" by Walkenbach.

[ Parent | on HN ]