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
Published on 13. January 2025
226 pages
978-1-78528-403-8 (ISBN)
Description
Key Features
Book DescriptionExcel 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.What you will learn
Who this book is for
Book DescriptionExcel 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.What you will learn
Who this book is for
All prices
More details
Edition
Digital original
Language
English
Place of publication
Birmingham
United Kingdom
Target group
US School Grade: College Graduate Student
Edition type
Digital original
File size
4,25 MB
ISBN-13
978-1-78528-403-8 (9781785284038)
Copyright in bibliographic data and cover images is held by Nielsen Book Services Limited or by the publishers or by their respective licensors: all rights reserved.
Schweitzer Classification
Other editions
Additional editions
Book
10/2015
Packt Publishing
€50.50
Shipment within 3-4 weeks
Person
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 (www.hedaro.com). You will often find his work being cited by various professors and other data enthusiasts around the Bay Area.
Content
Table of Contents
Getting Data into Excel
Connecting to Databases
How to Clean Text Numbers and Dates
Using Formulas to Prepare Your Data for Analysis
Analyzing Your Data Using Descriptive Statistics and Charts
Link your Data using Data Models
A Primer on using the Excel Solver
Learning VBA Excels Scripting Language
How to Build and Style your Charts
Creating Interactive Spreadsheets using Tables and Filters
Tips Tricks and Shortcuts
Getting Data into Excel
Connecting to Databases
How to Clean Text Numbers and Dates
Using Formulas to Prepare Your Data for Analysis
Analyzing Your Data Using Descriptive Statistics and Charts
Link your Data using Data Models
A Primer on using the Excel Solver
Learning VBA Excels Scripting Language
How to Build and Style your Charts
Creating Interactive Spreadsheets using Tables and Filters
Tips Tricks and Shortcuts
