Excel常用函数

• =VLOOKUP()
• =LENB()
• =TEXTSPLIT()
• =CHOOSE(RANDBETWEEN(1,4),””)
• $A$3:$A$20000,$D$3:$D$20000,$G$3:$G$20000,$J$3:$J$20000
• =ISNUMBER(MATCH(A3,特殊链接!$E$2:$E$10000,0)) + ISNUMBER(MATCH(D3,特殊链接!$E$2:$E$10000,0)) + ISNUMBER(MATCH(G3,特殊链接!$E$2:$E$10000,0)) + ISNUMBER(MATCH(J3,特殊链接!$E$2:$E$10000,0)) > 0
• =OR(ISNUMBER(SEARCH("迪士尼",C2)), ISNUMBER(SEARCH("喜洋洋",C2)), ISNUMBER(SEARCH("原神",C2)), ISNUMBER(SEARCH("小蓝人",C2)), ISNUMBER(SEARCH("黑神话悟空",C2)),, ISNUMBER(SEARCH("恋与光",C2)))

Photoshop快捷键

• 新建图层: ctrl+shift+n
• 图层移动: ctrl+[ ]
• 导出为: ctrl+shift+alt+w
• 关闭当前窗口: ctrl+w

VsCode 快捷键

• ctrl+enter 跳转下一行
• shift+alt+方向键 复制当前一行
• shift+del 删除当前一行
• shift+alt+f 格式化文档