Dive into data analysis with Excel 2019 in this comprehensive tutorial designed for users with basic Excel knowledge. Learn to prepare, format, and analyze data using powerful features like table formatting, conditional functions, charting, and pivot tables. Master techniques for removing duplicates, applying filters, using IF functions, creating sparklines, and customizing pivot tables to draw meaningful insights from your data. Gain hands-on experience with practical exercises and discover how to effectively visualize your findings through various chart types and formatting options. By the end of this 1-hour 32-minute course, you'll be equipped with essential skills to transform raw data into valuable business intelligence using Excel's data analysis tools.
Excel 2019 - Intro to Data Analysis Tutorial
Overview
Syllabus
Start
Introduction
Preparing Data for Tables
Removing Blank Rows and Duplicates
Using Flash Fill to Apply Table Styles
Applying Table Styles
Auto Sorting and Filtering in Tables
Applying a Custom AutoFilter in Excel Tables
Adjusting Table Style Formats and Options
Applying Total Rows
Adding New Data and Turning Off Table Styles
Applying Conditional Formats
Editing and Turning Off Conditional Formats
IF Functions
SUMIF Functions
COUNTIF Functions
AVERAGEIF Functions
Creating Charts
Editing and Reformatting Charts
Creating Sparklines
Creating Win-Loss Sparklines
Creating Pivot Tables Using the Recommended Pivot Tables Button
Creating Pivot Tables from Scratch
Editing Summary Function and Format of Pivot Table Value Fields
Filtering, Sorting, and Editing Pivot Table Fields
Grouping Column Labels in Pivot Tables
Creating Slicers
Refreshing Pivot Table Data
Creating and Updating Pivot Charts
Conclusion
Taught by
Learnit Training
