How To Do : Microsoft Office Excel - Compare 2 Sets of Data

A bit different thing today, a simple task but greatly helps me in getting my jobs done fast. I am in the middle of housekeeping our Citrix licenses as it needs to be renewed. Due to the fact that we are using User/Device model, some users who are already left the Company might have their ID still utilizing the licenses. By freeing up the licenses, it will help the Company to reduce Operational costs and assign the licenses to the other users. Well, it is almost year end, and everybody is coming up with their plan for performance review, why shouldn't I? ^__^!

Description :

To compare 2 sets of data (Data 01 : all users who are utilizing the licenses, Data 02 : all disabled users id AD). I there are match, it means the users can be removed and the licenses can be released.

How To Do :

1. Launch MS Excel, put the first group of data in Column A
   
   
   
2. Put the second group of data in Column C
   
   
   
3. Put the following formula in Cell B1:
   Syntax : =IF(ISERROR(MATCH(A1,$C$1:$C$5,0)),"",A1)
   
   
   
4. Change the formula a bit so data in Column A could be compared against all data in Column B. In my case as I have 10 data, I changed from $C$5 to $C$10.
   
   
   
5. Next, copy the formula in B1 to B10 (in may case, yours might be more / lesser than that).
   

Read More

Microsoft has removed a feature from Microsoft Office 2010 which quite oftenly being used by end users - that is Microsoft Office Document Imaging ( MODI ). Therefore, as a workaround, MODI can be installed in 2 ways - MDI to TIFF Converter or Installing MODI from SharePoint Designer 2007. For this purpose, we will focussing on getting MODI installed from SharePoint Designer 2007.

Description :
Installing Microsoft Office Document Imaging ( MODI ) from SharePoint Designer 2007.



How To Do :

1.  Download SharePoint Designer 2007 from http://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=21581
   
   
   
2.  Run the installer
   
   
   
   
3.  Extracting file
   
   
   
   
4.  Accept the agreement, and click Continue
   
   
   
   
5.   Click at Customize
   
   
   
   
6.  Put everything as Not Available, at first.
   
   
   
   
7. Now expand Office Tool, and Choose "Run All From My Computer" for Microsoft Office Document Imaging
   
   
   
   
    
8.  So this is how it looks like...
   
   
   
   
9.  Key in Desired location...
   
   
   
   
10.  As well as User Information
    
    
    
    
11. Once all done, click at Install Now
    
    
    
    
12.  Installation in progress.
    
    
    
    
13.  Click Close once installation completed
    
    
    
    
14.  MODI is now installed.
    

Reference :

• http://support.microsoft.com/kb/982760
• http://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=21581

Read More

How To Totally Remove GPO

Assuming you mistakenly created a GPO and want to delete it before your boss hammerring your head (huh?).. Okay, too much drama, so let's change it. You want to housekeep your GPO (again?), and there are some GPOs need to be deleted. You right click at it, press Delete, and this message box prompted. 

Do you want to delete this link? 

This will not delete the GPO itself.

So, are you doing it right? The answer is no. Deleting it from the OU structure will not totally remove the GPO, it only unlink the OG from the GPO.

Description :
Put Citrix servers out of Citrix load (some sort of private mode / maintenance mode).



How To Do :

1.  Within Group Policy Management Console, Go to Group Polcy Objects node. Right clik at the target GPO, and choose Delete
   
   
   
   
   

Read More

Info! Microsoft is Giving Away free eBook!

Microsoft is currently giving away free eBooks from their store, including: Windows 8.1, Windows 8, PowerShell, Server 2012, Exchange, Lync, etc etc.

From what they said, they already surpassed 1 millions downloaded copies, in just 2 days! Which equivalent to 347 copies in a second!

Dont forget to grab your copies from here!

Reference : http://blogs.msdn.com/b/mssmallbiz/archive/2014/07/07/largest-collection-of-free-microsoft-ebooks-ever-including-windows-8-1-windows-8-windows-7-office-2013-office-365-office-2010-sharepoint-2013-dynamics-crm-powershell-exchange-server-lync-2013-system-center-azure-cloud-sql.aspx

Read More