Excel培训课本V1.0体例人：体例时刻：外部材料，请勿分散第1页,共1页Excel培训课本目次1Excel简介......................................................................................................................Excel界面简介.....................................................................................................输出跟编纂数据...................................................................................................671.11.291.2.11.2.21.2.31.2.41.2.51.2.61.2.71.2.81.2.91.2.10选定操纵地区........................................................................................定位的应用..........................................................................................复制、挪动跟删除...............................................................................吊销跟规复..........................................................................................查寻跟交换..........................................................................................在单位格中输出数据...........................................................................其余添补方法......................................................................................庞杂的盘算..........................................................................................相对援用跟相对援用...........................................................................称号的应用..........................................................................................91010111112141515161717181819202121212222231.31.41.5增加、删除单位格、行跟列...............................................................................修改列宽跟行高.................................................................................................设置任务表的格局.............................................................................................单位格的格局设置...............................................................................数据表的丑化......................................................................................款式的应用跟设置...............................................................................格局的复制跟删除...............................................................................前提格局的设置..................................................................................暗藏行跟列..........................................................................................拼音的设置..........................................................................................主动套用格局......................................................................................修改字体............................................................................................................1.5.11.5.21.5.31.5.41.5.51.5.61.5.71.5.81.6外部材料，请勿分散第2页,共67页1.7设置页面属性、预览跟打印...............................................................................242424293030313132333434343536363737373738383939393940404041414243431.7.11.7.21.7.31.7.4打印预览.............................................................................................页面设置.............................................................................................设置打印地区......................................................................................打印选项.............................................................................................2Excel的自界说功用.....................................................................................................2.1启动选项............................................................................................................2.2设置Excel选项...................................................................................................2.3自界说屏幕........................................................................................................2.3.12.3.22.3.3调色板的应用......................................................................................应用全屏视图......................................................................................贮存以后任务簿中的视图....................................................................2.42.5录制跟应用宏....................................................................................................界说宏的键盘快捷键...........................................................................2.4.1保管自界说东西栏的规划..................................................................................2.5.1创破惯例自界说东西栏.......................................................................3EXCEL进步的浏览跟选择功用...................................................................................3.13.23.3挪动浏览............................................................................................................清楚所处的位置..................................................................................键盘浏览......................................................................。