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

Data Analysis and Business Modeling with Excel 2013

David Rojas

1 customer reviews
Manage, analyze, and visualize data with Microsoft Excel 2013 to transform raw data into ready to use information
Mapt Subscription
FREE
$29.99/m after trial
eBook
$22.40
RRP $31.99
Save 29%
Print + eBook
$39.99
RRP $39.99
What do I get with a Mapt Pro subscription?
  • Unlimited access to all Packt’s 5,000+ eBooks and Videos
  • Early Access content, Progress Tracking, and Assessments
  • 1 Free eBook or Video to download and keep every month after trial
What do I get with an eBook?
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with Print & eBook?
  • Get a paperback copy of the book delivered to you
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with a Video?
  • Download this Video course in MP4 format
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
$0.00
$22.40
$39.99
$29.99p/m after trial
RRP $31.99
RRP $39.99
Subscription
eBook
Print + eBook
Start 30 Day Trial
Subscribe and access every Packt eBook & Video.
 
  • 5,000+ eBooks & Videos
  • 50+ New titles a month
  • 1 Free eBook/Video to keep every month
Start Free Trial
 
Preview in Mapt

Book Details

ISBN 139781785289545
Paperback226 pages

Book Description

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.

Table of Contents

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

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

Authors

Table of Contents

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

Book Details

ISBN 139781785289545
Paperback226 pages
Read More
From 1 reviews

Read More Reviews

Recommended for You

Getting Started with Zurb Foundation 4 Book Cover
Getting Started with Zurb Foundation 4
$ 20.99
$ 14.70
Python Machine Learning Book Cover
Python Machine Learning
$ 35.99
$ 25.20
Practical Data Analysis Book Cover
Practical Data Analysis
$ 29.99
$ 21.00
Game Data Analysis – Tools and Methods Book Cover
Game Data Analysis – Tools and Methods
$ 17.99
$ 12.60
Machine Learning with R - Second Edition Book Cover
Machine Learning with R - Second Edition
$ 43.99
$ 30.80
Practical Machine Learning Book Cover
Practical Machine Learning
$ 37.99
$ 26.60