No video :(

Power Pivot Tutorial & Power Query in Excel - 1-Hour Class

Подписаться 596 тыс.

Просмотров 256 тыс.

50% 1

In this Power Pivot and Power Query tutorial from Simon Sez IT, Excel expert, Deb Ashby, teaches you how to get started with the Power Pivot and Power Query tools in Excel.
✅Download the Excel file we use in this Power Pivot tutorial here: ➡️www.simonsezit...
🔥Sign up for our full Power Pivot, Power Query, and DAX course here 👉bit.ly/3iWWnJT
In this Advanced Microsoft Excel tutorial, she looks at the following:
- Pivot Tables - a quick reminder ;-)
- Importing data into Excel from multiple sources
- Cleaning data using Power Query
- Creating a Power Pivot table
- Creating relationships using Power Pivot
- Using Measure and KPIs in Power Pivot
- Displaying data in a Pivot Chart
If you are new to Power Pivot in Excel or Power Query in Excel, this tutorial is a great place to start.
🌍 Get unlimited training with Simon Sez IT’s 150+ courses ⏩ www.simonsezit...
🚀 Level up your skills with a free 30-day trial to our complete training library of 8,500+ videos ⏩ www.simonsezit...
💻 Watch more free popular training tutorials from Simon Sez IT:
🔥Check out our FREE 300+ hour training course playlist here ➡️
• Simon Sez IT Long Trai...
✅ Check out our free video playlist for Excel beginners 👉 • Microsoft Excel Beginn...
✅ Excel 2021 Tutorials for Intermediate Users here 👉 • Excel 2021 Tutorials f...
✅ Microsoft Excel Tips and Tricks 👉 • Microsoft Excel Tips a...
✅ Microsoft Office 2021 and Office 365 Training here 👉 • Microsoft Office 2021 ...
💬Stay in touch!
SimonSezIT.com: www.SimonSezIT...
LinkedIn: / simon-sez-it
FaceBook: / simonsezit
🔔 Subscribe to our channel:
www.youtube.co...
If you enjoyed the video, please give a thumbs up 👍🏽 ;-)

Опубликовано:

19 авг 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 248

@SimonSezIT 3 года назад

To download the data files used in this video and follow along, go here: www.simonsezit.com/article/introduction-to-power-pivot-power-query-in-excel/

@2Tulipa 3 года назад

Any chance to get the two additional sales data files which you use on the webiner?

@oldschool4714 2 года назад

Where are the two sales_2017.csv & sales_2018.csv? Kindly share them as well.

@ivanstephan4324 2 года назад

@@oldschool4714 did you get them?

@steadyballer 2 года назад

Great video. Can I download the 2 sales data files "sales_2017.csv" & "sales_2018.csv" as well? Thanks.

@hemantsingh9966 Год назад

Indian Excel trainers do not such kind of bad activities. But British people are famous for it.

@leinadarcilla8217 Год назад

Found this in YT since i'm currently working as data analyst. This open my brain a lot that i could use this with our data that im working with. Thank you so much!

@SimonSezIT Год назад

Glad it was helpful! We have additional free tutorials for various data analysis tools and services here 👉 ru-vid.com/group/PLzj7TwUeMQ3iE3tUiAOKdVjSvcq0ynUS2

@agapheputrasusilo741 9 месяцев назад

This is very basic that nobody should not skip about power query and power pivot. Thanks deb.

@SimonSezIT 9 месяцев назад

I'm glad you found this video helpful! Power Query and Power Pivot are definitely essential tools for anyone working with data analysis. Keep exploring and learning, and you'll become a pro in no time! 🙂 We have additional free tutorials for various data analysis tools and services here 👉 ru-vid.com/group/PLzj7TwUeMQ3iE3tUiAOKdVjSvcq0ynUS2 For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! RU-vid Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► ru-vid.com ♥️ We appreciate your support!

@MusaSillahkamara Год назад

you make things so simple when you smile, i think it ease some burden in going through an hour of such a lesson ; thank you

@SimonSezIT Год назад

Our pleasure 😊

@cindyflores1172 3 года назад

Wow, this tutorial was so easy to follow. Your instructions are so clear. I have been watching other power query and power pivot tutorials and I would get lost because they wouldn't explain certain things or would go too fast. Thank you!!

@sonictype Год назад

I am sure Deb is a great woman to live with

@aarontwinomuzuni579 2 года назад

Very easy to follow and understand, I like it!, even the mood and articulative voice of Mrs. Ashby was incredible, thanks indeed

@nigelwaxley Год назад

Did you manage to secure the 2017 and 2018 Sales files?

@robertjcliu 3 года назад

English is always English, not American English. I am from Taiwan and I love your video, teaching me both software techniques and graceful English.

@SimonSezIT 3 года назад

Thank you! 😃

@sanguinj 2 года назад

Wow, Deb, What quality of instructor you are... Congrats!....Very well explained every subject. Regards from Mexico

@SimonSezIT 2 года назад

Thank you, Jorge for the kind comments! 😃

@nabanitadas2300 6 месяцев назад

Thank you So much for this amazing tutorial it was very knowledgeable and informative I learnt so many new things from this single video 🌞🤗

@SimonSezIT 6 месяцев назад

Thank you for your kind words! I'm glad you found the tutorial helpful and learned some new things from it. Keep exploring and learning! 😊 🔥Check out our FREE 300+ hour training course playlist here 👉 ru-vid.com/group/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU

@folashadeolaitan6222 Год назад

Awesome tutorial! Clear, concise and straight to the point. I learnt about Power Pivot and creating model relationships. Thank you.

@SimonSezIT Год назад

We're so glad!

@fabunmimoses3615 Год назад

hey... I'm sure you are a Nigerian, I guess you are a data analyst or hoping to go into data analysis. I just graduated from unilag and trying to go in data analysis. I just started my journey on the data analysis. what opportunity do I have as data analyst in Nigeria?

@yigithanemer8051 2 года назад

Thank you for the excellent work Mrs. Ashby.

@przemyslawkorolczuk 3 года назад

Thank you so much for this tutorial. Though I'm an Excel expert at my workplace, and most of the topics you have presented I'm familiar with, you showed then in an organized and simple way so I could refresh my knowledge and learn few things how to pass this to my colleagues in my Excel class. Good work :)

@SimonSezIT 3 года назад

Thank you Przemyslaw!

@hankabeEhub 2 года назад

This is awesome. I like the clarity and flow in her presentation. Thanks a lot

@sulemansiddiqui3027 3 года назад

Thank you. It was pretty useful an hour for understanding Power Pivot for a beginner like me ..

@SimonSezIT 3 года назад

Glad it helped!

@macromancarter8076 3 года назад

This is the second tutorial I have had with you and I find it very easy to follow. Others seem to be very good but move to fast. Others tend to skip some steps and get me lost. Your speed and organization is perfect. Thank you for that.

@SimonSezIT 3 года назад

You are so welcome! Thanks for the great feedback

@punchbuddies220 3 года назад

meowed

@tamirhayat 2 года назад

thank you very much from israel !

@robertjcliu 3 года назад

I have watched a lot of videos and believed you are the best.

@SimonSezIT 3 года назад

Thank you so much 😀

@izzynolimits 3 года назад

Thank you Deb for the tutorial, learned soooo much.

@SimonSezIT 3 года назад

Thank you for watching, I’m pleased to hear that this has helped you.

@chilarudanielokpulor2843 Год назад

Thank you for your information awareness for better work life experience exploring Excel power pivot. Thank you indeed for your love and sacrifice!

@SimonSezIT Год назад

Thank you for the kind words! 😊

@larssandgreen5464 4 года назад

Thank you so much. The tutorial is so easy to understand - i feel it saves me a lot of time. Will follow your work

@SimonSezIT 4 года назад

Glad it was helpful!

@nigelwaxley Год назад

@@SimonSezIT May you please share the Sales files used in this tutorial

@user-lq7hl7jo3q Год назад

amazing lesson , thank you for your clear tutorial, i can understand the basic as a whole

@jamessekadde8167 2 месяца назад

Ashby's teachings 🔥 🙌🙌🙌

@SimonSezIT 2 месяца назад

Glad it was helpful! 🤩 Learn more Microsoft Excel Tips and Tricks here ➡️ ru-vid.com/group/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc

@alebelyaregaldesale5045 4 месяца назад

Amazing tutorial!

@mirckianke 3 года назад

Wow. Simple and easy to understand. Am a happy soul being a beginner with the 2.. definitely subscribing

@SimonSezIT 3 года назад

Thanks Mercy!!

@simoiyahector-morales9521 2 года назад

The easiest way to create a table is to click into any cell except the header and just press ctrl +t and your data will be changed to a table. Shortcut to name a table is Alt, J,T,A. Shortcut to create a pivot table is Alt, N, V, T

@craigcanter9223 3 года назад

Very good introduction to Power Pivot and Power Query. Thank you

@sarahward5648 3 года назад

Been trying to teach myself power query & you have just helped me so much ..... amazing 😍 Brilliantly clear training module 🙏👍

@SimonSezIT 3 года назад

Happy to help Sarah!

@dbharathi2003 2 года назад

Wonderful and easy to understand.

@TheJoshtheboss 8 месяцев назад

29:00 I don't think you needed Power Query for the tables already in Excel. You can just import them to Power Pivot by pressing "Add to Data Model" in the Power Pivot contextual menu. Great tutorial 👍

@sammucai8462 7 месяцев назад

Nice tutorial ! Easy to follow.

@SimonSezIT 7 месяцев назад

Thank you so much for watching! We're glad you found the tutorial easy to follow. 😊 🔥Check out our FREE 300+ hour training course playlist here 👉 ru-vid.com/group/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU 🚀 Level up your Excel skills with free training here 👉 ru-vid.com/group/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 ru-vid.com/group/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Pivot Table training here 👉 ru-vid.com/group/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! RU-vid Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► ru-vid.com ♥️ We appreciate your support!

@kuwaitmina9 3 года назад

Thank you for you effort to make this video. I have learned lot from this and it may help on my career as well. I like to learn more from you. Great wishes...

@SimonSezIT 3 года назад

You're very welcome!

@sweenaarora4823 3 года назад

Thanks Deb ...I enjoyed every bit of this video...appreciate your awesome explanation!

@philllantos5336 2 года назад

it is 2022 and this still do its magic

@MrDrh042003 3 года назад

Thank you so much Deb, great job!

@SimonSezIT 3 года назад

Thanks! Delighted to hear that you've enjoyed the tutorial!

@craigbeuthin4299 3 года назад

Great session, It taught me a lot. Thanks very much

@SimonSezIT 3 года назад

Glad it helped! 😊

@qww760 Год назад

Awesome teaching. Thank you!

@SimonSezIT Год назад

Glad it was helpful! 🙂

@darrylmorgan 4 года назад

Nice Introductory Tutorial Thank You Deb :)

@SimonSezIT 4 года назад

I'm glad to hear that you enjoyed it Darryl

@salehfaruk6478 3 года назад

Deborah Ashby Excellent . thanks.

@SimonSezIT 3 года назад

Thanks for listening Saleh!

@independentthinker8750 3 года назад

This just blew my mind... It is amazing, thank you!

@SimonSezIT 3 года назад

Wow, thank you!

@filipchobodicky7914 2 года назад

Very helpful. Thanks for the video, Simon.

@SimonSezIT 2 года назад

Much appreciated! Thanks for the visit 👊

@nigelwaxley Год назад

@@SimonSezIT Files please

@ngee4925 3 года назад

This was great, thank you!

@SimonSezIT 3 года назад

Thank you!!!

@mohamedshazli6972 Год назад

I can't thank you enough for this amazing knowledge

@SimonSezIT Год назад

So nice of you 😊 If you haven't already seen it, additional free Excel training here 👉 ru-vid.com/group/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 ru-vid.com/group/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Pivot Table training here 👉 ru-vid.com/group/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u

@chandrakantha648 6 месяцев назад

Excellent guys 👍

@SimonSezIT 6 месяцев назад

Glad you enjoyed it. Thanks for watching! 🙂 🚀 Level up your Excel skills with free training here 👉 ru-vid.com/group/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 ru-vid.com/group/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Pivot Table training here 👉 ru-vid.com/group/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u

@marcelocoronado884 2 года назад

really amazing!!!! thank you so much!!!!

@SimonSezIT 2 года назад

Happy that it helped Marcelo!

@pradeepkapudasi2403 Год назад

very good explanation.... thank you

@SimonSezIT Год назад

Glad we could help!

@salehfaruk6478 3 года назад

Great work. So easy. Thank u

@SimonSezIT 3 года назад

Most welcome 😊

@tejaa9459 Год назад

Thank u so much I have learnt so much

@SimonSezIT Год назад

Glad to hear that!

@Finance_Life 3 года назад

Well done. Nice presentation

@SimonSezIT 3 года назад

Thanks Sunil, glad you enjoyed it!

@0722568703 2 года назад

Wow! Clear n precise! Thank you

@SimonSezIT 2 года назад

You're welcome! Thanks for watching.

@nigelwaxley Год назад

@@SimonSezIT 2017 and 2018 Files Please

@hamzalokhandwala5101 4 года назад

Fantastic explaination.

@SimonSezIT 4 года назад

Glad you liked it

@EverythingAboutLife117 Год назад

Thank you very much for this video tutorial it has helped me a lot.....Please can I get those dataset which you used that combines 2017 and 2016 dataset???. And also I want to ask a question................in creating relationships with different dataset when can we use "INDEX-MATCH" to create relationships with other dataset.....and also when can we use "power pivot options (view data in diagram)", to create relationships with other dataset. Thanks

@nikpaps1 10 месяцев назад

Thank you!

@SimonSezIT 10 месяцев назад

Glad it helped! Thanks for stopping by :-)

@georgeemmanuel1457 2 года назад

Thank you so much

@Justice_King 2 года назад

Really fantastic and helpful tutorial for excel learners. Thanks a lot.

@SimonSezIT 2 года назад

Glad you liked it

@nigelwaxley Год назад

@@SimonSezIT Where are the 2017 and 2018 Sales files

@chowa3686 3 года назад

Thanks for sharing 👏👏👏👍👍👍

@SimonSezIT 3 года назад

Glad you enjoyed it chow

@prajwalprakash8023 3 года назад

Great video!

@SimonSezIT 3 года назад

Thanks Prajwal!

@rdevdass 4 года назад

Great so easily explained

@SimonSezIT 4 года назад

Glad you think so!

@ehabshqairat8266 4 года назад

wonderful; great work and easy to understand. thank you

@nahumalexandercornejosanch7656 4 года назад

Wow.. What a great and useful tutorial is this one. Thanks for sharing your knowledge. Regards!

@SimonSezIT 4 года назад

Delighted that you've found the tutorial useful! Enjoy your weekend!

@nahumalexandercornejosanch7656 4 года назад

@@SimonSezIT you do the same! Blessings 😊

@fatguya2z 3 года назад

Thanks for great share.

@SimonSezIT 3 года назад

Thanks for visiting

@JaapVanderHorst Год назад

You should correct datatype before removing a colom, or take as step back. For example if you have a textnumber 310000.0010 you will lose the 10 if you convert it to text.

@winxrar2773 2 года назад

i found gems, thanks a lott ❤

@SimonSezIT 2 года назад

Glad you liked it!🙂 You can get additional Excel training here ➡️ ru-vid.com/group/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI

@harshpanchal7885 2 года назад

Very nice explanation of Power Pivot and its features. I would like to get other files by years which you used for practice. Please share those files which was used in the video for connection purpose in power pivot.

@nigelwaxley Год назад

Did you ever manage to secure these?

@gordoncraighton4937 2 года назад

This is a GREAT video!!

@SimonSezIT 2 года назад

Glad you think so, Gordon. Thanks for watching!

@vikramraghuwanshi9455 3 года назад

thankyou ofra wondr ful vedios ona powr ful query.

@SimonSezIT 3 года назад

You're welcome Vikram, So pleased you've enjoyed the tutorial!

@chinaguoxiaoyuan 3 года назад

You are so good.

@SimonSezIT 3 года назад

Many Thanks!

@StarProductions. 2 года назад

V good explanation, Plz provide link to other two workbooks u have used..

@c.k.abdulmajeed7783 3 года назад

Excellent

@SimonSezIT 3 года назад

Thank you so much 😀

@maxwell9566 3 года назад

Thank you so much for this tutorial. I learned a lot.

@SimonSezIT 3 года назад

Glad to hear that!

@jorgelara3116 2 года назад

Thanks !!! Excellent

@SimonSezIT 2 года назад

You are welcome! Thanks for watching ;-)

@chamanthawickramarathne2029 2 года назад

Absolutely a nice webinar to learn power pivot but It would be much better if you had shared other two files as well.

@kannemadugukrishna5349 2 года назад

Great work guys ☺️ thanks

@SimonSezIT 2 года назад

Our pleasure!

@akeemkazeem2744 3 года назад

The sales data for the two different year are not available online here, pls can I get it for practice

@ivanstephan4324 2 года назад

could you get them?

@janakadissanayake9350 3 года назад

Great tutorial Thanks 👍🏻

@SimonSezIT 3 года назад

Happy to help 👍

@malindalokugamage2358 3 года назад

the topic has been explained quite nicely ,great tutorial!

@SimonSezIT 3 года назад

Glad you liked it!

@syedaneesdurez8766 2 года назад

Awesome

@SimonSezIT 2 года назад

Thanks 😊 There is additional Excel training here if you need it -> ru-vid.com/group/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI

@adetayoadewolu7604 7 месяцев назад

Very nice class but I could not find the other two files and so was not able to finish the class.

@JBAhmad-vu2lr 5 месяцев назад

Deb, could you please show how we read Excel files from a folder in Sharepoint?

@drmattbriggs Год назад

Great video. Can you provide any comments and/or resources on how to update queries or the source data with updated data and still be able to use the same measures that were initially created.

@manojillangasooriya3590 3 года назад

Love it

@SimonSezIT 3 года назад

Thank you Manoj!

@RahulKumar-ly6ly 2 года назад

Thanks mam very helpful video

@SimonSezIT 2 года назад

Most welcome 😊

@MrEms333 4 года назад

Nice

@SimonSezIT 4 года назад

Thanks Fares!

@trueg261191 3 года назад

Thank you for this tutorial. The sales data for the power part of the course is not available for download. So I can't really follow along. But you have made power pivot look a lot less daunting!

@amadanes Год назад

The link mentioned is only to the power-pivot-workbook2 and not the 2 sales.....csv files

@aymanenawy7805 4 года назад

wonderful Deby!!, could you do some content for Mac users please?, thanks

@SimonSezIT 4 года назад

I'm glad you enjoyed it! Click here to watch our Mac specialized videos: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-sYU4k0P8c5g.html

@dans6562 Год назад

Would be nice to have the sales files used in video, but I found another power pivot video from Kevin Stratvert that has all files for his videos.

@groeisterk Год назад

Wow thx

@sr5726 3 года назад

Sales data files are missing in your blog. Could you upload them ? Thank you for your awesome presentation

@royeden1084 3 года назад

thank you!

@SimonSezIT 3 года назад

No worries!

@rachellecormier7468 2 года назад

Great training, thank you! If you want to show/compare data from your 2017 Sales Table and data from your 2018 Sales Table in your Power Pivot Table, how are you able to decipher between each year after the files have been ‘combined’ together?

@JohnPaulIghorue Год назад

Use conditional formating or create a column with the IF and Text Functions to create unique Identifiers

@lopelle 2 года назад

Hello! How do we sort by date?

@SimParadox 3 года назад

It was very good but I don't understand what the point was in having the tbl_trip_code table. It didn't contain anything that wasn't in sales data.

@harshpanchal7885 2 года назад

Thank you for sharing link. I appreciate if possible to get sales_2017 and sales_2018 excel files which is used in the video.

@doristsai819 Год назад

Thanks for the super useful tutorial. I tried to follow up the steps, but I noticed that my source data file is not a csv file and after I import and make the connection to the data file and select add this data to the Data Model, no Data model can be found when I start creating the pivot table. How can I solve this please?