Sign In Start Free Trial
Account

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Book Overview & Buying Data Analytics in Excel Using Real-World Examples
  • Table Of Contents Toc
Data Analytics in Excel Using Real-World Examples

Data Analytics in Excel Using Real-World Examples

By : Simon Sez IT
2.5 (4)
close
close
Data Analytics in Excel Using Real-World Examples

Data Analytics in Excel Using Real-World Examples

2.5 (4)
By: Simon Sez IT

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)
close
close
You're currently viewing a free sample. Access the full title and Packt library for free now with a free trial.
Chapter: 2
Using Excel Spreadsheets for Data Analysis
Icon This video is locked
Icon
Icon
0:00
2.0x
1.5x
1.25x
1.0x
0.5x
caption settings
caption off
Icon Icon
ShowHide Transcripts Icon
CONTINUE WATCHING
83
Tech Concepts
36
Programming languages
73
Tech Tools
Icon Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.
Icon Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.
Icon 50+ new titles added per month and exclusive early access to books as they are being written.
Data Analytics in Excel Using Real-World Examples
notes
bookmark Notes and Bookmarks search Search in title playlist Add to playlist download Download options font-size Font size

Change the font size

margin-width Margin width

Change margin width

day-mode Day/Sepia/Night Modes

Change background colour

Close icon Search
Country selected

Close icon Your notes and bookmarks

Confirmation

Modal Close icon
claim successful

Buy this book with your credits?

Modal Close icon
Are you sure you want to buy this book with one of your credits?
Close
YES, BUY

Submit Your Feedback

Modal Close icon
Modal Close icon
Modal Close icon