Excel Training - Excel 2019 Intro to Data Analysis Tutorial

Excel 2019 Intro to Data Analysis Tutorial Get Ad-Free Training by becoming a member today! https://www.youtube.com/channel/UCqyBfm_H9ugGirk1ufYA2YA/join Join Learnit Anytime for ad-free training, exams, certificates, and exclusive content: https://www.learnitanytime.com Exercise Files: https://tinyurl.com/3xunkxwf Who it's for: Excel users needing to analyze, summarize, and visualize their data. Basic knowledge of Excel (familiarity with formulas, cell referencing, simple functions like SUM and AVERAGE) is recommended. What it is: Microsoft Excel is the perfect program for viewing and analyzing data. What you'll learn: Beyond simple averages and totals, Microsoft Excel offers many features to help you draw insights from your data. Sometimes those observations come from a particular formatting or visualization of the data; other times a specific summary function will generate a surprisingly significant result. In this full-length introductory course, learn all about data analytics in Excel with tools like table formatting, conditional functions, charting, pivot tables, and much more. Start 0:00 Introduction 0:03 Preparing Data for Tables 1:22 Removing Blank Rows and Duplicates 3:35 Using Flash Fill to Apply Table Styles 7:52 Applying Table Styles 10:40 Auto Sorting and Filtering in Tables 13:55 Applying a Custom AutoFilter in Excel Tables 18:08 Adjusting Table Style Formats and Options 21:36 Applying Total Rows 24:13 Adding New Data and Turning Off Table Styles 27:04 Applying Conditional Formats 29:53 Editing and Turning Off Conditional Formats 33:38 IF Functions 36:01 SUMIF Functions 40:47 COUNTIF Functions 44:54 AVERAGEIF Functions 48:27 Creating Charts 51:58 Editing and Reformatting Charts 55:54 Creating Sparklines 1:00:20 Creating Win-Loss Sparklines 1:03:25 Creating Pivot Tables Using the Recommended Pivot Tables Button 1:05:19 Creating Pivot Tables from Scratch 1:08:25 Editing Summary Function and Format of Pivot Table Value Fields 1:11:53 Filtering, Sorting, and Editing Pivot Table Fields 1:15:02 Grouping Column Labels in Pivot Tables 1:19:17 Creating Slicers 1:22:09 Refreshing Pivot Table Data 1:24:45 Creating and Updating Pivot Charts 1:26:29 Conclusion 1:31:27 #Excel #Data #Analysis #Microsoft #Training Learnit is no longer associated with this channel/video. (C) 2025 Bomberry Productions Any illegal reproduction of this content will result in immediate legal action.