In this video, I will show you how to calculate age in Excel in Years, Months, and Days (when you have the date of Birth).

This can easily be done using the DATEDIF function, which is a legacy function and is made available for compatibility reasons with LOTUS 123.

With Datedif you can calculate:
— Total years that have passed in between the date of birth and current date
— Total number of months that have passed in between the date of birth and current date
— Total number of days that have passed in between the date of birth and current date

You can also read more about this here: https://ift.tt/32Ryp9y

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 #ExcelTutorial

View on YouTube

In this video, I will show you how to start a new line in the same cell in Excel.

If you’re manually typing the data you can do this using the keyboard shortcut ALT + ENTER. Place the cursor where you want the line break, hold the ALT key and then press the Enter key.

You can also use formulas to quickly get a line break and start something in a new line using a formula. In Excel 2016 and later versions you can use the TEXTJOIN formula and in prior versions, you can use the simple CONCATENATE formula or the & sign.

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 view and compare two sheets side by side in Excel (in the same view).

This can be made possible by using the NEW Window functionality in Excel. When you use the New Window option, it creates an exact replica of the workbook.

This means that you have two exact same workbooks open at the same time. Now you can arrange these vertically and view these side by side.

You can also enable synchronous scrolling for each worksheet.

This is a great way to view and compare different sheets in the same Excel file, or view different parts of the dataset in the same view.

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 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