Microsoft Excel articles
Jan 20
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 in colum B, would turn a bolded red color. He …
Permanent link to this article: http://www.davescomputertips.com/2012/01/sortingfiltering-conditional-format-results/
Jan 05
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 how:
Open the your first worksheet. On the View tab …
Permanent link to this article: http://www.davescomputertips.com/2012/01/need-to-see-two-excel-worksheets-simultaneously/
Aug 17
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 below to learn how:
Launch MS Excel. Open your workbook …
Permanent link to this article: http://www.davescomputertips.com/2011/08/how-to-copy-or-move-microsoft-excel-worksheets-to-another-workbook/
Aug 16
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 same manner.
Well, I found out how to do it …
Permanent link to this article: http://www.davescomputertips.com/2011/08/how-to-create-a-bulleted-list-in-microsoft-excel/
Aug 16
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 it was intended.
One very useful program in the Office …
Permanent link to this article: http://www.davescomputertips.com/2011/08/how-to-create-a-mortgage-calculator-using-microsoft-excel/
