Data Analysis and Business Modeling with Excel 2013

Packt Publishing Limited
  • 1. Auflage
  • |
  • erschienen am 27. Oktober 2015
  • |
  • 226 Seiten
E-Book | ePUB mit Adobe DRM | Systemvoraussetzungen
978-1-78528-403-8 (ISBN)
Manage, analyze, and visualize data with Microsoft Excel 2013 to transform raw data into ready to use informationAbout This BookCreate formulas to help you analyze and explain findingsDevelop interactive spreadsheets that will impress your audience and give them the ability to slice and dice dataA step-by-step guide to learn various ways to model data for businesses with the help of Excel 2013Who This Book Is ForIf 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 LearnDiscover what Excel formulas are all about and how to use them in your spreadsheet developmentIdentify bad data and learn cleaning strategiesCreate interactive spreadsheets that engage and appeal to your audienceLeverage Excel's powerful built-in tools to get the median, maximum, and minimum values of your dataBuild impressive tables and combine datasets using Excel's built-in functionalityLearn the powerful scripting language VBA, allowing you to implement your own custom solutions with easeIn DetailExcel 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 approachThis is a step-by-step guide to performing data analysis and business modelling with Excel 2013, complete with examples and tips.
  • Englisch
  • Birmingham
  • |
  • Großbritannien
978-1-78528-403-8 (9781785284038)
1785284037 (1785284037)
weitere Ausgaben werden ermittelt
David Rojas is a data enthusiast and Python evangelist. Currently, he is enjoying his time as a consultant in the data world. He lives in the Silicon Valley and is active within the data community. After receiving a degree from the University of Florida as an industrial and systems engineer and obtaining a minor in sales engineering, he received his state license as an engineer in training. Soon thereafter, he pursued a career change to the IT world as a data analyst and discovered his passion for data using various tools in order to manage and analyze data in a better way. After many years of working in a wide range of odd data roles, such as reporting, gathering requirements, writing documentation, working with databases, and working with flat files, he decided to make his love for data a reality and started his own business ( You will often find his work being cited by various professors and other data enthusiasts around the Bay Area.
  • Cover
  • Copyright
  • Credits
  • About the Author
  • About the Reviewers
  • Table of Contents
  • Preface
  • Chapter 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
  • 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
  • Question - how many applications were processed in the year 2014?
  • 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
  • Declaring variables
  • Conditional statements
  • Loops
  • Creating macros without any code
  • Saving macro-powered spreadsheets
  • Summary
  • Chapter 9: How to Build and Style Your Charts
  • Quick analysis charts
  • Charting options
  • Chart elements
  • Chart styles
  • Chart filters
  • Additional design options
  • Summary
  • Chapter 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
  • Appendix: Tips, Tricks, and Shortcuts
  • Shortcuts
  • Tips and tricks
  • Index

Dateiformat: EPUB
Kopierschutz: Adobe-DRM (Digital Rights Management)


Computer (Windows; MacOS X; Linux): Installieren Sie bereits vor dem Download die kostenlose Software Adobe Digital Editions (siehe E-Book Hilfe).

Tablet/Smartphone (Android; iOS): Installieren Sie bereits vor dem Download die kostenlose App Adobe Digital Editions (siehe E-Book Hilfe).

E-Book-Reader: Bookeen, Kobo, Pocketbook, Sony, Tolino u.v.a.m. (nicht Kindle)

Das Dateiformat EPUB ist sehr gut für Romane und Sachbücher geeignet - also für "fließenden" Text ohne komplexes Layout. Bei E-Readern oder Smartphones passt sich der Zeilen- und Seitenumbruch automatisch den kleinen Displays an. Mit Adobe-DRM wird hier ein "harter" Kopierschutz verwendet. Wenn die notwendigen Voraussetzungen nicht vorliegen, können Sie das E-Book leider nicht öffnen. Daher müssen Sie bereits vor dem Download Ihre Lese-Hardware vorbereiten.

Weitere Informationen finden Sie in unserer E-Book Hilfe.

Download (sofort verfügbar)

32,73 €
inkl. 19% MwSt.
Download / Einzel-Lizenz
ePUB mit Adobe DRM
siehe Systemvoraussetzungen
E-Book bestellen

Unsere Web-Seiten verwenden Cookies. Mit der Nutzung dieser Web-Seiten erklären Sie sich damit einverstanden. Mehr Informationen finden Sie in unserem Datenschutzhinweis. Ok