Artículos relacionados a Data Analysis and Business Modeling with Excel 2013
Sinopsis
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.
"Sinopsis" puede pertenecer a otra edición de este libro.
Reseña del editor
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 an experienced user.
Biografía del autor
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.
"Sobre este título" puede pertenecer a otra edición de este libro.
Comprar nuevo
Ver este artículo
EUR 41,91
EUR 5,20 gastos de envío desde Reino Unido a España
Destinos, gastos y plazos de envíoResultados de la búsqueda para Data Analysis and Business Modeling with Excel 2013
Imagen de archivo
Data Analysis and Business Modeling with Excel 2013
Librería: Ria Christie Collections, Uxbridge, Reino Unido
Calificación del vendedor: 5 de 5 estrellas
Condición: New. In. Nº de ref. del artículo: ria9781785289545_new
Cantidad disponible: Más de 20 disponibles
Imagen de archivo
Data Analysis and Business Modeling with Excel 2013
Impresión bajo demandaLibrería: PBShop.store UK, Fairford, GLOS, Reino Unido
Calificación del vendedor: 5 de 5 estrellas
PAP. Condición: New. New Book. Delivered from our UK warehouse in 4 to 14 business days. THIS BOOK IS PRINTED ON DEMAND. Established seller since 2000. Nº de ref. del artículo: L0-9781785289545
Cantidad disponible: Más de 20 disponibles
Imagen de archivo
Data Analysis and Business Modeling with Excel 2013
Impresión bajo demandaLibrería: PBShop.store US, Wood Dale, IL, Estados Unidos de America
Calificación del vendedor: 5 de 5 estrellas
PAP. Condición: New. New Book. Shipped from UK. THIS BOOK IS PRINTED ON DEMAND. Established seller since 2000. Nº de ref. del artículo: L0-9781785289545
Cantidad disponible: Más de 20 disponibles
Imagen de archivo
Data Analysis and Business Modeling with Excel 2013
Librería: California Books, Miami, FL, Estados Unidos de America
Calificación del vendedor: 5 de 5 estrellas
Condición: New. Nº de ref. del artículo: I-9781785289545
Cantidad disponible: Más de 20 disponibles
Imagen del vendedor
Data Analysis and Business Modeling with Excel 2013
Publicado por
Packt Publishing Limited, GB, 2023
ISBN 10: 1785289543
ISBN 13: 9781785289545
Nuevo
Digital
Librería: Rarewaves.com UK, London, Reino Unido
Calificación del vendedor: 5 de 5 estrellas
Digital. Condición: New. Manage, analyze, and visualize data with Microsoft Excel 2013 to transform raw data into ready to use informationAbout 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 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 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 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. Nº de ref. del artículo: LU-9781785289545
Cantidad disponible: Más de 20 disponibles
Imagen del vendedor
Data Analysis and Business Modeling with Excel 2013
Publicado por
Packt Publishing Limited, GB, 2023
ISBN 10: 1785289543
ISBN 13: 9781785289545
Nuevo
Digital
Librería: Rarewaves.com USA, London, LONDO, Reino Unido
Calificación del vendedor: 5 de 5 estrellas
Digital. Condición: New. Manage, analyze, and visualize data with Microsoft Excel 2013 to transform raw data into ready to use informationAbout 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 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 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 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. Nº de ref. del artículo: LU-9781785289545
Cantidad disponible: Más de 20 disponibles
Imagen de archivo
Data Analysis and Business Modeling with Excel 2013
Publicado por
Packt Publishing Limited, 2015
ISBN 10: 1785289543
ISBN 13: 9781785289545
Nuevo
Paperback / softback
Librería: THE SAINT BOOKSTORE, Southport, Reino Unido
Calificación del vendedor: 5 de 5 estrellas
Paperback / softback. Condición: New. This item is printed on demand. New copy - Usually dispatched within 5-9 working days 526. Nº de ref. del artículo: C9781785289545
Cantidad disponible: Más de 20 disponibles
Imagen de archivo
Data Analysis and Business Modeling with Excel 2013
Publicado por
Packt Publishing 2015-10-27, 2015
ISBN 10: 1785289543
ISBN 13: 9781785289545
Nuevo
Paperback
Librería: Chiron Media, Wallingford, Reino Unido
Calificación del vendedor: 4 de 5 estrellas
Paperback. Condición: New. Nº de ref. del artículo: 6666-IUK-9781785289545
Cantidad disponible: 10 disponibles
Imagen de archivo
Data Analysis and Business Modeling with Excel 2013
Impresión bajo demandaLibrería: Majestic Books, Hounslow, Reino Unido
Calificación del vendedor: 5 de 5 estrellas
Condición: New. Print on Demand pp. 226. Nº de ref. del artículo: 373159588
Cantidad disponible: 4 disponibles
Imagen de archivo
Data Analysis and Business Modeling with Excel 2013
Librería: Books Puddle, New York, NY, Estados Unidos de America
Calificación del vendedor: 4 de 5 estrellas
Condición: New. pp. 226. Nº de ref. del artículo: 26373967227
Cantidad disponible: 4 disponibles