- Видео 49
- Просмотров 87 477
ِ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
PT09: Pivot Tables based on Power Query - work with 3m+ records in excel
#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
ruclips.net/p/PLX4tbThHdEDdf8SU9fMntLsfGRxbAznR5
------------------------------...
--------------------------------------------------------------------
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
ruclips.net/p/PLX4tbThHdEDdf8SU9fMntLsfGRxbAznR5
------------------------------...
Просмотров: 654
Видео
PT08: Pivot Chart, Slicer & Timeline (Pivot Tables Presentation & Visualization)
Просмотров 427Месяц назад
#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
Просмотров 846Месяц назад
#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 ruclip...
PT06.2 | Excel Pivot Tables | Show Value AS | 5 essential features
Просмотров 375Месяц назад
#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: ruclip...
PT06.1| Excel Pivot Tables | Generate “GetPivotData” Function
Просмотров 418Месяц назад
#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
Просмотров 3162 месяца назад
#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
Просмотров 5633 месяца назад
#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: ruclips.net/channel/UCAxOgfPN8XqlB-lGmORVB5g 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
Просмотров 5153 месяца назад
#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: ruc...
Power BI (DAX) | Calendar Year vs Fiscal Year | FISCAL Date Table
Просмотров 4563 месяца назад
Visit my website: aaa-power.net Content: 0:00 intro 0:54 Example 3:46 CALENDARAUTO to Create a Date Table 5:40 Specify Fiscal year end 7:03 Month Name, Calendar & Fiscal Month # 11:36 Calendar & Fiscal Quarter # 14:59 Calendar & Fiscal Year # 20:19 Integrate the Date Table 22:07 Report according to Calendar & Fiscal years 24:30 Close To download the working files: drive.google.com/drive/folders...
PT03.2| Group Numeric Value | Sales Brackets&Performance Evaluation | Excel Pivot Tables
Просмотров 4323 месяца назад
#excel #pivottables Visit the website for more content: www.aaa-power.net Content: 0:00 Intro 0:54 Report sales buckets 5:58 Evaluate performance To download the excel files: drive.google.com/open?id=13fNKuxCX412UppBvrsSFxLOKgPUM6fJP To subscribe: ruclips.net/channel/UCAxOgfPN8XqlB-lGmORVB5g To follow on Facebook: excelispower To follow on LinkedIn: www.linkedin.com/in/amratef
APQ16 | High speed Data Refresh | Table.Buffer | Advanced Power Query
Просмотров 4,3 тыс.4 месяца назад
#excel #exceltutorial #powerquery #m_code Visit the website: www.aaa-power.net Chapters: 0:00 Intro 0:39Running Total | List.Sum / List.FirstN 4:35 Refresh before using Table.Buffer 5:42 Refresh after using Table.Buffer 7:15 Close To watch the full Playlist ruclips.net/p/PL5NlUYOM2iOjRsboi_z9cHTyM7yqwWu58 To download working files: drive.google.com/drive/folders/1uL_6LqPZPSWAgA60h5x-bjYs_urfK07...
PT03.1| Grouping of Dates | weekly, monthly & quarterly reports | Excel Pivot Tables
Просмотров 5224 месяца назад
#excel #pivottables Visit the website for more content: www.aaa-power.net Content: 0:00 Intro 0:37 Group dates by month and quarter 4:32 Independently group 2 pivot tables 6:06 Group dates by number of days To download the excel files: drive.google.com/open?id=13kn5EokFbF5ijY9FxYZXmVq-iC-vuTds To subscribe: ruclips.net/channel/UCAxOgfPN8XqlB-lGmORVB5g To follow on Facebook: excelis...
APQ15 | How "each" & "_" work? | Advanced Power Query
Просмотров 4,6 тыс.4 месяца назад
#excel #exceltutorial #powerquery #m_code Visit the website: www.aaa-power.net Chapters: 0:00 Intro 1:01 Shorthand for a custom function & an item in a list 5:42 Record in a table 9:19 Based on context 15:14 Table in a group of tables 18:15 With group by (Table.Group) 22:35 Close To watch the full Playlist ruclips.net/p/PL5NlUYOM2iOjRsboi_z9cHTyM7yqwWu58 drive.google.com/drive/folders/1sf5A-byc...
PT02: Pivot Tables | Refresh & Update New Data | Excel
Просмотров 3364 месяца назад
#excel #pivottables Visit the website for more content: www.aaa-power.net Content: 0:00 Intro 0:50 Change values inside Pivot Table data set 3:58 Copy and change Pivot Tables design 4:51 Add column/change column name in a Pivot Tables 7:29 Use named ranges with Pivot Tables 10:23 Use excel tables with Pivot Tables To download the excel files: drive.google.com/open?id=1XskUKxBl9XrF02En4PoN1Ckarc...
APQ14 | The easiest way to master “M” functions | Advanced Power Query
Просмотров 2,6 тыс.4 месяца назад
#excel #exceltutorial #powerquery #m_code Visit the website: www.aaa-power.net Chapters: 0:00 Intro 0:58 Example Overview 2:17 M Language Part I: Date & Text Functions 11:14 M Language Part II: Table Functions 19:5 Close To watch the full Playlist ruclips.net/p/PL5NlUYOM2iOjRsboi_z9cHTyM7yqwWu58 To download the working files: drive.google.com/drive/folders/1nyZKbDPZJLXqhtqQ7GCxHaNFLmXoDgS1?usp=...
PT01| Pivot Tables Basics | Excel | Create, Design & Layout
Просмотров 4284 месяца назад
PT01| Pivot Tables Basics | Excel | Create, Design & Layout
Stop 🛑using PIVOT TABLES Immediately | GROUPBY & PIVOTBY | Excel Worksheet Functions
Просмотров 6585 месяцев назад
Stop 🛑using PIVOT TABLES Immediately | GROUPBY & PIVOTBY | Excel Worksheet Functions
PivotTables to Replace VLOOKUP | PowerPivot & Data Model | Relations & DAX Measures
Просмотров 4215 месяцев назад
PivotTables to Replace VLOOKUP | PowerPivot & Data Model | Relations & DAX Measures
APQ13 | M-Code Functions | List.Split | List.Zip | Advanced Power Query
Просмотров 3,1 тыс.5 месяцев назад
APQ13 | M-Code Functions | List.Split | List.Zip | Advanced Power Query
Waterfall chart 📊 (bridge) made easy with excel 365
Просмотров 3165 месяцев назад
Waterfall chart 📊 (bridge) made easy with excel 365
Power Pivot (Part II) | Create calculation (MEASURE) inside Pivot Tables | DAX-SUM function
Просмотров 3975 месяцев назад
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
Просмотров 4305 месяцев назад
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,1 тыс.5 месяцев назад
Power Pivot | Create a Pivot Table from multiple tables | Actual vs Budget | One to Many Relations
APQ12 | Exact & Approximate Match | Lookup changing Prices & Discount | Advanced Power Query
Просмотров 2,4 тыс.6 месяцев назад
APQ12 | Exact & Approximate Match | Lookup changing Prices & Discount | Advanced Power Query
PT08: PivotTables Present & Visualize | Part IV: Dashboards
Просмотров 3476 месяцев назад
PT08: PivotTables Present & Visualize | Part IV: Dashboards
PT08 Part III: Pivot Tables - Slicers & Timelines
Просмотров 2046 месяцев назад
PT08 Part III: Pivot Tables - Slicers & Timelines
APQ11 | Merge Queries - Next Level | Merge | M-Code | Custom Column | Records | Advanced Power Query
Просмотров 7 тыс.6 месяцев назад
APQ11 | Merge Queries - Next Level | Merge | M-Code | Custom Column | Records | Advanced Power Query
PT08 Part II : Pivot Charts without pivot tables & charts templates
Просмотров 3416 месяцев назад
PT08 Part II : Pivot Charts without pivot tables & charts templates
PQC09 | Flex Filter | M-CODE & User Interface | Power Query Challenge Solution
Просмотров 2,2 тыс.6 месяцев назад
PQC09 | Flex Filter | M-CODE & User Interface | Power Query Challenge Solution
PQC09 | Power Query Challenge | Flex Filter
Просмотров 3987 месяцев назад
PQC09 | Power Query Challenge | Flex Filter
This helped a lot! Thank you! :)
Amazing Information
Hi. Also put target table and explain thank you
Excellent. Masterpiece
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! :)
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 😍
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 ❤
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
Amazing video, explain so clearly, very useful.
Happy that you liked it !
Lover of ms excel should be subscribe this channel plz We grate love and honour for you sir
Thank you so much 😊
Some New features i didn't know thanks !
Excellent, happy that you learned a bit
wonderful series of powerpivot videos
Thanks for this! I got it working, but sometimes the output shows less rows than my samplesize. How do I fix this?
👌🏼💪🏻💪🏻💪🏻
😊😊👍👍
Truly a fantastic tutorial, thanks for the contribution. 👍
Thank you so much 😊
very well done
Thank you 🙏
This presentation has really helped me in my power bi project
Happy to hear 👍👍
you are a wonderful teacher and with a knack of simplifying complex opics. learnt so much from this series. hope u will update this series with more videos covering many more dax functions. Do you have a similar video series on Power BI
Happy that you liked it, I have a introductory video about power bi
Your first Power BI report | Introduction | Interactive Visuals | Slicers | Power Query | AI ruclips.net/video/ZQM1CeDDgz4/видео.html
@@aaaexcelenglish Please update the list and other lists as well. Your method of teaching is too good
Great
Thank you 🙏
Learning about Excel and pivot tables has non end ! Thanks to you !
You’re absolutely right, most welcome 🙏
Excellent, clear explanations. Many thanks.
Most welcome 🙏
Excellent 🌹🌹
Thank you 🙏
Awesome Video, I got something new.. Keep creating more videos... ❤
Thank you, will do my best 👍
Great Video, I learnt new thing, Thanks for creating such wonderful video.
Happy to hear, most welcome 🙏
Great video, masterful explanation. Greetings and thanks
Thank you 🙏
Great example of Table.Buffer, something I've never exploited but after this video I really need to apply it more often in my solutions. Thank you for sharing and explaining it in a simple way!
Thank you for your comment 👍
Awesome video!.. Thank you for shaning...
Most welcome 🙏
i have noticed in the measure calculating gm is being divided by 1000000... any specific reason.. thanks for your clariification
Outstanding! Thank you.
You’re welcome ☺️
Thanks as always. A quick one. What should we do if the refresh time in the PQ Editor is taking too long? This is happening to me right now and I have so many qurries in one sheet
If qty equal to monthly qty it is correct