Microsoft Excel articles
For decades, anyone working with text data in Excel has been limited to the same old functions for separating or parsing text strings. But recently, Excel added three new dynamic array text functions. And they are awesome! The new functions are designed to manipulate text […]
New Excel Functions: TEXTBEFORE, TEXTAFTER, TEXTSPLIT Read More »
Degree of difficulty explanation: Windows Tips DOD (degree of Difficulty) = 1 How To Freeze Panes In Excel Whenever you have either several columns of data or more likely several rows of data, it can be difficult to remember where you are when you have
Lots of folks have opined in the past that Excel has never been a user-friendly application. It is true that Excel has so many powerful features but it can be tough to keep track of them all. Microsoft has listened to these laments and in
A lot of folks are not aware of it but there is a feature in Excel that will allow you to quickly and easily adjust the information that appears in a cell in your worksheet. Sometimes, you just want it to appear a little bit
I think most of us already know when your first cell is just a number and not a formula, Excel will automatically fill in your cells by counting upward by one. Suppose, though, you do not want to apply the Excel autofill formula to each
Follow the steps below to learn how: On your Home tab, in the Style group, click Conditional Formatting Click Highlight Cells Rules. Select the command you would like, (i.e., Between, Equal To Text that Contains, or A Date Occurring). Enter the values you would like
How To Apply Conditional Formatting In Excel 365 Read More »
It just makes sense to work as efficiently in your Excel worksheet as you can. One way to do that is using drop-down lists. Using a drop-down list will allow users to select an item from a list that you have created. Follow the steps
Why would you want to apply data validation to the cells in your Excel worksheet? Well, using data validation will restrict certain data types or values that your users can enter into a cell seems like a good idea to me. Don’t you agree? Follow
How To Add Data Validation To Cells In Excel 365 Read More »
In an earlier post, I told you how to move data from Excel to Access and vice versa. In that post, I told you that you should, if you want a smooth process with glitches, clean your data. Now, I am going to tell you
3D? Really? You can do that in Excel??? Why yes, you certainly can. It is a three-dimensional map that allows you to view your information in newer, more modern ways. So why would you want to use this? Well, there is more than one answer
If you are met with this message when opening a spreadsheet, it’s time to start worrying, especially if you don’t have a backup saved elsewhere. This is exactly what happened yesterday to my wife when she tried to open her most used and valuable spreadsheet
Formulas are those wonderful features in Excel that do all the work for folks like me who are not all that adept dealing with numbers. Am I OK letting the program do that work for me? Heck yeah! Follow the steps below to allow Excel
Do not ask me why, but some users find the Paste icon to be distracting when they are working on an Excel worksheet. It does not bother me but to each his own! Should you be one of those folks it does bother, as was
I do not claim to be an expert in Excel, but I do like to learn about it and use it when warranted. As such, it behooves me to try to keep abreast of what is going on in the world of Excel. In that
