https://youtube.com/watch?v=ymB0D16AdzQLearn how to remove non-printable characters. When text that was imported from another program contains characters that your operating system might not be able to print, use CLEAN. For instance,…
https://youtube.com/watch?v=nnM850RK8EoDiscover how do I calculate days remaining from today in Excel. You can also extend this technique to answer how to calculate remaining days in a month in excel. It…
https://youtube.com/watch?v=90WAPs38dLUIf you select header and press Ctrl + A, the cursor will scroll down. If you select any cell other than the header, and press Ctrl + A, the cursor…
https://youtube.com/watch?v=vbEXmx9XTKELearn how to compare two tables in Excel To effectively analyze data in Excel, several methods can be employed to compare tables and sheets, highlighting differences and identifying matches. To…
https://youtube.com/watch?v=37i6EDBfGHILearn how to insert blanks space between rows fast!! Here are the steps highlighted in the video. 1) Enter 1 and 2 on the first two records. 2) Populate the…
https://youtube.com/watch?v=k0EG8QlPVLgLearn how I can make vertical in cell bar chart. Essentially, learning how to create vertical bar chart in excel. I will be addressing how do I add a vertical…
https://youtube.com/watch?v=p3UngSCRbK8Learn how to identify or highlight expired and upcoming dates in Excel is important for a lot of retails stores from supermarkets to sale departments to computer parts store. It…
https://youtube.com/watch?v=u-yChPIxP3sIn Excel, learn how to automatically sort when data changes are added. You will also learn if you can automatically sort in Excel, and how do you make a spreadsheet…
https://youtube.com/watch?v=Gx_zm_8OvZELearn how to create am invoice template in Excel. You will learn how to create a simple and auto fill invoice in Excel. If you do this you are essentially…
