An Excel Tutorial for Converting Miles per Hour to KM per Hour.

And we are closing the week with another Microsoft Excel Tutorial. I want to show you with this Excel Tutorial how you can convert miles per hour to kilometers per hour and it’s pretty simple.

 

If you want to convert miles per hour to kilometers per hour you’ll need to follow the next steps.

 

I’m starting this Excel tutorial with this column.

 

Excel-tutorial-converting-miles-km-hour-pic1

 

 

Excel-tutorial-converting-miles-km-hour-pic2

 

 

Excel-tutorial-converting-miles-km-hour-pic3

Just click this line to read the rest of this article.

New to the World of Office, XP and Vista Tips & Tricks?

  Here are a few posts the other readers recommend you check out.

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.

 

Just click this line to read the rest of this article.

An Excel Tutorial for Combining the TEXT and the NOW Functions.

I hope you enjoyed yesterday’s Outlook Tutorial but for now you can forget about it because where picking up where we left off with our Microsoft Excel Tutorial week.

 

I explained in the Excel Tutorial for using the TEXT and the TODAY functions that Microsoft Excel saves the dates in his software as a sequential number. Excel needs to do this otherwise the program can’t use that value to calculate with. I explained that sequential numbering started on January 1, 1900. And that January 1, 1900 had the value 1 and May 27, 2008 had the value 39594. This was because of the 39594 days that came after January 1, 1900 till May 27, 2008. Excel uses this same setup for calculating the time. If the number to right of the decimal point is .5, then the value stands for 12:00 noon. If the value would be 1.75 then the real date and time would be January 1, 1900 and 18:00 hours.

Just click this line to read the rest of this article.

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.

 

Just click this line to read the rest of this article.

An Excel Tutorial with a Formula for Checking Future Dates.

Hi folks, I hope you all had a great weekend!! It’s Monday again and it’s the last week of the month and we are having another Microsoft Excel Tutorial week. And I got some great Excel Tutorials lined up for you this week. We covered in the last Excel Tutorial week several Excel Tutorials that had to do with currencies. The last Tutorial we’ve covered that week was a tutorial with a Formula for Calculating the End Date of a Project and we are continuing on this road. This week is going to be about date and time functions in Excel.

 

We are starting the week with an Excel Formula for checking future dates.

 

Just click this line to read the rest of this article.

Print Your Excel Comments.

The last Tip and Trick for this week is an Excel Tip and Trick. Today I want to show you something cool/useful that has to do with the comments in excel. We already know that using comments in MS Excel can be really helpful.

 

Normally you only make the comments in your spreadsheet and you don’t print them. Well you can but the default setting in Excel is that you don’t print them. This is also the case when you right click on the cell and select Show Comment. This way your comment stays open and can you continue to work in your spreadsheet. If you want to print your comments you’ll need to change some settings.

 

Just click this line to read the rest of this article.

Next Page →