《Excel基本教程5.xls》由会员分享，可在线阅读，更多相关《Excel基本教程5.xls（34页珍藏版）》请在taowenge.com淘文阁网|工程机械CAD图纸|机械工程制图|CAD装配图下载|SolidWorks_CaTia_CAD_UG_PROE_设计图分享下载上搜索。
1、基基金金简简称称单单位位净净值值(元元)累累计计净净值值(元元)上投优势2.06872.08874.1574创创建建图图表表景顺长城内需1.9262.0163.9421 1、“图图表表向向导导”（以以后后有有四四步步）广发小盘1.88771.98773.8754（1 1）选选择择图图类类型型:柱柱形形(子子类类型型:三三维维)上投摩根股票1.87081.91083.7816（2 2）拖拖拽拽“数数据据区区”（A1:B5,A1:B5,创创建建系系列列）（3 3）填填写写图图表表选选项项（如如数数据据标标志志等等，可可选选）分分类类数数据据数数据据系系列列（4 4）确确定定图图表表位位置置（内内嵌
2、嵌/插插入入工工作作表表）字字符符或或数数只只能能是是数数2 2、修修饰饰图图表表隐藏2和4行后，C2+C4=4.0764（1 1）用用鼠鼠标标右右键键单单击击修修饰饰处处，相相应应选选项项2.12.0521.951.91.851.8上投优势景顺长城内需广发小盘上投摩根股票开放式基金累计净值(元)累计净值(元)2.12.0521.951.91.851.81.75上投优势景顺长城内需广发小盘上投摩根股票创建图表单位净值(元)2.12.0521.951.91.851.81.75上投优势景顺长城内需广发小盘上投摩根股票基金净值分析单位净值(元)累计净值(元)基基金金简简称称单单位位净净值值(元元)累
3、累计计净净值值(元元)上投优势2.06872.0887创建图表景顺长城内需1.9262.0161、“图表向导”按钮（共四步）广发小盘1.88771.9877（1）选图的类型(或子类型)上投摩根股票1.87081.9108（2）拖拽（用于作图的）“数据区”（创建系列）（3）输入图表选项（如数据标志等，可选）（4）确定图表位置（内嵌/插入工作表）2、修饰图表直直方方图图（1）用鼠标右键单击修饰处，相应选项（2）拖拽（用于作图的）“数据区”（创建系列）（3）输入图表选项（如数据标志等，可选）（4）确定图表位置（内嵌/插入工作表）（1）用鼠标右键单击修饰处，相应选项734834基金净值表05/9/30
4、05/12/3006/3/3106/6/106/7/700.511.522.5累计净值单位净值934北北京京地地区区生生产产总总值值（单位：亿元）第一产业97.70 0、图图表表向向导导；(以以后后有有四四步步)第二产业2100.51 1、选选择择类类型型：饼饼图图/三三维维饼饼图图第三产业4616.32 2、拖拖拽拽数数据据区区（A2A2：B4B4）（选选系系列列产产生生在在：列列）3 3、填填写写图图表表选选项项（数数据据标标志志/百百分分比比）4 4、确确定定图图表表位位置置,选选“内内嵌嵌”方方式式修修饰饰:选选中中三三维维饼饼图图的的相相应应部部分分 拖拖拽拽 1%31%68%200
5、5年北京地区生产总值（单位：亿元）第一产业第二产业第三产业某某分分理理处处存存款款汇汇总总表表 时间部 门一季度二季度三季度四季度第第一一储储蓄蓄所所700650800780第第二二储储蓄蓄所所850760900820第第三三储储蓄蓄所所580600720750第第四四储储蓄蓄所所600700800900第第五五储储蓄蓄所所4304215106500 0、图图表表向向导导；(以以后后有有四四步步)1 1、选选择择类类型型：柱柱形形/堆堆积积柱柱形形；2 2、拖拖拽拽数数据据区区：整整个个表表虚虚线线部部分分（系系列列产产生生在在：行行，则则按按“季季度度”）（系系列列产产生生在在：列列，则则按
6、按“储储蓄蓄所所”）3 3、填填写写选选项项，标标题题4 4、确确定定位位置置，内内嵌嵌5 5、鼠鼠标标指指向向“柱柱上上某某个个区区域域”，右右键键（1 1）数数据据系系列列格格式式，选选项项，系系列列线线（2 2）数数据据系系列列格格式式，数数据据标标志志，值值（3 3）数数据据系系列列格格式式，图图案案，颜颜色色700850580600430650760600700421800900720800510780820750900650某分理处存款汇总表第一储蓄所第二储蓄所第三储蓄所第四储蓄所第五储蓄所01000200030004000四季度三季度二季度一季度某分理处存款汇总表第一储蓄所第二储
7、蓄所第三储蓄所第四储蓄所第五储蓄所0500100015002000250030003500四季度三季度二季度一季度1,1,右右键键,选选第第一一层层图图2,2,选选 数数据据系系列列格格式式 3,3,选选 数数据据标标志志,值值 4,4,选选 选选项项,系系列列线线 5,5,选选 图图案案,相相应应颜颜色色6,对堆积图各层,重复1-5,即为汇总表700850580600430650760600700421800900720800510780820750900650某分理处存款汇总表第一储蓄所第二储蓄所第三储蓄所第四储蓄所第五储蓄所01000200030004000四季度三季度二季度一季度某分理
8、处存款汇总表第一储蓄所第二储蓄所第三储蓄所第四储蓄所第五储蓄所0500100015002000250030003500四季度三季度二季度一季度P69,表5.42001200120022002200320032004200420052005创创建建，组组合合图图表表两两种种图图表表类类型型存存款款余余额额737627376286911869111036181036181195551195551410511410511 1、“图图表表向向导导”（以以后后有有四四步步）增增长长14.714.717.817.819.219.215.415.41818（1 1）选选择择图图类类型型:自自定定义义类类型型
9、，两两轴轴线线-柱柱图图（典典型型的的组组合合图图表表）（2 2）拖拖拽拽“数数据据区区”（虚虚线线部部分分）（3 3）填填写写图图表表选选项项（如如数数据据标标志志等等，可可选选）（4 4）确确定定图图表表位位置置（内内嵌嵌/插插入入工工作作表表）修修饰饰图图表表：右右键键（要要修修饰饰的的图图表表对对象象）两轴线-柱图200120022003200420050200004000060000800001000001200001400001600000510152025存款余额增长两两轴轴线线-柱柱图图(典典型型的的组组合合图图表表）200120012002200220032003200420
10、04200520050200004000060000800001000001200001400001600000510152025存款余额增长创创建建，组组合合图图表表两两种种图图表表类类型型1 1、“图图表表向向导导”（以以后后有有四四步步）（1 1）选选择择图图类类型型:自自定定义义类类型型，两两轴轴线线-柱柱图图（典典型型的的组组合合图图表表）（2 2）拖拖拽拽“数数据据区区”（虚虚线线部部分分）（3 3）填填写写图图表表选选项项（如如数数据据标标志志等等，可可选选）（4 4）确确定定图图表表位位置置（内内嵌嵌/插插入入工工作作表表）修修饰饰图图表表：右右键键（要要修修饰饰的的图图表表对
11、对象象）两轴线-柱图200120022003200420050200004000060000800001000001200001400001600000510152025存款余额增长两两轴轴线线-柱柱图图(典典型型的的组组合合图图表表）20012001200220022003200320042004200520050200004000060000800001000001200001400001600000510152025存款余额增长20012002200320042005居 民 人 民币 储 蓄 存款余额7376286911103618119555141051比 上 一 年末增长14.717
12、.819.215.41814.717.819.215.418居民人民币储蓄存款余额与增长速度20012002200320042005050000100000150000010203040居民人民币储蓄存款余额比上一年末增长14.717.819.215.418居民人民币储蓄存款余额与增长速度20012002200320042005050000100000150000010203040居民人民币储蓄存款余额比上一年末增长5.3例1449ab35a597c5446f96236d3870e4c3c.xlsX:fileroot42023-11546db30d4-0c3a-4a67-90a6-a6d738
13、584605449ab35a597c5446f96236d3870e4c3c.xls制作人:FtpDown 2023/1/15 第 18 页四月份五月份六月份消费者信心指数93.893.894.1对当前经济状况满意程度指数89.990.1902006年消费者调查四月份五月份六月份878889909192939495消费者信心指数对当前经济状况满意程度指数四月份五月份六月份878889909192939495消费者信心指数对当前经济状况满意程度指数5.3例1449ab35a597c5446f96236d3870e4c3c.xlsX:fileroot42023-11546db30d4-0c3a-4
14、a67-90a6-a6d738584605449ab35a597c5446f96236d3870e4c3c.xls制作人:FtpDown 2023/1/15 第 19 页四月份五月份六月份878889909192939495消费者信心指数对当前经济状况满意程度指数基基金金简简称称单单位位净净值值(元元)累累计计净净值值(元元)上投优势2.06872.0887景顺长城内需1.9262.016修饰图表广发小盘1.88771.9877（1）用鼠标右键单击修饰处，相应选项上投摩根股票1.87081.91082.08872.0161.98771.91082.12.0521.951.91.851.8上投优
15、势景顺长城内需广发小盘上投摩根股票开放式基金累计净值(元)累计净值(元)（1）用鼠标右键单击修饰处，相应选项2.08872.0161.98771.91082.12.0521.951.91.851.8上投优势景顺长城内需广发小盘上投摩根股票开放式基金累计净值(元)累计净值(元)有3种视图，P741、普通视图，用于编辑和显示工作表；设置：工具，选项，视图（例如：不希望显示“行号列标”）2、分页预览（分页符操作），显示每1页包含的范围（行和列），设置和调整“分页符”操作：视图，分页预览（1）分页符为“虚线”；（2）移动分页符，拖拽（变为实线）（3）插入、删除分页符：选定光标位置，鼠标右键（选插入或删
16、除）注：在某行的上面，或某列的左侧；或在某单元格的左侧和上面，插入或删除3、打印预览，显示打印内容操作：文件，打印预览设置：（1）页面P75；（2）页边距；（3）页眉/页脚；（4）工作表图5.10449ab35a597c5446f96236d3870e4c3c.xlsX:fileroot42023-11546db30d4-0c3a-4a67-90a6-a6d738584605449ab35a597c5446f96236d3870e4c3c.xls制作人:FtpDown 2023/1/15 第 24 页四月份五月份六月份消费者信心指数93.893.894.1对当前经济状况满意程度指数89.990
17、.1909792872006年消费者调查四月份五月份六月份消费者信心指数93.893.894.1对当前经济状况满意程度指数89.990.190消费者信心指数对当前经济状况满意程度指数第 25 页，共 34 页基基金金代代码码基基金金简简称称单单位位净净值值(元元)累累计计净净值值(元元)净净值值增增长长率率基基金金代代码码基基金金简简称称单单位位净净值值(元元)180008银华货币A0.36642.8188.65951华夏成长1.352180009银华货币B0.42883.0646.296511华夏大盘精选1.699290001泰信天天收益0.79181.63754.16671001华夏债券1
18、.033161604融通深证100指数0.820.982.24442001华夏回报1.40151005050ETF0.8310.8312.08852011华夏红利1.584519180天同1800.83780.88781.514620001国泰金鹰增长1.658210001金鹰优选0.84160.93161.987420002国泰金龙债券1.085233001巨田基础行业0.87760.87760.780920003国泰金龙行业1.526213001宝盈鸿利收益0.88111.01112.453520005国泰金马稳健1.58288101中信现金优势货币0.88341.93499.278120
19、006国泰金象保本1.11850002博时裕富0.8840.9341.843340001华安创新1.447200002长城久泰0.88970.88971.656840002华安中国A股1.27110003易基500.89370.89372.33640004华安宝利1.582360001光大量化核心0.89450.89452.100250001博时增长1.48940002华安1800.8991.0191.467350002博时裕富1.266162102金鹰中小盘0.91120.91121.787350004博时精选1.441206001鹏华行业成长0.92970.98971.473570001嘉
20、实成长1.4885150103银泰理财分红0.93280.93281.623370002嘉实增长1.79870006嘉实服务0.9390.9392.399170003嘉实稳健1.438580001东吴嘉禾0.94090.94091.66470005嘉实债券1.157161606融通行业景气0.9430.9430.747970006嘉实服务1.216257010德盛小盘0.9450.9450.853870007嘉实浦安保本1.128151001银河稳健0.94551.01051.995780001长盛成长价值1.489290002泰信先行策略0.95040.95042.237590001大成价值
21、增长1.5423240005华宝策略0.95960.95961.053190003大成蓝筹稳健1.4799398001国联优质成长0.96240.96241.444190004大成精选增值1.480890003大成蓝筹稳健0.96380.97381.346100016富国动态平衡1.3228162605景顺鼎益0.9650.9650.8359100018富国天利增长1.1163510003海富通收益增长0.9720.9721.4614100020富国天益价值1.695420005国泰金马稳健0.9740.9741.2474100022富国天瑞强势地区1.44711华夏成长0.9761.0961
22、.7727110001易基平稳1.61160105南方积配0.97670.97672.6592110002易基策略1.822288001中信经典配置0.9770.9770.6594110003易基501.1732310308盛利精选0.97780.97781.6847110005易基积极1.6535350002天治品质优选0.97810.97811.9598121001国投融华1.3168310318盛利配置0.97950.98950.3483121002国投景气1.5885410001华富竞争力0.98530.98530.5408150103银泰理财分红1.272837001a上投摩根货币A
23、0.98641.214131.8214151001银河稳健1.3899217005招商先锋0.990.990.9792151002银河收益1.2028161903天同公用0.99110.99110.9678159901深100ETF1.35450004博时精选0.99141.00141.1736160105南方积配1.4639第 26 页，共 34 页162205湘财荷银预算0.99281.04280.2423160106南方高增1.5341519996长信银利精选0.99360.99360.9243160505博时主题1.4079255010德盛稳健0.9951.0552.051316060
24、3鹏华收益1.398100016富国动态平衡0.99661.07661.332160605鹏华中国501.443160706嘉实3000.9990.9991.8349160706嘉实3001.174202301南方现金增利1.00142.06344.9624161005富国天惠1.4711519005海富通股票1.0031.0030.804161601融通新蓝筹1.4152420001天弘精选混合1.00341.00340.3601161603融通债券1.028270005广发聚丰1.0061.0060.6403161604融通深证1001.102160602普天债券1.0061.0611.5
25、136161605融通蓝筹成长1.294288002红利精选股票1.00621.00620.0995161606融通行业景气1.293217002招商平衡1.00681.11680.68161607融通巨潮1.089240003宝康债券1.00881.08880.0496161706招商成长1.4163217004招商现金增值1.01041.622223.2246161902万家保本1.1164510081长盛动态精选1.01081.01081.5369161903万家公用1.2583398011国联分红混合1.01181.02181.4336162102金鹰中小盘1.488220006国泰金
26、象保本1.0121.0370.198162201荷银成长1.5544200001长城久恒1.0131.0730.997162202荷银周期1.529390004大成精选增值1.01461.01461.6531162203荷银稳定1.559520002国泰金龙债券1.0171.0591.497162204荷银精选1.6225180002银华保本增值1.01721.03220.276162205荷银风险预算1.22382011华夏红利1.0181.0181.2935162605景顺鼎益1.542217001招商股票1.01841.13340.8017162607景顺资源1.406260103动力平
27、衡1.01991.11990.3937162703广发小盘1.808740001华安创新1.021.150.691163302巨田资源1.4421400001东方龙1.02021.04020.7804163402兴业趋势1.524460001友邦盛世1.02061.05061.3405163503天治核心1.2235160505博时主题1.02081.04181.0293163801中银中国1.475811华夏大盘精选1.0211.0211.998163803中银增长1.2244160605鹏华中国501.0211.0211.998180001银华优势企业1.44341001华夏债券1.022
28、1.1120.5906180002银华保本增值1.087213002宝盈泛沿海1.02231.05231.9954180003银华道琼斯881.3942519087新世纪混合1.02271.02271.2675200001长城久恒1.276253010德盛安心成长1.0231.0230.3925200002长城久泰1.346470007嘉实浦安保本1.0251.0450.1955200006长城消费增值1.0782481001工银瑞信股票1.02521.02520.9453202001南方稳健成长1.5549基基金金代代码码基基金金简简称称单单位位净净值值(元元)累累计计净净值值(元元)净净值
29、值增增长长率率基基金金代代码码基基金金简简称称单单位位净净值值(元元)第 27 页，共 34 页163302巨田资源1.02591.02590.6278202101南方宝元1.125470005嘉实债券1.0271.0570.293202201南方避险1.2891163801中银中国1.02751.02750.8045206001鹏华行业成长1.382100018富国天利增长1.02841.09841.2404210001金鹰优选1.1026163402兴业趋势1.03021.03021.2979213001宝盈鸿利收益1.3844121002国投景气1.03071.03071.3571213
30、002宝盈泛沿海1.378162202湘财合丰周期1.03071.21571.4668217001招商安泰股票1.4021340001兴业转债1.03081.06582.2923217002招商安泰平衡1.2681240004华宝动力1.0311.0310.4384217003招商安泰债券1.0236450001中国收益1.03131.04130.5656217005招商先锋1.3554377010上投摩根股票1.03341.03341.2839233001巨田基础行业1.1405161902天同保本增值1.03361.07260.1162240001宝康消费品1.56161005富国天惠1.
31、03391.03391.0853240002宝康灵活配置1.47962001华夏回报1.0341.1530.4859240004华宝动力1.4254162203湘财合丰稳定1.03431.14430.6716240005华宝策略1.2679161607融通巨潮1.0351.0852.2727253010德盛安心成长1.172519008添富优势1.03721.03722.157255010德盛稳健1.258162204湘财荷银精选1.03861.05861.3268257010德盛小盘1.327260104景顺长城内需增长1.0391.0991.07257020德盛精选1.349161601融
32、通新蓝筹1.03941.22442.002260101优选股票1.5843161706招商成长1.03951.03950.756260103动力平衡1.5286202101南方宝元1.04041.21041.7407260104景顺长城内需1.836151002银河收益1.04261.12260.4238270001广发聚富1.6783161605融通蓝筹成长1.0431.1531.1639270002广发稳健增长1.7133519688交银精选1.04381.04382.1731270005广发聚丰1.67217003招商债券1.04451.10450.1726288001中信经典配置1.3
33、049350001天治财富增长1.04451.04451.4078288002红利精选股票1.3789320001诺安平衡1.04621.11621.7407290002泰信先行策略1.3344310328申万巴黎股票1.04631.04632.1079310308盛利精选1.341890001大成价值增长1.04651.25651.8591310318盛利配置1.069220003国泰金龙行业1.0471.0791.6505310328申万巴黎新动力1.553620001国泰金鹰增长1.051.121.2536320001诺安平衡1.4727110005易基积极1.051.071.62632
34、0003诺安股票1.4154160603鹏华收益1.051.1651.8429340001兴业转债1.1342100022富国天瑞强势地区1.05191.07192.7246350001天治财富增长1.24437001b上投摩根货币B1.05231.454114.2305350002天治品质优选1.1215基基金金代代码码基基金金简简称称单单位位净净值值(元元)累累计计净净值值(元元)净净值值增增长长率率基基金金代代码码基基金金简简称称单单位位净净值值(元元)第 28 页，共 34 页202201南方避险1.05471.18771.8542360001光大量化核心1.3027161603融通债
35、券1.0551.1262.0309360005光大红利股票1.0789260101优选股票1.05581.19580.9466375010上投优势1.9227510080长盛债券1.05891.15891.1559377010上投摩根股票1.7841162703广发小盘1.0621.0621.3069398001国联优质成长1.380370003嘉实稳健1.0621.1371.7241398011国联分红混合1.0385519001银华优选股票1.06271.06272.597400001东方龙1.1235121001国投融华1.06441.16441.3135400003东方精选1.0865
36、80001长盛成长价值1.0761.2421.5094410001华富竞争力1.2933510005海富通货币1.07831.422262.2103450001中国收益1.2411270001广发聚富1.07941.23941.058460001友邦盛世1.1991240002宝康灵活配置1.08071.19071.4837481001工银价值1.441570001嘉实成长1.08121.23121.559351005050 ETF1.11540004华安宝利1.0871.1370.8349510080长盛债券1.1437202001南方稳健成长1.09051.26552.3175510081
37、长盛动态精选1.5505270002广发稳健增长1.09111.17110.9997519001银华优选股票1.5463510001海富通精选1.09221.26721.1765519003海富通收益增长1.219180003银华道琼斯881.09291.09291.8736519005海富通股票1.476162201湘财合丰成长1.11.280.8065519008添富优势1.7305100020富国天益价值1.10011.22010.9359519011海富通精选1.4518180001银华优势企业1.10061.27061.7661519087新世纪混合1.0475160106南方高增1
38、.10251.10253.0952519180万家1801.229375010上投优势1.10711.12712.1593519300大成3001.1357240001宝康消费品1.11091.24090.89519688交银精选1.454950001博时增长1.1241.2720.8977519994长信金利1.0644110001易基平稳1.1271.3471.8067519996长信银利精选1.3383110002易基策略1.1441.2641.6889530001建信恒久价值1.206170002嘉实增长1.1921.323-0.0838550001信诚四季红1.0488260102景
39、顺长城货币1.23761.696243.4915580001东吴嘉禾1.3096270004广发货币1.34111.646515.4658162206湘财荷银货币1.37382.035295.1107320002诺安货币1.45251.929261.2286360003光大货币1.57541.838376.5275519999长信利息收益1.68422.03366.6667200003长城货币1.77422.009387.6855240006华宝货币2.01982.11491.2763基基金金代代码码基基金金简简称称单单位位净净值值(元元)累累计计净净值值(元元)净净值值增增长长率率基基金金代
40、代码码基基金金简简称称单单位位净净值值(元元)第 29 页，共 34 页163802中银货币2.03262.223110.3923240007现金宝B2.08422.354412.2143160606鹏华货币2.1282.009692.8465基基金金代代码码基基金金简简称称单单位位净净值值(元元)累累计计净净值值(元元)净净值值增增长长率率基基金金代代码码基基金金简简称称单单位位净净值值(元元)第 30 页，共 34 页累累计计净净值值(元元)净净值值增增长长率率1.6120.59521.8190.83091.1630.09691.7670.64661.6341.8651.7610.8516
41、1.1270.09231.5980.85921.611.67311.1630.44921.6770.7661.441.68131.7220.63611.6871.91651.3161.68671.5011.46461.68851.81951.9990.89791.5831.84141.2270.08651.2561.16471.1480.53481.6930.67611.78231.60751.57991.76731.80081.40381.42281.64441.25630.16151.93540.83861.58711.7581.881.00382.0121.50421.23322.052
42、91.81351.43551.46680.55751.61850.6081.30281.31341.51490.75391.31280.4511.3542.03471.46392.4279第 31 页，共 34 页1.69112.51941.49891.93311.7430.07161.6331.12121.4241.73311.59111.33641.68021.52811.20301.4021.94261.5541.01481.3531.89131.4691.77571.71631.00561.1814-0.80851.25830.89811.51821.52121.78441.79441
43、.76431.27811.71952.07491.69251.18491.28880.51751.6021.18111.4060.50041.90871.10681.62711.3851.6241.89211.25351.64491.5258-1.77051.23442.08441.78341.00061.1310.2121.71421.27121.5661.51151.37641.50781.07821.4491.77992.0677累累计计净净值值(元元)净净值值增增长长率率第 32 页，共 34 页1.34540.85131.45311.92931.5020.85381.19262.11
44、151.57441.38411.5282.29381.6271-0.36951.4631-0.11811.13510.05871.4804-0.04421.20050.90241.731.63531.62960.94151.46541.50981.38791.31851.1921.03451.3781.36991.3271.06631.6191.65791.76430.90441.68860.7781.9260.49261.93830.46091.88330.49271.7750.49341.35491.24921.48891.71131.38440.90741.36181.3751.0962
45、0.56431.60361.42321.64771.50951.51041.28811.40120.82671.3240.69611.28151.0907累累计计净净值值(元元)净净值值增增长长率率第 33 页，共 34 页1.38271.26711.07891.63921.94271.64951.82411.11651.43031.18761.38851.3271.53352.09921.47450.30471.44332.25331.28610.82051.47912.19021.64151.82961.3482.10621.30370.38621.57051.9731.76631.46331.2790.82711.5861.58291.78050.95681.80181.50321.35150.68241.2791.78051.13571.84741.55491.53531.06441.77851.40831.07241.28610.96271.04881.38231.45961.1665累累计计净净值值(元元)净净值值增增长长率率内内衣衣男男西西服服休休闲闲服服女女西西服服儿儿童童服服装装销售利润900027000150004000023000评比销售利润男西服休闲服女西服01000020000300004000050000销售利润