Microsoft 工具笔记
Office 软件教学整理,按「软件」分类,持续更新中。
Excel
Excel 数据处理与公式教学,内容量最大
ℹ️ Excel 怎么读
概览
- Excel 数据处理与公式教学,内容量最大
- 按来源分了「大分组 → 分类」两层子系列,各自从 EP01 开始编号
阅读建议
- 想系统学某个子系列:照该子系列底下的 EP 编号顺序读
- 只想查某个功能怎么用:直接用左侧软件导航跳到对应笔记
Excel · Introduction · Range
01
EP01. “AutoFill 自动填充”
02
EP02. “Fibonacci Sequence 斐波那契数列”
03
EP03. “Custom Lists 自定义列表”
04
EP04. “Hide Columns or Rows 隐藏列/行”
05
EP05. “Skip Blanks 跳过空白单元格”
06
EP06. “AutoFit 自动调整列宽/行高”
07
EP07. “Transpose 转置数据”
08
EP08. “Split Cells 拆分单元格”
09
EP09. “Flash Fill 闪填”
10
EP10. “Move Columns 移动列”
11
EP11. “ROW Function ROW 函数”
Excel · Introduction · Formulas and Functions
01
EP01. “10 Most Used Functions in Excel 最常用的 10 个函数”
02
EP02. “Subtract in Excel 减法”
03
EP03. “Multiply in Excel 乘法”
04
EP04. “Divide in Excel 除法”
05
EP05. “Square Root in Excel 平方根”
06
EP06. “Percentage in Excel 百分比”
07
EP07. “Named Range in Excel 命名区域”
08
EP08. “Dynamic Named Range in Excel 动态命名区域”
09
EP09. “Paste Options in Excel 粘贴选项”
10
EP10. “Discount Formulas in Excel 折扣公式”
Excel · Basics · Ribbon
01
EP01. “Formula Bar in Excel 公式栏”
02
EP02. “Quick Access Toolbar in Excel 快速访问工具栏”
03
EP03. “Customize the Ribbon in Excel 自定义功能区”
04
EP04. “Developer Tab in Excel 开发者选项卡”
05
EP05. “Status Bar in Excel 状态栏”
06
EP06. “Insert a Checkbox in Excel 插入复选框”
Excel · Basics · Workbook
01
EP01. “Themes in Excel 主题”
02
EP02. “View Multiple Workbooks in Excel 同时查看多个工作簿”
03
EP03. “AutoRecover an Excel File 自动恢复文件”
04
EP04. “Merge Excel Files 合并 Excel 文件”
05
EP05. “Save in Excel 97-2003 Format 存成 97-2003 格式”
Excel · Basics · Worksheets
01
EP01. “Zoom in and out in Excel 缩放”
02
EP02. “Split an Excel Sheet 分割窗格”
03
EP03. “Freeze Panes in Excel 冻结窗格”
04
EP04. “Group Worksheets in Excel 工作表分组”
05
EP05. “Consolidate Data in Excel 合并计算”
06
EP06. “View Multiple Worksheets in Excel 同时查看多个工作表”
07
EP07. “Get Sheet Name in Excel 取得工作表名称”
08
EP08. “Insert Comments in Excel 插入评论”
09
EP09. “Spell Check in Excel 拼写检查”
10
EP10. “Unhide Sheets in Excel 取消隐藏工作表”
11
EP11. “Chart Sheet in Excel 图表工作表”
Excel · Basics · Find & Select
01
EP01. “Find Features 查找功能”
02
EP02. “Wildcards 通配符”
03
EP03. “Delete Blank Rows 删除空白行”
04
EP04. “Row Differences 逐行差异比对”
05
EP05. “Copy Visible Cells Only 只复制可见单元格”
06
EP06. “Search Box 制作搜索框”
Excel · Basics · Templates
01
EP01. “Budget 制作预算表”
02
EP02. “Calendar 制作万年历”
03
EP03. “Holidays 自动计算节假日日期”
04
EP04. “Meal Planner 制作膳食计划表”
05
EP05. “Invoice 制作简易发票”
06
EP06. “Automated Invoice 自动化发票”
07
EP07. “Default Templates 设置默认模板”
08
EP08. “Time Sheet 制作工时表”
09
EP09. “BMI Calculator 制作 BMI 计算器”
Excel · Basics · Data Validation
01
EP01. “Reject Invalid Dates 拒绝无效日期”
02
EP02. “Budget Limit 限制预算总额”
03
EP03. “Prevent Duplicate Entries 防止重复输入”
04
EP04. “Product Codes 限制产品代码格式”
05
EP05. “Drop-down List 制作下拉列表”
06
EP06. “Dependent Drop-down Lists 相关下拉列表”
07
EP07. “Cm to Inches 厘米转英寸”
08
EP08. “Kg to Lbs 公斤转磅”
Excel · Basics · Keyboard Shortcuts
01
EP01. “Function Keys 功能键(F1~F12)大全”
02
EP02. “Insert Row 快速插入行”
03
EP03. “Save As 另存为快捷键”
04
EP04. “Delete Row 快速删除行”
05
EP05. “Formula to Value 公式转数值”
06
EP06. “Scroll Lock 关闭滚动锁定”
Excel · Functions · Count and Sum
01
EP01. “COUNTIF Function COUNTIF 函数”
02
EP02. “Count Blank/Nonblank Cells 计数空白/非空白单元格”
03
EP03. “Count Characters 计数字符数量”
04
EP04. “Not Equal To Operator 不等于运算符”
05
EP05. “Count Cells with Text 计数含文字的单元格”
06
EP06. “SUM Formulas SUM 求和公式”
07
EP07. “Running Total 累计总计”
08
EP08. “SUMIF Function SUMIF 函数”
09
EP09. “SUMPRODUCT Function SUMPRODUCT 函数”
Excel · Functions · Logical
01
EP01. “IF Function IF 函数”
02
EP02. “Comparison Operators 比较运算符”
03
EP03. “OR Function OR 函数”
04
EP04. “Roll the Dice 掷骰子模拟”
05
EP05. “IFS Function IFS 函数”
06
EP06. “Contains Specific Text 判断是否包含特定文字”
07
EP07. “SWITCH Function SWITCH 函数”
08
EP08. “If Cell is Blank 判断单元格是否空白”
09
EP09. “Absolute Value 绝对值”
10
EP10. “AND Function AND 函数”
Excel · Functions · Cell References
01
EP01. “Copy a Formula 复制公式”
02
EP02. “3D-reference 三维引用”
03
EP03. “Name Box 名称框”
04
EP04. “External References 外部引用”
05
EP05. “Hyperlinks 超链接”
06
EP06. “Union and Intersect 并集与交集运算符”
07
EP07. “Percent Change 百分比变化”
08
EP08. “Add a Column 插入列”
09
EP09. “Absolute Reference 绝对引用”
10
EP10. “ADDRESS Function ADDRESS 函数”
Excel · Functions · Text
01
EP01. “Separate Strings 拆分字符串”
02
EP02. “Count Words 计算单词数量”
03
EP03. “Text to Columns 文本分列”
04
EP04. “FIND Function FIND 函数”
05
EP05. “SEARCH Function SEARCH 函数”
06
EP06. “Change Case 大小写转换”
07
EP07. “Remove Spaces 删除空格”
08
EP08. “Compare Text 比较文本”
09
EP09. “SUBSTITUTE vs REPLACE SUBSTITUTE 与 REPLACE 的区别”
10
EP10. “TEXT Function TEXT 函数”
11
EP11. “CONCATENATE 拼接文本”
12
EP12. “Substring 提取子字符串”
Excel · Functions · Lookup & Reference
01
EP01. “VLOOKUP Function VLOOKUP 函数”
02
EP02. “Tax Rates 用 VLOOKUP 计算税率”
03
EP03. “INDEX and MATCH INDEX 与 MATCH 组合查找”
04
EP04. “Two-way Lookup 二维查找”
05
EP05. “OFFSET Function OFFSET 函数”
06
EP06. “Case-sensitive Lookup 区分大小写查找”
07
EP07. “Left Lookup 向左查找”
08
EP08. “Locate Maximum Value 定位最大值位置”
09
EP09. “INDIRECT Function INDIRECT 函数”
10
EP10. “Two-column Lookup 双列查找”
11
EP11. “Closest Match 查找最接近的值”
12
EP12. “Compare Two Columns 比较两列数据”
13
EP13. “XLOOKUP Function XLOOKUP 函数”
14
EP14. “XMATCH Function XMATCH 函数”
Excel · Functions · Statistical
01
EP01. “Average AVERAGE 函数”
02
EP02. “Negative Numbers to Zero 负数转零”
03
EP03. “Random Numbers 随机数生成”
04
EP04. “Rank RANK 函数”
05
EP05. “Percentiles and Quartiles 百分位数和四分位数”
06
EP06. “Box and Whisker Plot 箱线图”
07
EP07. “AverageIf AVERAGEIF 和 AVERAGEIFS 函数”
08
EP08. “Forecast FORECAST 预测函数”
09
EP09. “MaxIfs and MinIfs MAXIFS 和 MINIFS 函数”
10
EP10. “Weighted Average 加权平均数”
11
EP11. “Mode MODE 众数函数”
12
EP12. “Standard Deviation 标准差”
13
EP13. “Frequency FREQUENCY 函数”
Excel · Functions · Round
01
EP01. “Chop off Decimals INT 和 TRUNC 去除小数”
02
EP02. “Nearest Multiple MROUND、CEILING、FLOOR 舍入到指定倍数”
03
EP03. “Even and Odd EVEN、ODD、ISEVEN、ISODD 函数”
04
EP04. “Mod MOD 函数”
05
EP05. “Rounding Times 时间取整”
Excel · Functions · Formula Errors
01
EP01. “IfError IFERROR 函数”
02
EP02. “IsError ISERROR 函数”
03
EP03. “Aggregate AGGREGATE 函数”
04
EP04. “Circular Reference 循环引用”
05
EP05. “Formula Auditing 公式审核工具”
06
EP06. “Sum Range with Errors 对含错误值的范围求和”
07
EP07. “Floating Point Errors 浮点数误差”
08
EP08. “IFNA IFNA 函数”
Excel · Data Analysis · Sort
01
EP01. “Custom Sort Order 自定义排序顺序”
02
EP02. “Sort by Color 按颜色排序”
03
EP03. “Reverse List 反转列表顺序”
04
EP04. “Randomize List 随机打乱列表”
05
EP05. “SORT Function SORT 函数”
06
EP06. “Sort by Date 按日期排序”
07
EP07. “Alphabetize 按字母顺序排序”
Excel · Data Analysis · Filter
01
EP01. “Number and Text Filters 数字与文本筛选”
02
EP02. “Date Filters 日期筛选”
03
EP03. “Advanced Filter 高级筛选”
04
EP04. “Data Form 数据窗体”
05
EP05. “Remove Duplicates 删除重复项”
06
EP06. “Outlining Data 数据分组大纲”
07
EP07. “SUBTOTAL Function SUBTOTAL 函数”
08
EP08. “Unique Values 唯一值”
09
EP09. “FILTER Function FILTER 函数”
Excel · Data Analysis · Conditional Formatting
01
EP01. “Manage Rules 管理条件格式规则”
02
EP02. “Data Bars 数据条”
03
EP03. “Color Scales 颜色刻度”
04
EP04. “Icon Sets 图标集”
05
EP05. “Find Duplicates 找出重复值”
06
EP06. “Shade Alternate Rows 隔行上色”
07
EP07. “Compare Two Lists 比较两份清单”
08
EP08. “Conflicting Rules 冲突规则”
09
EP09. “Heat Map 热力图”
Excel · Data Analysis · Charts
01
EP01. “Column Chart 柱状图”
02
EP02. “Line Chart 折线图”
03
EP03. “Pie Chart 饼图”
04
EP04. “Bar Chart 条形图”
05
EP05. “Area Chart 面积图”
06
EP06. “Scatter Plot 散点图”
07
EP07. “Data Series 图表数据系列”
08
EP08. “Chart Axes 图表坐标轴”
09
EP09. “Trendline 趋势线”
10
EP10. “Error Bars 误差线”
11
EP11. “Sparklines 迷你图”
12
EP12. “Combination Chart 组合图”
13
EP13. “Gauge Chart 仪表图”
14
EP14. “Thermometer Chart 温度计图”
15
EP15. “Gantt Chart 甘特图”
16
EP16. “Pareto Chart 帕累托图”
Excel · Data Analysis · Pivot Tables
01
EP01. “Group Pivot Table Items 透视表项目分组”
02
EP02. “Multi-level Pivot Table 多层级数据透视表”
03
EP03. “Frequency Distribution 频率分布”
04
EP04. “Pivot Chart 数据透视图”
05
EP05. “Slicers 切片器”
06
EP06. “Update Pivot Table 更新数据透视表”
07
EP07. “Calculated Field/Item 计算字段与计算项”
08
EP08. “GetPivotData GETPIVOTDATA 函数”
Excel · Data Analysis · Tables
01
EP01. “Structured References 结构化引用”
02
EP02. “Table Styles 表格样式”
03
EP03. “Merge Tables 合并表格”
04
EP04. “Table as Source Data 表格作为数据源”
05
EP05. “Remove Table Formatting 移除表格格式”
06
EP06. “Quick Analysis Tool 快速分析工具”
Excel · Data Analysis · What-If Analysis
01
EP01. “Data Tables 数据表”
02
EP02. “Goal Seek 单变量求解”
03
EP03. “Quadratic Equation 用 Excel 解二次方程”
Excel · Data Analysis · Solver
01
EP01. “Transportation Problem 运输问题”
02
EP02. “Assignment Problem 指派问题”
03
EP03. “Shortest Path Problem 最短路径问题”
04
EP04. “Maximum Flow Problem 最大流量问题”
05
EP05. “Capital Investment 资本投资决策”
06
EP06. “Sensitivity Analysis 敏感度分析”
07
EP07. “System of Linear Equations 解线性方程组”
Excel · Data Analysis · Analysis ToolPak
01
EP01. “Histogram 直方图”
02
EP02. “Descriptive Statistics 描述性统计”
03
EP03. “ANOVA 方差分析”
04
EP04. “F-Test F 检验”
05
EP05. “t-Test t 检验”
06
EP06. “Moving Average 移动平均”
07
EP07. “Exponential Smoothing 指数平滑”
08
EP08. “Correlation 相关性分析”
09
EP09. “Regression 回归分析”
Excel · VBA · Create a Macro
01
EP01. “Swap Values 交换两个值”
02
EP02. “Run Code from a Module 从模块运行代码”
03
EP03. “Macro Recorder 宏录制器”
04
EP04. “Use Relative References 使用相对引用”
05
EP05. “FormulaR1C1 FormulaR1C1 属性”
06
EP06. “Add a Macro to the Toolbar 把宏加到工具栏”
07
EP07. “Enable Macros 启用宏”
08
EP08. “Protect Macro 给宏加密码保护”
Excel · VBA · MsgBox
01
EP01. “MsgBox Function MsgBox 函数(带返回值的消息框)”
02
EP02. “InputBox Function InputBox 函数”
Excel · VBA · Workbook and Worksheet Object
01
EP01. “Path and FullName Path 和 FullName 属性”
02
EP02. “Close and Open 关闭和打开工作簿”
03
EP03. “Loop through Books and Sheets 循环遍历工作簿和工作表”
04
EP04. “Sales Calculator 销售额计算器”
05
EP05. “Files in a Directory 遍历目录下的文件”
06
EP06. “Import Sheets 汇入其他文件的工作表”
07
EP07. “Programming Charts 用 VBA 操作图表”
Excel · VBA · Range Object
01
EP01. “CurrentRegion 当前数据区域”
02
EP02. “Dynamic Range 动态范围应用”
03
EP03. “Resize Property Resize 属性”
04
EP04. “Entire Rows and Columns 整行整列操作”
05
EP05. “Offset Property Offset 属性”
06
EP06. “From Active Cell to Last Entry 选到最后一笔数据”
07
EP07. “Union and Intersect 合并与交集”
08
EP08. “Test a Selection 检验选取内容”
09
EP09. “Font Font 属性(字体颜色/加粗)”
10
EP10. “Background Colors 背景色设置”
11
EP11. “Sort a Range 排序范围”
12
EP12. “Areas Collection Areas 集合”
13
EP13. “Compare Ranges 比较多个范围”
Excel · VBA · Variables
01
EP01. “Option Explicit 强制声明变量”
02
EP02. “Variable Scope 变量作用域”
03
EP03. “Life of Variables 变量的存活时间”
04
EP04. “Type Mismatch 类型不匹配错误”
Excel · VBA · If Then Statement
01
EP01. “Logical Operators 逻辑运算符”
02
EP02. “Select Case Select Case 结构”
03
EP03. “Tax Rates 税率计算”
04
EP04. “Mod Operator Mod 求余运算符”
05
EP05. “Prime Number Checker 质数检查器”
06
EP06. “Find Second Highest Value 找出第二高值”
07
EP07. “Sum by Color 按字体颜色求和”
08
EP08. “Delete Blank Cells 删除空白单元格”
Excel · VBA · Loop
01
EP01. “Loop through Defined Range 遍历指定范围”
02
EP02. “Loop through Entire Column 遍历整列”
03
EP03. “Do Until Loop Do Until 循环”
04
EP04. “Step Keyword Step 关键字”
05
EP05. “Create a Pattern 用双层循环画图案”
06
EP06. “Sort Numbers 冒泡排序数字”
07
EP07. “Randomly Sort Data 随机排序数据”
08
EP08. “Remove Duplicates 移除重复数字”
09
EP09. “Complex Calculations 复杂数列计算”
10
EP10. “Possible Football Matches 列出所有可能对阵组合”
11
EP11. “Knapsack Problem 背包问题”
Excel · VBA · Macro Errors
01
EP01. “Debugging 调试代码”
02
EP02. “Error Handling 错误处理”
03
EP03. “Err Object Err 对象”
04
EP04. “Interrupt a Macro 中断宏”
05
EP05. “Subscript Out of Range 下标超出范围错误”
06
EP06. “Macro Comments 宏注释”
Excel · VBA · String Manipulation
01
EP01. “Separate Strings 拆分字符串(VBA 版)”
02
EP02. “Reverse Strings 反转字符串”
03
EP03. “Convert to Proper Case 转换成首字母大写”
04
EP04. “InStr Function InStr 函数”
05
EP05. “Count Words 统计字数”
Excel · VBA · Date and Time
01
EP01. “Compare Dates and Times 比较日期和时间”
02
EP02. “DateDiff Function DateDiff 函数”
03
EP03. “Weekdays 统计工作日数量”
04
EP04. “Delay a Macro 延迟执行宏”
05
EP05. “Year Occurrences 统计某年份出现次数”
06
EP06. “Tasks on Schedule 任务进度标色”
07
EP07. “Sort Birthdays 按生日排序(忽略年份)”
08
EP08. “Date Format 日期格式设置”
Excel · VBA · Events
01
EP01. “BeforeDoubleClick Event 双击事件”
02
EP02. “Highlight Active Cell 高亮活动单元格”
03
EP03. “Create a Footer Before Printing 打印前自动生成页脚”
04
EP04. “Bills and Coins 钞票与硬币找零计算”
05
EP05. “Rolling Average Table 滚动平均表”
Excel · VBA · Array
01
EP01. “Dynamic Array 动态数组”
02
EP02. “Array Function Array 函数”
03
EP03. “Month Names 月份名称自定义函数”
04
EP04. “Size of an Array 数组大小”
Excel · VBA · Function and Sub
01
EP01. “User Defined Function 自定义函数”
02
EP02. “Custom Average Function 自定义平均值函数”
03
EP03. “Volatile Functions 易变函数”
04
EP04. “ByRef and ByVal 传值方式”
Excel · VBA · Application Object
01
EP01. “StatusBar Property 状态栏进度提示”
02
EP02. “Read Data from Text File 读取文本文件”
03
EP03. “Write Data to Text File 写入文本文件”
04
EP04. “Vlookup in VBA VBA 里用 VLOOKUP”
Excel · VBA · ActiveX Controls
01
EP01. “Text Box 文本框控件”
02
EP02. “List Box 列表框控件”
03
EP03. “Combo Box 组合框控件”
04
EP04. “Check Box 复选框控件(VBA 版)”
05
EP05. “Option Buttons 选项按钮控件”
06
EP06. “Spin Button 微调按钮控件”
07
EP07. “Loan Calculator 贷款计算器”
Excel · VBA · Userform
01
EP01. “Userform and Ranges 用户表单接收范围”
02
EP02. “Currency Converter 货币转换器”
03
EP03. “Progress Indicator 进度条表单”
04
EP04. “Multiple List Box Selections 列表框多选设置”
05
EP05. “Multicolumn Combo Box 多列组合框”
06
EP06. “Dependent Combo Boxes 联动组合框”
07
EP07. “Loop through Controls 循环遍历表单控件”
08
EP08. “Controls Collection 用名字动态引用控件”
09
EP09. “Userform with Multiple Pages 多页表单”
10
EP10. “Interactive Userform 互动式表单(查找/编辑/新增)”
Word
Word 文档编辑教学
ℹ️ Word 怎么读
概览
- Word 文档编辑教学
阅读建议
- 刚开始用:先看 EP01
- 只想查某个功能怎么用:直接用左侧软件导航跳到对应笔记
Word
01
EP01. “起始画面、界面导览与帮助/检视模式”
02
EP02. “文字格式设置(Font Commands)”
03
EP03. “段落格式设置(Paragraph Commands)”
04
EP04. “样式(Styles)与格式刷(Format Painter)”
05
EP05. “建立与管理清单(Lists)”
06
EP06. “校对工具(Editor)与存档”
07
EP07. “关联式标签(Contextual Tab)、文本框与形状”
08
EP08. “插入与格式化图片(含在线图库、裁剪与编辑)”
09
EP09. “页面版面设置(页边距/方向/纸张大小/分页符)”
10
EP10. “页首页尾、页面颜色边框与转存 PDF”
11
EP11. “自建样式与套用”
12
EP12. “插入与管理表格(含 Excel 表格)”
13
EP13. “插入与管理图表”
14
EP14. “快速部件(Quick Parts)与可重复使用内容”
15
EP15. “主题(Themes)与文件格式设计(Document Formatting)”
16
EP16. “把设计另存为模板(Template)”
17
EP17. “分栏(Columns)与分节符(Section Breaks)”
18
EP18. “封面页、目录(Table of Contents)与索引(Index)”
19
EP19. “大纲检视(Outline View)”
20
EP20. “邮件合并(Mail Merge)与 Outlook 整合”
21
EP21. “插入在线视频与截图工具”
22
EP22. “插入本机媒体(影片与音频)”
23
EP23. “SmartArt 信息图:插入与管理”
24
EP24. “绘图工具(Draw)与手写手势(Drawing Gestures)”
25
EP25. “云端协作与共享”
26
EP26. “追踪修订(Track Changes)”
27
EP27. “图表目录(Table of Figures)”
28
EP28. “超链接(Hyperlinks)与书签(Bookmarks)”
29
EP29. “脚注、尾注与研究工具(Researcher)”
30
EP30. “引文(Citations)与文献目录(Bibliography)”
31
EP31. “文件安全:格式限制与编辑限制”
32
EP32. “建立可填写表单与开发人员标签(Developer Tab)”
33
EP33. “在线表单 App(Microsoft Forms)与录制宏(Macros)/ VBA”
34
EP34. “用 Draft with Copilot 起草文件”
35
EP35. “用 Rewrite with Copilot 改写与调整语气”
36
EP36. “把文字可视化成表格(Visualize as a Table)”
37
EP37. “引用现有文件生成内容(Reference a File)”
38
EP38. “Copilot 面板:问答与摘要文件”
39
EP39. “Copilot 搭配编辑器(Editor)一起使用”
40
EP40. “Copilot Lab 与网页版 Word 的 Copilot”
PowerPoint
PowerPoint 简报制作教学
ℹ️ PowerPoint 怎么读
概览
- PowerPoint 简报制作教学
阅读建议
- 刚开始用:先看 EP01
- 只想查某个功能怎么用:直接用左侧软件导航跳到对应笔记
PowerPoint
01
EP01. “起始画面、界面导览与搜索框”
02
EP02. “幻灯片版面配置(Layout)与内容占位符(Placeholder)”
03
EP03. “主题(Theme)与 Designer 智能设计工具”
04
EP04. “文字格式设置”
05
EP05. “用关联式选项卡(Contextual Tab)格式化占位符与文本框”
06
EP06. “插入与格式化图片”
07
EP07. “滴管工具(Eyedropper)、存档与幻灯片放映基础”
08
EP08. “物件分组(Group)、排列与对齐”
09
EP09. “物件动画基础”
10
EP10. “插入与格式化表格(含 Excel 表格)”
11
EP11. “插入与格式化图表(含 Excel 图表)”
12
EP12. “切换效果、Morph 动态转场与打印”
13
EP13. “自定义功能区标签与实用选项设置”
14
EP14. “Slide Master 幻灯片母版入门:全局与局部格式修改”
15
EP15. “自定义幻灯片版面配置(新建 Layout)”
16
EP16. “用 Slide Master 打造可重复使用的自定义幻灯片(含标志/图片/形状)”
17
EP17. “把设计另存为模板(Template)”
18
EP18. “SmartArt 信息图:插入、修改与加内容”
19
EP19. “插入媒体:本机视频、在线视频与屏幕录制”
20
EP20. “云端协作:共享、批注与版本记录”
21
EP21. “幻灯片放映设置、自定义放映与 Zoom 缩放导航功能”
22
EP22. “演示工具:批注、字幕、排练录制与导出视频”
23
EP23. “Copilot 是什么,以及用 Copilot 从零生成一份简报”
24
EP24. “Copilot 配合现有模板与 Designer 使用”
25
EP25. “用 Copilot 新增/编辑幻灯片”
26
EP26. “用 Copilot 把 Word 文件转成简报”
27
EP27. “用 Copilot 提问与摘要简报”
28
EP28. “Copilot Lab 提示词学习中心”
29
EP29. “网页版 PowerPoint 的 Copilot”
30
EP30. “用故事结构规划简报大纲”
31
EP31. “用 Designer 增加视觉吸引力,把故事讲清楚”
32
EP32. “提升简报留存率的科学方法,与用 SmartArt 信息图快速提升留存”
33
EP33. “用白板(Whiteboard)与 Forms 增加简报互动”
34
EP34. “常见简报错误,与用动画呈现动态 Excel 图表”
35
EP35. “掌握演示者视图(Presenter View)”
36
EP36. “用 Slide Master 打造自定义主题、统一版面与三重点版面配置”
37
EP37. “三分法构图(Rule of Thirds)与可重复使用的自定义幻灯片”
38
EP38. “高对比配色(High Contrast)与无障碍检查工具(Accessibility Checker)”
39
EP39. “Rehearse with Coach 排练教练工具,与实用简报小技巧总结”
Outlook
Outlook 邮箱与日程管理教学
ℹ️ Outlook 怎么读
概览
- Outlook 邮箱与日程管理教学
阅读建议
- 刚开始用:先看 EP01
- 只想查某个功能怎么用:直接用左侧软件导航跳到对应笔记
Outlook
01
EP01. “新版 Outlook 界面导览与账号设置”
02
EP02. “撰写与发送邮件(含进阶选项)”
03
EP03. “收件箱管理全攻略”
04
EP04. “Quick Steps 与 Rules 自动化”
05
EP05. “Outlook 日历基础操作”
06
EP06. “日历进阶——多重日历、共享与打印”
07
EP07. “联系人(People)与任务管理”
08
EP08. “自定义设置、Outlook 群组与应用整合”
09
EP09. “Outlook Copilot 基础与邮件查找、摘要”
10
EP10. “用 Copilot 撰写邮件、写作教练与 Copilot Lab”