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…
https://youtube.com/watch?v=k8KUQpFRB-kDiscover I can create a progress tracker with animated image in Google Sheet. I will not be using an animated gif in cell, but use logical IF to shuffle the…
https://youtube.com/watch?v=J0VpFDOp6mcDiscover how to highlight active cell in Excel, or otherwise asked as how do I highlight only selected cells in Excel? This tip and trick will also answer how do…
https://youtube.com/watch?v=WUOw2mpp5YUDiscover how to correct a #VALUE! error in the TRANSPOSE function in Excel. We will learn about how do you correct a value error in the Transpose function, and find…
https://youtube.com/watch?v=4r-rm1sxrKwLearn how to group data set real fast in Excel. Group Dataset Into Headers 1) Select cell D3 2) =A2=A3 3) Apply formula to the rest of the rows. 4)…
https://youtube.com/watch?v=ZCI9VXk5D8YLearn how to crosshair highlight in excel, essentially, how to highlight row and column of active cell Here's how to achieve a crosshair cell highlighting effect where both row and…