相關主題
商品描述
Advanced Excel Essentials is the only book for the experienced Excel developer. This book starts from the assumption that you are well-versed in Excel--and builds on your skills to take them to the advanced level. It will show you the building blocks of advanced development and then take you through the development of your own advanced spreadsheet application. For the seasoned analyst, accountant, financial professional, management consultant, and engineer--this is the book you've been waiting for!
* Covers advanced formula topics like array formulas and Boolean logic
* Shows you how to build correctly with hands-on examples
* Provides insight into better code and formulas development
* Builds on a foundation of industry best practices and the author's hard won real-world experience
What you'll learn
* Covers advanced formula topics like array formulas and Boolean logic
* Shows you how to build correctly with hands-on examples
* Provides insight into better code and formulas development
* Builds on a foundation of industry best practices and the author's hard won real-world experience
What you'll learn
- How to build better, faster, and leaner spreadsheets that will make you a force to be reckoned with, in your organization
- How to write optimized code and formulas that are easily understood even by less experienced users
- Learn how to turn a spreadsheet into a powerhouse application that rivals commercial software
- Learn the tools and techniques for optimal layout, data storage, and advanced analytics
Intermediate or advanced excel users who wish to learn how to be more productive and develop more powerful applications
Table of Contents
Table of Contents
1. Introduction
2. Visual Basic for Applications for Excel, a Refresher
3. Introducing Formula Concepts
4. Advanced Formula Concepts
5. Introduction to Controls
6. Getting Input from Users
7. Storage Patterns for User Input
8. Building for Sensitivity Analysis
9. Perfecting the Presentation
2. Visual Basic for Applications for Excel, a Refresher
3. Introducing Formula Concepts
4. Advanced Formula Concepts
5. Introduction to Controls
6. Getting Input from Users
7. Storage Patterns for User Input
8. Building for Sensitivity Analysis
9. Perfecting the Presentation
商品描述(中文翻譯)
《進階 Excel 必備技巧》是專為經驗豐富的 Excel 開發者而設的唯一書籍。本書假設您已經熟悉 Excel，並在此基礎上提升您的技能至進階水平。它將展示進階開發的基本構件，然後引導您開發自己的進階電子表格應用程式。對於資深分析師、會計師、金融專業人士、管理顧問和工程師來說，這是您一直在等待的書籍！
* 涵蓋進階公式主題，如陣列公式和布林邏輯
* 透過實作範例教您如何正確構建
* 提供更佳的程式碼和公式開發見解
* 基於行業最佳實踐和作者辛苦獲得的實務經驗
您將學到什麼
- 如何構建更好、更快且更精簡的電子表格，使您在組織中成為不可忽視的力量
- 如何撰寫優化的程式碼和公式，即使是經驗較少的使用者也能輕易理解
- 學習如何將電子表格轉變為一個強大的應用程式，與商業軟體相媲美
- 學習最佳佈局、數據儲存和進階分析的工具和技術
本書適合誰
中級或高級 Excel 使用者，希望學習如何提高生產力並開發更強大的應用程式
目錄
1. 介紹
2. Excel 的應用程式視覺基本語言回顧
3. 公式概念介紹
4. 進階公式概念
5. 控制項介紹
6. 獲取使用者輸入
7. 使用者輸入的儲存模式
8. 敏感度分析的構建
9. 完善展示
