computeexpert1's profile picture. The place where you can learn things about excel

Compute Expert

@computeexpert1

The place where you can learn things about excel

Want to round your number while adding a dollar symbol and thousand delimiters to it? Use the DOLLAR function! Learn how to use this DOLLAR function in excel here: bit.ly/3ne9N79 #Learn #learning #computeexpert


Did you know? You can write a TRUE/FALSE logic value directly in excel. Just type a TRUE or FALSE word in excel and excel will immediately think of it as a TRUE/FALSE logic value! #learning #Excel #computeexpert


Want to compare two texts in excel in case-sensitive manner and get TRUE/FALSE based on the comparison result? Use the EXACT function! Learn how to use the EXACT function in excel here: bit.ly/3niptGw #learning #Excel #computeexpert


Did you know? LEN doesn’t count the characters that show up from your data formatting result! Want to learn more about how to use LEN in excel? Read this: bit.ly/3JLQZ8J #Learn #Excel #computeexpert


Did you know? COUNTIFS/SUMIFS/AVERAGEIFS can replace the function of COUNTIF/ SUMIF/ AVERAGEIF! #learning #Excel #computeexpert


Want to write “not the same as” as a part of your formula criterion in excel? Use the <> symbol. Learn more about the criterion writing in an excel formula here: bit.ly/3zwLCWl #Learn #Excel #computeexpert


Want to add border lines on the outside of your cell/cell range? Highlight the cell/cell range and then press Ctrl + Shift + & (Command + Option + 0 in Mac) buttons! #learning #Excel #computeexpert


Need to change your date writing format in excel by using a function? Use the excel TEXT function to help you with that! Learn completely about the way to use the TEXT function in excel here: bit.ly/3HpLScj #learning #Excel #computeexpert


Did you know? In excel 2019, there is this IFS function that you can use to replace nested IFs. Learn how to use the IFS function in excel 2019 here: bit.ly/3FoMTRy #Learn #Excel #computeexpert


Did you know? You can input up to 64 IFs in a nested IF formula writing in excel. Is this enough to get the result you want in excel? #learning #Learn #computeexpert


Did you know? You can input up to 127 criteria into COUNTIFS, SUMIFS, and AVERAGEIFS functions in excel. Is this enough to accommodate all the calculation criteria you have in excel? #learning #Excel #computeexpert


Need to duplicate an object in excel with its relative position fast? Choose the object and press Ctrl + D (Command + D in Mac)! #learning #Excel #computeexpert


Need to represent a new text line in your formula writing in excel? Type CHAR(10) in your formula! #Learn #Excel #computeexpert


Need a formula to convert your number into its words form in excel? Here is a tutorial from Compute Expert that discusses about the formula completely: bit.ly/3y2Otpa #Learn #Excel #computeexpert


This account does not follow anyone

United States Trends

Loading...

Something went wrong.


Something went wrong.