Data Analytics in Excel Using Real-World Examples: Explore the key features of Microsoft Excel that make it such an essential tool for data analytics

Simon Sez IT

$131.99

2.5 (4 Ratings)

Video Sep 2023 4hrs 15mins 1st Edition

Simon Sez IT

$131.99

2.5 (4 Ratings)

Video Sep 2023 4hrs 15mins 1st Edition

What do you get with a video?

Download this video in MP4 format

Access this title in our online reader with advanced features

DRM FREE - Read whenever, wherever and however you want

View table of contents

Download Code

Key benefits

Describe the fundamentals of Excel spreadsheets, from their layout to the applications
Understand the What-If Analysis toolkit, which includes the Scenario Manager, Goal Seek, and Data Table functions
Use the Analysis ToolPak to calculate statistical concepts such as correlation and covariance

Description

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.

Who is this book for?

This course is designed for a diverse audience of professionals, including business analysts, data enthusiasts, and individuals seeking to strengthen their data analytics skills. It’s a valuable resource for students pursuing careers in data science, business intelligence, or related fields. If you are eager to harness the power of Microsoft Excel for data manipulation and analysis, this course provides essential insights and techniques.

What you will learn

Learn to view, enter, and format data types in Excel
Understand and apply Excel formulas and functions
Learn to sort data and apply filters, including advanced filtering techniques
Work with Excel charts, including clustered columns, line graphs, and waterfalls
Apply techniques to recognize and avoid formula errors
Create problem statements to tackle complicated “or” criteria

What do you get with a video?