Excel Intro to Data Analysis Tutorial

Excel Intro to Data Analysis Tutorial Get Ad-Free Training by becoming a member today! Join Learnit Anytime for ad-free training, exams, certificates, and exclusive content: Exercise Files: https://tinyurl.com/467h9ar7 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:09 List Design Basics 1:25 Inserting Tables for Analysis 4:59 Filtering Data in Tables 9:57 Using the Total Row 15:10 Conditional Formatting 18:57 IF Function 25:23