Create Custom Data Labels. Excel Charting.
Jan 27, 2022
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
Unstack Your Excel Data From Columns To Rows
Jan 27, 2022
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
Create Custom Data Labels. Excel Charting.
Jan 23, 2022
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
Excel Tip - Create A Dynamic Search Bar In An Excel Cell To Highlight Data
Jan 14, 2022
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
How To Count Cells With Text. Excel Tip.
Jan 9, 2022
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
Quick Way To Remove Blanks -Excel Data Tidy Up
Nov 20, 2021
Read The corresponding blog post below https://howtoexcelatexcel.com/excel-tip-category/quick-way-to-remove-blanks-excel-data-tidy-up/ 𝐉𝐨𝐢𝐧 𝐦𝐞 𝐄𝐕𝐄𝐑𝐘 𝐅𝐑𝐈𝐃𝐀𝐘 𝐟𝐨𝐫 #𝐟𝐨𝐫𝐦𝐮𝐥𝐚𝐟𝐫𝐢𝐝𝐚𝐲 𝐚𝐧𝐝 𝐄𝐕𝐄𝐑𝐘 𝐌𝐎𝐍𝐃𝐀𝐘 𝐟𝐨𝐫 #𝐦𝐚𝐜𝐫𝐨𝐦𝐨𝐧𝐝𝐚𝐲𝐬 𝐨𝐧 𝐭𝐡𝐞 𝐡𝐭𝐭𝐩://𝐰𝐰𝐰.𝐡𝐨𝐰𝐭𝐨𝐞𝐱𝐜𝐞𝐥𝐚𝐭𝐞𝐱𝐜𝐞𝐥.𝐜𝐨𝐦 𝐛𝐥𝐨
Excel Tip. How To Convert Positive To Negative Numbers
Nov 20, 2021
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
Data Bars Excel. Too Long?. Easy Fix!
Nov 20, 2021
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
Draw Shapes In Excel Quickly
Nov 20, 2021
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
Super Quick Way To Unprotect Multiple Excel Worksheets
Oct 4, 2021
𝐉𝐨𝐢𝐧 𝐦𝐞 𝐄𝐕𝐄𝐑𝐘 𝐅𝐑𝐈𝐃𝐀𝐘 𝐟𝐨𝐫 #𝐟𝐨𝐫𝐦𝐮𝐥𝐚𝐟𝐫𝐢𝐝𝐚𝐲 𝐚𝐧𝐝 𝐄𝐕𝐄𝐑𝐘 𝐌𝐎𝐍𝐃𝐀𝐘 𝐟𝐨𝐫 #𝐦𝐚𝐜𝐫𝐨𝐦𝐨𝐧𝐝𝐚𝐲𝐬 𝐨𝐧 𝐭𝐡𝐞 𝐡𝐭𝐭𝐩://𝐰𝐰𝐰.𝐡𝐨𝐰𝐭𝐨𝐞𝐱𝐜𝐞𝐥𝐚𝐭𝐞𝐱𝐜𝐞𝐥.𝐜𝐨𝐦 𝐛𝐥𝐨𝐠 𝐟𝐨𝐫 𝐥𝐨𝐭𝐬 𝐨𝐟 #𝐞𝐱𝐜𝐞𝐥𝐭𝐢𝐩𝐬. 𝐉𝐨𝐢𝐧 𝐭𝐡𝐨𝐮𝐬𝐚𝐧𝐝𝐬 𝐨𝐟 𝐨𝐭𝐡𝐞𝐫 𝐄𝐱𝐜𝐞𝐥 𝐮𝐬𝐞𝐫𝐬 𝐰𝐡𝐨 𝐡𝐚𝐯𝐞 𝐚𝐥𝐫𝐞𝐚𝐝𝐲 𝐣𝐨𝐢𝐧𝐞𝐝 𝐭𝐡𝐞 𝐄𝐱𝐜𝐞𝐥 𝐀𝐭 𝐄𝐱𝐜𝐞𝐥 𝐌𝐨𝐧𝐭𝐡𝐥𝐲 𝐍𝐞𝐰𝐬𝐥𝐞𝐭𝐭𝐞𝐫. 𝟑 𝐅𝐑𝐄𝐄 𝐄𝐱𝐜𝐞𝐥
Excel Tip. Show Value And Percent In Same Report- No Formulas!
Oct 4, 2021
👍𝐌𝐲 𝐑𝐞𝐜𝐨𝐦𝐦𝐞𝐧𝐝𝐞𝐝 𝐏𝐢𝐯𝐨𝐭 𝐓𝐚𝐛𝐥𝐞 𝐂𝐨𝐮𝐫𝐬𝐞: 𝐡𝐭𝐭𝐩://𝐰𝐰𝐰.𝐦𝐨𝐭𝐡𝐫𝐞𝐬𝐨𝐮𝐫𝐜𝐞.𝐜𝐨𝐦/𝟏𝟓𝟐-𝟐𝟕-𝟏-𝟒𝟏.𝐡𝐭𝐦𝐥 𝐉𝐨𝐢𝐧 𝐦𝐞 𝐄𝐕𝐄𝐑𝐘 𝐅𝐑𝐈𝐃𝐀𝐘 𝐟𝐨𝐫 #𝐟𝐨𝐫𝐦𝐮𝐥𝐚𝐟𝐫𝐢𝐝𝐚𝐲 𝐚𝐧𝐝 𝐄𝐕𝐄𝐑𝐘 𝐌𝐎𝐍𝐃𝐀𝐘 𝐟𝐨𝐫 #𝐦𝐚𝐜𝐫𝐨𝐦𝐨𝐧𝐝𝐚𝐲𝐬 𝐨𝐧 𝐭𝐡𝐞 𝐡𝐭𝐭𝐩://𝐰𝐰𝐰.𝐡𝐨𝐰𝐭𝐨𝐞𝐱𝐜𝐞𝐥𝐚𝐭𝐞𝐱𝐜𝐞𝐥.𝐜𝐨𝐦 𝐛𝐥𝐨𝐠 𝐟𝐨𝐫 𝐥𝐨𝐭𝐬 𝐨𝐟 #𝐞𝐱𝐜𝐞𝐥𝐭𝐢𝐩𝐬 𝐉𝐨𝐢𝐧 𝐭𝐡𝐨𝐮𝐬𝐚𝐧𝐝𝐬 𝐨𝐟 𝐨𝐭𝐡𝐞𝐫 𝐄𝐱𝐜𝐞
Excel Find And Replace Trick. (Match Entire Cell Contents)
Oct 4, 2021
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 #
Quick Way To Remove Blanks -Excel Data Tidy Up
Oct 4, 2021
Read The corresponding blog post below https://howtoexcelatexcel.com/excel-tip-category/quick-way-to-remove-blanks-excel-data-tidy-up/ 𝐉𝐨𝐢𝐧 𝐦𝐞 𝐄𝐕𝐄𝐑𝐘 𝐅𝐑𝐈𝐃𝐀𝐘 𝐟𝐨𝐫 #𝐟𝐨𝐫𝐦𝐮𝐥𝐚𝐟𝐫𝐢𝐝𝐚𝐲 𝐚𝐧𝐝 𝐄𝐕𝐄𝐑𝐘 𝐌𝐎𝐍𝐃𝐀𝐘 𝐟𝐨𝐫 #𝐦𝐚𝐜𝐫𝐨𝐦𝐨𝐧𝐝𝐚𝐲𝐬 𝐨𝐧 𝐭𝐡𝐞 𝐡𝐭𝐭𝐩://𝐰𝐰𝐰.𝐡𝐨𝐰𝐭𝐨𝐞𝐱𝐜𝐞𝐥𝐚𝐭𝐞𝐱𝐜𝐞𝐥.𝐜𝐨𝐦 𝐛𝐥𝐨
Resize The Excel Formula Bar
Jul 23, 2021
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
How To Use Emojis In Excel Formulas.
Oct 4, 2021
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
Delete Values But Keep Formulas. Reset An Excel Worksheet.
Oct 4, 2021
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
Excel Tip. How To Convert Positive To Negative Numbers
Oct 4, 2021
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
Delete Values But Keep Formulas. Reset An Excel Worksheet.
Jul 19, 2021
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
Create A Timestamp In Excel With Formulas
Jul 9, 2021
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.
Excel Tip Two Ways To Highlight Today's Date In Excel
Jun 25, 2021
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.
Convert Positive Numbers To Negative Numbers
Jun 16, 2021
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
How To Sum Entire Columns and Rows In Excel
Jun 9, 2024
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