In this video, I will show you how to quickly unpivot data in Excel using Power Query.

Since the Pivot table needs a specific data format, in case you get the data in any other format, you need to change it to able to use it in pivot tables.

In this example, I show you a common format that you can easily unpivot in Power Query with a few clicks.

The best part about using Power Query is that it’s linked to the original data. So in case your original data expand or change, all you need to do is refresh the resulting data and it will automatically update.

This video is a part of my ‘Excel is two-minute’ series, where I share simple and quick tips to help you speed up your work and be more efficient

Subscribe to this YouTube channel to get updates on Excel Tips and Excel Tutorials videos – https://www.youtube.com/c/trumpexcel

This YouTube channel is managed by Sumit Bansal (who also runs the TrumpExcel website). This channel is meant for people who want to learn Excel. It covers a lot of Excel basics and advanced Excel topics such as Excel Formulas, Functions, Pivot Table, Shortcuts, Excel VBA, Macros, Excel Dashboards, Excel Charts, Conditional Formatting, Power Query, etc. Please subscribe to this channel to be the first to know when new Excel tutorials come out.

You can find a lot of useful Excel resources on the following site: https://trumpexcel.com/

#Excel #ExcelTips #Excelin2Minutes

View on YouTube

In this video, I will show you a really easy way to show numbers in thousands in Excel (or in millions or billions).

You can do this using the custom number formatting where you can specify the format to show values in thousands (or millions) and also add the word “Thousand” or “K” to it.

The best part about this method is that it only changes how your data looks in Excel and has no impact on the value within the cell. So you can still use the cell in calculations.

This video is a part of my ‘Excel is two-minute’ series, where I share simple and quick tips to help you speed up your work and be more efficient

Subscribe to this YouTube channel to get updates on Excel Tips and Excel Tutorials videos – https://www.youtube.com/c/trumpexcel

This YouTube channel is managed by Sumit Bansal (who also runs the TrumpExcel website). This channel is meant for people who want to learn Excel.

It covers a lot of Excel basics and advanced Excel topics such as Excel Formulas, Functions, Pivot Table, Shortcuts, Excel VBA, Macros, Excel Dashboards, Excel Charts, Conditional Formatting, Power Query, etc. Please subscribe to this channel to be the first to know when new Excel tutorials come out.

You can find a lot of useful Excel resources on the following site: https://trumpexcel.com/

#Excel #ExcelTips #Excelin2Minutes

View on YouTube

Download Start Excel file: https://ift.tt/2MwVY1F
Download Finished Excel file: https://ift.tt/2MCjWZv
Pdf files with notes: https://ift.tt/2IOoqtJ

This is an alternative method for what we did last video, where we need a report to show all Teams and All Employees regardless of whether or not they had sales. This shows how to deal with a Slowly Changing Dimension where the employees on Teams change over time. See Power Query M Code from Bill Szysz.
Topics:
1. (00:09) Introduction to Data Setup and Goal of Power Query Data Modeling
2. (01:46) Power Query Transformation for Dimension Table into a Fact Table. Including List Syntax to create a list of dates that we can use to expand and repeat the record for each date in the period.
3. (06:06) Build Standard PivotTable Report, including Loading Power Query Output directly to a Standard PivotTable.
4. (06:35) Summary

Comprehensive Microsoft Power Tools for Data Analysis Class, BI 348, taught by Mike Girvin, Excel MVP and Highline College Professor.

Excelisfun, Highline College, Data Analysis, Business Intelligence, BI 348, Mike Girvin, Microsoft Power Tools for Data Analysis 32, MSPTDA 32, MSPTDA 33, MSPTDA 34, MSPTDA 35, Slowly Changing Dimensions, Data modeling Slowly Changing Dimension, Power Query Data Modeling, Power Query M Code, Standard PivotTable, List Syntax, Dates as Whole Numbers, List Syntax Trick for List of Dates, Bill Szysz, Power Query Transformation

View on YouTube

In this video, I will show you how to find and select all the cells that have a bold text formatting applied to it.

You can do this easily using the Find and Replace dialog box. There is an option in the Find and Replace dialog box which allows you to select the formatting from a cell and then finds all the cells that have the same formatting.

You can use this to select the cell with bold font formatting and then find all the cells that have bold text.

Once you have selected these, you can easily highlight these, change the formatting, or delete the cells/rows.

This video is a part of my ‘Excel is two-minute’ series, where I share simple and quick tips to help you speed up your work and be more efficient

Subscribe to this YouTube channel to get updates on Excel Tips and Excel Tutorials videos – https://www.youtube.com/c/trumpexcel

This YouTube channel is managed by Sumit Bansal (who also runs the TrumpExcel website). This channel is meant for people who want to learn Excel.

It covers a lot of Excel basics and advanced Excel topics such as Excel Formulas, Functions, Pivot Table, Shortcuts, Excel VBA, Macros, Excel Dashboards, Excel Charts, Conditional Formatting, Power Query, etc. Please subscribe to this channel to be the first to know when new Excel tutorials come out.

You can find a lot of useful Excel resources on the following site: https://trumpexcel.com/

#Excel #ExcelTips #Excelin2Minutes

View on YouTube

In this video, I will show you how to open specific Excel files when you start Excel.

You can specify a folder so that whenever you start Excel, it will automatically open all the files in that folder.

You can read more about this here: https://ift.tt/2MxbQkI

You can also modify the files in this folder, and Excel would automatically consider these files when you open Excel the next time. You can also add new files to this folder, and Excel would open these files when you start Excel the next time.

This video is a part of my ‘Excel is two-minute’ series, where I share simple and quick tips to help you speed up your work and be more efficient

Subscribe to this YouTube channel to get updates on Excel Tips and Excel Tutorials videos – https://www.youtube.com/c/trumpexcel

This YouTube channel is managed by Sumit Bansal (who also runs the TrumpExcel website). This channel is meant for people who want to learn Excel. It covers a lot of Excel basics and advanced Excel topics such as Excel Formulas, Functions, Pivot Table, Shortcuts, Excel VBA, Macros, Excel Dashboards, Excel Charts, Conditional Formatting, Power Query, etc. Please subscribe to this channel to be the first to know when new Excel tutorials come out.

You can find a lot of useful Excel resources on the following site: https://trumpexcel.com/

#Excel #ExcelTips #Excelin2Minutes

View on YouTube