- 56
- 98 881
ِAAA Excel English
เข้าร่วมเมื่อ 22 ต.ค. 2021
This is my new English dedicated channel; I have been posting Excel and Power BI videos for more than 4 years in both Arabic and English languages, now I decided to separate my English content from my Arabic content, please subscribe and stay tuned for high quality content about Power Query, Power Pivot, Power BI, Dynamic Array and much more
PQB04 | Extract data from a folder | “CSV files” | Automatically update new data | PowerQueryBasics
#excel #powerquery
--------------------------------------------------------------------
Visit the website for more content: www.aaa-power.net
--------------------------------------------------------------------
0:00 Intro
1:28 Example explained
2:41 Extract data from a folder
4:36 Use sheet name as an input
6:06 Csv.Document
8:32 Transform data
10:46 Create a date column
12:52 Load data a pivot table
14:43 Add new data & auto update the report
---------------------------------------------------------------------
Excel Data Analysis Series: PQB “Power Query Basics”
PQB04: Extract data from folders “CSV files”
Extract data from a folder containing “CSV” files
Split columns by position
Use Csv.Document formula
Create date column considering your locale (regional settings)
Use file name as a new column in the query
Merge 3 columns to create new full date column
Load query to a pivot table and create sales report
Report will be updating automatically once you add new files to the folder
--------------------------------------------------------------------
To Download the excel files:
drive.google.com/open?id=1a9ZYOUh9XDUjdJ6wjdKht75wYjVXMuEv
CSV files:
drive.google.com/drive/folders/1emXHiHjwcPeuGZAFflV9YkyjQahuokpd?usp=drive_link
--------------------------------------------------------------------
To view the full play list
th-cam.com/play/PLX4tbThHdEDeZtxaFwIBbxHCtvrC14SXu.html
--------------------------------------------------------------------
To subscribe:
th-cam.com/channels/AxOgfPN8XqlB-lGmORVB5g.html
---------------------------------------------------------------------
To follow on Facebook:
excelispower
---------------------------------------------------------------------
To follow on LinkedIn:
www.linkedin.com/in/amratef
--------------------------------------------------------------------
Visit the website for more content: www.aaa-power.net
--------------------------------------------------------------------
0:00 Intro
1:28 Example explained
2:41 Extract data from a folder
4:36 Use sheet name as an input
6:06 Csv.Document
8:32 Transform data
10:46 Create a date column
12:52 Load data a pivot table
14:43 Add new data & auto update the report
---------------------------------------------------------------------
Excel Data Analysis Series: PQB “Power Query Basics”
PQB04: Extract data from folders “CSV files”
Extract data from a folder containing “CSV” files
Split columns by position
Use Csv.Document formula
Create date column considering your locale (regional settings)
Use file name as a new column in the query
Merge 3 columns to create new full date column
Load query to a pivot table and create sales report
Report will be updating automatically once you add new files to the folder
--------------------------------------------------------------------
To Download the excel files:
drive.google.com/open?id=1a9ZYOUh9XDUjdJ6wjdKht75wYjVXMuEv
CSV files:
drive.google.com/drive/folders/1emXHiHjwcPeuGZAFflV9YkyjQahuokpd?usp=drive_link
--------------------------------------------------------------------
To view the full play list
th-cam.com/play/PLX4tbThHdEDeZtxaFwIBbxHCtvrC14SXu.html
--------------------------------------------------------------------
To subscribe:
th-cam.com/channels/AxOgfPN8XqlB-lGmORVB5g.html
---------------------------------------------------------------------
To follow on Facebook:
excelispower
---------------------------------------------------------------------
To follow on LinkedIn:
www.linkedin.com/in/amratef
มุมมอง: 261
วีดีโอ
PQB03 | Consolidate budget from multiple worksheets in 1 report | PQB | Power Query Basics
มุมมอง 36621 วันที่ผ่านมา
#excel #powerquery Visit the website for more content: www.aaa-power.net 0:00 Intro 1:03 Example explained 1:41 Consolidate multiple excel sheet from another workbook 7:09 Unpivot columns 9:45 Load query to a pivot table 10:50 Add new data & auto update query Excel Data Analysis Series: PQB “Power Query Basics” PQB03: Consolidate Budgets from multiple worksheets using Power Query Consolidate bu...
PQB02 | Extract data from current workbook, and create a dynamic unique list | PQB
มุมมอง 602หลายเดือนก่อน
#excel #powerquery Visit the website for more content: www.aaa-power.net 0:00 Intro 1:07 Example explained 2:37 Extract data from a named range 7:04 Extract data from an unnamed range 7:52 Extract data from an excel table 10:50 Add new data & auto update query Excel Data Analysis Series: PQB: Power Query Basics PQB02: Extract data from the same workbook Three ways with three examples: 1- From a...
PQB00 | Power Query Basics Series Content | PQB
มุมมอง 373หลายเดือนก่อน
#excel #powerquery Visit the website for more content: www.aaa-power.net Excel Data Analysis Series: PQB: Power Query Basics Pqb00: Series structure & topics Series structure & TOPICS - Introduction: Why Power Query? Where can we find it? How PQ Editor works? - Data Sources: will focus on: 1) Excel: same & other Workbooks 2) CSV/Text files - Load DATA to: Tables & Sheets, Pivot Tables & Charts,...
PT00: Excel Data Analysis Series PT (Pivot Table) - Intro Video
มุมมอง 130หลายเดือนก่อน
#excel #pivottables Visit the website for more content: www.aaa-power.net Excel Data Analysis: PT (Pivot Tables) Series PT 01: Create, Layout & Design PT 02: Refresh & Update PT 03: Group Data: Dates, Numbers & Text Fields PT 04: Calculated Fields and Items (Formulas inside Pivot Tables) PT 05: Auto Generate Multiple Reports (Using Filter Options) PT 06: Present & Visualize: Custom styles, Show...
PQB01| Introduction to Power Query | PQB: Power Query Basics | Excel Data Analysis Series
มุมมอง 373หลายเดือนก่อน
#excel #powerquery Visit the website for more content: www.aaa-power.net 0:00 Intro 0:32 Why power Query? 2:02 Where can we find Power Query in excel? 2:49 How Power Query editor works? 3:19 Example & Power Query Editor tour 7:57 Transform data using Power Query 10:37 Load data and create report 12:05 Add new data & automatically refresh your report 1-Why Power Query? (Extract data from anywher...
PT10: Pivot Tables & Power Pivot - Relations between tables, DAX functions & measures (SUMX)
มุมมอง 318หลายเดือนก่อน
#excel #pivottables Visit the website for more content: www.aaa-power.net 0:00 Intro 1:04 Relations between table 3:49 Pivot table based on data model 5:11 Measure & Dax functions (SUMX) 8:35 Reuse measures 9:32 Close To Download the excel file: drive.google.com/open?id=1A1qbuinCutCfT8dyNBwt62SxZZlDKckS To view the full play list th-cam.com/play/PLX4tbThHdEDdf8SU9fMntLsfGRxbAznR5.html To subscr...
PT09: Pivot Tables based on Power Query - work with 3m+ records in excel
มุมมอง 776หลายเดือนก่อน
#excel #pivottables Visit the website for more content: www.aaa-power.net 0:00 Intro 1:28 Check row data file size 2: 06 Import data from CSV file using Power Query 6:15 Load 3 million rows to a pivot table 8:17 Lookup data using Power Query To Download the excel file: drive.google.com/open?id=1ZFLmnujAV8vqFJWnSQG9NY_bdWG97Te4 To view the full play list th-cam.com/play/PLX4tbThHdEDdf8SU9fMntLsf...
PT08: Pivot Chart, Slicer & Timeline (Pivot Tables Presentation & Visualization)
มุมมอง 4772 หลายเดือนก่อน
#excel #pivottables Visit the website for more content: www.aaa-power.net Content: 0:00 Intro 2:07 Create & Format a Pivot Chart from a pivot table 6:11 Directly create a Pivot Chart & use Chart Template 10:54 Slicers and Timeline 15:38 Interactive DASHBOARDS (Build, Organize & Format) To Download the excel file: drive.google.com/open?id=1vJez3MVN1mNjl72wOxxABqXW7VL3EzQx To view the full play l...
PT07: Excel Pivot Tables-7 Power Features you must know about Pivot Tables
มุมมอง 8933 หลายเดือนก่อน
#excel #pivottables Visit the website for more content: www.aaa-power.net Content: 0:00 Intro 1:27 Double Click on a value 2:23 Filter Pivot Tables 10:55 Sort Labels & Values 16:26 Filed List Sort & Search 17:43 Auto Fit Column Width 19:06 Show/hide Labels 20:55 Custom Styles To download the excel file: drive.google.com/open?id=1ic6YDrUe0g1NJis49HrCVku8mcB5UZfy To view the full play list th-cam...
PT06.2 | Excel Pivot Tables | Show Value AS | 5 essential features
มุมมอง 4143 หลายเดือนก่อน
#excel #pivottables Visit the website for more content: www.aaa-power.net Content: 0:00 Intro 0:56 Show value as "Running Total" 4:15 Show value as "% of" 8:56 Show value as "% of Totals & Parents" 10:21 Show value as "Difference from & Difference % from" 12:17 Show value as "Rank" To download the excel file: drive.google.com/open?id=1iH6lwnhyhyCZF1zRzOxIV-YvC-MxUjIk To watch Video PT04: th-cam...
PT06.1| Excel Pivot Tables | Generate “GetPivotData” Function
มุมมอง 4523 หลายเดือนก่อน
#excel #pivottables Visit the website for more content: www.aaa-power.net Content: 0:00 Intro 1:09 Formulas outside pivot tables 3:06 Generate “GetPivotData” Function 4:38 Understand & Manipulate "GetPivotData" Excel Data Analysis Series: PT- Pivot Tables Calculations Outside Pivot Table - A Complement to Video PT04 - Activate “Get Pivot Table” Formula - How GetPivotData formula works - Copy & ...
PT05: Pivot Tables | generate hundreds of reports with 1 click | Report Filter Pages
มุมมอง 3494 หลายเดือนก่อน
#excel #pivottables Visit the website for more content: www.aaa-power.net Content: 0:00 Intro 1:25 Accounts Receivable template 5:20 Customer Statement using Pivot Tables 8:18 tens of reports with one click 11:27 Update all reports instantly with new data Refreshable Accounts Receivable System Using : Formulas & Pivot Tables Best practical example for Accountants, specially who is working on Ac...
PT04: Excel Pivot Tables | Calculated Fields & Items | formulas inside the Pivot Table
มุมมอง 6114 หลายเดือนก่อน
#excel #pivottables Visit the website for more content: www.aaa-power.net Content: 0:00 Intro 0:58 Calculated Fields 10:42 Calculated Items To download the excel file: drive.google.com/open?id=1fzTsHyr-ujLy8nKCFZfIqhoLzI42PHAa To subscribe: th-cam.com/channels/AxOgfPN8XqlB-lGmORVB5g.html To follow on Facebook: excelispower To follow on LinkedIn: www.linkedin.com/in/amratef
PT03.3 | Grouping of text fields | Categorize Data & Minimize File Size | Excel Pivot Tables
มุมมอง 5575 หลายเดือนก่อน
#excel #pivottables Visit the website for more content: www.aaa-power.net Content: 0:00 Intro 0:58 Use of Helper Columns 3:03 Categorize Using Pivot Tables 7:43 Close To Download the excel files: 1) Grouping using Pivot Tables: drive.google.com/open?id=1XNFSaDQ6ABmIHHLK1Jszv7oRjHRuu9WP 2) Grouping using helper columns: drive.google.com/open?id=1bjCAPj43zTzydl5RqpDzRVcYA8VD6DZt To subscribe: th-...
Power BI (DAX) | Calendar Year vs Fiscal Year | FISCAL Date Table
มุมมอง 5605 หลายเดือนก่อน
Power BI (DAX) | Calendar Year vs Fiscal Year | FISCAL Date Table
PT03.2| Group Numeric Value | Sales Brackets&Performance Evaluation | Excel Pivot Tables
มุมมอง 4715 หลายเดือนก่อน
PT03.2| Group Numeric Value | Sales Brackets&Performance Evaluation | Excel Pivot Tables
APQ16 | High speed Data Refresh | Table.Buffer | Advanced Power Query
มุมมอง 6K5 หลายเดือนก่อน
APQ16 | High speed Data Refresh | Table.Buffer | Advanced Power Query
PT03.1| Grouping of Dates | weekly, monthly & quarterly reports | Excel Pivot Tables
มุมมอง 6135 หลายเดือนก่อน
PT03.1| Grouping of Dates | weekly, monthly & quarterly reports | Excel Pivot Tables
APQ15 | How "each" & "_" work? | Advanced Power Query
มุมมอง 6K6 หลายเดือนก่อน
APQ15 | How "each" & "_" work? | Advanced Power Query
PT02: Pivot Tables | Refresh & Update New Data | Excel
มุมมอง 3656 หลายเดือนก่อน
PT02: Pivot Tables | Refresh & Update New Data | Excel
APQ14 | The easiest way to master “M” functions | Advanced Power Query
มุมมอง 3.1K6 หลายเดือนก่อน
APQ14 | The easiest way to master “M” functions | Advanced Power Query
PT01| Pivot Tables Basics | Excel | Create, Design & Layout
มุมมอง 4906 หลายเดือนก่อน
PT01| Pivot Tables Basics | Excel | Create, Design & Layout
Stop 🛑using PIVOT TABLES Immediately | GROUPBY & PIVOTBY | Excel Worksheet Functions
มุมมอง 7086 หลายเดือนก่อน
Stop 🛑using PIVOT TABLES Immediately | GROUPBY & PIVOTBY | Excel Worksheet Functions
PivotTables to Replace VLOOKUP | PowerPivot & Data Model | Relations & DAX Measures
มุมมอง 4256 หลายเดือนก่อน
PivotTables to Replace VLOOKUP | PowerPivot & Data Model | Relations & DAX Measures
APQ13 | M-Code Functions | List.Split | List.Zip | Advanced Power Query
มุมมอง 3.7K7 หลายเดือนก่อน
APQ13 | M-Code Functions | List.Split | List.Zip | Advanced Power Query
Waterfall chart 📊 (bridge) made easy with excel 365
มุมมอง 4537 หลายเดือนก่อน
Waterfall chart 📊 (bridge) made easy with excel 365
Power Pivot (Part II) | Create calculation (MEASURE) inside Pivot Tables | DAX-SUM function
มุมมอง 4667 หลายเดือนก่อน
Power Pivot (Part II) | Create calculation (MEASURE) inside Pivot Tables | DAX-SUM function
Excel Functions | FILTER & XLOOKUP For Approximate Match | Search Price & Discount in Changing Lists
มุมมอง 4517 หลายเดือนก่อน
Excel Functions | FILTER & XLOOKUP For Approximate Match | Search Price & Discount in Changing Lists
Power Pivot | Create a Pivot Table from multiple tables | Actual vs Budget | One to Many Relations
มุมมอง 1.2K7 หลายเดือนก่อน
Power Pivot | Create a Pivot Table from multiple tables | Actual vs Budget | One to Many Relations
Very clear explanation and you really bring great changes in many of our career, Thank you very much.
Many many thanks to you for the effort of making things clear and even adding files to practice
ممتاز استاذ عمرو،🌹🌹🌹ياريت مواضيع جديده علي سلسله الكويري و البيفوت بس بالعربي،🌹🌹🌹بالتوفيق دائما 😊😊
very nice explanation. and i also like your little little mcode teaching in between your video like renaming column inside M in this video
The concept is explained in clear and simple language that anyone can easily understand. Thank you for providing this valuable tool for data analysis in our office. It will be beneficial for our work.
Once again thanks
الله يباركلك
its been a long time good to see a new vid in the series welcome back Amr!
Excellent series. Extremely informative and resourceful.
Great video, but you forgot to change the formatting for the Sales column on the last table. Thanks!
You are absolutely right! It's important to ensure the correct formatting is applied, unfortunately I discovered that after posting the video, thank you 🙏
Sir i really didn't know how to thank you,becoz you are serving without any penny, may pray you and your family for presperiou healty and wealthy Sir i request you plz keep it up Grate 💕 form the land of pakistan for our brother Thanks
Thank you so much, prayers and Doua are the best things to receive from brothers in Pakistan. May Allah bless you and be with you all the way
Awesome tutorial, compreehensivel, concise and crystal clear. You have nailed the concept. I had to play the tutorial many times for days and practice to get the hang of it. Well done, Sir. You are truly M Code Legend and you absolutely master the state of art in teaching. I salute you. Keep it up.
The download points to PT10Pivottabel&DataModelStart.xlsx. I have the file needed since September 5th - PQB01.xlsx which has the data in this lesson.
Ma Sha ALLAH, keep going
Jazak Allah khairan 🙏
🎉🎉💪👏👏👏
🙏🙏
رائع كالعاده
Thank you 🙏
This case was really awesome!... as a pricing consultant, i loved!
Excellent! Happy you found it useful!
The beauty is in the simplicity!. Thank you. Maybe in future video videos you can include kpi’s Excel feature.
Thank you for your comment, will definitely consider
Very good Mr.Amr🌹🌹🌹🌹
I appreciate the kind words!
Sensational, Split the list, Zip it and then get into the table.
Excellent! Happy that you found it helpful!
Bravo
Thank you 🙏
Well Explained
Happy that you found it useful.
Thank you 😊
Awesome tutorial, concise and crystal clear. Thank you for sharing. Do you have a tutorial on advanced group by?
This helped a lot! Thank you! :)
Happy to hear that, most welcome
Amazing Information
Happy that you found it helpful 😊
Hi. Also put target table and explain thank you
Great suggestion! I'll keep that in mind for future videos.
Excellent. Masterpiece
Thank you 😊
Thanks❤
Most welcome 🙏
Super video . explained powrr querry in a very short time...thanks 🙏
Happy that you found it useful
Thank you
Most welcome 🙏
Very well explained. Thank you
You’re welcome
hi i seems not to get the way you set up the date in the budget table
Very clear. Straight to the point. You deserve more subscribers, and we deserve more videos from your channel.
Thank you so much 🙏
Amazing explanation!
Thank you 🙏
Excellent communication and good examples
Happy that you found it useful
Great video!
Thank you 🙏
Thank you for your excellent course
Most welcome 🙏
This is absolutely EPIC. Records has taken the merge to a new level! Please make a video where the price is retreived correctly after the date of change. Meaning, look at my transaction date and fetch the price on or after that date from the price list
I would like to see that too. Please make such a video! :)
@@juja2819 I took up that challenge and made that one myself !
Happy that you found it useful, if I am not mistaken, this video will answer your question APQ12 | Exact & Approximate Match | Lookup changing Prices & Discount | Advanced Power Query th-cam.com/video/rQZBORgxg14/w-d-xo.html
Explained beautifully... Easy to understand. Thanks
Happy that you found it useful, most welcome 🙏
Great video!
Thank you 🙏
In a folder I've so many Excel files and want to load into power query in one go as different data like Sales, Payroll, Attandance, Returns, Product etc. here I just want to load and I don't want to combine it. Thanks a lot AAA EXCEL English!!😮😮😊😊
great job 😍
Thank you! 😊
Go to the 4:50 minute Mark to review the Table Buffer. You Are Welcome😊
Love uou sir love alot from pakistan
look forward your next video, it's awesome
Thank you.. soon 👍
You have really made outstanding lectures...much obliged sir❤ I have watched your all videos and it's really very much helpful. Please provide power pivot more advanced lectures ❤
I appreciate the kind words, I'm glad you're finding the videos helpful! 😊 I'm always working on new Power Pivot content, stay tuned!
Dear, Sir your Every video fantastic helping me
Thank you i
Thanks a ton for this Power Pivot Series!! Very Helpful and easily explained with perfect examples.
Happy that you found it helpful, thank you 🙏
We are a great teacher Amr - Gazak Allah Khier
Thank you, w gazak kheir
hi how to calculate the ageing eg-0-07-,7-14 & so on ,pls help