Excel Tutorials

What Does It Do ? This function examines a list of information and produces the total. Syntax =DSUM(DatabaseRange,FieldName,CriteriaRange) The DatabaseRange is the entire list of information you need to examine, including the field names at the top of the columns. The FieldName is the name, or cell, of the values to be totalled, such as "Value Of Stock" or I3. The CriteriaRange is made up of two types of information.    The first set of information is the name, or names, of the Fields(s) to be used as the basis    for selecting the records, such as the category Brand or Wattage.    The second set of information is the actual record, or records, which are to be selected, such     as Horizon as a brand name, or 10

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

HOLIDAYS DATE MONTH DAY New Year 1 January Tuesday Guru Gobind Singh Jayanti 5 January Saturday Makar sankranti 14 January Monday *Warafaat 25 January Friday Republic day 26 January Saturday Mauni Amavasya 10 February Sunday Basant panchmi 15 February Friday Ravidas jayanti 25 February Monday Maha shivratri 10 March Sunday Holika dahan 26 March Tuesday Holi 27 March Wednesday Good Friday 29 March Friday Ambedkar jayanti, Baisakhi 14 April Sunday Ram navmi 19 April Friday Mahavir jayanti 24 April Wednesday Buddha Purnima 25 May Saturday Rathyatra 10 July Wednesday *Id 1 August Friday Independence day 15 August Thursday Raksha bandhan 21 August Wednesday Shri Krishna Janmashtmi 28 August Wednesday Vishwakarma Puja 17 September Tuesday Gandhi jayanti 2 October Wednesday Pitra visarjan 4 October Friday Vijayadashmi (dussehra) 13 October Sunday *bakrid 16 October Wednesday Deepavali 3 November Sunday *Muharram 15 November Friday Kartik Purnima, Guru Nanak 17 N

Secret Codes For Android Mobile Phones: 1. Complete Information About your Phone *#*#4636#*#* This code can be used to get some interesting information about your phone and battery. Usage statistics 2. Factory data reset *#*#7780#*#* This code can be used for a factory data reset. It'll remove following things: Google account settings stored in your phone System and application data and settings Downloaded applications It'll NOT remove: Current system software and bundled application SD card files e.g. photos, music files, etc. Note: Once you give this code, you get a prompt screen asking you to click on "Reset phone" button. So you get a chance to cancel your operation. 3. Format Android Phone *2767*3855# Think before you give this code. This code is used for factory format. It'll remove all files and settings including the internal memory storage. It'll also reinstall the phone firmware. Note: Once you give this code, there is no wa