culiao2169的博客

数据透视表切片器显示空白Instead of adding and removing pivot table values one at a time, click a Slicer, to quickly add and remove them, in groups. Most pivot tables won't need this, but for source data with lots...

excel中转换为数值Last weekend I set up a little spreadsheet in Excel to compare the cost of a trip in a rented RV versus a small car. The only gas consumption numbers I could find for the RV were in miles p...

excel保存自定义宏The Quick Access Toolbar (QAT) is at the top of the Excel window, and comes with a few default commands installed. See how to customize the QAT, use shortcuts to run the commands, and how t...

excel组合汇总In this week's roundup, KPI dashboards, pricing lookups, autofit for merged cell rows, and more. 在本周的综述中，KPI仪表板，定价查询，合并单元格行的自动拟合等等。 1.自动调整合并行 (1. AutoFit Merged Rows)If you merge cells, E...

excel组合汇总In this week's roundup, make VLOOKUP faster, use keyboard shortcuts, run macros when Excel is closed, and many more tips. 在本周的综述中，使VLOOKUP更快，使用键盘快捷键，在Excel关闭时运行宏以及更多技巧。 If you read or wrote...

outlook 联系人 慢Occasionally you might get an email in which the sender mentions someone else. In the example shown below, the client promises to ask Xavier to contact you. 有时您可能会收到一封发件人提到其他人的电子邮件。 在下面显...

1000卡路里计算器Good work! You’ve stopped eating cookies, and you’re recording your daily food intake in the Excel Calorie Counter. The pounds are magically melting away, and you’re keeping track of your we...

数据透视表和数据交叉表When you summarize data in a pivot table, it usually shows a sum of the values. (If there are blanks or text values in the field, usually the pivot table shows a count instead.) 当您汇总数据透视表中...

jmeter 板书Heather R, with comment 5 希瑟·R， 评论5 Jeff, with comment 26 杰夫， 评论26 Congratulations, and I will email you later today, to arrange sending your copy of the file. 恭喜，我将在今天晚些时候给您发送电子邮件，以安排发送文件副本...

if函数和and函数嵌套The IF function lets you test something in Excel, and show one result if the test result is TRUE, and another result for FALSE. For example: IF函数使您可以在Excel中进行测试，如果测试结果为TRUE，则显示一个结果，对于FALS...

excel按照天分组 Excel 4000天快乐 (Happy Excel Day 44000) Since you love Excel, you probably already noticed that today (June 15, 2020), is Excel day 44000. You'll see that if you type today's date in a worksh...

fastexcel 使用FastExcel工具修复慢的Excel文件 (Fix Slow Excel Files with FastExcel Tools) If we're sitting at home, with little to do but eat, watch TV and sleep, we might get a bit slow and bloated, which isn't...

透视表二级菜单 从数据透视表下拉菜单中清除旧项目 (Clear Old Items from Pivot Table Drop Downs) Old items might still appear in pivot table drop down lists, even after you remove the items from the source data. Here’s how to ...

表单生成excel Excel搜索表单生成器更新2020-06 (Excel Search Form Builder Update 2020-06) There's been an update to my Excel Search Form Builder (SFB), so download the latest version if you've bought this product be...

excel 多项 匹配 在Excel中显示匹配项列表 (Show List of Matching Items in Excel) Today's video shows how to set up a matching items list – select a region name, and the list shows all employees who work in that regi...

九九乘法表练习 Excel乘法表练习工作簿 (Excel Multiplication Table Practice Workbook) Do you remember the number grids from your schools days, where you filled in the multiplication answers? What's 4 times 8? Or 9 tim...

如何右键菜单添加命令提示符 在右键菜单顶部添加过滤器命令 (Add Filter Commands at Top of Right-Click Menus) Do you spend lots of time in Excel tables, filtering the data, then clearing those filters later? If so, this free add-in...

funcode高尔夫 高尔夫发球时间的Excel工作簿 (Excel Workbook for Golf Tee Off Times) The golf courses aren't too crowded here this summer, because of the social distancing rules. So, if you're trying to spread out the...

奇数项求和公式 Excel公式求和奇数或偶数周 (Excel Formula to Sum for Odd or Even Weeks) Here's an Excel formula challenge for you, based on an email question that someone sent to me. They wanted help with an Excel formu...

膳食结构 Excel每周膳食计划程序更新20200402 (Excel Weekly Meal Planner Update 20200402) There's an Excel weekly meal planner on my website, to help you organize your meals, and create a shopping list. Now that we're...