Course overview

Advanced Excel – Data Analysis, Power Query and Pivot Tables

Course content31 lessons
What Is a CSV File and Why It's So Widely Used What Is a CSV File and Why It's So Widely Used Lesson 1 Importing a CSV into Excel with Power Query Importing a CSV into Excel with Power Query Lesson 2 Importing Multiple CSV Files into a Single Table with Power Query Importing Multiple CSV Files into a Single Table with Power Query Lesson 3 Importing Data from Another Excel File with Power Query Importing Data from Another Excel File with Power Query Lesson 4 Importing a Table from a Web Page with Power Query Importing a Table from a Web Page with Power Query Lesson 5 Removing Duplicates Safely and Quickly in Excel Removing Duplicates Safely and Quickly in Excel Lesson 6 Validating Numeric Data in an Excel Table Validating Numeric Data in an Excel Table Lesson 7 Data Validation with a Dropdown List in Excel Data Validation with a Dropdown List in Excel Lesson 8 Custom Validation Rules: Empty Cells, TRIM, and Email Format Custom Validation Rules: Empty Cells, TRIM, and Email Format Lesson 9 Custom Sorting and Qualitative Variables in Excel Custom Sorting and Qualitative Variables in Excel Lesson 10 Excel Tables and Advanced Filters Excel Tables and Advanced Filters Lesson 11 Table Filters and Complex Data Operations in Excel Table Filters and Complex Data Operations in Excel Lesson 12 Advanced Table Filters and Data Operations in Excel (Part 2) Advanced Table Filters and Data Operations in Excel (Part 2) Lesson 13 VLOOKUP, INDEX, and MATCH Functions in Excel VLOOKUP, INDEX, and MATCH Functions in Excel Lesson 14 HLOOKUP and LOOKUP Functions in Excel HLOOKUP and LOOKUP Functions in Excel Lesson 15 Logical Functions: IF and IFERROR Combined with VLOOKUP Logical Functions: IF and IFERROR Combined with VLOOKUP Lesson 16 Logical Functions AND, OR, and IF in Excel (Part 2) Logical Functions AND, OR, and IF in Excel (Part 2) Lesson 17 Aggregation Functions: SUM, SUMIF, and COUNTIF in Excel Aggregation Functions: SUM, SUMIF, and COUNTIF in Excel Lesson 18 Freezing Rows and Columns and Optimizing Table Layout in Excel Freezing Rows and Columns and Optimizing Table Layout in Excel Lesson 19 Excel Outlines: Creating, Removing, and Managing Levels Excel Outlines: Creating, Removing, and Managing Levels Lesson 20 Introduction to Conditional Formatting in Excel Introduction to Conditional Formatting in Excel Lesson 21 Data Bars in Excel Conditional Formatting Data Bars in Excel Conditional Formatting Lesson 22 Custom Rules in Excel Conditional Formatting Custom Rules in Excel Conditional Formatting Lesson 23 Highlighting Rows by Criteria and Finding Duplicates in Excel Highlighting Rows by Criteria and Finding Duplicates in Excel Lesson 24 AutoFill and Smart Series in Excel AutoFill and Smart Series in Excel Lesson 25 Using Cell References in AutoFill: Relative, Absolute, and Mixed Using Cell References in AutoFill: Relative, Absolute, and Mixed Lesson 26 What Are Circular References in Excel and How to Manage Them What Are Circular References in Excel and How to Manage Them Lesson 27 Introduction to PivotTables and Dimension Management in Excel Introduction to PivotTables and Dimension Management in Excel Lesson 28 Complex Aggregations in Excel PivotTables Complex Aggregations in Excel PivotTables Lesson 29 Groupings, Calculated Fields, and Layouts in Excel PivotTables Groupings, Calculated Fields, and Layouts in Excel PivotTables Lesson 30 Introduction to PivotCharts in Excel Introduction to PivotCharts in Excel Lesson 31
Previous
Up next Next
Current lesson | Lesson 2/31

Importing a CSV into Excel with Power Query

Advanced Excel – Data Analysis, Power Query and Pivot Tables 0%
Let's walk through importing a CSV table into Excel with Power Query step by step: I'll show you how to load the file, preview the data, and prepare it for analysis in just a few clicks.
Instructor
G Giovanni Pace
Up next Importing Multiple CSV Files into a Single Table with Power Query