Pivot table is a powerful tool of MS Excel. A PivotTable provides an interactive mechanism to quickly summarize large amount of data. It allows you to; analyze data having up to 1 million rows with just a few mouse clicks. show the results in an easy to read table (Pivot table). modify the report […]
Continue Reading
Working with Sql to query a database is both simple and complex but is an alluring experience for everybody. For the simple requirement it is quite simple and straight forward, but for complex scenarios you have to give a fair amount of thought before finalizing your desired query. Below we’ll walk you through some simple […]
Continue Reading
While developing in IBM/HCL Notes you may stumble across the situations where your search of documents requires more than one key. The custom function placed below provides you with the same facility. Its prototype is pretty simple, it gets the form name, first field name and its key value, and second field name and its […]
Continue Reading
XML is everywhere, and you can’t (and most probably don’t want to) get rid of it. Pulling in data from heterogeneous technologies in a single well defined and widely accepted data format, that is XML, has made a developer’s life far comfortable than ever. PowerShell makes handling XML quite simple. It converts XML elements to […]
Continue Reading
Windows PowerShell is a robust programming platform which has the capability to cover, by and large, everything a developer can imagine. In this article we’ll articulate a little example to get the weather update through RSS feed. This example uses the PowerShell’s Invoke-RestMethod cmdlet to get weather information from BBC Weather update. Invoke-RestMethod cmdlet pulls […]
Continue Reading
Microsoft PowerPoint is a powerful presentation software which uses a collection of slides to demonstrate information for any purpose. It is one of the flagship products of Microsoft Office suite. Microsoft PowerPoint has been around since 1987 and is still the most popular presentation tool in the market. Let’s come to the point. Here is […]
Continue Reading
In order to connect to any local area network (LAN), the first thing every computer requires is the Network Adapter or a Network Interface Card. A network interface card is a computer hardware device that connects a computer to a computer network. Below, we’re going to discover almost all information regarding the connected network adapter; […]
Continue Reading
Window PowerShell is indeed the richest and the most powerful tool to retrieve simple to complex information about your entire computer system. In this article we are going to walk you through a handful of PowerShell cmdlets to find out processor information on your computer. The beauty of Windows PowerShell is that it can be […]
Continue Reading
Windows PowerShell is a command-line shell for Microsoft Windows that is mostly used for system administration. It uses cmdlets (commandlets) that are .NET classes to perform simple to complex administrative tasks. It can access Component Object Model (COM) and Windows Management Instrumentation (WMI) for local, as well as remote administration. PowerShell can also be embedded […]
Continue Reading
A Permutation is a re-arrangement of the elements of an ordered list such that each element in the list assumes every position in the list one by one. A string of length n has n! permutation. Putting it simple, a permutation of a string ABC will be all possible combinations of the characters ABC. There […]
Continue Reading