“自从公司上了财务系统,又听说AI要取代人工,我就没怎么钻研EXCEL了。结果上周做季度分析,领导临时要一份按区域、产品线、客户分层交叉透视的销售毛利表,我折腾了一整天,最后被新来的95后同事用数据透视表+Power Query十分钟搞定......
Many people avoid Power Query because they think it's too technical, but it's actually one of the safest and easiest ways to organize your data. It handles the dirty work with an intuitive interface, ...