BOOK DESCRIPTION
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.
WHAT YOU WILL LEARN
WHO THIS BOOK IS FOR
Les mer
Produktdetaljer
ISBN
9781785284038
Publisert
2015
Utgave
1. utgave
Utgiver
Packt Publishing
Språk
Product language
Engelsk
Format
Product format
Digital bok
Forfatter