Daily Excel Tip

Tips from 3 designated accountants that, when not changing diapers, watching football or playing hockey, leverage the power of spreadsheets to Excel

[Daily Excel Tip @DailyExcelTip]

@engineers_feed That YouTuber needs to follow us to be more efficient with Excel 😀

[Daily Excel Tip @DailyExcelTip]

Use the formula below to sum the same cell across multiple adjacent sheets

[Daily Excel Tip @DailyExcelTip]

Replace old text with new text using the SUBSTITUTE function. See example below

[Daily Excel Tip @DailyExcelTip]

Use the UPPER(A1) and LOWER(A1) formulas to convert cells containing text to either Upper or Lower case

[Daily Excel Tip @DailyExcelTip]

Excel Shortcuts
Shift + Space -> Selects entire row
Ctrl + Space -> Selects entire column

[Daily Excel Tip @DailyExcelTip]

Use MATCH function to find the position of a value in a range of cells. Note Hockey is positioned 4th in range A2:A8

[Daily Excel Tip @DailyExcelTip]

Always set final parameter in VLOOKUP formula to FALSE to find Exact match. If not "close" match will be returned.

[Daily Excel Tip @DailyExcelTip]

Replace old text with new text using the SUBSTITUTE function. See example below

[Daily Excel Tip @DailyExcelTip]

We also provide Daily Excel Tip's on Facebook. Please Like our page https://t.co/1wZX41u6oc

[Daily Excel Tip @DailyExcelTip]

The following formula will pull all characters left of the @ symbol from an email address
=LEFT(A2,FIND("@",A2,1)-1)

[Daily Excel Tip @DailyExcelTip]

Use the LEN() function if you want to find the number of characters in a text string.

[Daily Excel Tip @DailyExcelTip]

Set a comment to be visible at all times by right clicking on the cell that has comment and click Show/Hide Comments

[Daily Excel Tip @DailyExcelTip]

The =TODAY() function returns today's date, and changes each time you open file to reflect current date

[Daily Excel Tip @DailyExcelTip]

Use this formula to find the file path of your Excel file: =LEFT(CELL("filename"),FIND("[",CELL("filename"),1)-1)

[Daily Excel Tip @DailyExcelTip]

Use the RANK function in Excel to rank the value of a number compared to other numbers in a list.

[Daily Excel Tip @DailyExcelTip]

REPT function will repeat text specified # of times. This formula will repeat cell A1 contents 5 times: REPT(A1,5)

[Daily Excel Tip @DailyExcelTip]

Copy data, select Paste Special, check the Transpose box - this will paste your data with a different orientation

[Daily Excel Tip @DailyExcelTip]

The =COUNTA() function counts cells in a range that are not empty

[Daily Excel Tip @DailyExcelTip]

Use formula below to sum same cell across multiple adjacent sheets. In this example cell C2 is added across sheets

[Daily Excel Tip @DailyExcelTip]

A formula to see if your date cell is a weekday or weekend

=IF(OR(WEEKDAY(A2)=1,WEEKDAY(A2)=7),"Weekend","Weekday")