Microsoft Excel: Advice tips and practices

Software

Microsoft Excel is one such program that is used by each person at some point in his life. It is a program that uses binary digits and a lot of esoteric secrets. Here are some useful Microsoft Excel tips and tricks:Delete blank lines: If there is a set of data separated by blank rows or cells, these should be deleted. The standard procedure is to select the column, press F5, click Special, and then...Read More

Posted: 11 May 2012

Tags: Microsoft Excel Advice tips and practices Microsoft Excel Advice tips and practices

Apache Subversion Insider Tips

Software

So, you have to address the use of Subversion in your development on a daily basis; you have read on best practices, and even branching and merging is no longer giving you nightmares - but are fully take you advantage of all Subversion has to offer? In this post, we look at some useful features, but often overlooked Subversion.Return to commandThe Subversion repository remembers any changes to files...Read More

Posted: 09 May 2012

Tags: Apache Subversion Insider Tips Apache Subversion Insider Tips

MS Excel tips - count how many numbers in your Excel list are above average

Software

The function COUNTIF in Excel counts the number of cells in a range of cells that meet a given criteria. The range is the range of cells you want to count cells and the criteria are the criteriain in the form of a number, expression, the reference cell or text that defines which cells in the selected range will be taken into account.For example, the criteria could be the next 13, "14", B2, "> =...Read More

Posted: 03 May 2012

Tags: MS Excel tips count how many numbers in your Excel list are above average Excel tips count how many numbers your list are above average

10 Tips on the conversion of MS SQL queries for MySQL

Software

When the migration of Microsoft SQL databases to MySQL server, it is often necessary to translate the SQL queries based on the same MySQL syntax. The MS SQL and MySQL SQL query syntax are similar but not identical. This article discovers 10 most popular differences between MS SQL and MySQL syntax. The target audience of this guide should have knowledge of General database management and experience...Read More

Posted: 02 May 2012

Tags: 10 Tips on the conversion of MS SQL queries for MySQL Tips the conversion SQL queries for MySQL

10 Tips to merge in Apache Subversion

Software

A quick search on Google will discover countless stories of the hell of the merger in Apache Subversion but, when used properly, the branching and merging can be a valuable tool for developers of Subversion. Essentially, a merger is the differences between two different revisions and applies the path copy of work, using various calls of the SVN merge command. A merger never creates a new version,...Read More

Posted: 01 May 2012

Tags: 10 Tips to merge in Apache Subversion Tips merge Apache Subversion