Windows知识
课程参与者将能够以透明的方式有效地进行各种计算,以安排和呈现他们的结果,使用多种机制来促进和加速分布表的创建,以及保护计算和结果免受未经授权的人。
简介
- 关于程式的基本资讯
- 主视窗的构建
- 对工作簿（笔记本）和工作表进行操作
在工作表单元格中输入和修改数据
格式化数据
- 确定如何显示不同类型的数据和计算结果（例如日期、金额、百分比或分数）
- 确定单元格的边缘和背景
- 格式化行和列的标题
- 使用样式
导航
- 在大型工作表中移动
- 同时处理多个工作表/工作簿
复制和移动数据
- 选择区域（单元格范围）
- 移动数据
- 特殊插入
- 自动填充数据部分（系列）（例如序号和下一个工作日的日期）
公式、地址和单元格名称
- 创建、修改和复制公式
- 循环引用
- 条件格式化
- 地址类型及其使用
- 引用其他工作表和工作簿
- 使用单元格名称
函数
- 使用函数的一般规则
- 常用函数
- 嵌套函数
- 使用条件
- 函数创建器
电子表格中的图形
- AutoShapes和WordArt
- 静态和动态数据图像
图表
- 主要图表类型及其应用
- 创建引人注目的图表的一般原则
- 创建图表
- 图表的组件及其修改
- 创建自定义图表类型
隐藏和Data Protection
- 隐藏工作表、列和行
- 隐藏公式和单元格条目
- 保护工作表和免被修改
- 在打开前保护工作簿
打印
- 打印工作表和不相连的区域
- 打印图表
United Arab Emirates - Working with spreadsheet in Microsoft Excel
Qatar - Working with spreadsheet in Microsoft Excel
Egypt - Working with spreadsheet in Microsoft Excel
Saudi Arabia - Working with spreadsheet in Microsoft Excel
South Africa - Working with spreadsheet in Microsoft Excel
中国 - Working with spreadsheet in Microsoft Excel
香港 - Working with spreadsheet in Microsoft Excel
澳門 - Working with spreadsheet in Microsoft Excel
台灣 - Working with spreadsheet in Microsoft Excel
USA - Working with spreadsheet in Microsoft Excel
Österreich - Working with spreadsheet in Microsoft Excel
Schweiz - Working with spreadsheet in Microsoft Excel
Deutschland - Working with spreadsheet in Microsoft Excel
Czech Republic - Working with spreadsheet in Microsoft Excel
Denmark - Working with spreadsheet in Microsoft Excel
Estonia - Working with spreadsheet in Microsoft Excel
Finland - Working with spreadsheet in Microsoft Excel
Greece - Working with spreadsheet in Microsoft Excel
Magyarország - Working with spreadsheet in Microsoft Excel
Ireland - Working with spreadsheet in Microsoft Excel
Luxembourg - Working with spreadsheet in Microsoft Excel
Latvia - Working with spreadsheet in Microsoft Excel
España - Working with spreadsheet in Microsoft Excel
Italia - Working with spreadsheet in Microsoft Excel
Lithuania - Working with spreadsheet in Microsoft Excel
Nederland - Working with spreadsheet in Microsoft Excel
Norway - Working with spreadsheet in Microsoft Excel
Portugal - Working with spreadsheet in Microsoft Excel
România - Working with spreadsheet in Microsoft Excel
Sverige - Working with spreadsheet in Microsoft Excel
Türkiye - Working with spreadsheet in Microsoft Excel
Malta - Working with spreadsheet in Microsoft Excel
Belgique - Working with spreadsheet in Microsoft Excel
France - Working with spreadsheet in Microsoft Excel
日本 - Working with spreadsheet in Microsoft Excel
Australia - Working with spreadsheet in Microsoft Excel
Malaysia - Working with spreadsheet in Microsoft Excel
New Zealand - Working with spreadsheet in Microsoft Excel
Philippines - Working with spreadsheet in Microsoft Excel
Singapore - Working with spreadsheet in Microsoft Excel
Thailand - Working with spreadsheet in Microsoft Excel
Vietnam - Working with spreadsheet in Microsoft Excel
India - Working with spreadsheet in Microsoft Excel
Venezuela - Working with spreadsheet in Microsoft Excel
Polska - Microsoft Office Excel - poziom podstawowy
United Kingdom - Working with spreadsheet in Microsoft Excel
South Korea - Working with spreadsheet in Microsoft Excel
Pakistan - Working with spreadsheet in Microsoft Excel
Sri Lanka - Working with spreadsheet in Microsoft Excel
Bulgaria - Working with spreadsheet in Microsoft Excel
Bolivia - Working with spreadsheet in Microsoft Excel
Indonesia - Working with spreadsheet in Microsoft Excel
Kazakhstan - Working with spreadsheet in Microsoft Excel
Moldova - Working with spreadsheet in Microsoft Excel
Morocco - Working with spreadsheet in Microsoft Excel
Tunisia - Working with spreadsheet in Microsoft Excel
Kuwait - Working with spreadsheet in Microsoft Excel
Oman - Working with spreadsheet in Microsoft Excel
Slovakia - Working with spreadsheet in Microsoft Excel
Kenya - Working with spreadsheet in Microsoft Excel
Nigeria - Working with spreadsheet in Microsoft Excel
Botswana - Working with spreadsheet in Microsoft Excel
Slovenia - Working with spreadsheet in Microsoft Excel
Croatia - Working with spreadsheet in Microsoft Excel
Serbia - Working with spreadsheet in Microsoft Excel
Bhutan - Working with spreadsheet in Microsoft Excel