Tutorials

If Block – Control Structure In Python – Free Python Tutorials

Control Structure In Python – To process the inputs as per user’s requirement, there are some conditional statements available in Python like other languages. They are: if, else and elif block for loop while loop Boolean logic Operator precedence We will discuss the above points one by one. if, else and elif block These are one of …

If Block – Control Structure In Python – Free Python Tutorials Read More »

Formula Auditing in Excel – Free Excel Tutorials

What is Formula Auditing in Excel? Formula Auditing in Excel is an option in that allows you to understand the relationships between various formulas and cells. It maybe done in the following ways: Trace Precedents Trace Dependents Remove Arrows Show Formulas Error Checking Evaluate Formulas Where to Find Formula Auditing in Excel? Select the ‘Formulas’ …

Formula Auditing in Excel – Free Excel Tutorials Read More »

AutoSum in Excel , Sum ,Average , Count , Minimum and Maximum Functions

What is AutoSum in Excel? AutoSum  in Excel, is an option in the ‘Editing’ group under the ‘Home’ menu where you can compute values automatically without having to type the entire formula. The ‘AutoSum’ dropdown list shows you various operations that you can perform like this which are Sum Average Count Maximum Minimum Where to …

AutoSum in Excel , Sum ,Average , Count , Minimum and Maximum Functions Read More »

Customization in Excel Sheet – Free Excel Tutorials

One of the most desirable features of the Microsoft Excel Spreadsheet is that one can customize it according to the needs and purposes of one’s organization. This article is about the different ways in which one may do the Customization in Excel. Following is a list of various customizing features available in Microsoft Excel: Changing …

Customization in Excel Sheet – Free Excel Tutorials Read More »