Compute Expert
@computeexpert1
Followers
4
Following
4
Media
10
Statuses
382
The place where you can learn things about excel
Joined March 2014
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: #Learn #learning #computeexpert.
0
0
0
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.
0
0
0
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: #learning #Excel #computeexpert.
0
0
0
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: #Learn #Excel #computeexpert.
0
0
0
Did you know? COUNTIFS/SUMIFS/AVERAGEIFS can replace the function of COUNTIF/ SUMIF/ AVERAGEIF!. #learning #Excel #computeexpert.
0
0
0
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: #Learn #Excel #computeexpert.
0
0
0
Have you ever utilized the paste special format feature in excel before?. #learning #Excel #computeexpert.
0
0
0
Next, choose Formatting. Your cell/cell range format will immediately be copied!. #learning #Excel #computeexpert.
1
0
0
Just highlight the cell/cell range from where you want to copy the format and press Ctrl + C. Then, highlight the cell/cell range to where you want to copy the format. Click the Paste dropdown button in the Home tab. #learning #Excel #computeexpert.
1
0
0
Want to copy the format of a cell/cell range in excel? Use the Paste Special Formats feature in excel!. #learning #Excel #computeexpert.
1
0
0
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.
0
0
0
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: #learning #Excel #computeexpert.
0
0
0
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: #Learn #Excel #computeexpert.
0
0
0
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.
0
0
0
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.
0
0
0
0
0
0
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.
0
0
0
Need to represent a new text line in your formula writing in excel? Type CHAR(10) in your formula!. #Learn #Excel #computeexpert.
0
1
0
0
0
0
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: #Learn #Excel #computeexpert.
0
0
0