Udemy - Excel with AI From Zero to Hero in Data Skills

Files:

• Get Bonus Downloads Here.url (0.2 KB)
~Get Your Files Here ! 1 - Introduction
• 1 - Introduction.mp4 (35.3 MB)
• 2 - Getting started on Windows, macOS, Android, and IOS.mp4 (12.5 MB)
• 3 - How to ask great questions.mp4 (14.1 MB)
• 4 - FAQ’s.mp4 (13.7 MB)
10 - Data Cleaning and Text Management in Excel
• 1 - Split Text into columns.mp4 (60.3 MB)
• 2 - Flash Fill.mp4 (64.9 MB)
• 3 - Remove Duplicates.mp4 (74.7 MB)
• 4 - Data Validation.mp4 (46.1 MB)
• 5 - Get- import Data from Text file.mp4 (57.6 MB)
• 6 - Get - import Data from CSV file.mp4 (36.5 MB)
11 - Data Consolidation and PivotTables
• 1 - Creating Pivot Table.mp4 (67.2 MB)
• 2 - Value field settings.mp4 (47.1 MB)
• 3 - Number format.mp4 (29.1 MB)
• 4 - Pivot Table Design.mp4 (39.8 MB)
• 5 - Excel Exercise.mp4 (17.1 MB)
• 6 - Solution for Excel Exercise.mp4 (20.1 MB)
12 - Data Visualization - Excel Charts
• 1 - Excel Chart Basics.mp4 (17.3 MB)
• 2 - Elements of a chart.mp4 (31.6 MB)
• 3 - Easy way to create charts.mp4 (16.3 MB)
• 4 - Column or Bar charts.mp4 (41.1 MB)
• 5 - Formatting charts.mp4 (38.0 MB)
• 6 - Line charts.mp4 (21.4 MB)
• 7 - Area charts.mp4 (20.4 MB)
• 8 - Pie and Doughnut charts.mp4 (37.5 MB)
13 - Pivot Charts
• 1 - Pivot charts.mp4 (22.3 MB)
14 - Maps Chart above 2019
• 1 - Maps chart.mp4 (35.7 MB)
• 2 - 3D Maps chart.mp4 (27.9 MB)
15 - Named Ranges
• 1 - Named ranges.mp4 (38.4 MB)
• 2 - Indirect Name range Function.mp4 (54.1 MB)
16 - Importing Data from PDF & Web Sources in Excel
• 1 - Import Data table from PDF file – Excel 2021.mp4 (37.3 MB)
• 2 - Import Data from Website – Excel 2019 above.mp4 (76.2 MB)
17 - Advanced Excel Techniques on Projects
• 1 - Project Sales forecast tracker.mp4 (72.8 MB)
• 2 - Product Sale Tax invoice Tax Calculations.mp4 (35.0 MB)
2 - Introduction to Generative AI - ChatGPT
• 1 - What is ChatGPT.mp4 (34.8 MB)
• 2 - Generative AI (Gen AI) for Excel Developers.mp4 (33.4 MB)
• 3 - Setting up ChatGPT for prompts.mp4 (27.1 MB)
• 4 - How to use ChatGPT Gen AI.mp4 (34.8 MB)
• 5 - ChatGPT for your day-to-day tasks (Prompting Basics).mp4 (45.7 MB)
3 - Excel Basics – Zero to Foundation
• 1 - Excel + AI course overview.mp4 (35.1 MB)
• 2 - Data Importance in Business Using Excel.mp4 (37.0 MB)
• 3 - Starting Excel Interface.mp4 (37.8 MB)
• 4 - Worksheet basics.mp4 (130.7 MB)
• 5 - Data Entry, values and formulas.mp4 (71.1 MB)
• 6 - Data formats.mp4 (66.8 MB)
• 7 - Data handling basics – cut, copy and paste.mp4 (47.7 MB)
• 8 - Save and print in excel.mp4 (63.4 MB)
• 9 - Excel Ranges.mp4 (31.2 MB)
4 - Learn Excel with ChatGPT AI
• 1 - Benefits of using AI for Excel practice and problem-solving.mp4 (31.6 MB)
• 2 - Setting up Add-on - GPT for Excel Word.mp4 (26.3 MB)
• 3 - Use ChatGPT to learn SUM, AVERAGE.mp4 (34.9 MB)
• 4 - Use ChatGPT to learn COUNT, MAX, MIN.mp4 (47.3 MB)
• 5 - List 10 ways to improve Excel productivity using AI.mp4 (29.1 MB)
5 - Perplexity AI to Learn Excel
• 1 - What is Perplexity AI.mp4 (44.6 MB)
• 2 - AI Search vs Traditional Search (Google vs Perplexity).mp4 (36.9 MB)
• 3 - Creating a Perplexity AI Account and Basic Setup.mp4 (24.8 MB)
• 4 - Exploring the Interface and Dashboard.mp4 (61.8 MB)
• 5 - Real-World Uses of Perplexity AI – day-to-day activities.mp4 (86.0 MB)
6 - Data Analysis using AI
• 1 - Data Analysis Made Easy Using Excel with AI.mp4 (48.6 MB)
• 2 - Data Visualization – chart creation using AI Prompt.mp4 (38.9 MB)
7 - Excel Basic Formulas
• 1 - Basic formula operations.mp4 (40.8 MB)
• 2 - Mathematic formulas1 (SUM, AVERAGE, AVERAGEIF).mp4 (156.3 MB)
• 3 - Mathematic formulas2 (COUNTA, COUNTIF, MOD, ROUND).mp4 (100.2 MB)
• 4 - Text formulas 1 (LEFT, RIGHT, MID, JOIN Cells).mp4 (63.2 MB)
• 5 - Text formulas 2 (REPLACE, LOWER, UPPER, LEN).mp4 (93.3 MB)
• 6 - Logical functions (AND, OR).mp4 (80.9 MB)
• 7 - Date time functions.mp4 (44.8 MB)
8 - Lookup Functions
• 1 - VLOOKUP formula.mp4 (79.9 MB)
• 2 - HLOOKUP formula.mp4 (31.7 MB)
• 3 - HLOOKUP + Match formula.mp4 (64.9 MB)
• 4 - INDEX + MATCH formula.mp4 (41.7 MB)
9 - XLookup only for Excel 2021 and Office 365
• 1 - XLookup - The Next-Gen Excel Lookup Function.mp4 (58.0 MB)
• 2 - Handling #NA and Approximates match in XLookup.mp4 (77.0 MB)
• 3 - Wildcard matching in XLookup.mp4 (47.9 MB)
• Bonus Resources.txt (0.1 KB)