In the previous post Excel Technique: How To Create Pivot Table about creating Pivot tables in Excel we’ve elaborated how to createsimple Pivot tables in Excel. In the current article we’re moving some further to create Pivot Charts using Pivot Tables. A Pivot chart is a shiny diamond added to MS Excel’s crown. It […]
Continue Reading
Replace any image’s background with the color of your choice, any image you want or render it transparent without any graphics design effort, for free. No strings attached!!! Source: https://www.remove.bg/t/change-backgroundhttps://www.designify.com/
Continue Reading
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
The web as we know today, has evolved rapidly over the last couple of decades. It got inception in 1969, with the creation of ARPNET network by the US Department of Defense. This network was meant to enable computers to communicate with each other using modems connected to the leased telephone lines. ARPNET opened the […]
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
Problem of duplicate records in databases arises when a table doesn’t have a primary or unique key. Nevertheless, its easy to find duplicate records in the table by using “Group By” and “Having” clauses of SQL query. Group by clause is used to group data based upon one or more columns. In our simple example […]
Continue Reading
Progressive Web Apps (PWA) is a modern way to build applications, including mobile apps, using only web technologies and relying entirely on the proficiency and power of the Web platform. Hence a PWA is a web application that captures the benefits of native and web applications. On account of the lack of these capabilities on […]
Continue Reading
Serial numbers are usually required in the very first column of almost every excel sheet. They are the sequence of number normally started from one and incremented by one for each subsequent row, hence providing a unique number to each row. If you’re a regular Excel user and well up in it you may already […]
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