Christopher Kibble's Technical Ramblings
  • Video: How to use VLOOKUP in Microsoft Excel

    2016-03-09 MSOffice Excel

    In this video demo I'm going to show you how use VLOOKUP on a table in Excel. In order to see the text clearly, please set the video to one of the two HD options using the gear icon. Attachment: Using the VLOOKUP Function

    Read More
  • Video: Text Manipulation in Microsoft Excel

    2015-10-19 MSOffice 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 …

    Read More
  • Updated PingCell Function for Excel

    2009-08-24 VBA 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 …

    Read More

Chris Kibble

Technologist, PowerShell, Desktop Engineering, SQL.

Recent Posts

  • Excel COM Error Cant Load Library Fix
  • Running Powerpoint in Windowed Mode
  • Managing Chrome in the Enterprise
  • Setup Google Cloud Certificate Authority - Part 2

Categories

CONFIGURATION-MANAGER 19 PKI 9 POWERSHELL 9 SYSTEMS-ADMINISTRATION 9 TROUBLESHOOTING 9 CONFERENCES 5 APPLICATION-PACKAGING 4 MSOFFICE 3 ACTIVE-DIRECTORY 2 DOMAINS-AND-HOSTING 2
All Categories
ACTIVE-DIRECTORY2 APPLICATION-PACKAGING4 CONFERENCES5 CONFIGURATION-MANAGER19 DOMAINS-AND-HOSTING2 EXCEL1 GEEKING-OUT1 GOOGLE1 GOOGLE-CHROME1 IPHONE1 JAVA1 MCAFEE-ENDPOINT-ENCRYPTION2 MICROSOFT-DOCS1 MSDOCS1 MSOFFICE3 NINITE1 PKI9 POWERPOINT1 POWERSHELL9 SYSTEMS-ADMINISTRATION9 TROUBLESHOOTING9 WINDOWS-101 YNAB2
[A~Z][0~9]

Series

STANDING-UP-A-CERTIFICATE-AUTHORITY 8 VIDEOS 5 STANDING-UP-A-GOOGLE-CERTIFICATE-AUTHORITY 2 SPEAKING-ENGAGEMENTS 1

Tags

CONFIGMGR 19 POWERSHELL 16 MSOFFICE 11 SQL 9 CA 8 PKI 8 EXCEL 7 MMS 7 GOOGLE 4 AUTOIT 3
All Tags
ACROBAT1 ANKER1 AUTOIT3 BATCH1 CA8 CHROME3 CITRIX1 CONFIGMGR19 DOMAINS2 EDGE1 EXCEL7 FLASH1 GITHUB2 GOOGLE4 IPHONE2 JAVA1 MMS7 MOPHIE1 MSDOCS1 MSIEXEC1 MSOFFICE11 NAS1 NINITE1 NOTEPAD++1 PKI8 POWERPOINT1 POWERSHELL16 SAFEBOOT2 SCCM1 SKYPE1 SONOS1 SQL9 SYNOLOGY1 TRAVEL1 VAMT1 VBA2 VISIO1 VMWARE1 WINDIRSTAT1 WINDOWS-103 YNAB2
[A~Z][0~9]