-
Notifications
You must be signed in to change notification settings - Fork 1
/
excel.mm
180 lines (180 loc) · 16.8 KB
/
excel.mm
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
<map version="1.0.0">
<!-- To view this file, download free mind mapping software FreeMind from http://freemind.sourceforge.net -->
<node CREATED="1388651530018" ID="ID_171261059" MODIFIED="1388651537412" TEXT="excel">
<node CREATED="1388655178333" FOLDED="true" ID="ID_489625015" MODIFIED="1388679182448" POSITION="right" TEXT="自定义快速访问工具栏">
<node CREATED="1388655192332" ID="ID_1963277522" MODIFIED="1388655243714" TEXT="很多工具按钮在面板上找不到, 可设定"自定义快速访问工具栏""/>
</node>
<node CREATED="1388651873485" ID="ID_37032714" MODIFIED="1388925814007" POSITION="right" TEXT="加密">
<node CREATED="1388651900714" ID="ID_614932769" MODIFIED="1388651928345" TEXT="左上角"Office 按钮">"准备">"加密文档""/>
</node>
<node CREATED="1388839469533" ID="ID_716198356" MODIFIED="1388839832341" POSITION="right" TEXT="分区域锁定">
<node CREATED="1388839838087" ID="ID_363839280" MODIFIED="1388840038421" TEXT="选择锁定的区域>单元格格式>保护>锁定(单元格)/隐藏公式"/>
</node>
<node CREATED="1388654045997" ID="ID_148228503" MODIFIED="1388654052193" POSITION="right" TEXT="公式审核"/>
<node CREATED="1388654241851" FOLDED="true" ID="ID_1429925514" MODIFIED="1388654806971" POSITION="right" TEXT="标题居中">
<node CREATED="1388654253439" ID="ID_873526883" MODIFIED="1388654277151" TEXT="选择单元格>合并后居中"/>
</node>
<node CREATED="1388654807431" FOLDED="true" ID="ID_1127720852" MODIFIED="1388679181532" POSITION="right" TEXT="设置边框">
<node CREATED="1388654811632" ID="ID_536390565" MODIFIED="1388654839971" TEXT="设置单元格格式>边框"/>
</node>
<node CREATED="1388678294709" FOLDED="true" ID="ID_365586181" MODIFIED="1388679179516" POSITION="right" TEXT="每页重复打印标题">
<node CREATED="1388678332109" ID="ID_319122191" MODIFIED="1388678356998" TEXT="页面设置>页面布局>打印标题"/>
</node>
<node CREATED="1388678694097" FOLDED="true" ID="ID_166534821" MODIFIED="1388678934326" POSITION="right" TEXT="行高和列宽">
<node CREATED="1388678727168" FOLDED="true" ID="ID_1812848393" MODIFIED="1388678820075" TEXT="行(列)选定">
<node CREATED="1388678749637" ID="ID_1479694277" MODIFIED="1388678786298" TEXT="一行 (点击)"/>
<node CREATED="1388678759173" ID="ID_322207749" MODIFIED="1388678792749" TEXT="多行 (点击拖动)"/>
<node CREATED="1388678762349" ID="ID_885267148" MODIFIED="1388678818543" TEXT="所有行 (左上角)"/>
</node>
<node CREATED="1388678832521" ID="ID_1045997323" MODIFIED="1388678850191" TEXT="开始>格式>单元格大小"/>
</node>
<node CREATED="1388678935239" FOLDED="true" ID="ID_335645422" MODIFIED="1388838231714" POSITION="right" TEXT="中文大写数字">
<node CREATED="1388678944612" ID="ID_96503335" MODIFIED="1388678986132" TEXT="开始>格式>单元格设置>数字>特殊"/>
</node>
<node CREATED="1388839206174" ID="ID_1366510087" MODIFIED="1388839208739" POSITION="right" TEXT="宏"/>
<node CREATED="1388840156007" FOLDED="true" ID="ID_1827965474" MODIFIED="1388840731032" POSITION="right" TEXT="复制单元格">
<node CREATED="1388840161106" ID="ID_896673439" MODIFIED="1388840169187" TEXT="拖拉"/>
</node>
<node CREATED="1388840731817" ID="ID_1117789339" MODIFIED="1388840754155" POSITION="right" TEXT="公式中相对引用和绝对引用"/>
<node CREATED="1388840859167" FOLDED="true" ID="ID_392086323" MODIFIED="1388885823473" POSITION="right" TEXT="行列转置">
<node CREATED="1388840872171" ID="ID_1678520578" MODIFIED="1388840886435" TEXT="复制>选择性粘贴>转置"/>
</node>
<node CREATED="1388885824930" FOLDED="true" ID="ID_1962422770" MODIFIED="1388938774267" POSITION="right" TEXT="公式">
<node CREATED="1388885828685" FOLDED="true" ID="ID_1218556677" MODIFIED="1388925797878" TEXT="单元格引用">
<node CREATED="1388885836689" ID="ID_1885684797" MODIFIED="1388886150107" TEXT="直接引用">
<node CREATED="1388885980391" ID="ID_863616993" MODIFIED="1388886019221" TEXT="D4 (单元格)"/>
<node CREATED="1388885983170" ID="ID_1353946379" MODIFIED="1388886019222" TEXT="D2:E3 (矩阵)"/>
<node CREATED="1388886138009" ID="ID_1412030117" MODIFIED="1388886139030" TEXT="Sheet2!$E$6:$F$8"/>
<node CREATED="1388886140278" ID="ID_825425198" MODIFIED="1388886146247" TEXT="Sheet2!$E$6"/>
</node>
<node CREATED="1388885858502" FOLDED="true" ID="ID_622302731" MODIFIED="1388886182406" TEXT="名称引用">
<node CREATED="1388886155820" ID="ID_866481238" MODIFIED="1388886155820" TEXT=""/>
</node>
</node>
<node CREATED="1388886184245" FOLDED="true" ID="ID_621645513" MODIFIED="1388925796323" TEXT="插入空行">
<node CREATED="1388886188622" ID="ID_1358331963" MODIFIED="1388886195021" TEXT="alt+enter"/>
</node>
<node CREATED="1388886697441" FOLDED="true" ID="ID_1991025992" MODIFIED="1388887326811" TEXT="operators">
<node CREATED="1388886862437" FOLDED="true" ID="ID_710449462" MODIFIED="1388886884053" TEXT="arithmetic">
<node CREATED="1388886714356" ID="ID_465521019" MODIFIED="1388886873925" TEXT="+ - * / ^(pow)"/>
<node CREATED="1388886792790" ID="ID_304611610" MODIFIED="1388886873924" TEXT="< = > <= >= <>"/>
<node CREATED="1388886831223" ID="ID_1641384920" MODIFIED="1388886873923" TEXT="% (/100)"/>
</node>
<node CREATED="1388886878765" FOLDED="true" ID="ID_703543363" MODIFIED="1388886885357" TEXT="string">
<node CREATED="1388886843279" ID="ID_319338234" MODIFIED="1388886850967" TEXT="& (strcat)"/>
</node>
<node CREATED="1388886896205" FOLDED="true" ID="ID_234849163" MODIFIED="1388887045292" TEXT="cell referencing">
<node CREATED="1388886910277" ID="ID_67863669" MODIFIED="1388886991527" TEXT=": (matrix[left,top>right,bottom])"/>
<node CREATED="1388886993865" ID="ID_852969479" MODIFIED="1388886998124" TEXT=", union"/>
<node CREATED="1388886998377" ID="ID_91281455" MODIFIED="1388887042700" TEXT="ws, intersection"/>
</node>
</node>
<node CREATED="1388887481215" FOLDED="true" ID="ID_689757747" MODIFIED="1388888214676" TEXT="计算">
<node CREATED="1388888163114" FOLDED="true" ID="ID_195193939" MODIFIED="1388888209611" TEXT="evaluating mode {manual,automatic}">
<node CREATED="1388887327757" ID="ID_1476650269" MODIFIED="1388888178652" TEXT="公式>计算选项>{自动,手动}"/>
</node>
<node CREATED="1388888127322" FOLDED="true" ID="ID_361185901" MODIFIED="1388888190440" TEXT="hotkey F9">
<node CREATED="1388887525634" ID="ID_236420211" MODIFIED="1388887536493" TEXT="F9 计算所有的工作薄"/>
<node CREATED="1388887537084" ID="ID_749570467" MODIFIED="1388887754120" TEXT="SHIFT+F9 计算当前工作簿的活动工作表"/>
<node CREATED="1388887786541" ID="ID_1787312544" MODIFIED="1388887792450" TEXT="CTRL+ALT+F9">
<node CREATED="1388887793440" ID="ID_1397605475" MODIFIED="1388887903251" TEXT="强制重新计算所有工作簿"/>
</node>
<node CREATED="1388887909938" ID="ID_1023899024" MODIFIED="1388888154740" TEXT="CTRL+SHIFT+ALT+F9">
<node CREATED="1388887917050" ID="ID_1493875523" MODIFIED="1388887967255" TEXT="重现检查全部从属公式,强制重新计算所有工作簿"/>
</node>
</node>
</node>
<node CREATED="1388888215690" FOLDED="true" ID="ID_68898063" MODIFIED="1388930876660" TEXT="cell referencing: path[book]sheet!cellRange ">
<node CREATED="1388923704989" ID="ID_1315298384" MODIFIED="1388923720034" TEXT="cell">
<node CREATED="1388888219303" ID="ID_702274311" MODIFIED="1388923722694" TEXT="A3 (relative cell)"/>
<node CREATED="1388888457223" ID="ID_1428643545" MODIFIED="1388923722693" TEXT="$A$3 (absolute cell)"/>
<node CREATED="1388888477272" ID="ID_1956138559" MODIFIED="1388923722692" TEXT="A$3 relative col/absolute row"/>
<node CREATED="1388888484008" ID="ID_1910632284" MODIFIED="1388923722691" TEXT="$A3 relative row/absolute col"/>
</node>
<node CREATED="1388923724162" ID="ID_1700380508" MODIFIED="1388923790289" TEXT="sheet">
<node CREATED="1388923727355" ID="ID_1028054957" MODIFIED="1388923872655" TEXT="Sheet1!A3"/>
</node>
<node CREATED="1388923757480" ID="ID_1365470178" MODIFIED="1388924015263" TEXT="book">
<node CREATED="1388923763714" ID="ID_42470385" MODIFIED="1388923878632" TEXT="[Book1.xlsx]Sheet1!A3"/>
<node CREATED="1388923792946" ID="ID_1245333302" MODIFIED="1388923976599" TEXT="'[Budget Analysis .xlsx]Sheet1!A3"/>
</node>
<node CREATED="1388924018449" ID="ID_79735965" MODIFIED="1388924019438" TEXT="path">
<node CREATED="1388923792946" ID="ID_1001280812" MODIFIED="1388924052491" TEXT="'C:\[Budget Analysis .xlsx]Sheet1!A3"/>
</node>
</node>
<node CREATED="1388930884003" FOLDED="true" ID="ID_1993236889" MODIFIED="1388930944950" TEXT="cellRange{cell,vector,matrix}">
<node CREATED="1388930904023" ID="ID_1714475628" MODIFIED="1388930923505" TEXT="cell:A3"/>
<node CREATED="1388930912357" ID="ID_1185141051" MODIFIED="1388930933360" TEXT="vector: A3:A4"/>
<node CREATED="1388930934092" ID="ID_1567665242" MODIFIED="1388930943076" TEXT="matrix:A1:D4"/>
</node>
<node CREATED="1388930218007" FOLDED="true" ID="ID_1793042324" MODIFIED="1388938773141" TEXT="name">
<node CREATED="1388930241873" ID="ID_1291778347" MODIFIED="1388930879866" TEXT="cellref: path[book]sheet!cellRange"/>
<node CREATED="1388930322437" ID="ID_1906752036" MODIFIED="1388930378621" TEXT=", (UNION) cellref1,cellref..."/>
<node CREATED="1388932690480" ID="ID_75221376" MODIFIED="1388932729170" TEXT="ws(INTERSECTION) cellref cellref..."/>
<node CREATED="1388930738015" ID="ID_1761706630" MODIFIED="1388930958856" TEXT="'firstSheet:lastSheet'!cellRange"/>
<node CREATED="1388931154138" ID="ID_8437720" MODIFIED="1388935695447" TEXT="Sheet!$1:$1"/>
<node CREATED="1388931176341" ID="ID_223424319" MODIFIED="1388935700784" TEXT="Sheet!$A:$A"/>
<node CREATED="1388932734067" ID="ID_1680019287" MODIFIED="1388932738162" TEXT="name,name"/>
<node CREATED="1388932738406" ID="ID_1790437553" MODIFIED="1388932740639" TEXT="name:name"/>
<node CREATED="1388932740943" ID="ID_525262036" MODIFIED="1388932748396" TEXT="name name"/>
</node>
<node CREATED="1388934797230" FOLDED="true" ID="ID_1775321130" MODIFIED="1388938771791" TEXT="高级命名技术">
<node CREATED="1388934814853" ID="ID_1319423040" MODIFIED="1388938695260" TEXT="定义矩阵">
<node CREATED="1388934721091" ID="ID_495695437" MODIFIED="1388934844402" TEXT=""新建名称" ={a11,a12,..,a1n; a21,a22,...,a2n; ...}"/>
<node CREATED="1388934846946" ID="ID_1752323693" MODIFIED="1388934871336" TEXT="INDEX(matrix,col,row)"/>
<node CREATED="1388934886736" ID="ID_1236573974" MODIFIED="1388934938123" TEXT="将矩阵拷贝到同型的单元格范围中">
<node CREATED="1388934943093" ID="ID_555605760" MODIFIED="1388935001157" TEXT=""单元格范围">"=matrix">CTRL+SHIFT+ENTER"/>
</node>
</node>
<node CREATED="1388935100171" ID="ID_878562475" MODIFIED="1388935707821" TEXT="indirect(symbol reference)">
<node CREATED="1388935168947" ID="ID_277938546" MODIFIED="1388935265162" TEXT="indirect("A3") as A3"/>
</node>
</node>
<node CREATED="1388932772776" FOLDED="true" ID="ID_1095282507" MODIFIED="1388932864012" TEXT="index(matrix,col,row)">
<node CREATED="1388932850212" ID="ID_268181652" MODIFIED="1388932859230" TEXT="matrix[row][col]"/>
</node>
<node CREATED="1388925469738" FOLDED="true" ID="ID_1386887544" MODIFIED="1388932763489" TEXT="复制公式">
<node CREATED="1388925476105" ID="ID_1220861610" MODIFIED="1388925682815" TEXT="复制">
<node CREATED="1388925484721" ID="ID_756062396" MODIFIED="1388925579892" TEXT="单元格>F2>CTRL+HOME>CTRL+SHIFT+END>开始|剪贴板|复制>ESC(退出复制模式)"/>
</node>
<node CREATED="1388925559780" ID="ID_506983690" MODIFIED="1388925678663" TEXT="粘贴">
<node CREATED="1388925592913" ID="ID_1417241577" MODIFIED="1388925668946" TEXT="单元格>开始|剪贴板|粘贴>ESC(退出粘贴模式)"/>
</node>
</node>
<node CREATED="1388925695469" FOLDED="true" ID="ID_1811105434" MODIFIED="1388925805678" TEXT="公式转换为值(粘贴值)">
<node CREATED="1388925708347" ID="ID_224730439" MODIFIED="1388925770941" TEXT="单元格>开始|剪贴板|复制>开始|剪贴板|粘贴|粘贴值>ESC"/>
</node>
<node CREATED="1388925806522" FOLDED="true" ID="ID_324141431" MODIFIED="1388929002807" TEXT="隐藏公式">
<node CREATED="1388925835489" ID="ID_1963682545" MODIFIED="1388925845749" TEXT="单元格>单元格格式>保护>锁定(单元格)/隐藏公式 "/>
<node CREATED="1388925851240" ID="ID_1682682959" MODIFIED="1388925895957" TEXT="审阅>更改>保护工作表"/>
</node>
<node CREATED="1388925971140" FOLDED="true" ID="ID_674464696" MODIFIED="1388929004027" TEXT="ERROR">
<node CREATED="1388925974107" ID="ID_222423952" MODIFIED="1388925989780" TEXT="#N/A"/>
<node CREATED="1388925990140" ID="ID_679471860" MODIFIED="1388925994797" TEXT="#DIV/0!"/>
<node CREATED="1388925995138" ID="ID_1514634682" MODIFIED="1388925999636" TEXT="#REF!"/>
<node CREATED="1388925999962" ID="ID_143296988" MODIFIED="1388926002868" TEXT="#NUM!"/>
<node CREATED="1388926003422" ID="ID_634919595" MODIFIED="1388926007229" TEXT="#VALUE!"/>
<node CREATED="1388926022512" ID="ID_1024364465" MODIFIED="1388926025902" TEXT="#NAME?"/>
<node CREATED="1388926026427" ID="ID_1248397271" MODIFIED="1388926029206" TEXT="#NULL!"/>
</node>
<node CREATED="1388929005368" FOLDED="true" ID="ID_1777134995" MODIFIED="1388930284482" TEXT="单变量求解(解一元方程)">
<node CREATED="1388929030190" ID="ID_192841345" MODIFIED="1388929052129" TEXT="数据|数据工具|假设分析|单变量求解"/>
</node>
</node>
<node CREATED="1388938778703" ID="ID_539953388" MODIFIED="1388938787960" POSITION="right" TEXT="function">
<node CREATED="1388938788961" ID="ID_1419909101" MODIFIED="1388938793350" TEXT="text/string">
<node CREATED="1388938847250" ID="ID_1064016921" MODIFIED="1388939781444" TEXT="lower,upper,proper"/>
<node CREATED="1388938854066" ID="ID_332730671" MODIFIED="1388938859010" TEXT="value,text"/>
<node CREATED="1388939071688" ID="ID_1806292039" MODIFIED="1388939094438" TEXT="{left,mid,right}{,b}"/>
<node CREATED="1388939402318" ID="ID_46902846" MODIFIED="1388939410931" TEXT="{find,search}{,b}"/>
<node CREATED="1388939509413" ID="ID_1381995548" MODIFIED="1388939532674" TEXT="substitute replace{,b}"/>
<node CREATED="1388939604249" ID="ID_476316787" MODIFIED="1388939702898" TEXT="asc,code,jis"/>
<node CREATED="1388939606077" ID="ID_272545333" MODIFIED="1388939744692" TEXT="bahttext,dollar,fixed,phonetic,"/>
<node CREATED="1388939648523" ID="ID_284738003" MODIFIED="1388939810254" TEXT="clean,trim"/>
<node CREATED="1388939665632" ID="ID_832375667" MODIFIED="1388939754065" TEXT="concatenate, rept"/>
<node CREATED="1388939683170" ID="ID_210156861" MODIFIED="1388939713683" TEXT="exact,len,lenb"/>
<node CREATED="1388939765376" ID="ID_1741747228" MODIFIED="1388939766930" TEXT="t"/>
</node>
</node>
</node>
</map>