Deep Learning ,

Power Query Jumpstart

View Course details
Preview this Course
Not Enrolled
This course is currently closed

Course Includes

  • 2 Sections
  • 7 Lessons
  • Course Certificate

Responses

  2. William Shapiro November 1, 2024

    Hello , as per the video I’m attempting to select multiple worksheets within the same workbook. I’m using Excel MS 365 and it is not possible to do this. Reading online gives answers like this and other similar comments. “The online version of Excel has limited functionality, and currently that is one of the features that is missing in the online version, they are constantly adding new features to the online version, so that may become available in the future.” Is there a workaround? Many thanks WS

    1. Justin @ExcelCampus Moderator November 5, 2024

      Hi William,

      Thank you for posting! 🙂 Agreed that the online version has limited functionality.

      I attempted to try a workaround with the online version and noticed some changes even from what I used a few months ago. Are you using the free version of MS 365, or are you using MS 365 Personal/Business? To make substantial progress in Excel training, I would consider it necessary to have a full desktop version of Excel, which does come with a cost (less than the price of 2 Power Query Jumpstarts). Below is a link for pricing.

      https://www.microsoft.com/en-us/microsoft-365/buy/compare-all-microsoft-365-products

      Power Query (Get & Transform) has been around since 2010. There is more Power Query functionality on Excel 2013 than there is on the online version from what I viewed today. Even an old laptop from family/friends with Excel 2013/2016 on it would be great to use … and possibly free!

      I apologize that I do not have a good workaround to give you, William. If you have any additional questions, let us know. Have a great day! 🙂

    1. Justin @ExcelCampus Moderator November 5, 2024

      Hi Richard,

      Great question! 🙂 One workaround is to add an index column, then sort by descending. That will bring the bottom row to the top. To do this in Power Query, choose Add Column > Index Column. Then click the dropdown on the Index column that was added (far right) and choose Sort Descending.

      Let us know if you have additional questions about this, Richard – we’re glad to help! Have a great day! 🙂

    2. Justin @ExcelCampus Moderator November 1, 2024

      Hi William,

      Thank you for posting and for your kind feedback! 👍 Again, we apologize for not responding sooner. We’re glad that you are enjoying Power Query Jumpstart here at Excel Campus. 🙂

      Let us know if you are interested in joining the Elevate Excel program or if you have any questions.

      Have a nice weekend! 🙂

    2. Justin @ExcelCampus Moderator October 31, 2024

      Hi Ed,

      Great question! 🙂 Again, we apologize for not responding sooner. Yes, the Elevate Excel program grants access to all of Excel Campus’ courses, including The VBA Pro Course which covers how to create customized UserForms.

      Let us know if you have additional questions about Elevate Excel or anything else! 🙂

  6. Rubina August 15, 2024

    Hi really amazing. I’m already using it and hope next month end will be a time saver. Where to next pls. Which course should I do next for the next step in learning power query? Thanks

    1. Justin @ExcelCampus Moderator August 14, 2024

      Thank you, Christene! 👍 We are glad that you learned a lot! 🙂 The virtual station concept explained in the other replies (e.g., Parallels, Boot Camp) can get you to the full function and enjoyment of Power Query in Excel on Mac.

      Let us know if you have any questions or have topics on which you would like additional training. Thanks again, Christene, and keep learning! 🙂

    1. Justin @ExcelCampus Moderator July 26, 2024

      Hi Mike,

      Great question! 🙂 The Jumpstart course is for beginners that want to get up and running with Power Query quickly. The Power Query Pro Course will cover everything in Jumpstart and goes into more depth on advanced functions and features of Power Query. You do not need Jumpstart if you do the Pro course.

      Have a great weekend, and keep learning! 🙂

      1. Justin @ExcelCampus Moderator July 26, 2024

        Hi Prashant,

        Great question! 🙂 The Jumpstart course is for beginners that want to get up and running with Power Query quickly. The Power Query Pro Course covers everything in Jumpstart and goes into more depth on advanced functions and features of Power Query. You do not need Jumpstart if you do the Pro course.

        Let us know if you have additional questions, Prashant. Have a great weekend, and keep learning! 🙂

    2. Justin @ExcelCampus Moderator July 26, 2024

      Hi Jacqueline,

      Great question! 🙂 The Jumpstart course is for beginners that want to get up and running with Power Query quickly. The Power Query Pro Course covers everything in Jumpstart and goes into more depth on advanced functions and features of Power Query.

      The Power Query Pro Course has 96 lessons, whereas Power Query Jumpstart has only 7 lessons.

      Let us know if you have additional questions, Jacqueline. Have a great weekend, and keep learning! 🙂

    1. Jon Acampora July 18, 2024

      Hi Debra,
      Sorry about that. We had a backend issue with granting access to Elevate members. You should have access now.
      Please let us know if you have any questions. Thanks!

    1. Jon Acampora July 18, 2024

      Hi Lola,
      Sorry about that. We had a backend issue with granting access to Elevate members. You should have access now.
      Please let us know if you have any questions. Thanks!

    1. Jon Acampora July 18, 2024

      Hi Timothy,
      Sorry about that. We had a backend issue with granting access to Elevate members. You should have access now.
      Please let us know if you have any questions. Thanks!

Report

Harassment or bullying behavior
Contains mature or sensitive content
Contains misleading or false information
Contains abusive or derogatory content
Contains spam, fake content or potential malware

Block Member?

Please confirm you want to block this member.

You will no longer be able to:

  • See blocked member's posts
  • Mention this member in posts
  • Invite this member to groups
  • Message this member
  • Add this member as a connection

Please note: This action will also remove this member from your connections and send a report to the site admin. Please allow a few minutes for this process to complete.

Report

You have already reported this .