Excel Tutorials

1>> Round Function =ROUND(cell,number of digits to round) i.e. cell D2 = 45.256 =round(d2,1) would return 45.3 =round(d2,2) would return 45.26 =round(d2,-1) would return 50 =round(d2,-2) would return 0 2>> Payment Function =PMT(interest rate,total number of payments,principal,future value,type) Type is a 0 or 1 indicting when the payment is due. 0 or omitted = At the end of the period 1 = At the beginning of the period Future value and type are optional arguments. Note: be sure interest for year is divided by 12 Note: PMT function should be preceded by a minus to display a positive number. 3>> Countif Function The countif function will count how many cells within a range meet the criteria or test. COUNTIF(range,criteria) Range = range to check Criteria = test 4>> If Function A simple If function will allow a cell to change depending on a conditional test. =IF(test, what to do if it is true, what to do if it is false) 5>> Embedded If

15 Top Paying Certifications for 2013 Randy Muller, Global Knowledge Instructor, MCT, MCSE, MCSA, MCDST January 2013 Having earned an IT certification, many individuals think they are automatically entitled to a huge raise. The truth is that several factors, including geography, industry, experience, and yes, certifications, combine to play a major role in determining an individual's salary. However, certain certifications do have greater impact on the earning potential of an individual. Here, we take a look at the 15 certifications with the highest earning potential for 2013. Note: The rankings below are derived from certifications that received the minimum number of responses to be statistically relevant in the Global Knowledge annual salary survey completed in October 2012. Certain certifications pay more, but are not represented due to their exclusive nature. These include CCIE: Cisco Certified Internetworking Expert and VCDX: VMware Certified Design Expert, for examp

Which are the keywords Indians are searching in Google ? If you want to know then, here is the latest Google Zeitgeist 2012 India data. It gives top ten keywords in different categories like Searches, Most searched people, Most Searched Movies, Most Searched Places, Most Searched News, Most Searched cities etc. You can also find the last years searches here to compare it. Searches IBPS Gate Exams Sunny Leone Ek Tha Tiger Rowdy Rathore Cbse Rajesh Khanna Aakash Tablet Hdfc Jabong People Sunny Leone Rajesh Khanna Poonam Pandey Alia Bhatt Nirmal Baba Sherlyn Chopra Yash Chopra Saif Ali Khan Diana Penty Vilasrao Deshmukh Movies Ek Tha Tiger Rowdy Rathore Jannat 2 Housefull 2 Raaz 3 Jism 2 Barfi Ishaqzaade Agent Vinod Vicky Donor News Sensex Vilasrao Deshmukh Death Hurricane Sandy Anna Hazare Aseem Trivedi Cartoons Abhishek Manu Singhv Kingfisher Airlines Earthquake In Chennai Pranab Mukharjee President Rajesh Khanna Death Local Places