Archive for the Microsoft Excel Category

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 >>

Aug 23 2009

Updated PingCell Function for Excel

This post was previously released under a different blog and is being republished by me below. That site is no longer available. I am the original author.

I’ve updated my Microsoft Excel PingCell code that I published previously. The new function returns all results from Win32_PingStatus back to Excel. You can now ping and choose the results you’d like to see returned (example below code). The Win32_PingStatus class is documented on Microsoft’s Website.
Read More >>

Jul 6 2009

Creating an SMS 2003 CCR within Excel

This post was previously released under a different blog and is being republished by me below. That site is no longer available. I am the original author.

I created the following function to create Microsoft SMS 2003 Client Configuration Requests from within Excel and dump them all out into a temporary directory for me to copy to the SMS inbox. For those that are unaware, you can “ask” SMS 2003 to remotely install the client by putting a CCR file into the INBOXES\CCR.BOX folder on the SMS Site server.
Read More >>

May 8 2009

Generating a List of Values in Excel (VBA)

This post was previously released under a different blog and is being republished by me below. That site is no longer available. I am the original author.

I frequently find myself needing to create lists of values I have in Excel in one cell. For example, I might get have a column of IDs and I need to create a comma delimited list of them to put into a SQL Query. I have the following function I put in an XLA that loads with Excel to generate these lists.
Read More >>