Article on the subject of "excel function"
-
Difference between REPLACE and SUBSTITUTE in Microsoft Excel
replace and substitute are two common functions with quite similar names in excel. however, the way to use replace & substitute is different.
-
CONCAT vs. TEXTJOIN: Which function should I choose to concatenate data?
both concat and textjoin help you to concatenate data in different cells. let's learn how to use tipsmake.com.com, the difference between them to see which function you should choose to join the data!
-
Common mistakes in using Excel functions
here are some common errors in using excel functions and how to fix them, so you can better understand and know how to fix errors when making them.
-
The SUMIFS function, how to use multiple conditional calculation functions in Excel
the sumifs function in excel calculates multiple conditions, combining multiple conditions.
-
How to capitalize the first letter in Excel
initial capitalization in excel is mandatory with proper nouns and proper names.
-
How to use the AVERAGE function in Excel
average function on excel will calculate the average of the data in the spreadsheet.
-
Ways to round numbers in Excel
to round numbers in excel, we can use different functions, with different rounding types.
-
How to use COUNTIF function on Excel
the countif function on excel is the cell count function to satisfy the given condition, often used in statistics tables.
-
How to add computers to Excel
to perform complex calculations on excel or even change units, we can install computers on excel.
-
How to use the TEXTJOIN function in Excel 2016
the textjoin function concatenates text from multiple ranges and / or strings, which includes a delimiter between the connected text value. if the delimiter is an empty text string, this function effectively matches the ranges.
-
How to use the SUM function to calculate totals in Excel
sum is a popular and very useful excel function, and is also a basic arithmetic function. as its name suggests, the sum function is used to calculate totals in excel. and the parameters can be single parameters or ranges of cells. in this article, tipsmake.com will guide you to use the sum
-
Save time with these text formatting functions in Microsoft Excel
microsoft excel is a main application for anyone who has to work with numbers, from students to accountants. but its usefulness extends beyond a large database, it can do a lot of great things with text. the functions listed below will help you analyze, edit, convert, change text and save many
-
How to use the IF function in Excel
the if function in excel checks for a true or false condition. if the condition is true, the function returns a value, if the condition fails the function returns another value
-
How to use the LEN function in Excel
the len function in excel is used to measure the length of a certain string of characters, including spaces and correctly return the total character for the user.
-
How to use AVERAGEIF function in Excel
averageif function on excel is a conditional plus average function in the data table, with the given conditions set by the user.
-
How to use the DAVERAGE function in Excel
daverage in excel is a function that calculates the average value of data with given conditions in a spreadsheet. so, how to use this function?
-
MS Excel 2007 - Lesson 6: Calculation in Excel
excel supports many calculation functions, logic functions for calculating, filtering, collating and analyzing data. this is also a feature that makes excel an indispensable tool for office jobs. in this article, tipsmake.com will show you how to use the overview calculation function in excel
-
Basic Excel functions that anyone must know
the basic functions in excel such as the excel function, the excel statistics function we summarized below will be very helpful for you who often have to work on excel spreadsheets, especially in the field of accounting. let's refer to offline.
-
The Index function in Excel: Formulas and usage.
the index function in excel is widely used in spreadsheets today. below is a detailed guide on how to use the index function in microsoft excel.
-
Basic Excel functions that anyone must know
the basic functions in excel such as the excel function, the excel statistics function we summarized below will be very helpful for you who often have to work on excel spreadsheets, especially in the field of accounting. let's refer to offline.
-
How to use Hlookup function on Excel
hlookup function basically also has the function syntax and features like vlookup function, which is to help users find data in excel table, with the conditions or given information. here is the guide for using the hlookup function in detail.
-
How to use the SUM function to calculate totals in Excel
sum is a popular and very useful excel function, and is also a basic arithmetic function. as its name suggests, the sum function is used to calculate totals in excel. and the parameters can be single parameters or ranges of cells. in this article, tipsmake.com will guide you to use the sum
-
DATE Function: Converts numbers to a valid date format
the date function in excel is a useful and most commonly used function. let's learn how to use the date function in excel with tipsmake.com.com!
-
The IF function in Excel: Syntax and specific examples of the IF function.
the if function in excel is a frequently used conditional function. here's what you need to know about the if statement in excel.
-
How to use the LEN function in Excel
the len function in excel is used to measure the length of a certain string of characters, including spaces and correctly return the total character for the user.
-
6 Conditional Functions That Make Excel Spreadsheets Smarter
if your formulas get complex, conditional functions are a smarter choice, hidden in plain sight.
-
How to use COUNTIF function on Excel
the countif function on excel is the cell count function to satisfy the given condition, often used in statistics tables.
-
How to use the MOD function and QUOTIENT function in Excel
injury in excel has many ways of doing it, can be used manually or using the calculation function.
-
8 little-known Excel functions that can save you a lot of work
even seasoned excel users often find themselves stuck performing tasks manually that could be automated with a few clever functions.
-
How to use MID functions to get strings in Excel
mid function in excel is a function that takes the middle character string corresponding to the value that the user requires to perform.
-
MAP function in Excel
the map function is part of excel's dynamic array functions and requires excel 365 or excel 2021 or later to work. if you're using an earlier version, you won't see this function available.
-
How to use Excel's VALUE function
excel's value function will convert a string to a digital form, which can be combined with other functions such as left function, right function, mid function.
-
How to use the IFS function in Excel 2016
the ifs function in excel is a logical function introduced in excel 2016. this function is a function that replaces the nested if function and is much easier to use. the ifs function checks one or more conditions and returns a value that meets the first true condition.
-
How to use the WRAPROWS function in Excel
having trouble with handling large data sets in excel? then learn how to use the wraprows function to split them into more manageable rows.
-
The RIGHT function in Excel: syntax and illustrative examples.
to search for information and retrieve data in excel, in addition to using functions like vlookup, mid, left, etc., you can also use the right function. simply put, the right function in excel retrieves the number of selected characters from the right side of an excel cell. if you don't know the
-
How to use the NPER function in Excel to plan loans and savings
do you want to effectively manage and control your personal finances? then we invite you to learn how to use excel's nper function.
-
How to use the function to delete spaces in Excel
deleting white space with functions in excel makes it easier for users to handle content, instead of traditional editing.
-
How to fix the SUM function doesn't add up in Excel
in the process of summing with sum in excel, you will encounter some errors such as not jumping the number, not adding the sum. so how to handle this problem?