20 year anniversary
Close

Search the Toolbox

Excel Time Saving Tips (Free Videos)

How to use some basic Excel commands

Link to sitelogtool.com
Account requiredYes

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

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

Using the VLOOKUP Command

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

Using the Exact Command

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

Removing Duplicates

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

How to create a Pivot Table

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

Fixing Leading Zeros on NIINs

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

Practical application of the VLOOKUP Command

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

 

 

Print
26945 Rate this article:
4.3
Team Rubicon Logo
Back To Top