In this video, I will show you the camera tool in Excel, which you can use to create dynamically linked images that update when you change the original data.

You can read more about it here: https://ift.tt/2s4spII

Camera tool is not available by default in Excel, so you need to add it first in the Quick Access Toolbar. Once you have added it, you can create a linked image with a single click.

All you need to do is select the range of cells for which you want to create the image and then click on the camera tool icon in the QAT.

You can place the image on the same sheet or in any other sheet of the workbook.

In case you need to take a snapshot of a chart and create a linked picture, you need to select all the cells around it (in such a way that the chart is within the range of cells.

Once done, simply click on the camera tool icon and it will create a linked picture of the chart.

This tool can be really useful when you want to create a dashboard. You can use these images to quickly take a snapshot and create the dashboard.

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 the fastest way to move rows and columns in Excel.

In most of the cases, people copy the row/columns and then insert them in the place they want it. But you can also simply drag and move rows/columns.

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, learn how to highlight cells with dates that are past the due date.

This can easily be done using the TODAY function in conditional formatting.

In this video, I cover the following two examples:
⏵ How to highlight dates that are past the due date
⏵ How to highlight dates where the due date is in the next 5 days

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 Excel File: https://ift.tt/2IFd37a
Learn about how to use XLOOKUP or VLOOKUP to lookup a rectangular range of lookup values and return a rectangular range of returns values.

View on YouTube

In this video, I will show you how to protect a sheet in Excel but have some cells that are unprotected and can be edited.

This can be useful when you’re sharing the workbook with other people and don’t want them to make any edits in some of the cells. In this case, you can only unprotect some cells and keep rest everything protected/locked.

You can also have a password for a specific range so that only the person with the password can edit that range.

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