Microsoft Excel articles
There is an interesting function in Excel worksheets. I know that you are most likely thinking – well most of them are pretty interesting, but this particular function is interesting in that it makes sure that your text is clean. What do I mean by […]
A client recently e-mailed me inquiring about filtering in his Excel worksheet. It seems he had a list of data in column A and one in Column B. He had created a conditional format such that any data that was in column A and also
Sometimes you may need to see two worksheets in the same workbook side by side. I have actually had folks write to me asking how they can do this. I tell them, relax – it isn’t all that difficult. Follow the steps below to learn
Need to See Two Excel Worksheets Simultaneously? Read More »
If you have the need to more or copy a worksheet from one workbook to another it is very easy to do in version 2010. You can use the Move or Copy dialog box to accomplish this task very easily and smoothly. Follow the steps
How to copy or move Microsoft Excel worksheets to another workbook Read More »
I remember a time when I had "Googled" how to create a bulleted list in MS Excel and was very disappointed when all I found was articles telling me that it couldn’t be done. Perhaps you have searched as well and been dead-ended in the
How to create a bulleted list in Microsoft Excel Read More »
Most folks think of the Microsoft Office Suite as something you you have to use at work and perhaps they use it for personal correspondence at home as well. Of course, there are some savvy computer enthusiasts who also use it for myriad purposes, as
How to create a mortgage calculator using Microsoft Excel Read More »
