Data Analysis and Business Modeling with Excel 2013
eBook - ePub

Data Analysis and Business Modeling with Excel 2013

  1. 226 pages
  2. English
  3. ePUB (mobile friendly)
  4. Available on iOS & Android
eBook - ePub

Data Analysis and Business Modeling with Excel 2013

Book details
Book preview
Table of contents
Citations

About This Book

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.

Frequently asked questions

Simply head over to the account section in settings and click on “Cancel Subscription” - it’s as simple as that. After you cancel, your membership will stay active for the remainder of the time you’ve paid for. Learn more here.
At the moment all of our mobile-responsive ePub books are available to download via the app. Most of our PDFs are also available to download and we're working on making the final remaining ones downloadable now. Learn more here.
Both plans give you full access to the library and all of Perlego’s features. The only differences are the price and subscription period: With the annual plan you’ll save around 30% compared to 12 months on the monthly plan.
We are an online textbook subscription service, where you can get access to an entire online library for less than the price of a single book per month. With over 1 million books across 1000+ topics, we’ve got you covered! Learn more here.
Look out for the read-aloud symbol on your next book to see if you can listen to it. The read-aloud tool reads text aloud for you, highlighting the text as it is being read. You can pause it, speed it up and slow it down. Learn more here.
Yes, you can access Data Analysis and Business Modeling with Excel 2013 by David Rojas in PDF and/or ePUB format, as well as other popular books in Informatica & Applicazioni per aziende. We have over one million books available in our catalogue for you to explore.

Information

Publisher
Packt Publishing
Year
2015
ISBN
9781785289545
Edition
1
Topic
Informatica
Subtopic
Applicazioni per aziende

Data Analysis and Business Modeling with Excel 2013

Table of Contents

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
Why subscribe?
Free access for Packt account holders
Instant updates on new Packt books
Preface
What this book covers
What you need for this book
Who this book is for
Conventions
Reader feedback
Customer support
Downloading the example code
Downloading the color images of this book
Errata
Piracy
Questions
1. Getting Data into Excel
Getting started with data
Gathering data
Preparing data
Analyzing data
Presenting data
Manually creating data
Importing data from various sources
Importing data from a text file
Importing a CSV file
Importing other Excel files
Importing data from the Web
Summary
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
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
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
5. Analyzing Your Data Using Descriptive Statistics and Charts
Gathering data
Preparing the data for analysis
Analyzing our data
Question – how many applications were processed in the year 2014?
Summary
6. Link Your Data Using Data Models
Gathering data
Preparing data
Analyzing data
Data models
Summary
7. A Primer on Using the Excel Solver
Activating the Excel Solver
Modeling our linear programming problem
Using the Excel Solver
Summary
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
Declaring variables
Conditional statements
Loops
Creating macros without any code
Saving macro-powered spreadsheets
Summary
9. How to Build and Style Your Charts
Quick analysis charts
Charting options
Chart elements
Chart styles
Chart filters
Additional design options
Summary
10. Creating Interactive Spreadsheets Using Tables and Slicers
What are slicers?
How to create slicers
Styling slicers
Adding multiple slicers
Clearing filters
Final tweaks
Summary
A. Tips, Tricks, and Shortcuts
Shortcuts
Tips and tricks
Index

Data Analysis and Business Modeling with Excel 2013

Copyright © 2015 Packt Publishing
All rights reserved. No part of this book may be reproduced, stored in a retrieval system, or transmitted in any form or by any means, without the prior written permission of the publisher, except in the case of brief quotations embedded in critical articles or reviews.
Every effort has been made in the preparation of this book to ensure the accuracy of the information presented. However, the information contained in this book is sold without warranty, either express or implied. Neither the author, nor Packt Publishing, and its dealers and distributors will be held liable for any damages caused or alleged to be caused directly or indirectly by this book.
Packt Publishing has endeavored to provide trademark information about all of the companies and products mentioned in this book by the appropriate use of capitals. However, Packt Publishing cannot guarantee the accuracy of this information.
First published: October 2015
Production reference: 1191015
Published by Packt Publishing Ltd.
Livery Place
35 Livery Street
Birmingham B3 2PB, UK.
ISBN 978-1-78528-954-5
www.packtpub.com

Credits

Author
David Rojas
Reviewers
Skanda Bhargav
Manoj Kumar
Rajesh S
Kimberly J. E. Williamson
Commissioning Editor
Veena Pagare
Acquisition Editor
Sonali Vernekar
Content Development Editor
Parita Khedekar
Technical Editor
Madhunikita Sunil Chindarkar
Copy Editor
Rashmi Sawant
Project Coordinator
Milton Dsouza
Proofreader
Safis Editing
Indexer
Hemangini Bari
Production Coordinator
Shantanu N. Zagade
Cover Work
Shantanu N. Zagade
2323__p...

Table of contents

  1. Data Analysis and Business Modeling with Excel 2013