Data Analysis and Business Modeling with Excel 2013

Manage, analyze, and visualize data with Microsoft Excel 2013 to transform raw data into ready to use information

About This Book

• Create formulas to help you analyze and explain findings
• Develop interactive spreadsheets that will impress your audience and give them the ability to slice and dice data
• A step-by-step guide to learn various ways to model data for businesses with the help of Excel 2013

Who This Book Is For

If you want to start using Excel 2013 for data analysis and business modeling and enhance your skills in the data analysis life cycle then this book is for you, whether you're new to Excel or experienced.

What You Will Learn

• Discover what Excel formulas are all about and how to use them in your spreadsheet development
• Identify bad data and learn cleaning strategies
• Create interactive spreadsheets that engage and appeal to your audience
• Leverage Excel's powerful built-in tools to get the median, maximum, and minimum values of your data
• Build impressive tables and combine datasets using Excel's built-in functionality
• Learn the powerful scripting language VBA, allowing you to implement your own custom solutions with ease

In Detail

Excel 2013 is one of the easiest to use data analysis tools you will ever come across. Its simplicity and powerful features has made it the go to tool for all your data needs. Complex operations with Excel, such as creating charts and graphs, visualization, and analyzing data make it a great tool for managers, data scientists, financial data analysts, and those who work closely with data. Learning data analysis and will help you bring your data skills to the next level.

This book starts by walking you through creating your own data and bringing data into Excel from various sources. You'll learn the basics of SQL syntax and how to connect it to a Microsoft SQL Server Database using Excel's data connection tools. You will discover how to spot bad data and strategies to clean that data to make it useful to you. Next, you'll learn to create custom columns, identify key metrics, and make decisions based on business rules. You'll create macros using VBA and use Excel 2013's shiny new macros. Finally, at the end of the book, you'll be provided with useful shortcuts and tips, enabling you to do efficient data analysis and business modeling with Excel 2013.

Style and approach

This is a step-by-step guide to performing data analysis and business modelling with Excel 2013, complete with examples and tips.

使用Microsoft Excel 2013來管理、分析和視覺化數據，將原始數據轉化為可用的信息。

關於本書：
- 創建公式以幫助您分析和解釋發現
- 開發互動式電子表格，給觀眾留下深刻印象，並讓他們能夠切割和分析數據
- 逐步指南，學習使用Excel 2013為企業建模提供各種方法

本書適合對Excel 2013進行數據分析和業務建模，並提升數據分析生命周期技能的讀者，無論您是新手還是有經驗。

您將學到：
- 了解Excel公式的基本知識以及如何在電子表格開發中使用它們
- 辨識不良數據並學習清理策略
- 創建引人入勝且吸引觀眾的互動式電子表格
- 利用Excel強大的內置工具獲取數據的中位數、最大值和最小值
- 使用Excel的內置功能建立令人印象深刻的表格並結合數據集
- 學習強大的腳本語言VBA，輕鬆實現自定義解決方案

Excel 2013是您將遇到的最易於使用的數據分析工具之一。它的簡單性和強大功能使其成為經理、數據科學家、金融數據分析師以及與數據密切合作的人的首選工具。學習數據分析將幫助您將數據技能提升到更高水平。

本書首先引導您創建自己的數據並從各種來源將數據帶入Excel。您將學習SQL語法的基礎知識，以及如何使用Excel的數據連接工具將其連接到Microsoft SQL Server數據庫。您將發現如何辨識不良數據並採取清理策略，使其對您有用。接下來，您將學習創建自定義列、識別關鍵指標並根據業務規則做出決策。您將使用VBA創建宏並使用Excel 2013的新宏。最後，在本書結尾，我們將提供有用的快捷方式和技巧，使您能夠使用Excel 2013進行高效的數據分析和業務建模。

本書以示例和技巧完整呈現了使用Excel 2013進行數據分析和業務建模的逐步指南。