目錄(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
推薦閱讀
- 垃圾回收的算法與實現
- Boost C++ Application Development Cookbook（Second Edition）
- 神經網絡編程實戰：Java語言實現（原書第2版）
- Vue.js 3.0源碼解析（微課視頻版）
- Apache Spark Graph Processing
- VMware vSphere 6.7虛擬化架構實戰指南
- PLC編程及應用實戰
- MATLAB for Machine Learning
- Vue.js應用測試
- 計算機應用基礎項目化教程
- Django Design Patterns and Best Practices
- Penetration Testing with the Bash shell
- ASP.NET Core and Angular 2
- Mastering Machine Learning with R
- 測試工程師Python開發實戰
- Three.js Essentials
- Visual FoxPro數據庫程序設計
- 深入淺出Go語言核心編程
- Building RESTful Web Services with PHP 7
- Cadence Concept-HDL ＆ Allegro原理圖與電路板設計（第2版）
- 軟件測試（第2版）
- WebGIS之Leaflet全面解析
- INSTANT OSGi Starter
- 湖南省大學生計算機程序設計競賽試題與應用軟件開發類作品集萃（2005—2016）
- Magento PHP Developer's Guide（Second Edition）
- Unity 2018 Cookbook（Third Edition）
- ScratchJr趣味編程精彩實例
- Unreal Engine 4.X By Example
- Python程序設計案例課堂
- H5安全開發實踐教程
