David Rojas - Data Analysis and Business Modeling with Excel 2013
Here you can read online David Rojas - Data Analysis and Business Modeling with Excel 2013 full text of the book (entire story) in english for free. Download pdf and epub, get meaning, cover and reviews about this ebook. year: 2015, publisher: Packt Publishing, genre: Home and family. Description of the work, (preface) as well as reviews are available. Best literature library LitArk.com created for fans of good reading and offers a wide selection of genres:
Romance novel
Science fiction
Adventure
Detective
Science
History
Home and family
Prose
Art
Politics
Computer
Non-fiction
Religion
Business
Children
Humor
Choose a favorite category and find really read worthwhile books. Enjoy immersion in the world of imagination, feel the emotions of the characters or learn something new for yourself, make an fascinating discovery.
- Book:Data Analysis and Business Modeling with Excel 2013
- Author:
- Publisher:Packt Publishing
- Genre:
- Year:2015
- Rating:5 / 5
- Favourites:Add to favourites
- Your mark:
Data Analysis and Business Modeling with Excel 2013: summary, description and annotation
We offer to read an annotation, description, summary or preface (depends on what the author of the book "Data Analysis and Business Modeling with Excel 2013" wrote himself). If you haven't found the necessary information about the book — write in the comments, we will try to find it.
Manage, analyze, and visualize data with Microsoft Excel 2013 to transform raw data into ready to use informationAbout This Book
- 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 youre 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 Excels powerful built-in tools to get the median, maximum, and minimum values of your data
- Build impressive tables and combine datasets using Excels 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. Youll learn the basics of SQL syntax and how to connect it to a Microsoft SQL Server Database using Excels data connection tools. You will discover how to spot bad data and strategies to clean that data to make it useful to you. Next, youll learn to create custom columns, identify key metrics, and make decisions based on business rules. Youll create macros using VBA and use Excel 2013s shiny new macros. Finally, at the end of the book, youll 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.
David Rojas: author's other books
Who wrote Data Analysis and Business Modeling with Excel 2013? Find out the surname, the name of the author of the book and a list of all author's works by series.