English Japanese Korean Thai Traditional Chinese 简体中文
Publish Now
Publish Books Publish Media Products My Store Self Publish
Gold Log In Cart
Category
Browse all kinds of eBooks, magazines, videos by category
    More services
    • All You Can Read

    • Channels

    • Hot topics

    Language
    English Japanese Korean Thai Traditional Chinese 简体中文
    Back
    Category
    • Home

    • Books

    • Pubook E-Ink reader

    • Magazines

    • Media

    • Newspapers

    • Adult

    Back
    Books
    • All

    • Free to read

    • Finance

      Finance
      • All

      • Management

      • Investing

      • Marketing

    • Literature/Fiction

      Literature/Fiction
      • All

      • LGBTQ

      • Literature

      • Fiction

      • Romantic Fiction

    • Leisure Life

      Leisure Life
      • All

      • Recreation

      • Illustrated Book

      • Fortune Telling

      • Travel

      • Eating Habits

      • Fitness

    • Humanities

      Humanities
      • All

      • History/Geography

      • Law

      • Politics/Military

      • Applied Sciences

      • Natural Sciences

      • Philosophy

      • Biographies

      • Sociology

    • News/Entertainment

    • Language/Computers

      Language/Computers
      • All

      • Computers/Technology

      • Language

    • Religion/Spirituality

      Religion/Spirituality
      • All

      • Motivational

      • Health/Nutrition

      • Christianity

      • Buddhism

      • Taoism

      • Islam

      • Other Religions

      • Relationships

    • Mangas

      Mangas
      • All

      • Comics

      • Illustrations

      • Fan Works

      • Romance Mangas for Teens

      • Teenage Mangas

      • High School Mangas

      • Romance Mangas

      • Yaoi Mangas

      • GL Mangas

      • TL Mangas

      • Gay Mangas

      • Others

    • Art/Design

      Art/Design
      • All

      • Performance Art

      • Art

      • Design

      • Photography

    • Parenting/Relationships

      Parenting/Relationships
      • All

      • Education

      • Kids/Teenagers

      • Pregnancy/Childbirth

    • Exams

      Exams
      • All

      • Study

      • Government Exams

      • Financial Licenses

      • Teacher Exams

      • Professional Exams

      • TOEFL/TOEIC

      • Learning Skills

      • Official Publications

      • Job Hunting Exams

    • Photo Books

      Photo Books
      • All

      • Female Photo Books

      • Male Photo Books

    Back
    Magazines
    • All

    • Free to read

    • Finance

      Finance
      • All

      • Business Management

      • Investing

      • Direct Marketing

      • Advertising

      • Law

    • News/Entertainment

      News/Entertainment
      • All

      • News Analysis

      • General News

      • Stars

    • Leisure Life

      Leisure Life
      • All

      • Travel

      • Hobby

      • Family Life

      • Fitness

    • Art/Design

      Art/Design
      • All

      • Design

      • Art Appreciation

      • Decoration

      • Photography

    • Literature/Spirituality

      Literature/Spirituality
      • All

      • Literature

      • Christianity

      • Buddhism

    • Male Fashion

      Male Fashion
      • All

      • Fashion

    • Female Fashion

      Female Fashion
      • All

      • Urban Fashion

      • Teen Fashion

    • Car/Audio

      Car/Audio
      • All

      • Music/Audio

      • Cars/Motorbikes

    • Sports

      Sports
      • All

      • Basketball

      • Baseball

      • Outdoor Sports

    • Language/Computers

      Language/Computers
      • All

      • Computers/Technology

      • Natural Sciences

      • Language

    • Parenting/Relationships

      Parenting/Relationships
      • All

      • Pregnancy/Childbirth

      • Education

      • Books for Kids

      • Books for Teenagers

    • Photo Books

      Photo Books
      • All

      • Female Photo Books

      • Male Photo Books

    Back
    Media
    • All

    • Free to read

    • Careers

    • Careers
      • All

    • Investing

    • Investing
      • All

    • Parenting/Relationships

    • Parenting/Relationships
      • All

    • Art/Culture

    • Art/Culture
      • All

    • Religion/Spirituality

    • Religion/Spirituality
      • All

      • Buddhism

      • Christianity

      • Motivational

    • Exams

    • Exams
      • All

      • Government Exams

      • Learning Skills

      • Professional Exams

      • Teacher Exams

      • Study

      • Financial Licenses

    • Language

    • Language
      • All

    • Leisure Life

    • Leisure Life
      • All

    • Literature/Fiction

    • Literature/Fiction
      • All

    Back
    Newspapers
    • All

    • 工商時報

    • 中國時報

    • 旺報

    • 联合日報

    • 光華日報

    Back
    Adult
    • Free to read

    • Gay

    • Nude male

    • Lesbian

    • Nude female

    • Adult Manga

    Finance
    • All

    • Management

    • Investing

    • Marketing

    Literature/Fiction
    • All

    • LGBTQ

    • Literature

    • Fiction

    • Romantic Fiction

    Leisure Life
    • All

    • Recreation

    • Illustrated Book

    • Fortune Telling

    • Travel

    • Eating Habits

    • Fitness

    Humanities
    • All

    • History/Geography

    • Law

    • Politics/Military

    • Applied Sciences

    • Natural Sciences

    • Philosophy

    • Biographies

    • Sociology

    News/Entertainment
    • All

    Language/Computers
    • All

    • Computers/Technology

    • Language

    Religion/Spirituality
    • All

    • Motivational

    • Health/Nutrition

    • Christianity

    • Buddhism

    • Taoism

    • Islam

    • Other Religions

    • Relationships

    Mangas
    • All

    • Comics

    • Illustrations

    • Fan Works

    • Romance Mangas for Teens

    • Teenage Mangas

    • High School Mangas

    • Romance Mangas

    • Yaoi Mangas

    • GL Mangas

    • TL Mangas

    • Gay Mangas

    • Others

    Art/Design
    • All

    • Performance Art

    • Art

    • Design

    • Photography

    Parenting/Relationships
    • All

    • Education

    • Kids/Teenagers

    • Pregnancy/Childbirth

    Exams
    • All

    • Study

    • Government Exams

    • Financial Licenses

    • Teacher Exams

    • Professional Exams

    • TOEFL/TOEIC

    • Learning Skills

    • Official Publications

    • Job Hunting Exams

    Photo Books
    • All

    • Female Photo Books

    • Male Photo Books

    Back
    Finance
    • All

    • Business Management

    • Investing

    • Direct Marketing

    • Advertising

    • Law

    Back
    News/Entertainment
    • All

    • News Analysis

    • General News

    • Stars

    Back
    Leisure Life
    • All

    • Travel

    • Hobby

    • Family Life

    • Fitness

    Back
    Art/Design
    • All

    • Design

    • Art Appreciation

    • Decoration

    • Photography

    Back
    Literature/Spirituality
    • All

    • Literature

    • Christianity

    • Buddhism

    Back
    Male Fashion
    • All

    • Fashion

    Back
    Female Fashion
    • All

    • Urban Fashion

    • Teen Fashion

    Back
    Car/Audio
    • All

    • Music/Audio

    • Cars/Motorbikes

    Back
    Sports
    • All

    • Basketball

    • Baseball

    • Outdoor Sports

    Back
    Language/Computers
    • All

    • Computers/Technology

    • Natural Sciences

    • Language

    Back
    Parenting/Relationships
    • All

    • Pregnancy/Childbirth

    • Education

    • Books for Kids

    • Books for Teenagers

    Back
    Photo Books
    • All

    • Female Photo Books

    • Male Photo Books

    Back
    Channels
    • 今周刊

    • 飽讀商周

    • 經理人

    • 大師輕鬆讀

    • 普洛達康

    • 禾馬

    • 台灣武俠傳說

    You haven't completed email verification, please complete email verification to purchase DRM Free or magazine subscription products
    You haven't completed phone verification, please complete phone verification to enable publishing features
    You haven't completed email verification, please complete email verification to enable publishing features
    • Home

    • Favorite

    • Account

    • Gold

    • Library

    More
    1. Home
    2. Books
    3. Language/Computers
    4. Computers/Technology
    5. Excel函數精用密技字典(第二版)

    Excel函數精用密技字典(第二版)

    Author PCuSER研究室
    Publisher 城邦文化 /PCuSER電腦人文化
    Follow Save Saved Share
    Released
    2016/07/26
    Language
    Traditional Chinese
    File format
    PDF (26MB), fit in large screen and Pubook
    Pages
    260
    ID
    75416
    ISBN
    9789861994680
    Provide Adobe DRM
    Provide PDF
    Offer DRM free license
    No
    Series 密技字典

    Buy products firstAnd download app to watch

    Details
    DRM
    NT$104
    Explanation
    eBook
    Printed book
    Standard NT$149
    Get NT$16 off
    查看適用禮券
    Buy

    Preview View

    Buy for others
    庫存
    • Intro

    • Chapters

    • Author

    函數絕對是Excel中的精髓!學會函數保證你在製作高難度報表時更加無往不利,本書收錄了超過百則常用的Excel函數,不管是文字格式、邏輯函數、時間日期、資料庫檢視、運算統計、財務金融、工程函數……等,不管是臨時忘了函數怎麼用,還是要查詢有哪些函數可以使用,都很方便實用!

    ◎四大類39個工程領域的專業函數,分析難解數值一點也沒問題
    ◎23種設定文字格式的函數,強化報表的易讀性與美觀
    ◎41項多變的時間及日期函數,讓報表更加有條不紊
    ◎41則強化運算的邏輯函數,搭配組合讓問題迎刃而解
    ◎17款聰明理財的財務管家,免手帳記事也能管理開銷
    ◎11大類Excel函數分類一覽,快速查找360多個內建函數
    More
    More
    【Part 1 Excel函數初體驗】 P.7
    Trick 01 認識Excel的十一大類函數 P.8
    Trick 02 Excel函數與引數的基本寫法 P.11
    Trick 03 輸入函數的兩種方法 P.13
    Trick 04 加入更多Excel函數-安裝分析工具箱 P.15
    Trick 05 Excel的儲存格格式 P.18

    【Part 2 設定文字格式的函數】 P.19
    Trick 01 CHAR P.20
    Trick 02 CODE P.21
    Trick 03 LEFT P.22
    Trick 04 LOWER P.24
    Trick 05 MID P.26
    Trick 06 PROPER P.28
    Trick 07 REPLACE P.30
    Trick 08 RIGHT P.32
    Trick 09 SEARCH P.34
    Trick 10 SUBSTITUTE P.36
    Trick 11 TRIM P.39
    Trick 12 UPPER P.41
    Trick 13 VALUE P.45

    【Part 3 強化運算的邏輯函數】 P.47
    Trick 01 AND P.48
    Trick 02 IF P.50
    Trick 03 NOT P.54
    Trick 04 OR P.57

    【Part 4 變化多端的時間及日期函數】 P.59
    Trick 01 NOW P.60
    Trick 02 TODAY P.61
    Trick 03 WEEKDAY P.62
    Trick 04 DATE P.66
    Trick 05 MONTH P.68
    Trick 06 YEAR P.70
    Trick 07 TIME P.71
    Trick 08 HOUR P.73

    【Part 5 各種訊息手到擒來】 P.75
    Trick 01 AREAS P.76
    Trick 02 CELL P.78
    Trick 03 CHOOSE P.84
    Trick 04 DGET P.87
    Trick 05 HLOOKUP P.90
    Trick 06 HYPERLINK P.92
    Trick 07 INDEX P.94
    Trick 08 INDIRECT P.96
    Trick 09 INFO P.99
    Trick 10 ISNUMBER P.103
    Trick 11 ISTEXT P.104
    Trick 12 LOOKUP(向量) P.105
    Trick 13 LOOKUP(陣列) P.108
    Trick 14 MATCH P.110
    Trick 15 OFFSET P.112
    Trick 16 PHONETIC P.114
    Trick 17 ROW、COLUMN P.116
    Trick 18 ROWS、COLUMNS P.117
    Trick 19 VLOOKUP P.118

    【Part 6 運算最佳的函數搭檔】
    Trick 01 ABS P.122
    Trick 02 AVERAGE P.124
    Trick 03 CEILING P.126
    Trick 04 COMBIN P.129
    Trick 05 COUNT P.131
    Trick 06 COUNTA P.133
    Trick 07 COUNTBLANK P.135
    Trick 08 COUNTIF P.137
    Trick 09 FACT P.139
    Trick 10 FLOOR P.140
    Trick 11 MEDIAN P.142
    Trick 12 MIN、MAX P.144
    Trick 13 MOD P.146
    Trick 14 POWER P.148
    Trick 15 PRODUCT P.150
    Trick 16 RAND P.152
    Trick 17 ROMAN P.154
    Trick 18 ROUND P.156
    Trick 19 ROUNDDOWN P.158
    Trick 20 ROUNDUP P.160
    Trick 21 SIN P.162
    Trick 22 SQRT P.164
    Trick 23 SUBTOTAL P.166
    Trick 24 SUM P.168
    Trick 25 SUMIF P.171
    Trick 26 SUMPRODUCT P.173
    Trick 27 TRIMMEAN P.175

    【Part 7 聰明理財的財務管家】 P.177
    Trick 01 FV P.178
    Trick 02 IPMT P.180
    Trick 03 IRR P.182
    Trick 04 MIRR P.184
    Trick 05 NPER P.186
    Trick 06 NPV P.188
    Trick 07 PMT P.190
    Trick 08 PPMT P.192
    Trick 09 PV P.194
    Trick 10 RATE P.197

    【Part 8 工程領域的專業函數】 P.199
    Trick 01 貝塞爾(Bessel)函數 P.200
    Trick 02 2、8、10、16進位數字轉換函數 P.203
    Trick 03 誤差相關函數 P.207
    Trick 04 複數計算函數 P.208

    【Part 9 Excel函數分類全覽表】 P.209
    Trick 01 財務函數 P.210
    Trick 02 日期及時間函數 P.221
    Trick 03 數學與三角函數 P.223
    Trick 04 統計函數 P.228
    Trick 05 查閱與參照函數 P.238
    Trick 06 資料庫函數 P.241
    Trick 07 文字函數 P.243
    Trick 08 邏輯函數 P.247
    Trick 09 資訊函數 P.248
    Trick 10 工程函數 P.250
    Trick 11 CUBE函數 P.254
    More
    PCuSER研究室
    致力於匯集各方最專業的內容,提供第一手的消息與最實用的密技。

    相關著作
    《Excel精算速學500招【新裝修訂版】》
    《地表最強Windows 10完全攻略!升級、設定、優化、問題排除,高手活用技巧速學實戰》
    《密技偷偷報年度精悍練功版6.0》
    《Android地表最強密技超級精選》
    《Word、Excel、PowerPoint 強效精攻500招 (超實用增量版)》
    《密技偷偷報【密】字第柒拾陸號》
    《iPhone 6地表最強密技大集合!找出你沒想過的活用法,揭開隱藏版的裏技攻略》
    《密技偷偷報【密】字第柒拾伍號》
    《Google活用技巧大解密:絕對能派上用場的Google超級攻略》
    《密技偷偷報【密】字第柒拾肆號》
    《密技偷偷報【密】字第柒拾參號》
    《大家的facebook問題集》
    《密技偷偷報【密】字第柒拾壹號》
    《密技偷偷報年度精悍練功版Ver5.0》
    《密技偷偷報【密】字第柒拾號》
    《Excel 精算速學500招》
    《密技偷偷報【密】字第陸拾玖號》
    《密技偷偷報【密】字第陸拾捌號》
    《密技偷偷報【密】字第陸拾柒號》
    《Google精用密技字典》
    《密技偷偷報【密】字第陸拾陸號》
    《Windows 7 精用密技字典》
    《Windows 8 精用密技字典》
    《Windows 8終極強化高手制霸技》
    《密技偷偷報【密】字第陸拾伍號》
    《Word、Excel、PowerPoint 強效精攻500招》
    《EXCEL函數精用密技字典》
    《EXCEL精用密技字典》
    《密技偷偷報【密】字第陸拾肆號》
    《PowerPoint精用密技字典》
    《Word精用密技字典》
    《密技偷偷報【密】字第陸拾參號》
    《Evernote超效率數位筆記術》
    《密技偷偷報【密】字第陸拾貳號》
    《密技偷偷報【密】字第陸拾壹號》
    《Best Download !部落客評選最優軟體大補帖》
    《密技偷偷報年度精悍練功版Ver4.0》
    《iPhone 4S無禁忌活用術 X iOS 5升級即戰力》
    《密技偷偷報【密】字第陸拾號》
    《密技偷偷報【密】字第伍拾玖號》
    《密技偷偷報【密】字第伍拾捌號》
    《密技偷偷報【密】字第伍拾柒號》
    《密技偷偷報【密】字第伍拾陸號》
    《密技偷偷報【密】字第伍拾伍號》
    More

    Details

    Released
    2016/07/26
    Language
    Traditional Chinese
    File format
    PDF: Fit in large screen
    Provide Adobe DRM
    Provide PDF
    Offer DRM free license
    No
    ID
    75416
    ISBN
    9789861994680

    報表製作

    電腦程式

    函數

    Excel

    密技字典

    Buy products firstAnd download app to watch

    Details

    See more 城邦文化 / PCuSER電腦人文化

    More

    城邦國際名表 6月號/2025 第159期

    與眾不同的大腦:為什麼我們能理解科學和藝術?電腦與AI會影響大腦的演化嗎?

    法國 France

    讓你健康不失智的體智能:活化大腦與身體的雙適能鍛鍊

    黃阿瑪的後宮生活:貓永遠是對的[經典改版]

    新電子科技雜誌2025年6月號471期

    地中海一萬五千年史【中文世界唯一法語直譯本,地中海研究權威亞蘭.布隆迪扛鼎經典著作回歸】(2冊合售)

    山稜上的無名英雄:從背工到高山協作,雪巴人、巴爾蒂人在大山深處寫下自己的勝利

    La Vie 6月號/2025 第254期

    逆局套書(上下集)

    Related Product

    Excel精用密技字典(第二版)

    Excel精算速學500招【新裝修訂版】

    Excel VBA最強權威〈國際中文版〉

    跟四大會計師事務所學做Excel圖表(第二版)

    Python x AI辦公室作業自動化

    翻倍效率工作術– 詢問度破表的Office最強職人技(加量增訂版)

    Excel自學聖經(第二版):從完整入門到職場活用的技巧與實例大全

    Office 2021高效實用範例必修16課

    App Inventor 2:趣味手遊自己做

    Word+Excel+PowerPoint超效率500招速成技

    用micro:bit學MakeCode Block Editor程式設計製作簡單小遊戲

    地表最強Windows 10完全攻略!升級、設定、優化、問題排除,高手活用技巧速學實戰

      

    Review

    0 ratings
    1 stars
    0%
    2 stars
    0%
    3 stars
    0%
    4 stars
    0%
    5 stars
    0%
    Write a review
    Eligible to write reviews after purchasing products or add to Library
    Explanation
    DRM needs to login with Pubu Web or App, DRM free can be opened with any device or App
    You already owned this product
    Are you sure you want to buy Excel函數精用密技字典(第二版) again? This will generate duplicated items in your Library
    Buy again
    Buy for others
    After completing the checkout process, go to "Profile, Manage gift codes" to send the gift code to your friends or group members
    Quantity
    OK
    English Japanese Korean Thai Traditional Chinese 简体中文

    • About Pubu

    • Terms of Service

    • Privacy policy

    • Publish Books

    • Publish Media Products

    • Self Publish

    • Support

    • Join AP Alliance

    • 用台灣之星看飽讀

    • Redeem Retail Products

    Free downloaddddddddddddd
    Free download
    Payment
    About Pubu
    湛天創新科技股份有限公司
    24488585
    Copyright © Nuazure Innovative Technology Co., Ltd. & HK Renascimedia Co., Ltd.
    pubu-web-3.9.0.202009251127
    Download Android APK
    Download

    系統訊息


    您的合約條件不符合推廣聯盟申請資格,如有疑問請洽詢Pubu版權部窗口

    系統訊息


    您必須啟用賣家功能,才能透過專屬推廣連結,賣書賺回饋金
    Choose language
    English 日本語 한국어 ไทย 繁體中文 简体中文
    Processing