In this video, I will show you how to use Excel Autocorrect to save time in Excel.

Excel autocorrect is a feature that’s built to correct misspelled words or convert some shortcodes into symbols.

In this video, I cover the following examples:
— Get full-text string by using an abbreviation. For example, when you type “abc”, it can automatically change it to ABC Private Limited
— Insert a symbol as soon as you type a shortcode
— Get a full formula as soon as you use a specific text string (shortcode)

You can read more about Excel autocorrect here: https://ift.tt/2BZk9jm

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 show negative numbers in red color and/or with brackets.

This can be done using two methods:
— Conditional Formatting
— Custom Number formatting

Once you decide the format and apply that format (negative numbers showing in red and in bracket), it would automatically be applied to all any changes that happen.

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

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 three ways to create a histogram chart in Excel.

The following three methods are covered:
— Using in-built histogram chart option (available in Excel 2016 and later versions)
— Using Data Analysis Toolpak
— Using the FREQUENCY function

A histogram is a chart that you can use to see how many times an event occurs in a given range. For example, you can use it to quickly how many students have scored less than 35 and in 35-50 range, or 50-70 range and so on.

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 add a secondary axis in an Excel Chart.

You can use the recommended chart feature (available in Excel 2013 and later versions). With this feature, it may automatically show you a chart that has a secondary axis. All you have to do is click on that chart and it will be added to the worksheet.

The other way is to manually select the series you want to plot on a secondary axis and select the secondary axis option in the Format Series options.

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