Excel

15 个 Excel 效率 Skill:清数据、写公式、查错一次配齐

15 Excel Productivity Tips: Clean Data, Write Formulas, and Troubleshoot—All in One Place

The most tedious part of working with Excel is always the entire process: cleaning data, writing formulas, summarizing results, and checking for errors. I cross-checked each entry from the two lists one by one on GitHub, removed those for which I couldn’t find the source code, and narrowed it down to 15 Skills that can actually be installed. I grouped them into three categories based on their use, along with star ratings and repository links—the star ratings are for reference only.

cheng cheng 2026-11-18
50 0 0
Excel求和统计函数,SUM、AVERAGE、COUNT、SUMIF、SUMIFS 一次学会

Excel Sum and Statistical Functions: SUM, AVERAGE, COUNT, SUMIF, and SUMIFS—Learn Them All at Once

Many people aren’t very familiar with Excel functions. They see others writing formulas but don’t know where to start themselves. Today, I’ll introduce five of the most commonly used summation and statistical functions: SUM, AVERAGE, COUNT, SUMIF, and SUMIFS. They’ve helped me solve almost every numerical and statistical problem I’ve encountered. SUM Function SUM is a summation function—it was the first function I learned—and its purpose is simple: to add up a set of numbers

cheng cheng 2026-09-30
81 0 0
Excel常用函数入门:公式、区域、绝对引用和错误值

Introduction to Common Excel Functions: Formulas, Ranges, Absolute References, and Error Values

Have you ever had this experience: you open a spreadsheet, see an equals sign in a cell, and think, “This is just a simple calculation,” but as soon as you hit Enter, Excel throws an error value at you, and you’re instantly stumped? Don’t worry—Excel isn’t trying to trip you up. It’s actually trying to communicate with you, but it’s using terms you haven’t quite grasped yet. Once you understand these four terms—formula, range, absolute reference, and error value—everything else will fall into place. Use the equals sign to tell E

cheng cheng 2026-09-20
92 0 0