目錄(76章)
倒序
- coverpage
- Data Analysis and Business Modeling with Excel 2013
- Credits
- About the Author
- About the Reviewers
- www.PacktPub.com
- Support files eBooks discount offers and more
- Preface
- What this book covers
- What you need for this book
- Who this book is for
- Conventions
- Reader feedback
- Customer support
- Chapter 1. Getting Data into Excel
- Getting started with data
- Manually creating data
- Importing data from various sources
- Summary
- Chapter 2. Connecting to Databases
- Reading a table from MSSQL – the Microsoft SQL Server database
- Reading multiple tables from MSSQL
- Reading from MSSQL using SQL
- Summary
- Chapter 3. How to Clean Texts Numbers and Dates
- Leading/trailing/in-between spaces
- Capitalization
- Duplicates
- Text to Columns
- Combine data from multiple columns into one column
- Fixing similar words
- Text to dates
- Text to numbers
- Summary
- Chapter 4. Using Formulas to Prepare Your Data for Analysis
- How to create formulas
- Combining strings and numbers
- Using built-in functions
- If/else/then statements
- Comparing columns
- Summary
- Chapter 5. Analyzing Your Data Using Descriptive Statistics and Charts
- Gathering data
- Preparing the data for analysis
- Analyzing our data
- Summary
- Chapter 6. Link Your Data Using Data Models
- Gathering data
- Preparing data
- Analyzing data
- Data models
- Summary
- Chapter 7. A Primer on Using the Excel Solver
- Activating the Excel Solver
- Modeling our linear programming problem
- Using the Excel Solver
- Summary
- Chapter 8. Learning VBA – Excel's Scripting Language
- What is VBA?
- What is a macro?
- Opening the VBA Editor
- Your very first "Hello World" VBA script
- Summary
- Chapter 9. How to Build and Style Your Charts
- Quick analysis charts
- Charting options
- Additional design options
- Summary
- Chapter 10. Creating Interactive Spreadsheets Using Tables and Slicers
- What are slicers?
- Final tweaks
- Summary
- Appendix A. Tips Tricks and Shortcuts
- Shortcuts
- Tips and tricks
- Index 更新時間：2021-07-09 21:35:39
推薦閱讀
- PyTorch自動駕駛視覺感知算法實戰
- Java面向對象思想與程序設計
- C#編程入門指南（上下冊）
- .NET 4.0面向對象編程漫談：基礎篇
- 青少年美育趣味課堂：XMind思維導圖制作
- 數據結構習題精解（C語言實現+微課視頻）
- 數據結構（Python語言描述）（第2版）
- 機械工程師Python編程：入門、實戰與進階
- Flux Architecture
- Hands-On Natural Language Processing with Python
- 劍指MySQL：架構、調優與運維
- Python機器學習基礎教程
- jQuery Mobile移動應用開發實戰（第3版）
- .NET 4.5 Parallel Extensions Cookbook
- Building UIs with Wijmo
- 你必須知道的.NET（第2版）
- Java Web應用開發
- 新手學ASP.NET 3.5網絡開發
- VBA Automation for Excel 2019 Cookbook
- GitHub Essentials
- 鋒利的SQL
- Machine Learning with R Cookbook
- Android Programming for Beginners
- 小猴編程：Scratch 3.0趣味少兒編程（提高篇）
- SaltStack技術入門與實戰
- SproutCore Web Application Development
- Mastering Hibernate
- Mastering Adobe Captivate 8
- Python開發技術大全
- Python編程課
