Compute Expert @computeexpert1

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

Happy new year from Compute Expert! #HAPPYNEWYEAR #NewYear2022 #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

Merry Christmas from Compute Expert! #MerryChristmas #Christmas2021 #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