update

jiangxincode · jiangxincode · commit da98f086f47b · 2022-04-05T19:25:22.000+08:00
diff --git a/EditorAndIDE学习之路.md b/EditorAndIDE学习之路.md
@@ -85,7 +85,6 @@
 * xmlspy: <https://www.altova.com/xmlspy.html>
 * Bluefish: <http://bluefish.openoffice.nl/index.html>
 * codelite: <http://www.codelite.org/>
-* kite: <https://kite.com/>
 * kdevelop：<https://www.kdevelop.org/>
 * xcode: <https://developer.apple.com/xcode/>
 * QtCreator: <https://www.qt.io/qt-features-libraries-apis-tools-and-ide/#ide>
diff --git a/Excel学习之路.md b/Excel学习之路.md
@@ -0,0 +1,28 @@
+# Excel学习之路
+
+## 书籍
+
+* Excel 2019 Bible[EXCEL2019宝典(第10版)]: Michael Alexander,Dick Kusleika,Previously by John Walkenbach: 主力学习
+* Excel 2016 Power Programming with VBA[Excel 2016高级VBA编程宝典（第8版）]: Michael Alexander,Dick Kusleika: 主力学习
+* Excel 2016应用大全: 主力学习
+* Excel 2007 VBA办公范例应用: 内容老旧，阅读人数少，不适合学习
+* Excel 2010实用技巧集锦: 内容老旧，阅读人数少，不适合学习
+* Excel VBA实战技巧精粹: 评价不错
+* Excel 2010 VBA编程与实践: 已经有了《Excel 2013 VBA编程与实践》，但是后者找不到对应的电子版。前者评价还不错
+* Excel VBA程序开发自学宝典(第3版): 已经有了，但是后者找不到对应的电子版。前者评价还不错
+
+## 函数
+
+• All functions (alphabetical): <https://support.microsoft.com/en-us/office/excel-functions-alphabetical-b3944572-255d-4efb-bb96-c6d90033e188>
+• IFS function: <https://support.microsoft.com/en-us/office/ifs-function-36329a26-37b2-467c-972b-4a39bd951d45>
+• SWITCH function: <https://support.microsoft.com/en-us/office/switch-function-47ab33c0-28ce-4530-8a45-d532ec4aa25e>
+
+## 小知识点
+
+### 改变日期格式
+
+```shell
+# 'Fri Mar 18 22:49:05 2022 +0800'->'20220318 22:49:05'
+# =MID(C1, 21,4)&TEXT(MONTH(MID(C1,5,3)&"-1"), "00")&MID(C1,9,2)&" "&MID(C1,12,8)
+# 如果有点时间格式不稳定，如'Fri Mar 8 22:49:05 2022 +0800'，则先分列再处理
+```
diff --git a/J2EE学习之路.md b/J2EE学习之路.md
@@ -568,6 +568,7 @@ Eclipse中`Update Project`，选择`Force Update of Snapshots/Releases`
 * 解决Maven报Plugin execution not covered by lifecycle configuration: <http://blog.csdn.net/xxd851116/article/details/25197373>
 * Maven编译jar出现：无法确定 T 的类型参数的异常的原因和处理方案: <http://www.cnblogs.com/peida/p/4218210.html>
 * Hosting a Maven repository on github: <https://stackoverflow.com/questions/14013644/hosting-a-maven-repository-on-github/14013645>
+* Working with the Apache Maven registry: <https://docs.github.com/en/packages/working-with-a-github-packages-registry/working-with-the-apache-maven-registry>
 * 如何发布Maven依赖到中央仓库: <https://www.cnblogs.com/jiangxinnju/p/9903517.html>
 * Maven添加本地依赖: <http://blog.csdn.net/xwl617756974/article/details/7832882>
 * Maven常用插件: <http://iffiffj.iteye.com/blog/1661936>
