I started posting Excel tips on my Linkedin page in early October 2020, and as of the 16th my "Did you know"post took the form it holds till this day. You can find my posts on Facebook, Instagram and Linkedin, all of which you can access via the links in the right hand column of this website.
-
October 26, 2020 - Did you know that Excel can tell you the date
-
October 23, 2020 - Did you know that Excel can tell you the date
-
October 22, 2020 - Did you know that Excel can tell you the date
EXTENDED EXCELLENT EXCEL TIPS - Febuary 2021
I started posting Excel tips on my Linkedin page in early October 2020, and as of the 16th my "Did you know"post took the form it holds till this day. You can find my posts on Facebook, Instagram and Linkedin, all of which you can access via the links in the right hand column of this website.
-
February 1, 2021 - Did you know ...
Did you know that in #excel you can use something called #sparklines to give you a quick visual graph that will show you how a value is changing over time. Like any graph, sparklines can be colored and adjusted in many different ways.
In our example you will see 8 cities with a several data points. In order to create sparklines for each city do the following:
1. Highlight all the #datapoints in a row.
2. Select Sparklines from the #insert tab
3. Chose which cell you want the sparkline in.
4. Done
​
​
​
​
​
-
February 2, 2021 - Did you know ...
Did you know that it is all right for me to come with a tip this late in the day. While it is my goal to get these out nice and early in the morning, that just does not happen every day. So here we are.
Today's tip:
Lets say that you are given a large list of items that you have found in your warehouse (or other place) and you want to filter it down to only unique items. In the #data tab you can find an icon called #removeduplicates. Simply highlight the range where the items are listed, click the remove duplicates button and then approve. #Excel will tell you how many duplicates it found while automatically removing them from the range. Quick, easy and done.
​
​
​
​
​
-
February 3, 2021 - Did you know ...
Did you know that there is a great way to quickly remove blank rows (or cells or columns) in #excel.
Once again Excel comes to the rescue here. Lets say that you get a set of data, but you get it sent to you with a lot of blank rows that you don't want to be there when you start working with the data.
1. Simply press F5, and then click on #special.
2. Select Blanks, and press #Enter
3. You will get all your blank cells, in the region around your range, highlighted.
4. Right click to delete and thenselect which way you want your range to move.
5. Done
​
​
​
​
​
