EXCEL : Power Query Tutorial – Part 1 | HR Project (35 Tricks)




About this tutorial:

Video duration: 00:33:42
Power Query Beginner Tutorial. 35 Minutes Video cover 35 Power Query Steps for HR Salary Calculation project for Excel 365, Excel 2019, 2016, 2013 2010 users

What are the Benefits of POWER QUERY
How to use POWER QUERY
POWER QUERY Editor in Excel 365, Excel 2019, Excel 2016, Excel 2013 & Excel 2010
How to Insert or Pull or Import Excel Sheets and Files into POWER QUERY
How to Check Header, Remove Top ROWs, and Select Header in POWER QUERY
How to Rename Column Header and Rename Table Name in POWER QUERY
How to Remove Empty or Null Rows and Error Rows in POWER QUERY
How to Replace Values in…

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads

1 thought on “EXCEL : Power Query Tutorial – Part 1 | HR Project (35 Tricks)

    My Accounting Tricks

    (October 4, 2020 - 10:16 pm)

    MCQ/QUIZ –
    When you use APPEND QUERIES between two tables, which of the following is mandatory to maintain

    A. Column Name of Both Tables Should be the same

    B. Both table should be identical (same column)

    C. Data Type of the column should be the same

    D. All of the above
    (Post your answer reply, I will reply and explain)

Leave a Reply

Your email address will not be published. Required fields are marked *