Excel Tips

Cells and Text

• Concatenate text and values
• Keep the same cell during copying
• Refer to a cell on another sheet
• Name a cell or a range of cells
• Line break in a cell

Dates and Times

• Number of days remaining before a date
• Number of days, months, or years between 2 dates

Miscellaneous

• Import data from a CSV file into Excel
• List all external links of a workbook
• List of Excel errors (#NAME?, #DIV/0, #N/A, #VALUE!, ...)
• Round to 5 cents
• Save in a PDF document

Sheets

• Freeze panes
• Hide row and column headers

Functions

• Create a custom function
• Replace based on an array of values

Ranges and Tables

• Vertically invert a range

More tips are available on the functions page...