ِAAA Excel English
ِAAA Excel English
  • Видео 49
  • Просмотров 87 477
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
------------------------------...
Просмотров: 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

Комментарии

  • @juja2819
    @juja2819 8 часов назад

    This helped a lot! Thank you! :)

  • @WaqasKhan-sp3sn
    @WaqasKhan-sp3sn 15 часов назад

    Amazing Information

  • @RoyalGate-to8rm
    @RoyalGate-to8rm 21 час назад

    Hi. Also put target table and explain thank you

  • @WaqasKhan-sp3sn
    @WaqasKhan-sp3sn День назад

    Excellent. Masterpiece

  • @meliketasdelen123
    @meliketasdelen123 2 дня назад

    Thanks❤

  • @vinodkamath2057
    @vinodkamath2057 4 дня назад

    Super video . explained powrr querry in a very short time...thanks 🙏

  • @newidentity9299
    @newidentity9299 4 дня назад

    Thank you

  • @seamushand8439
    @seamushand8439 4 дня назад

    Very well explained. Thank you

  • @eniolaadekoya5623
    @eniolaadekoya5623 9 дней назад

    hi i seems not to get the way you set up the date in the budget table

  • @LaloinLondon
    @LaloinLondon 11 дней назад

    Very clear. Straight to the point. You deserve more subscribers, and we deserve more videos from your channel.

  • @sasda1234s
    @sasda1234s 19 дней назад

    Amazing explanation!

  • @HasnainSabir-y1i
    @HasnainSabir-y1i 23 дня назад

    Excellent communication and good examples

  • @kennethstephani692
    @kennethstephani692 25 дней назад

    Great video!

  • @paolotombolato4497
    @paolotombolato4497 28 дней назад

    Thank you for your excellent course

  • @rajanpradeepankarath8846
    @rajanpradeepankarath8846 Месяц назад

    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

    • @juja2819
      @juja2819 8 часов назад

      I would like to see that too. Please make such a video! :)

  • @rameshep2633
    @rameshep2633 Месяц назад

    Explained beautifully... Easy to understand. Thanks

    • @aaaexcelenglish
      @aaaexcelenglish 2 дня назад

      Happy that you found it useful, most welcome 🙏

  • @kennethstephani692
    @kennethstephani692 Месяц назад

    Great video!

  • @KumarAnalytic
    @KumarAnalytic Месяц назад

    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!!😮😮😊😊

  • @amrraafat8929
    @amrraafat8929 Месяц назад

    great job 😍

  • @warrenanderson412
    @warrenanderson412 Месяц назад

    Go to the 4:50 minute Mark to review the Table Buffer. You Are Welcome😊

  • @muhammaddilshadshad2658
    @muhammaddilshadshad2658 Месяц назад

    Love uou sir love alot from pakistan

  • @leetran8328
    @leetran8328 Месяц назад

    look forward your next video, it's awesome

  • @mamta347
    @mamta347 Месяц назад

    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 ❤

  • @MdKarim-rj3op
    @MdKarim-rj3op Месяц назад

    Dear, Sir your Every video fantastic helping me

  • @azwarmzafar
    @azwarmzafar Месяц назад

    Thanks a ton for this Power Pivot Series!! Very Helpful and easily explained with perfect examples.

    • @aaaexcelenglish
      @aaaexcelenglish Месяц назад

      Happy that you found it helpful, thank you 🙏

  • @heshamsaad9883
    @heshamsaad9883 Месяц назад

    We are a great teacher Amr - Gazak Allah Khier

  • @ancycruz2029
    @ancycruz2029 Месяц назад

    hi how to calculate the ageing eg-0-07-,7-14 & so on ,pls help

  • @peggychen3411
    @peggychen3411 Месяц назад

    Amazing video, explain so clearly, very useful.

  • @muhammaddilshadshad2658
    @muhammaddilshadshad2658 Месяц назад

    Lover of ms excel should be subscribe this channel plz We grate love and honour for you sir

  • @boissierepascal5755
    @boissierepascal5755 Месяц назад

    Some New features i didn't know thanks !

  • @ferozkabir5184
    @ferozkabir5184 Месяц назад

    wonderful series of powerpivot videos

  • @fvdv1990
    @fvdv1990 Месяц назад

    Thanks for this! I got it working, but sometimes the output shows less rows than my samplesize. How do I fix this?

  • @boissierepascal5755
    @boissierepascal5755 Месяц назад

    👌🏼💪🏻💪🏻💪🏻

  • @flaviogarlatticosta
    @flaviogarlatticosta Месяц назад

    Truly a fantastic tutorial, thanks for the contribution. 👍

  • @SaleemShouket-r3p
    @SaleemShouket-r3p Месяц назад

    very well done

  • @peterkariuki5140
    @peterkariuki5140 Месяц назад

    This presentation has really helped me in my power bi project

  • @krnrajan
    @krnrajan Месяц назад

    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

    • @aaaexcelenglish
      @aaaexcelenglish Месяц назад

      Happy that you liked it, I have a introductory video about power bi

    • @aaaexcelenglish
      @aaaexcelenglish Месяц назад

      Your first Power BI report | Introduction | Interactive Visuals | Slicers | Power Query | AI ruclips.net/video/ZQM1CeDDgz4/видео.html

    • @krnrajan
      @krnrajan Месяц назад

      @@aaaexcelenglish Please update the list and other lists as well. Your method of teaching is too good

  • @SaleemShouket-r3p
    @SaleemShouket-r3p Месяц назад

    Great

  • @boissierepascal5755
    @boissierepascal5755 Месяц назад

    Learning about Excel and pivot tables has non end ! Thanks to you !

    • @aaaexcelenglish
      @aaaexcelenglish Месяц назад

      You’re absolutely right, most welcome 🙏

  • @houstonsam6163
    @houstonsam6163 Месяц назад

    Excellent, clear explanations. Many thanks.

  • @mostafasaad9556
    @mostafasaad9556 Месяц назад

    Excellent 🌹🌹

  • @KuldeepSingh-nq1vi
    @KuldeepSingh-nq1vi 2 месяца назад

    Awesome Video, I got something new.. Keep creating more videos... ❤

  • @KuldeepSingh-nq1vi
    @KuldeepSingh-nq1vi 2 месяца назад

    Great Video, I learnt new thing, Thanks for creating such wonderful video.

  • @eduardomunoz2764
    @eduardomunoz2764 2 месяца назад

    Great video, masterful explanation. Greetings and thanks

  • @paspuggie48
    @paspuggie48 2 месяца назад

    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!

  • @eduardomunoz2764
    @eduardomunoz2764 2 месяца назад

    Awesome video!.. Thank you for shaning...

  • @Excelvenky
    @Excelvenky 2 месяца назад

    i have noticed in the measure calculating gm is being divided by 1000000... any specific reason.. thanks for your clariification

  • @paulaparo1583
    @paulaparo1583 2 месяца назад

    Outstanding! Thank you.

  • @mcwahaab
    @mcwahaab 2 месяца назад

    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

  • @vudien2517
    @vudien2517 2 месяца назад

    If qty equal to monthly qty it is correct