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