מה צריך לדעת לפני
שתתחיל
מתחיל 4 June 2026 17:22
נגמר 4 June 2026
00
ימים
00
שעות
00
דקות
00
שניות
12 minutes
שדרוג אופציונלי זמין
Not Specified
התקדמות בקצב שלך
Free Video
שדרוג אופציונלי זמין
סקירה כללית
סילבוס
- Introduction to Power Query
- Importing Data into Power Query
- Working with Imported Data
- Basic Data Cleaning Techniques
- Basic Data Transformation Techniques
- Conclusion and Practical Tips
- Hands-On Practice
- Course Review and Next Steps
Overview of Power Query and its applications
Navigating the Power Query interface
Importing data from Excel files
Importing data from CSV files
Connecting to databases
Importing data from web pages
Understanding the Query Editor
Exploring data preview and navigation
Removing unwanted columns and rows
Filtering data
Handling nulls and errors
Renaming columns
Changing data types
Splitting and merging columns
Tips for efficient data import and processing
Common pitfalls and solutions in data handling
Guided exercises with sample datasets
Real-world scenario application for practice
Summarizing key takeaways
Resources for further learning
נושאים
Business