Search the Toolbox

Search

Categories: Air Force (USAF), Army (USA), Coast Guard (USCG), Defense Logistics Agency (DLA), Federal Government, Marine Corps (USMC), Navy (USN)

Excel Time Saving Tips (Free Videos)

How to use some basic Excel commands

Link to site	logtool.com
Account required	Yes

These videos guide you through using MS Excel's Text to Columns, Replace, Removing Duplicates, The Exact and VLOOKUP commands and how to set up a Pivot Table. For easy viewing, right-click on the below links (which will open a new tab or window) which go to the DoD milSuite website, enter your CAC PIN and the videos will start playing instantly. Or if a higher resolution video is needed, go to the bottom of the page and download the full video from the My NAVSUP server.

Help for registering for the My NAVSUP server is located at:
https://www.navsup.navy.mil/public/ops$public.access_self_help

Importing R-Supply JSL311 into Excel

https://www.milsuite.mil/video/watch/video/39814

Using Text to Column for Delimited Files

https://www.milsuite.mil/video/watch/video/39816

Using Text to Column for Fixed Width Data

https://www.milsuite.mil/video/watch/video/39825

Using the Excel Import Function

https://www.milsuite.mil/video/40117

How to use Replace

https://www.milsuite.mil/video/watch/video/39820

Preparing for VLOOKUP