Working With Dates in Excel
There are two ways to work with dates in Excel, the hard way where you do all the work or the easy way where Excel does all the work for you. If you work with monthly sheets e.g. Jan, Feb, etc. then this tutorial may […]
Microsoft Excel
Microsoft Excel articles
Turn the Legend On and Off in Your Excel Chart
As you most likely already know, when you create a chart in MS Excel, it will automatically create a chart legend for you, depending on which type of chart you have created. You are not, however, limited to using that particular legend. You do not
Specify the Page Printing Order in MS Excel
When the information in your worksheet will not fit on a single page, Excel will break it up for you at row and column boundaries, and then it will print your data on multiple pages. You cannot control the order in which Excel will pring
Underlines in MS Excel
Some folks are not aware that there are several kinds of underlines available in Excel that you can use within your cells. Follow the steps below to learn how: Display the Home tab of your Ribbon. In the Cells group, click the down-arrow under Format
Clean Your Text in Excel
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
Sorting/Filtering Conditional Format Results
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
Need to See Two Excel Worksheets Simultaneously?
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 »
How to copy or move Microsoft Excel worksheets to another workbook
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 »
How to create a bulleted list in Microsoft Excel
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 »
How to create a mortgage calculator using Microsoft Excel
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 »