Excel Tutorial Series - Tips & Tricks - JP Software Technologies

Excel Tutorial Series – Tips & Tricks

June 1, 2009 by JP · 361 words · Leave a Comment

This is part seven of the Excel Tutorial Series. Read all tutorial posts by browsing the Tutorial category.

This is the last post in the tutorial series. I will be showing you a few formula tricks, along with resources for further reading, if you want to continue learning about VBA and Excel. I hope you enjoyed all the posts!

Track UPS shipments on your worksheet

Cell A1 contains a UPS tracking number. Put this formula in cell B1:

=HYPERLINK("http://wwwapps.ups.com/WebTracking/processInputRequest?HTMLVersion=5.0&loc=en_US&Requester=UPSHome&tracknum="&A1&"&AgreeToTermsAndConditions=yes&ignore=&track.x=18&track.y=11","Track this shipment")

Click in the cell to open a browser window with the tracking information for this package.

Get Driving Directions

Hopefully you are familiar with my page with driving distance functions. I created the following formula for a ridiculously large client (at my last employer) to print maps and driving directions.

Cells A5 through D5 contain a starting address.

A5: Street Address
B5: City
C5: State
D5: Zip

Cells E5 through H5 contain a destination address.

E5: Street Address
F5: City
G5: State
H5: Zip

This formula will open a browser window with the driving directions, courtesy of MapQuest:

=HYPERLINK("http://www.mapquest.com/directions/main.adp?go=1&do=nw&1a="&$A5&"&1c="&$B5&"&1s="&$C5&"&1z="&$D5&"&2a="&$E5&"&2c="&$F5&"&2s="&$G5&"&2z="&$H5&"&1y=US&2y=US&cid=lfddlink","Driving Directions & Distance")