Posts Tagged Excel

Mar 9 2016

Video: How to use VLOOKUP in Microsoft Excel

In this video demo I’m going to show you how use VLOOKUP on a table in Excel.

 

Read More >>

Oct 19 2015

Video: Text Manipulation in Microsoft Excel

In this video demo I’m going to show you how concatenate strings, as well as the functions LEFT, MID, RIGHT, FIND, TRIM, and LEN, and then how to use them together to get what it is you’re looking for. At the end of the demo, we’ll touch on the IF function and show you how you can manipulate the table based on some set of criteria.

 

Read More >>

Jun 3 2015

Creating an SCCM Collection from an List of Computers in Excel

I frequently use this trick to manage collections of computers in SCCM where the original list comes from Excel, or from a query of another system that I can dump into Excel.  Doing it this way, you don’t have to rely on adding computers one at a time to a collection query or dumping systems into tools like the the ConfigMgr 2012 Right Click Tools (which by the way are awesome).  One thing to note is that you’re adding systems by name when you do it in a query, and not as direct adds.  This may or may not be your desired state, just something to keep in mind.

Read More >>