Formula for Combining Different Values into One Date Column.

It is time for the fourth and final Excel tutorial of this Excel week. The tutorials that we’ve covered this week are some pretty cool ones. The first was the tutorial with a formula for checking future dates followed by the Excel tutorial for using the TEXT and the TODAY functions and we discussed yesterday a tutorial for combining the TEXT and the NOW functions.

In today’s Excel tutorial I want to show you how you can combine 3 columns that hold different date values into one column.

It’s a pretty simple formula but its Friday so I don’t believe it’s a real problem. Entering all the data in the spreadsheet takes up most time.

Use the Same Formatting for Multiple Cells, the Easy Way. – Part 2

This next Excel Tip and Trick is a follow-up of the article that I wrote last week about using the same formatting for multiple excel cells. I’m now using also using the Format Painter Tool. In the first article I explained how to copy the format to the second cell and how we can drag the formatting to the cell next to it.

This works great unless the cells don’t connect. I’m using the Format Painter Tool in this Excel Tip and Trick to apply to same formatting in non connecting cells.

For this example I used the same table that I used as the earlier article.

Excel-tip-trick-pic1

Work Faster With a Drop Down List For Auto Filling Your Cells.

In the last couple of months we’ve covered some really cool Excel Tips and Tricks. But more important some of these Excel Tips and Tricks were really useful and will save you lots of time. Some of my personal favorite Excel Tips and Tricks are the Excel formula’s that we used to count all the empty cells, the one to automatically highlight the weekdays, and the Trick for Excel telling you your input so you can check your data. You can imagine that I would publish the Tips and Tricks first that I’m using most often. This is why I was a bit surprised when Danielle send me an e-mail if I could make a tutorial for her with a small explanation about the use of auto-form’s in Microsoft Excel. I’m using the drop down menus in Microsoft Excel quite often and they are real handy, they will save you lots of time so it was quite surprising that I didn’t cover it earlier but if you ask me; better late than never;).

An Excel Tutorial for Using the TEXT and the TODAY Functions.

It’s the second day of the Excel Tutorial week. Yesterday was Monday and Monday is of course the day that we need to take it a bit slow and we did so with an Excel Tutorial with the formula for checking future dates.

Today we are taking it a bit further. It is still kind of a easy Excel formula but it’s too warm you up a bit for later this week, when we are really starting to use Excel for calculating with dates and time spans.

Microsoft Excel Formula to Count all the Cells with Text.

A while back I showed you how to create Formula to Count all the Empty Cells. Not only can it be useful to have a little help counting all the empty cells but an Excel Formula to count all the cells that contain Text and numbers can be just as helpful. This very useful Microsoft Excel Tutorial will do that for you.

This is how you use the Excel “Count” and “Counta” function.

We are going to use two Excel functions within this formula. We are using “Count” for all numeric cells and “Counta” for the text cells.