-
Book Overview & Buying
-
Table Of Contents
Data Analytics in Excel Using Real-World Examples
By :
Data Analytics in Excel Using Real-World Examples
By:
Overview of this book
Embark on a comprehensive journey through Excel with this engaging video course. Discover the fundamental techniques in Navigating Excel, from data types to entering and formatting information. Delve into the world of formulas with Excel Formula Basics and expand your skills by exploring various functions. Master data quality with Introduction to Data Quality, learning to import, clean, and enhance data.
Unlock advanced data manipulation in Sort and Filter Data, Concatenation and SUMIF, and master Pivot Tables for insightful data summarization. Dive into visual storytelling with Creating a Pivot Chart and Working with Excel Charts. Tackle financial analysis, create Waterfall charts, and learn conditional formatting techniques.
Navigate the intricacies of database functions and resolve formula errors with finesse. Unleash the potential of What-If Analysis using the Scenario Manager, Data Tables, and Goal Seek. Harness the Analysis ToolPak for calculating correlations, covariances, and descriptive statistics.
Incorporate moving average and exponential smoothing techniques for precise analyses. Elevate your skills with additional analytical and statistical applications. Through practical examples, this course equips you to tackle real-world business challenges.
Table of Contents (5 chapters)
Course Introduction
Using Excel Spreadsheets for Data Analysis
Cleaning and Managing Data
Analyzing Data
What-If Analysis and Analysis ToolPak