<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[flywing521的专栏]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/flywing521</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; flywing521]]></copyright><item><title><![CDATA[DataGrip测试连接时出现报错解决方案]]></title><link>https://blog.youkuaiyun.com/flywing521/article/details/149025193</link><guid>https://blog.youkuaiyun.com/flywing521/article/details/149025193</guid><author>flywing521</author><pubDate>Mon, 30 Jun 2025 15:58:21 +0800</pubDate><description><![CDATA[DBMS: MySQL (无版本) 区分大小写: 普通形式=mixed，分隔形式=exact Connection refused: connect.    ]]></description><category></category></item><item><title><![CDATA[王佩丰24节Excel学习笔记——第二十四讲：宏表函数]]></title><link>https://blog.youkuaiyun.com/flywing521/article/details/143995240</link><guid>https://blog.youkuaiyun.com/flywing521/article/details/143995240</guid><author>flywing521</author><pubDate>Tue, 31 Dec 2024 18:45:26 +0800</pubDate><description><![CDATA[【以 Excel2010 系列学习，用 Office LTSC 专业增强版 2021 实践】]]></description><category></category></item><item><title><![CDATA[王佩丰24节Excel学习笔记——第二十三讲：饼图美化与PPT图表]]></title><link>https://blog.youkuaiyun.com/flywing521/article/details/143995218</link><guid>https://blog.youkuaiyun.com/flywing521/article/details/143995218</guid><author>flywing521</author><pubDate>Sat, 28 Dec 2024 17:20:38 +0800</pubDate><description><![CDATA[【以 Excel2010 系列学习，用 Office LTSC 专业增强版 2021 实践】]]></description><category></category></item><item><title><![CDATA[王佩丰24节Excel学习笔记——第二十二讲：制作甘特图与动态甘特图]]></title><link>https://blog.youkuaiyun.com/flywing521/article/details/143995202</link><guid>https://blog.youkuaiyun.com/flywing521/article/details/143995202</guid><author>flywing521</author><pubDate>Sat, 28 Dec 2024 14:17:53 +0800</pubDate><description><![CDATA[【以 Excel2010 系列学习，用 Office LTSC 专业增强版 2021 实践】]]></description><category></category></item><item><title><![CDATA[王佩丰24节Excel学习笔记——第二十一讲：经典Excel动态图表实现原理]]></title><link>https://blog.youkuaiyun.com/flywing521/article/details/143995157</link><guid>https://blog.youkuaiyun.com/flywing521/article/details/143995157</guid><author>flywing521</author><pubDate>Fri, 27 Dec 2024 17:44:52 +0800</pubDate><description><![CDATA[语法：以某个点为基准，下移N行，右移N列，取N行，取N列类似经纬度：东京北纬30度，向下多少，再向右多少？步骤：1、点开发工具，插入2个滚动条2、设置滚动条控制属性3、写公式，定义名称，链接数据源。]]></description><category></category></item><item><title><![CDATA[王佩丰24节Excel学习笔记——第二十讲：图表基础]]></title><link>https://blog.youkuaiyun.com/flywing521/article/details/143995128</link><guid>https://blog.youkuaiyun.com/flywing521/article/details/143995128</guid><author>flywing521</author><pubDate>Fri, 27 Dec 2024 14:54:31 +0800</pubDate><description><![CDATA[【以 Excel2010 系列学习，用 Office LTSC 专业增强版 2021 实践】]]></description><category></category></item><item><title><![CDATA[王佩丰24节Excel学习笔记——第十九讲：Indirect函数]]></title><link>https://blog.youkuaiyun.com/flywing521/article/details/143995105</link><guid>https://blog.youkuaiyun.com/flywing521/article/details/143995105</guid><author>flywing521</author><pubDate>Thu, 26 Dec 2024 11:10:12 +0800</pubDate><description><![CDATA[【以 Excel2010 系列学习，用 Office LTSC 专业增强版 2021 实践】]]></description><category></category></item><item><title><![CDATA[王佩丰24节Excel学习笔记——第十八讲：Lookup和数组]]></title><link>https://blog.youkuaiyun.com/flywing521/article/details/143995093</link><guid>https://blog.youkuaiyun.com/flywing521/article/details/143995093</guid><author>flywing521</author><pubDate>Thu, 26 Dec 2024 09:54:41 +0800</pubDate><description><![CDATA[【以 Excel2010 系列学习，用 Office LTSC 专业增强版 2021 实践】]]></description><category></category></item><item><title><![CDATA[王佩丰24节Excel学习笔记——第十七讲：数据函数]]></title><link>https://blog.youkuaiyun.com/flywing521/article/details/143995079</link><guid>https://blog.youkuaiyun.com/flywing521/article/details/143995079</guid><author>flywing521</author><pubDate>Wed, 18 Dec 2024 11:36:39 +0800</pubDate><description><![CDATA[【以 Excel2010 系列学习，用 Office LTSC 专业增强版 2021 实践】]]></description><category></category></item><item><title><![CDATA[王佩丰24节Excel学习笔记——第十六讲：简单文本函数]]></title><link>https://blog.youkuaiyun.com/flywing521/article/details/143995065</link><guid>https://blog.youkuaiyun.com/flywing521/article/details/143995065</guid><author>flywing521</author><pubDate>Tue, 17 Dec 2024 18:19:57 +0800</pubDate><description><![CDATA[【以 Excel2010 系列学习，用 Office LTSC 专业增强版 2021 实践】]]></description><category></category></item><item><title><![CDATA[王佩丰24节Excel学习笔记——第十五讲：条件格式与公式]]></title><link>https://blog.youkuaiyun.com/flywing521/article/details/143995042</link><guid>https://blog.youkuaiyun.com/flywing521/article/details/143995042</guid><author>flywing521</author><pubDate>Tue, 17 Dec 2024 16:10:38 +0800</pubDate><description><![CDATA[1、如何管理条件 ：条件格式中的1到5就是新建规则里的前五个，第六个是使用公式。2、创建多重条件3、多重条件的优先级问题1、条件格式中公式的书写规则2、使用weekday函数标记周末3、标记未来15天的日期。]]></description><category></category></item><item><title><![CDATA[王佩丰24节Excel学习笔记——第十四讲：日期函数]]></title><link>https://blog.youkuaiyun.com/flywing521/article/details/143995029</link><guid>https://blog.youkuaiyun.com/flywing521/article/details/143995029</guid><author>flywing521</author><pubDate>Mon, 16 Dec 2024 17:15:07 +0800</pubDate><description><![CDATA[【以 Excel2010 系列学习，用 Office LTSC 专业增强版 2021 实践】]]></description><category></category></item><item><title><![CDATA[王佩丰24节Excel学习笔记——第十三讲：邮件合并]]></title><link>https://blog.youkuaiyun.com/flywing521/article/details/143995010</link><guid>https://blog.youkuaiyun.com/flywing521/article/details/143995010</guid><author>flywing521</author><pubDate>Mon, 16 Dec 2024 15:42:17 +0800</pubDate><description><![CDATA[生成试卷操作：题目在Excel表中，先连接数据源，选目录方式，再编写内容。数字格式：\#"#,##0.00"，如金额带有千分符号。日期格式：\@"yyyy-M-d"（m需要大写）先在outlook上登录邮箱，再点邮件发送。1、利用邮件合并批量生成单个的文档。4、邮件合并后的数字格式的处理。2、为不同的邮件插入不同的附件。2、利用word发送邮件。1、批量生成多个文档。3、每页显示多条记录。]]></description><category></category></item><item><title><![CDATA[王佩丰24节Excel学习笔记——第十二讲：match + index]]></title><link>https://blog.youkuaiyun.com/flywing521/article/details/143994994</link><guid>https://blog.youkuaiyun.com/flywing521/article/details/143994994</guid><author>flywing521</author><pubDate>Sun, 15 Dec 2024 17:16:53 +0800</pubDate><description><![CDATA[【以 Excel2010 系列学习，用 Office LTSC 专业增强版 2021 实践】]]></description><category></category></item><item><title><![CDATA[王佩丰24节Excel学习笔记——第十一讲：Vlookup函数]]></title><link>https://blog.youkuaiyun.com/flywing521/article/details/143994965</link><guid>https://blog.youkuaiyun.com/flywing521/article/details/143994965</guid><author>flywing521</author><pubDate>Sun, 15 Dec 2024 15:22:34 +0800</pubDate><description><![CDATA[【以 Excel2010 系列学习，用 Office LTSC 专业增强版 2021 实践】]]></description><category></category></item><item><title><![CDATA[王佩丰24节Excel学习笔记——第十讲：Sumif函数]]></title><link>https://blog.youkuaiyun.com/flywing521/article/details/143994951</link><guid>https://blog.youkuaiyun.com/flywing521/article/details/143994951</guid><author>flywing521</author><pubDate>Thu, 12 Dec 2024 13:32:23 +0800</pubDate><description><![CDATA[【以 Excel2010 系列学习，用 Office LTSC 专业增强版 2021 实践】]]></description><category></category></item><item><title><![CDATA[王佩丰24节Excel学习笔记——第九讲：Countif函数]]></title><link>https://blog.youkuaiyun.com/flywing521/article/details/143994926</link><guid>https://blog.youkuaiyun.com/flywing521/article/details/143994926</guid><author>flywing521</author><pubDate>Tue, 10 Dec 2024 12:05:23 +0800</pubDate><description><![CDATA[【以 Excel2010 系列学习，用 Office LTSC 专业增强版 2021 实践】]]></description><category></category></item><item><title><![CDATA[王佩丰24节Excel学习笔记——第八讲：IF函数逻辑判断]]></title><link>https://blog.youkuaiyun.com/flywing521/article/details/143994905</link><guid>https://blog.youkuaiyun.com/flywing521/article/details/143994905</guid><author>flywing521</author><pubDate>Sun, 01 Dec 2024 16:22:39 +0800</pubDate><description><![CDATA[【以 Excel2010 系列学习，用 Office LTSC 专业增强版 2021 实践】]]></description><category></category></item><item><title><![CDATA[王佩丰24节Excel学习笔记——第七讲：认识函数与公式]]></title><link>https://blog.youkuaiyun.com/flywing521/article/details/143994888</link><guid>https://blog.youkuaiyun.com/flywing521/article/details/143994888</guid><author>flywing521</author><pubDate>Sun, 01 Dec 2024 10:45:04 +0800</pubDate><description><![CDATA[【以 Excel2010 系列学习，用 Office LTSC 专业增强版 2021 实践】]]></description><category></category></item><item><title><![CDATA[王佩丰24节Excel学习笔记——第六讲：认识数据透视表]]></title><link>https://blog.youkuaiyun.com/flywing521/article/details/143994853</link><guid>https://blog.youkuaiyun.com/flywing521/article/details/143994853</guid><author>flywing521</author><pubDate>Fri, 29 Nov 2024 13:00:25 +0800</pubDate><description><![CDATA[【以 Excel2010 系列学习，用 Office LTSC 专业增强版 2021 实践】]]></description><category></category></item></channel></rss>