Excel Tips
Video thumbnail for Create Custom Data Labels. Excel Charting.
Create Custom Data Labels. Excel Charting.

805 views · Jan 27, 2022

howtoexcelatexcel.com

Are you looking to create custom data labels to your Excel chart? Maybe you want to add the title of a song or the name of a magazine. Whatever the reason, it’s easy to do as long as you know how to use formulas. In this video, we’ll show you how to add c

Video thumbnail for Unstack Your Excel Data From Columns To Rows
Unstack Your Excel Data From Columns To Rows

34K views · Jan 27, 2022

howtoexcelatexcel.com

Today I will show you how to unstack data in Excel that looks like the sample data set below WITHOUT Formulas!. I have inherited an Excel worksheet that contains address data. Unfortunately, each address line stacked on top of another makes data analysis

Video thumbnail for Create Custom Data Labels. Excel Charting.
Create Custom Data Labels. Excel Charting.

2K views · Jan 23, 2022

howtoexcelatexcel.com

Are you looking to create custom data labels to your Excel chart? Maybe you want to add the title of a song or the name of a magazine. Whatever the reason, it’s easy to do as long as you know how to use formulas. In this video, we’ll show you how to add c

Video thumbnail for Excel Tip - Create A Dynamic Search Bar In An Excel Cell To Highlight Data
Excel Tip - Create A Dynamic Search Bar In An Excel Cell To Highlight Data

298 views · Jan 14, 2022

howtoexcelatexcel.com

In this Excel Tip Video Learn How To Create A Dynamic Search Bar In An Excel Cell. You can use conditional formatting to create a search bar in Excel along with the SEARCH Function. Download the file to work along here http://www.howtoexcelatexcel.com/y

Video thumbnail for How To Count Cells With Text. Excel Tip.
How To Count Cells With Text. Excel Tip.

2K views · Jan 9, 2022

howtoexcelatexcel.com

In this Excel Tip video, I demonstrate How To Count Cells With Text. So, do you need to count how many cells contain text?. I have used this technique to find how many rows in my Excel data set contain any text. For example, the text references in my da

Video thumbnail for Quick Way To Remove Blanks -Excel Data Tidy Up
Quick Way To Remove Blanks -Excel Data Tidy Up

48 views · Nov 20, 2021

howtoexcelatexcel.com

Read The corresponding blog post below https://howtoexcelatexcel.com/excel-tip-category/quick-way-to-remove-blanks-excel-data-tidy-up/ 𝐉𝐨𝐢𝐧 𝐦𝐞 𝐄𝐕𝐄𝐑𝐘 𝐅𝐑𝐈𝐃𝐀𝐘 𝐟𝐨𝐫 #𝐟𝐨𝐫𝐦𝐮𝐥𝐚𝐟𝐫𝐢𝐝𝐚𝐲 𝐚𝐧𝐝 𝐄𝐕𝐄𝐑𝐘 𝐌𝐎𝐍𝐃𝐀𝐘 𝐟𝐨𝐫 #𝐦𝐚𝐜𝐫𝐨𝐦𝐨𝐧𝐝𝐚𝐲𝐬 𝐨𝐧 𝐭𝐡𝐞 𝐡𝐭𝐭𝐩://𝐰𝐰𝐰.𝐡𝐨𝐰𝐭𝐨𝐞𝐱𝐜𝐞𝐥𝐚𝐭𝐞𝐱𝐜𝐞𝐥.𝐜𝐨𝐦 𝐛𝐥𝐨

Video thumbnail for Excel Tip.  How To Convert Positive To Negative Numbers
Excel Tip. How To Convert Positive To Negative Numbers

419 views · Nov 20, 2021

howtoexcelatexcel.com

In this Excel tip, I share a really fast way of converting a list of positive Excel numbers into negative numbers. You may receive data from another source that contains positive numbers. They may need to be converted from positive to negative. I do th

Video thumbnail for Data Bars Excel.  Too Long?.  Easy Fix!
Data Bars Excel. Too Long?. Easy Fix!

2K views · Nov 20, 2021

howtoexcelatexcel.com

Did you know that you fine-tune your data bars in Excel to adjust the conditional formatting? If your data bars are sitting on top of the value of your cell, you can manually adjust them, so they fit better in your Excel cell. So, you can transform your

Video thumbnail for Draw Shapes In Excel Quickly
Draw Shapes In Excel Quickly

567 views · Nov 20, 2021

howtoexcelatexcel.com

If you draw shapes in Excel for flow charts or diagrams then this Excel trick may help speed things up. Did you know you can use the Lock drawing mode feature to draw multiple shapes one after another? This saves time. A lot of time. So, use lock drawi

Video thumbnail for Super Quick Way To Unprotect Multiple Excel Worksheets
Super Quick Way To Unprotect Multiple Excel Worksheets

324 views · Oct 4, 2021

howtoexcelatexcel.com

𝐉𝐨𝐢𝐧 𝐦𝐞 𝐄𝐕𝐄𝐑𝐘 𝐅𝐑𝐈𝐃𝐀𝐘 𝐟𝐨𝐫 #𝐟𝐨𝐫𝐦𝐮𝐥𝐚𝐟𝐫𝐢𝐝𝐚𝐲 𝐚𝐧𝐝 𝐄𝐕𝐄𝐑𝐘 𝐌𝐎𝐍𝐃𝐀𝐘 𝐟𝐨𝐫 #𝐦𝐚𝐜𝐫𝐨𝐦𝐨𝐧𝐝𝐚𝐲𝐬 𝐨𝐧 𝐭𝐡𝐞 𝐡𝐭𝐭𝐩://𝐰𝐰𝐰.𝐡𝐨𝐰𝐭𝐨𝐞𝐱𝐜𝐞𝐥𝐚𝐭𝐞𝐱𝐜𝐞𝐥.𝐜𝐨𝐦 𝐛𝐥𝐨𝐠 𝐟𝐨𝐫 𝐥𝐨𝐭𝐬 𝐨𝐟 #𝐞𝐱𝐜𝐞𝐥𝐭𝐢𝐩𝐬. 𝐉𝐨𝐢𝐧 𝐭𝐡𝐨𝐮𝐬𝐚𝐧𝐝𝐬 𝐨𝐟 𝐨𝐭𝐡𝐞𝐫 𝐄𝐱𝐜𝐞𝐥 𝐮𝐬𝐞𝐫𝐬 𝐰𝐡𝐨 𝐡𝐚𝐯𝐞 𝐚𝐥𝐫𝐞𝐚𝐝𝐲 𝐣𝐨𝐢𝐧𝐞𝐝 𝐭𝐡𝐞 𝐄𝐱𝐜𝐞𝐥 𝐀𝐭 𝐄𝐱𝐜𝐞𝐥 𝐌𝐨𝐧𝐭𝐡𝐥𝐲 𝐍𝐞𝐰𝐬𝐥𝐞𝐭𝐭𝐞𝐫. 𝟑 𝐅𝐑𝐄𝐄 𝐄𝐱𝐜𝐞𝐥

Video thumbnail for Excel Tip. Show Value And Percent In Same Report- No Formulas!
Excel Tip. Show Value And Percent In Same Report- No Formulas!

33 views · Oct 4, 2021

howtoexcelatexcel.com

👍𝐌𝐲 𝐑𝐞𝐜𝐨𝐦𝐦𝐞𝐧𝐝𝐞𝐝 𝐏𝐢𝐯𝐨𝐭 𝐓𝐚𝐛𝐥𝐞 𝐂𝐨𝐮𝐫𝐬𝐞: 𝐡𝐭𝐭𝐩://𝐰𝐰𝐰.𝐦𝐨𝐭𝐡𝐫𝐞𝐬𝐨𝐮𝐫𝐜𝐞.𝐜𝐨𝐦/𝟏𝟓𝟐-𝟐𝟕-𝟏-𝟒𝟏.𝐡𝐭𝐦𝐥 𝐉𝐨𝐢𝐧 𝐦𝐞 𝐄𝐕𝐄𝐑𝐘 𝐅𝐑𝐈𝐃𝐀𝐘 𝐟𝐨𝐫 #𝐟𝐨𝐫𝐦𝐮𝐥𝐚𝐟𝐫𝐢𝐝𝐚𝐲 𝐚𝐧𝐝 𝐄𝐕𝐄𝐑𝐘 𝐌𝐎𝐍𝐃𝐀𝐘 𝐟𝐨𝐫 #𝐦𝐚𝐜𝐫𝐨𝐦𝐨𝐧𝐝𝐚𝐲𝐬 𝐨𝐧 𝐭𝐡𝐞 𝐡𝐭𝐭𝐩://𝐰𝐰𝐰.𝐡𝐨𝐰𝐭𝐨𝐞𝐱𝐜𝐞𝐥𝐚𝐭𝐞𝐱𝐜𝐞𝐥.𝐜𝐨𝐦 𝐛𝐥𝐨𝐠 𝐟𝐨𝐫 𝐥𝐨𝐭𝐬 𝐨𝐟 #𝐞𝐱𝐜𝐞𝐥𝐭𝐢𝐩𝐬 𝐉𝐨𝐢𝐧 𝐭𝐡𝐨𝐮𝐬𝐚𝐧𝐝𝐬 𝐨𝐟 𝐨𝐭𝐡𝐞𝐫 𝐄𝐱𝐜𝐞

Video thumbnail for Excel Find And Replace Trick. (Match Entire Cell Contents)
Excel Find And Replace Trick. (Match Entire Cell Contents)

164 views · Oct 4, 2021

howtoexcelatexcel.com

In Today's video, I show you how to use the Excel Find and Replace functionality to replace just the values you need to. Need to replace cells with just zero (0), but do not want to affect the cells that just happen to also contain zero (0). This neat #

Video thumbnail for Quick Way To Remove Blanks -Excel Data Tidy Up
Quick Way To Remove Blanks -Excel Data Tidy Up

33 views · Oct 4, 2021

howtoexcelatexcel.com

Read The corresponding blog post below https://howtoexcelatexcel.com/excel-tip-category/quick-way-to-remove-blanks-excel-data-tidy-up/ 𝐉𝐨𝐢𝐧 𝐦𝐞 𝐄𝐕𝐄𝐑𝐘 𝐅𝐑𝐈𝐃𝐀𝐘 𝐟𝐨𝐫 #𝐟𝐨𝐫𝐦𝐮𝐥𝐚𝐟𝐫𝐢𝐝𝐚𝐲 𝐚𝐧𝐝 𝐄𝐕𝐄𝐑𝐘 𝐌𝐎𝐍𝐃𝐀𝐘 𝐟𝐨𝐫 #𝐦𝐚𝐜𝐫𝐨𝐦𝐨𝐧𝐝𝐚𝐲𝐬 𝐨𝐧 𝐭𝐡𝐞 𝐡𝐭𝐭𝐩://𝐰𝐰𝐰.𝐡𝐨𝐰𝐭𝐨𝐞𝐱𝐜𝐞𝐥𝐚𝐭𝐞𝐱𝐜𝐞𝐥.𝐜𝐨𝐦 𝐛𝐥𝐨

Video thumbnail for Resize The Excel Formula Bar
Resize The Excel Formula Bar

6K views · Jul 23, 2021

howtoexcelatexcel.com

This Excel tips video will show you how to Resize The Excel Formula bar. In versions of Excel earlier than 2007, editing a cell that has a lengthy formula or a cell containing lots of text is not easy. It can often block part of your worksheet. In Excel

Video thumbnail for How To Use Emojis In Excel Formulas.
How To Use Emojis In Excel Formulas.

74 views · Oct 4, 2021

howtoexcelatexcel.com

Yes, emojis are everywhere. Even in Excel formulas if you want them to be there. So, if emojis are your thing, follow the instructions in this #Exceltips video to use them in your formulas. This video takes you through how to use the IF Function with Emo

Video thumbnail for Delete Values But Keep Formulas. Reset An Excel Worksheet.
Delete Values But Keep Formulas. Reset An Excel Worksheet.

298 views · Oct 4, 2021

howtoexcelatexcel.com

In this video I will show you how to delete values from cells while keeping the formulas. This will allow you to reset your Excel worksheet. A popular way to set up an Excel spreadsheet is to have input cells (which the user changes) and formula cells

Video thumbnail for Excel Tip.  How To Convert Positive To Negative Numbers
Excel Tip. How To Convert Positive To Negative Numbers

327 views · Oct 4, 2021

howtoexcelatexcel.com

In this Excel tip, I share a really fast way of converting a list of positive Excel numbers into negative numbers. You may receive data from another source that contains positive numbers. They may need to be converted from positive to negative. I do th

Video thumbnail for Delete Values But Keep Formulas. Reset An Excel Worksheet.
Delete Values But Keep Formulas. Reset An Excel Worksheet.

57K views · Jul 19, 2021

howtoexcelatexcel.com

In this video I will show you how to delete values from cells while keeping the formulas. This will allow you to reset your Excel worksheet. A popular way to set up an Excel spreadsheet is to have input cells (which the user changes) and formula cells

Video thumbnail for Create A Timestamp In Excel With Formulas
Create A Timestamp In Excel With Formulas

7K views · Jul 9, 2021

howtoexcelatexcel.com

Learn how to enter an automatic date and timestamp into an Excel worksheet. This Excel tip walks you through how to use a circular reference in Excel to date and timestamp cells in Column B when an entry is made into cells in Column A.

Video thumbnail for Excel Tip Two Ways To Highlight Today's Date In Excel
Excel Tip Two Ways To Highlight Today's Date In Excel

3K views · Jun 25, 2021

howtoexcelatexcel.com

In this Excel Tip Video, let’s look at here a handy Excel Tip if you want to highlight today’s date in your Excel data set. I have found this really useful visually where I have sequential dates and want to see where today’s date sits in the sequence.

Video thumbnail for Convert Positive Numbers To Negative Numbers
Convert Positive Numbers To Negative Numbers

15K views · Jun 16, 2021

howtoexcelatexcel.com

In this Excel tip, I share a really fast way of converting a list of positive Excel numbers into negative numbers. You may receive data from another source that contains positive numbers. They may need to be converted from positive to negative. I do th

Video thumbnail for How To Sum Entire Columns and Rows In Excel
How To Sum Entire Columns and Rows In Excel

687 views · Jun 9, 2024

howtoexcelatexcel.com

In this back to basics Excel video, I show you how three ways to sum entire rows and columns Excel. I demonstrate three methods. 1. Use the SUM Function 2. Use the AUTO SUM Function 3. Use ALT+= keyboard shortcut Watch next video tutorial: https://www