PERHAPS A GIFT VOUCHER FOR MUM?: MOTHER'S DAY

Close Notification

Your cart does not contain any items

Excel for Data Insights

Am�rico Moreira

$28.95   $26.45

Paperback

Not in-store but you can order this
How long will it take?

QTY:

English
Americo Moreira
30 November 2023
"Excel for Data Insights is a comprehensive guide that explores the world of Business Intelligence and data analysis using Excel. This book covers everything from importing and cleansing data to creating interactive dashboards and visualizations. Whether you are a beginner or an experienced Excel user, this book will equip you with the skills and knowledge needed to effectively analyze and visualize data.

In the first few chapters, you will learn the basics of Excel as a tool for data insights, including setting up Excel for data analysis and navigating the Excel interface. The book then dives into data import and cleansing techniques, teaching you how to import data into Excel, clean and transform data, and handle errors and missing data.

The book also covers advanced data analysis techniques, such as using formulas and functions for analysis, performing statistical analysis, and utilizing Solver for optimization. Additionally, you will learn about data modeling and Power Query, creating relationships between tables, and combining data from multiple sources.

With a focus on data visualization, the book explores creating advanced charts and graphs, using sparklines and data bars, customizing chart elements, and visualizing geographic data. It also delves into PivotTables and Power Pivot for advanced data analysis, as well as Power View and Power Map for interactive data visualization.

Furthermore, the book covers topics like data analysis with Excel Solver, Excel macros for automating data analysis tasks, and using Excel add-ins for statistical analysis and data transformation. It concludes with best practices for data visualization, including choosing the right chart for your data, designing effective dashboards and reports, and presenting data insights effectively.

Whether you are a business professional, analyst, or student, ""Excel for Data Insights"" is your ultimate guide to harnessing the power of Excel for Business Intelligence and data analysis."

By:  
Imprint:   Americo Moreira
Dimensions:   Height: 216mm,  Width: 140mm,  Spine: 13mm
Weight:   281g
ISBN:   9798223336402
Pages:   218
Publication Date:  
Audience:   General/trade ,  ELT Advanced
Format:   Paperback
Publisher's Status:   Active

See Also