Miss Microsoft
Miss Microsoft
  • Видео 63
  • Просмотров 670 995
Combine & Transform Financial Statements: Make Your Analysis Easier!
Are you struggling to pull meaningful insights from your income statements or trial balances? In this video, I’ll walk you through transforming these financial statements into analysis-ready data, making your reports both actionable and easy to understand.
Whether you’re new to financial analysis or looking to deepen your skills, this video breaks down practical techniques for reshaping your income statements and trial balances. Follow these steps to automate your transformations and make impactful analysis a breeze!
✅Please click here to download the practice files: buymeacoffee.com/missmicrosoft/e/328518
✅ Please see links to videos mentioned in this video:
ruclips.net/video/MMF3bNXqT2c/ви...
Просмотров: 811

Видео

Combine Multiple Excel Files with Inconsistent Column Headers - No Coding & No Formulas Needed
Просмотров 2,2 тыс.4 месяца назад
Easily combine data when you have inconsistent column headers. The process involves using just your Power Query interface without the need for any coding or formulas! By following these steps, you can ensure your reports are automated with consistent and uniform column headers. ✅Please click here to download the practice files: buymeacoffee.com/missmicrosoft/e/277188 ✅ Please see links to video...
Create Your Own Easy Fiscal Year Calendar When 1 January is Not The Start Date | Power BI
Просмотров 1,4 тыс.5 месяцев назад
If your fiscal year does not start on January first, then you need to know about the most important date of your life Its going to help you analyse your data accurately by fiscal year, quarter, month, week and even day! Please click here to get the practice file and guide: buymeacoffee.com/missmicrosoft/e/258842 ✅ Please see links to videos mentioned in this video: 🎦 Measures versus Calculated ...
Combine Multiple Excel Files with Inconsistent Column Headers the Right Way!
Просмотров 8 тыс.7 месяцев назад
Easily combine multiple Excel files with inconsistent column headers in just four steps. And when new data is added you just need to hit refresh and your data is updated automatically even if your new data has completely different column names to your original data! Please click here to download the practice file: docs.google.com/spreadsheets/d/1lE0ciIHjcC30DZ7w3-nmrKTTNWlZEvw5/edit?usp=sharing...
Automate Like a Pro: Easy Refresh Macro for Power Query Reports!
Просмотров 5 тыс.Год назад
Learn how to create a refresh macro that will allow your reports to update automatically with just the click of a button. No more right click ➡️Refresh, just hit your Refresh macro and your reports update automatically. This is a game-changer for anyone looking to streamline their data analysis and reporting process in Power Query. 💡 Please click here if you would like to subscribe to "The Quer...
Don’t Skip These: The 4 Easiest Power Query Transformations You Must Try
Просмотров 3,4 тыс.Год назад
Learn how to create some nifty yet practical Power Query transformations using functions readily available to you in Power Query, such as Drill Down, Group By, Statistics, Custom Columns, Conditional Columns, and Merge. 💡 Please click here if you would like to subscribe to "The Query Editor" newsletter where you will receive Power Query tips, tricks and exclusive discounts to my upcoming course...
Effortlessly automate with Power BI & Power Automate in 4 Easy Steps
Просмотров 6 тыс.Год назад
In this Power BI tutorial, I'll guide you through the hassle-free process of how to send Power BI email alerts to anyone using Power Automate. ✅ Please see link to video mentioned in this video: 🎦Master Power BI: Create Your Own Easy Fiscal Year Calendar: ruclips.net/video/Lt_nNLQz0IE/видео.html ✅ If you would like to connect on LinkedIn: 🤝 www.linkedin.com/in/missmicrosoft ✅ If you would like ...
Master Power BI: Create Your Own Easy Fiscal Year Calendar
Просмотров 19 тыс.Год назад
In this Power BI tutorial, I'll guide you through the hassle-free process of creating a fiscal year calendar. Whether you're a data analyst or Power BI enthusiast, this step-by-step guide is perfect for beginners and experienced users alike. Having a fiscal year calendar is crucial for meaningful data analyses and decision-making. With this simplified approach, you'll master the art of building...
Don't Skip This: The Crucial First Step of the Pros
Просмотров 4,8 тыс.Год назад
Learn the crucial first step that Power Query Advanced users and Power BI Pro users take in these four examples using Power Query, Power Pivot and Power BI. Please download the practice file here: drive.google.com/drive/folders/1HYopUkC_RRiEv5-iKXh9uKMZLMyem5qB?usp=sharing Timestamps: 00:00 What's the Crucial First Step of the Pros? 00:24 Example 1 - Power Query 06:17 Example 2 - Power Pivot 08...
The #1 Mistake You're Making in Your Queries
Просмотров 37 тыс.Год назад
Have you ever encountered the dreaded "the table of the column wasn't found error" or the elusive "The key didn't match any rows in the table" error in Power Query? In this video, I will address a common mistake that many people make when creating queries and show you how to avoid that mistake by making your queries more dynamic. I'll explain what these errors mean and provide solutions to fix ...
Measures Versus Calculated Columns in DAX and Power BI - All You Need to Know
Просмотров 2,7 тыс.Год назад
In this Power BI DAX tutorial you will learn the crucial differences between measures and calculated columns in DAX and Power BI. Discover the secrets of creating measures and calculated columns that will transform your data analysis. Gain a deep understanding of the nuances between filter context and row context, and harness the full potential of SUM and SUMX (a powerful iterating function). S...
2 Power Query Refresh Secrets Everyone Should Know!
Просмотров 21 тыс.Год назад
In this video learn how to effortlessly refresh your queries in Power Query with just the latest data and how to prevent your files from being overwritten so that you’re not losing valuable insights when you hit refresh. Please download the practice file here: drive.google.com/drive/folders/1eoFtKEU6YKYxORmcD5qcFj6LMM-r4gqS?usp=share_link Matt Allington's blog: exceleratorbi.com.au/self-referen...
Create Power Query Parameters For Collaboration And Flexibility.
Просмотров 2 тыс.Год назад
Learn how to create Power Query Parameters to enable collaboration with your colleagues to make your queries more flexible and reusable. Please download the practice file here: drive.google.com/drive/folders/1L_1x3-G2RF8Sw5tM6KGETQYnuqm7JOm6?usp=sharing 00:00 The scene 00:36 Step 1 01:19 Step 2 03:50: Step 3 06:00 Step 4 ✅ If you would like to connect on LinkedIn: 🤝 www.linkedin.com/in/missmicr...
14 Power Query Hacks that Feel Illegal to Know
Просмотров 6 тыс.Год назад
14 Power Query Hacks that Feel Illegal to Know
How to Combine Multiple Excel Sheets with Power Query the RIGHT WAY 🤫
Просмотров 6 тыс.Год назад
How to Combine Multiple Excel Sheets with Power Query the RIGHT WAY 🤫
Unlock 4 Power Query Secrets Now
Просмотров 10 тыс.Год назад
Unlock 4 Power Query Secrets Now
Leila Gharani’s Top 10 Tips for Power BI Success
Просмотров 2 тыс.Год назад
Leila Gharani’s Top 10 Tips for Power BI Success
10X Your Power Query Skills with ChatGPT
Просмотров 13 тыс.Год назад
10X Your Power Query Skills with ChatGPT
Power BI: The Ultimate Beginner's Tutorial
Просмотров 2,3 тыс.Год назад
Power BI: The Ultimate Beginner's Tutorial
How to Combine Multiple Files with Inconsistent Column Headers into a Single Sheet
Просмотров 49 тыс.2 года назад
How to Combine Multiple Files with Inconsistent Column Headers into a Single Sheet
The ONE Useful Power Query Function You Wish You Knew Earlier!
Просмотров 1,9 тыс.2 года назад
The ONE Useful Power Query Function You Wish You Knew Earlier!
A Key Example to Unlock the Potential of List.Accumulate in Power Query
Просмотров 5 тыс.2 года назад
A Key Example to Unlock the Potential of List.Accumulate in Power Query
The Secret to List.Accumulate in Power Query
Просмотров 16 тыс.2 года назад
The Secret to List.Accumulate in Power Query
How to Create Killer Calculations 04 - Become a Power Query Pro - The Series
Просмотров 2,6 тыс.2 года назад
How to Create Killer Calculations 04 - Become a Power Query Pro - The Series
How to Automate the S&P500 in Excel - Become a Power Query Pro 03 (Create Killer Calculations)
Просмотров 2,5 тыс.2 года назад
How to Automate the S&P500 in Excel - Become a Power Query Pro 03 (Create Killer Calculations)
How to Create Killer Calculations 02 - Become a Power Query Pro - The Series
Просмотров 1,9 тыс.2 года назад
How to Create Killer Calculations 02 - Become a Power Query Pro - The Series
Become a Power Query Pro in Three Minutes and Thirty Seconds
Просмотров 2,3 тыс.2 года назад
Become a Power Query Pro in Three Minutes and Thirty Seconds
8 Powerful Power Query Transformations You Must Know
Просмотров 12 тыс.2 года назад
8 Powerful Power Query Transformations You Must Know
Create a Dynamic File Path from SharePoint & Change the Power Query Source Based on an Excel Cell
Просмотров 13 тыс.2 года назад
Create a Dynamic File Path from SharePoint & Change the Power Query Source Based on an Excel Cell
How to Fix Formula.Firewall Error in Power Query
Просмотров 13 тыс.2 года назад
How to Fix Formula.Firewall Error in Power Query

Комментарии

  • @enriquelimon1745
    @enriquelimon1745 День назад

    I love you❤

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

    Que bien lo explicas!!! Sigue así!!

  • @johnsyler2686
    @johnsyler2686 14 дней назад

    Thanks!

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

      Thank you so much for your kind support! Greatly appreciated!

  • @Luciano_mp
    @Luciano_mp 18 дней назад

    Very good...Thank you!

  • @mortenlanda2211
    @mortenlanda2211 18 дней назад

    Takk!

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

      Thank you so much!!! I appreciate your kind support 😊

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

    Wow! Great video! 💪 Do yout think, is there any solution for union in PQ .xlsx files with difrerend numbers of columns and order? Ex. file 1 has col. A, B, C. File 2 has col. B, C, D. FIle 3 has col. A, B, C, D. File 4 has col. A, C, B. In the end i want to get ALL files from folder in 1 table with col. A, B, C, D (all colums). Is it possible?

  • @barryalexander3209
    @barryalexander3209 23 дня назад

    Gives me an error stating function cannot find a base column of DateTime type in model....

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

    Thanks so much given the super TIP.

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

    Hi, great video and process, thank you. It seems like this will be a one-time query and the new combined file wouldn't update if users add or change data in the original files, is that correct?

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

    Very useful tutorial. You deserve more subscribers!!

  • @GuilleJiménez-s9g
    @GuilleJiménez-s9g Месяц назад

    Absolute masterpiece

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

    Thanks for the concise and clear explanation.

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

    Thanks!

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

      You’re welcome ☺️

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

      Thank you so much Heishoi for your kindness and support! Super appreciate it!!!!

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

      @MissMicrosoft love your videos, they are great

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

      Thank you ☺️

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

    Awesome 👍👍👍

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

    Another gem of a tutorial from my favorite power query instructor. Keep it up and more upload of videos like this

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

      This made my day!!! Thank you Lars ☺. I'm so glad the videos are helpful!

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

    Excellent tutorial 👌

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

    hi meslisa

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

    From how many days I am waiting for your videos please upload videos weekly 🙏 Your videos are really helpful

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

      Thank you so much for your support and kind words! I’m glad the videos are helpful. As for uploading weekly, my 9 to 5 keeps me extremely busy!

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

    This has helped me enormously with changing sheet name,t ahnk you so much.

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

    Bad teacher

  • @LIV-FREE-VET
    @LIV-FREE-VET Месяц назад

    Awesome video, just what I needed. Thank you Miss Microsoft!

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

    Nicely explained! Thank you very much.

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

    Thank you very much for making this video. I found it well detailed, easy to follow and extremely helpful!

  • @Gorman-84
    @Gorman-84 Месяц назад

    too cool. Thanks

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

    For some reason, this isn't working for me. The macro is tied to the button but clicking the button does nothing. Is there anything I should check?

  • @10ozGold
    @10ozGold Месяц назад

    Excellent channel. Spoken clearly and at a perfect pace. I've learned a lot from you. Thank-you.

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

    Excellent video. I'm curious... can one use the value from the Excel cell to pass directly to the parameter? For example, if I wanted the parameter itself to dynamically change based on the month entered, is there a way to do this? I'm wanting to be able to pass the data input to a SQL query.

  • @Gorman-84
    @Gorman-84 2 месяца назад

    What a great tip. Remove other columns.

  • @dr.sushilkumarph.d.8186
    @dr.sushilkumarph.d.8186 2 месяца назад

    Thank you for excellent video

  • @TinaLyles-d6g
    @TinaLyles-d6g 2 месяца назад

    why doesn't it save? everytime i open the file its back to leaving zero ot

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

    Thankyou for the solution i searching for this - but my problem is link is not dynamoc as it is not fetching file path dynamically

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

    thk u❤

  • @RAJUKONANKI-l3k
    @RAJUKONANKI-l3k 3 месяца назад

    Its working. Thank you.😀

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

    I have to repeat what another user said: Best video on this subject on RUclips so far. Thank you.

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

    😂😂😂 your highly funny

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

    How can I pass the value in mysql query dynamically from the report section whatever user selected in filter 1) users select a single date that date should pass on my store procedure which I am calling in power bi while fetching the data from database How can I achieve this please help..

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

    finally i found the video that i was looking for! This video has an obvious explanation, not too fast, so easy to follow. Thank you very much, you save my day. Just clicked Subscribe.

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

    Great explanation! Thank you!

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

    In my case it was referring to the PowerBI workspace i have used to create the dataflow to which I have connected excel. People who will not have access to the particular workspace, will get this error as well. Error message is not very intuitive if you ask me :)

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

    Awesome and simple to follow

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

    Thank you so much. Solved my exact problem!

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

    A very good use of UI instead of codes. Wonderful.

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

    Thank you so much for this very clear explanation! 🙏

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

    Thanks

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

    Thank you!!!

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

    Flashing subtitles is not an accessible way to communicate.

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

    Super. I had a very strong need to be able to do this and you solved it. A fellow South African I believe😁

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

    Oh!! that is so smart!! i couldn't have thought of that! thank you so much, sis :) BTW I've missed you a lot. god bless

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

    Hello, the query files do not have the spreadsheets to load or the folder for the path. queries are broken.😢

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

      Hi Daniel, please accept my sincere apologies, I've emailed you the files. Please let me know if you've received them?

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

      hello, I received the files, thank you for your attention!

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

      Glad to hear!