相關主題
商品描述
Your complete guide to Excel 365, written for newbies all the way to seasoned professionals
Neatly organised and written using accessible language, Microsoft Excel 365 Bible contains everything that readers need to know to get up and running quickly with Excel. Covering the numerous updates to Excel 365 since the previous edition was published in 2022, this Second Edition contains many useful examples and tips and tricks that cover all essential aspects of Excel--from the basics, such as navigating the user interface, to more advanced topics, such as creating visualisations and crafting custom functions.
Written by an accomplished team of authors with decades of Excel and business intelligence experience, this book explores topics including:
- Entering and editing worksheet data, with information on data types, formulas, dates, times and other cell contents
- Building formulas with Excel table objects, correcting common formula errors and using formula variables
- Working with data series, changing basic chart elements and making use of chart customization
- Loading data from other sources, performing common transformations and applying conditional logic
Microsoft Excel 365 Bible earns a well-deserved spot on the bookshelves of all professionals and individuals seeking to get the most out of Excel 365, from beginners with limited knowledge of the software all the way to advanced users with years of experience under their belts.
商品描述(中文翻譯)
您的完整 Excel 365 指南,適合新手到資深專業人士
《Microsoft Excel 365 Bible》以易於理解的語言整齊地組織和撰寫,包含讀者快速上手 Excel 所需的所有知識。這本第二版涵蓋了自 2022 年前一版出版以來 Excel 365 的眾多更新,並提供了許多有用的範例和技巧,涵蓋 Excel 的所有基本方面,從導航使用者介面等基礎知識,到創建視覺化和編寫自定義函數等更高級的主題。
本書由一支擁有數十年 Excel 和商業智慧經驗的優秀作者團隊撰寫,探討的主題包括:
- 輸入和編輯工作表數據,包括數據類型、公式、日期、時間和其他單元格內容的資訊
- 使用 Excel 表格對象構建公式,糾正常見的公式錯誤和使用公式變數
- 處理數據系列,改變基本圖表元素並利用圖表自定義
- 從其他來源加載數據,執行常見轉換並應用條件邏輯
《Microsoft Excel 365 Bible》在所有專業人士和希望充分利用 Excel 365 的個人書架上佔有應有的位置,無論是對於對該軟體知識有限的新手,還是擁有多年經驗的高級用戶。
作者簡介
Michael Alexander is a senior consultant at Slalom Consulting with more than 15 years' experience in data management and reporting. He is the author of more than a dozen books on business analysis using Microsoft Excel and has been named Microsoft Excel MVP for his contributions to the Excel community.
Dick Kusleika has been working with Microsoft Office for more than 20 years. He was formerly a Microsoft MVP, having been awarded 12 consecutive years. Dick has written several books about Excel and Access.
作者簡介(中文翻譯)
邁克爾·亞歷山大是Slalom Consulting的高級顧問,擁有超過15年的數據管理和報告經驗。他是多本關於使用Microsoft Excel進行商業分析的書籍的作者,並因對Excel社群的貢獻而被評選為Microsoft Excel MVP。
迪克·庫斯萊卡在Microsoft Office領域工作超過20年。他曾是Microsoft MVP,連續獲得12年的獎項。迪克撰寫了幾本關於Excel和Access的書籍。