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

Multiple entries "(web) staff" showing in OneNote

Mobile Phone

Question:HelloAfter the new SkyDrive came out, I started to experiment with the reorganization of my files and folders that it. Some time later, I noticed that on my Windows Phone (7.5), when I chose to view the OneNote notebooks, I have 6 copies of (web) staff that appear, even if I have only one line.I never used the OneNote other than to test a few notes online and see how they synchronized in...Read More

Posted: 04 May 2012

Tags: Multiple entries web staff showing in OneNote Multiple entries web staff showing OneNote

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