Lezione 1 di 1
Excel Full Course for Data Analysis with Projects [ 2 Hours] | Excel Tutorial 2025
Lezioni1 lezione
Capitoli
- 0:00Excel Introduction
- 1:28Introduction to MS Excel and Beginner's Guide
- 12:01Basic Functions of Excel
- 16:24Basics of Formatting in Excel
- 21:11Sorting Data in Excel - Different Methods to Sort
- 27:57Filtering Data in Excel
- 33:56Basics of Formula/Functions
- 39:22Text Functions in Excel
- 49:43sIf, AND and OR Functions in Excel
- 57:08Date & Time Functions in Excel
- 1:04:01COUNTIF, COUNTIFS, SUMIF, SUMIFS - Functions in Excel
- 1:10:38Data Validation in Excel
- 1:18:42Vlookup in Excel
- 1:28:43Hlookup in Excel
- 1:30:51Lookup in Excel
- 1:37:07Xlookup in Excel
- 1:44:25Index+Match in excel
- 1:49:14Using Conditional Formatting
- 1:56:32Macros in Excel
- 2:01:08Summarizing Data with Pivot Tables
- 2:07:33Working with Slicers
- 2:11:52Power Query in Excel
- 2:21:50Power Pivot in Excel
- 2:33:14Visualizing Data with Charts
- 2:39:31Excel Dashboard