Online Tutorials | C#, Python, MySQL, Excel
How to Use the AVERAGE Function and Formula in Excel In this tutorial, you’ll learn how to use the AVERAGE function and formula in Excel. AVERAGE() calculates the average of a group of numbers. AVERAGE Syntax The syntax of the AVERAGE() function is as follows: =AVERAGE (number1, [number2], …) Arguments number1: The first number, ranges, or cell … Read more
How to Use the ROUND Function and Formula in Excel In this tutorial, you’ll learn how to use the ROUND function and formula in Excel. The ROUND() function rounds a number to a specified number of digits. Excel ROUND Syntax The syntax of the ROUND() function is as follows: =ROUND(number, num_digits) Return value A rounded number Arguments number: … Read more
How to find the square root using the Python sqrt() function In this tutorial, you will learn how to find the square root of a number using the sqrt() function in Python. This tutorial will also show you how to find the square root without using the sqrt() function in Python. Absolute value in Python … Read more
How to Use the TRIM Function and Formula in Excel In this tutorial, you’ll learn how to use the TRIM function and formula in Excel. TRIM is a function to remove all spaces from a given text except for single spaces between words. TRIM() removes leading spaces, trailing spaces, and all blank spaces between words. TRIM Syntax =TRIM(text) Arguments Text: … Read more
How to Use the Python slice() Function In this tutorial, you’ll learn how to use the Python slice() function. The slice function returns a slice object representing the set of indices specified by the start, stop, and step arguments. You can use the Python slice() function to slice lists and tuples. Python slice() Syntax The syntax of the slice() function … Read more
How to Write a Hello Word Program in Python In this tutorial, you’ll learn how to write and print a hello world program in Python. This tutorial also provides an example and hello world python script. Python is a simple programming language, so even if you are a beginner or don’t have knowledge of programming … Read more
How to Use the MySQL MIN() Function and Examples In this tutorial, you will learn how to use the MySQL MIN() function. The MIN() function is an aggregate function that returns the minimum value in a group of values. Other aggregate functions in MySQL: MAX() function SUM() function AVG() function COUNT() function If you want … Read more
How to Generate Random Numbers in Python In this tutorial, you’ll learn how to generate a random number in Python. You’ll learn how to generate a random number using different methods with examples. To generate a random number in Python, you can use either the randint or randrange function. Note that you need to import random module to use … Read more
How to Use the RANK Function and Formula in Excel In this tutorial, you’ll learn how to use the RANK function and formula in Excel. RANK() is a function to get the rank of a number in a group of numbers. RANK Syntax The syntax of the RANK() function is as follows: =RANK(number, ref, [order]) Arguments number: … Read more
How to Use the REPLACE Function and Formula in Excel In this tutorial, you’ll learn how to use the REPLACE function and formula in Excel. REPLACE() is a function to replace part of a text string with a new text string based on the number of characters that you specify. Excel REPLACE Syntax The syntax of the REPLACE function … Read more
How to Use the FIND Function and Formula in Excel In this tutorial, you’ll learn how to use the Excel FIND function. FIND is a function to get the position of one text string (find_text) within another text string (within_text) and returns the number of the starting position of find_text in within_text. FIND() Syntax The syntax of the FIND() function … Read more
How to Use the SEARCH Function and Formula in Excel In this tutorial, you’ll learn how to use the SEARCH function and formula in Excel. SEARCH is a function to get the position of one text (find_text) within another text string (within_text). SEARCH returns the number of the starting position of find_text in within_text. SEARCH() Syntax The syntax of the SEARCH() function is as … Read more
How to Use the MATCH Function in Excel In this tutorial, you’ll learn how to use the Excel MATCH function. MATCH is a function to search for a specified value in a range of cells and return a number that represents the relative position. MATCH Syntax The syntax of the MATCH function is as follows: =MATCH(lookup_value, lookup_array, … Read more
How to Use the MySQL MAX() Function and Examples In this tutorial, you will learn how to use the MySQL MAX() function. MAX() is an aggregate function that returns the maximum value in a group of values. Other aggregate functions in MySQL are SUM() function, COUNT() function, MIN() function, etc. For example, suppose you have … Read more
How to Use the INDEX Function and Formula in Excel In this tutorial, you’ll learn how to use the INDEX function in Excel. INDEX() returns a value or a reference to a specified cell from within a range of cells. You can use the INDEX function in two forms. If you want to return to a value of a specified cell … Read more
How to Use the SUM Function in Excel In this tutorial, you’ll learn how to use the Excel SUM function to sum numbers. The SUM function is one of the most commonly used functions in Excel. Many people know very little about Excel functions, but they may hear about this function somewhere. The calculation to get … Read more
Count the Number of Cells Containing Numbers in Excel This tutorial explains how to use the COUNT function to count cells containing numerical values in Excel. In marketing or sales, there are many opportunities to aggregate sales and the number of visitors. Following the COUNTIF function introduced last time, this article explains the COUNT function helpful for … Read more
How to Use the COUNTIF Function in Excel In this tutorial, you’ll learn how to use the Excel COUNTIF function. COUNTIF is a function to count the number of cells in a range of cells that meet a single criterion. You can use it to count cells that contain numbers, dates, or references containing numbers. COUNTIF Syntax The … Read more
How to Use the Excel SUMIF Function In this tutorial, you’ll learn how to use the Excel SUMIF function to sum the numerical values in a range of cells that meet a single condition. The SUMIF function, along with the SUM function and VLOOKUP function, is one of the basic skills in Excel. While the SUM function … Read more
How to Use the MySQL REPLACE Function In this tutorial, you’ll learn how to use the MySQL REPLACE function. REPLACE is a function to replace all occurrences of an old substring within a given string with a new substring. MySQL REPLACE() Syntax The syntax of the REPLACE() function is as follows: REPLACE(string, old_substring, new_substring) Remark String: The string you … Read more