11242020 Teacher Lee 2 11242020 Teacher Lee 3

  • Slides: 25
Download presentation

@儲存格的用法? 11/24/2020 Teacher Lee 2

@儲存格的用法? 11/24/2020 Teacher Lee 2

@欄與列? 11/24/2020 Teacher Lee 3

@欄與列? 11/24/2020 Teacher Lee 3

@fx函數精靈用法? 11/24/2020 Teacher Lee 4

@fx函數精靈用法? 11/24/2020 Teacher Lee 4

@ 作表的認識? 11/24/2020 Teacher Lee 5

@ 作表的認識? 11/24/2020 Teacher Lee 5

@圖表精靈的操作? 11/24/2020 Teacher Lee 6

@圖表精靈的操作? 11/24/2020 Teacher Lee 6

@資料的排序sorting? 11/24/2020 Teacher Lee 7

@資料的排序sorting? 11/24/2020 Teacher Lee 7

@Word與excel的插入功能表? 11/24/2020 Teacher Lee 8

@Word與excel的插入功能表? 11/24/2020 Teacher Lee 8

@word的版面設定---(讚)? 11/24/2020 Teacher Lee 9

@word的版面設定---(讚)? 11/24/2020 Teacher Lee 9

@亞洲方式配置的種類? 11/24/2020 Teacher Lee 10

@亞洲方式配置的種類? 11/24/2020 Teacher Lee 10

@頁首頁尾設計與背景美化? 11/24/2020 Teacher Lee 12

@頁首頁尾設計與背景美化? 11/24/2020 Teacher Lee 12

謝謝聆聽及學習 v 最後再叮嚀 word存檔的類型有. docx及 網頁檔html v 而excel存檔的類型有. xls及網頁檔html v ~~~~~~~~~~~~~ v Happy Summer

謝謝聆聽及學習 v 最後再叮嚀 word存檔的類型有. docx及 網頁檔html v 而excel存檔的類型有. xls及網頁檔html v ~~~~~~~~~~~~~ v Happy Summer Vacation To You ! 11/24/2020 Teacher Lee 13

v v v v v =號當開頭 =today() 代表? =now() =time() =date() =day() =sum(__: __)

v v v v v =號當開頭 =today() 代表? =now() =time() =date() =day() =sum(__: __) 也可=_+_+_+_ or =sum(_, _, _, _. . . ) =rand() 其他average; rank; max; min; vlookup… =countif(__: __, ”條件”) 算符合條件的個數 11/24/2020 Teacher Lee 17