Excel Training - Excel 2021 Intro to Data Analysis Tutorial

Excel 2021 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/4kb55kuw 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 Working with Tables 3:51 Conditional Formats 15:46 Using the IF Function 24:33 Database Functions 30:41 Unique, Sort, and Filter Functions 35:27 Charts and Sparklines 38:35 Working with Pivot Tables 47:17 Conclusion 57:50 #excel #exceltutorial #exceltips #dataanalysis #dataanalytics #pivottable 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.