Computer Tutoring
Computer Tutoring
  • Видео 231
  • Просмотров 2 685 256
Getting Data Ready for a Pivot Table - Unpivot | Pivot | Transpose
Getting data ready for a Pivot Table involves unpivoting, pivoting and transposing data so that the data is in the correct structure to be analysed effectively.
#powerquery #unpivot #transpose #pivot
www.computertutoring.co.uk/power-query/unpivot/
00:00 Start
03:41 Unpivot Demonstration
07:30 Transpose Demonstration
09:18 Unpivot Months
11:19 Split Column
11:47 Pivot Column
13:28 Create Pivot Table
📷www.tiktok.com/@thecomptutor
📸www.pinterest.com/CT_Training/
🤳 computer_tutoring
🔗www.linkedin.com/company/computer-tutoring
🐤 CT_Tutoring
😉 pages/Computer-Tutoring/352245198291?ref=hl
Просмотров: 232

Видео

Excel Hacks: Unmerge Cells Like a Pro with Power Query | Tutorial #2 in Series
Просмотров 3584 месяца назад
Struggling with merged cells in Excel? 🤯 Discover the secrets of Power Query to streamline your data in our second tutorial of this beginner-friendly series. Whether you're tidying up sales data or prepping for complex reports, learn why merging cells can sabotage your spreadsheet and how to fix it seamlessly. Download our practical example from the description link below and transform the way ...
Easy Power Query Tutorial on Removing Blank Rows
Просмотров 5847 месяцев назад
Unlock the full potential of Excel with our Easy Power Query Tutorial on Removing Blank Rows. This video guide is tailored for beginners, simplifying the steps to clean your data by efficiently removing blank rows using Power Query. Perfect for first-time users, we'll walk you through the process from start to finish, ensuring your datasets are pristine and analysis-ready. Join us to learn why ...
Leap Year in Excel - Count how many leap years between dates
Просмотров 1,4 тыс.11 месяцев назад
Leap year in Excel is a formula that you need to know. Whether you want to check if a date is in a leap year, or you want to know how many leap years are between two dates working out the leap year in Excel is a must have formula. This Excel tutorial on how to create leap year formulas in Excel will show you how to do a basic formula all the way to how to calculate leap years between two dates ...
Master Dynamically Highlight Rows as you Type in Excel
Просмотров 1,7 тыс.Год назад
Are you struggling to manage and visualize large datasets in Excel? In this comprehensive tutorial, we'll show you how to dynamically highlight rows as you type in Excel, making data analysis and presentation a breeze. Discover how conditional formatting and custom formulas can transform your spreadsheets, enabling you to instantly identify and focus on specific data sets that match your criter...
Why should you get an Accountant?
Просмотров 435Год назад
Why should you get an Accountant? Questions about getting an accountant for you and your business that you've always wanted to ask. Want to know if you need an accountant for your business? Should you hire an accountant? Or simply how to know if I need an accountant. #computertutoring #accounts #fyp Welcome to our latest video where we will explore the topic of why you should get an accountant ...
How to Append Data from Multiple Files in a Folder into one Excel File?
Просмотров 7 тыс.Год назад
How to Append Data from Multiple Files in a Folder into one Excel File?
How to get rid of Blank Rows in Excel? - Delete Blank Rows in Excel!
Просмотров 8 тыс.Год назад
How to get rid of Blank Rows in Excel? - Delete Blank Rows in Excel!
How to Clean Messy Data for Quick Analysis in Excel? - Using Power Query
Просмотров 3,4 тыс.Год назад
How to Clean Messy Data for Quick Analysis in Excel? - Using Power Query
How to use SUMIF across multiple sheets in Excel?
Просмотров 49 тыс.2 года назад
How to use SUMIF across multiple sheets in Excel?
Bring Accounts Information Together on One Sheet - Excel Summary Sheet
Просмотров 10 тыс.2 года назад
Bring Accounts Information Together on One Sheet - Excel Summary Sheet
PowerPoint Master Slides Beginners Tutorial
Просмотров 65 тыс.2 года назад
PowerPoint Master Slides Beginners Tutorial
How to use a Green Screen in Microsoft Teams?
Просмотров 25 тыс.2 года назад
How to use a Green Screen in Microsoft Teams?
How to Manage Notifications in Microsoft Teams?
Просмотров 7 тыс.2 года назад
How to Manage Notifications in Microsoft Teams?
How to Get Attention in Microsoft Teams? - @ mention someone in Teams
Просмотров 2,9 тыс.3 года назад
How to Get Attention in Microsoft Teams? - @ mention someone in Teams
How to Post Across Multiple Channels in Teams?
Просмотров 8613 года назад
How to Post Across Multiple Channels in Teams?
How do you Create a Public Team in Teams? - Difference Between a Public and Private Team
Просмотров 3,4 тыс.3 года назад
How do you Create a Public Team in Teams? - Difference Between a Public and Private Team
How do I use Presenter view in Teams? - Teams PowerPoint live view
Просмотров 11 тыс.3 года назад
How do I use Presenter view in Teams? - Teams PowerPoint live view
How to Send an Invitation to a Teams Meeting? - How to Use the Scheduling Assistant in Teams?
Просмотров 73 тыс.3 года назад
How to Send an Invitation to a Teams Meeting? - How to Use the Scheduling Assistant in Teams?
Pivot Table Conditional Formatting
Просмотров 45 тыс.3 года назад
Pivot Table Conditional Formatting
How to use a Pivot Table Calculated Field?
Просмотров 124 тыс.3 года назад
How to use a Pivot Table Calculated Field?
How to Create a Financial Year in Excel?
Просмотров 27 тыс.3 года назад
How to Create a Financial Year in Excel?
How to use a Pivot Table to view Accounts?
Просмотров 7 тыс.3 года назад
How to use a Pivot Table to view Accounts?
How to Work Out How Much Money my Business made Last Month in Excel?
Просмотров 2,1 тыс.3 года назад
How to Work Out How Much Money my Business made Last Month in Excel?
How do I add DIFFERENT VAT rates into the same spreadsheet?
Просмотров 13 тыс.3 года назад
How do I add DIFFERENT VAT rates into the same spreadsheet?
How to Calculate VAT in Excel?
Просмотров 104 тыс.3 года назад
How to Calculate VAT in Excel?
How to Make Your Accounts Look Good in Excel?
Просмотров 7 тыс.3 года назад
How to Make Your Accounts Look Good in Excel?
How to do Super Easy Accounts in Excel?
Просмотров 11 тыс.3 года назад
How to do Super Easy Accounts in Excel?
Use PowerPoint to Speak another Language
Просмотров 4,2 тыс.3 года назад
Use PowerPoint to Speak another Language
How to use Zoom to give a PowerPoint presentation?
Просмотров 13 тыс.3 года назад
How to use Zoom to give a PowerPoint presentation?

Комментарии

  • @johnchapman4050
    @johnchapman4050 6 дней назад

    I thought I knew what I was doing on Publisher but your excellent video taught me a lot. Thanks!! Brilliant production and presentation. Obviously I have subscribed and will be seeking out your other tutorials.

    • @computertutoring
      @computertutoring 5 дней назад

      @@johnchapman4050 thanks will be getting back to publishing some more soon

  • @bmmrrr
    @bmmrrr 7 дней назад

    great video, but what happens if i have two commas before city

  • @DalisDL
    @DalisDL 7 дней назад

    straight to the point is an understatement, really appreciate the help <3

  • @peacefulllife8197
    @peacefulllife8197 13 дней назад

    you are the master of The Master slides

  • @murphyandmurphybrand
    @murphyandmurphybrand 16 дней назад

    If you can master powerpoint, you will find other Adobe software a breeze. Powerpoint and Word is the most godawful unintuitive software ever developed.

    • @computertutoring
      @computertutoring 12 дней назад

      I love Premiere however most companies are stuck with the Microsoft products

    • @murphyandmurphybrand
      @murphyandmurphybrand 12 дней назад

      @@computertutoring absolutely, especially the corporates

  • @stanTrX
    @stanTrX 17 дней назад

    Why too much work just to do conditional formatting for the entire row?

  • @user-ey7pq7ej6w
    @user-ey7pq7ej6w 26 дней назад

    Dear which is your best excel tutorial please

  • @marybegley8703
    @marybegley8703 29 дней назад

    Need more presentations

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

    Thank you very much. Excellent and easy explanation. Thank you very much.

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

    Thank you for this video. I agree with all the positive comments. I'm 76 years old and finally got it!

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

    in which condition the VAT is to be claimed example the "VAT claim in purchases and other input" "VAT Claim in sales and other output"

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

    I have Screen Recorded my commenary and mouse pointer movements onto PP slides but there are long dead spaces at the end of the audio. I use the Stop button to end the recording so am confused as to why after conversion to video some slides hang on for 5 or more seconds after the commentary was stopped. From your instructions: Click once on the video so that white circular resize handles appear at the edges and on the corners. (I assume "video" is meant to be "slide" as clicking on the video had no effect.) From then on, adjusting the beginnings and endings worked fine. But, is there a way to eliminate a few seconds of silence mid-audio? Might it be possible to capture the last few seconds of a slide's audio and move it to superimpose it over where the silence is obtrusive?

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

    It does not clarify that any data refresh or filter change will wipe out any formatting. Also does not allow pivot table formatting based on text.

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

    you solved a puzzle for me that I spent many days searching for, thanks

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

    Spoon feeded. I am so glad I understood master slides

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

    Thanks!

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

    Thank you, this helped clean up my Excel workbook quite a bit

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

    Fantastic. Straightforward, clear and it was fun. Thank you, I'll be back to learn more.

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

    Thank you

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

    Thank you for the amazing video. Very helpful!

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

    super easy tutorial , easy to follow thank you

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

      thanks - really appreciated

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

      @@computertutoring I have just managed to complete my first attempt of my accounts with the help of your awesome tuition . how do i add up all monthly totals of incoming together ?😃

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

    Excellent tutorial

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

    Amazing Tutor! you are a natural and I am lucky to have found your videos... you really helped me understand, thank you so much.

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

      Thanks glad that this has been helpful to you

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

    Great but very blur

  • @MirembeDeborah-jx4we
    @MirembeDeborah-jx4we 2 месяца назад

    Then how can i make a project booklet with portfolio

  • @MirembeDeborah-jx4we
    @MirembeDeborah-jx4we 2 месяца назад

    Hey so perfect

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

    Thank you!

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

    Not helpful. I want to freeze the first 12 rows not just one. It used to be easy and the old way doesn't work anymore.

  • @AndreaGolding-e7e
    @AndreaGolding-e7e 2 месяца назад

    Fantastic! Thank you and so clearly explained 🙂

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

    Excellent lesson! Thank you so much! Very clear and well paced! However, the "hover over" feature on the Master slide panel has been removed by Microsoft for those of us who use a Mac! Very frustrating!

  • @ChristinaSousa-of4uc
    @ChristinaSousa-of4uc 2 месяца назад

    The background music is too distracting. This video would have been much more helpful without it. I only made it a third of the way through because I could not concentrate on the presentation.

  • @J.K.Barrik
    @J.K.Barrik 2 месяца назад

    Hi, grateful for some advice please. I'm trying to save my pictures in CMYK colour mode for commercial printing, but every time I select the CMYK colour mode, the pictures become black and white and I can't understand why that could be and it's driving me mad. Any help would be appreciated.

  • @KirstiParker-fc9yw
    @KirstiParker-fc9yw 3 месяца назад

    After weeks of searching and finding complicated uninteresting videos, this was clear and really easy to follow, great tutorial! I’ll be definitely looking at other videos from this chap. Thank you!

  • @kifelewshawl1326
    @kifelewshawl1326 3 месяца назад

    THANK YOU SO MUCH

  • @rickdeckard9810
    @rickdeckard9810 3 месяца назад

    why don't you just use the ones under advanced output settings > crop marks ?

  • @Alfscan777
    @Alfscan777 3 месяца назад

    One of the better and more understandable presentations that i have watch that explain how to use PowerPoint on Zoom. The technical stuff was still a bit confusing but compared to others i have seen…. I was able to understand.

  • @natozeleo7579
    @natozeleo7579 3 месяца назад

    Nothing beats Google forms in this scenario.

  • @dfudge007ca
    @dfudge007ca 3 месяца назад

    This is great! Thanks! The only thing I can't figure out is, why my animations automatically advance when presenting in Teams. The animations do not automatically advance when in presenter view outside of Teams. Any advice?

    • @computertutoring
      @computertutoring 3 месяца назад

      Good question basically the animations shouldn’t automatically advance. Double check the transitions in the PowerPoint file to see if they are set there

  • @rexbk
    @rexbk 3 месяца назад

    Thank you much!

  • @rexbk
    @rexbk 3 месяца назад

    Thank you for this useful presentation.

  • @viksbunty
    @viksbunty 3 месяца назад

    i don't see similar option, like you have for ex. "All Cells showing "sum of profit%" values this is something cannot see where can apply for all cells with the sum data

    • @computertutoring
      @computertutoring 3 месяца назад

      Good question those options only appear when you have the pivot table with those fields in selected. If you don't have the cells selected you won't see it. I selected cell E6 before I went to Pivot Table to make sure I could see All Cells showing "Sum of Profit%".

  • @koushikhalder3708
    @koushikhalder3708 3 месяца назад

    great..I have been searching for this solution

    • @computertutoring
      @computertutoring 3 месяца назад

      So glad that you found the solution in our tutorials.

  • @zauralism
    @zauralism 3 месяца назад

    But is there any way to not lose the miscrosoft formatting when you add it to publisher?

    • @computertutoring
      @computertutoring 3 месяца назад

      Good question however whenever you transfer documents from one document to another you’re going to lose formatting. I would have a look at styles to help alleviate but it won’t be a perfect match

  • @computertutoring
    @computertutoring 4 месяца назад

    Download exercise files and follow along: www.computertutoring.co.uk/power-query/unpivot/

  • @RenatoNovelli
    @RenatoNovelli 4 месяца назад

    Awesome! It'd gonna be super useful to me! Tks for sharing!

  • @nicimie
    @nicimie 4 месяца назад

    Not gonna lie, I expected a friends-pivot-joke somewhere in this one 😂😂 helpful video nevertheless

    • @computertutoring
      @computertutoring 4 месяца назад

      Should have put the sofa removal clip on 😂

  • @paruppuvadai
    @paruppuvadai 4 месяца назад

    Y using 1

    • @computertutoring
      @computertutoring 4 месяца назад

      To work out the percentage 1 in Excel is equivalent to 100%

  • @kellyalvarado6533
    @kellyalvarado6533 4 месяца назад

    😂😅 Sniffing the water to see if the fly was in there was my absolute favorite part!!

  • @oscar-vo4jg
    @oscar-vo4jg 4 месяца назад

    what I'm saying is, it's supposed to go to the next slide after fade, but mine loops to the top of the same slide and as I click it sort of shakes each sentence or item of the slide and then fades and that's the only time it goes to the next slide.

  • @oscar-vo4jg
    @oscar-vo4jg 4 месяца назад

    how come mine using transition, it goes back to the top of the same slide (not next one), it shows everything on the slide and as I click, it sort of shakes each item and then finally it fades and goes to the next slide?

    • @computertutoring
      @computertutoring 4 месяца назад

      Check the order of your animations in the slide make sure there isn’t another object like a stray text box hanging around