Useful Excel features to work with a lot of data

   1.   For better navigation in the workbook with a large number of sheets or to highlight some important data, it is possible to create hyperlinks to another cell in the same spreadsheet.

See The best way to organize your workbook using hyperlinks for more details.

   2.   If you need to copy the range with blank cells and paste only non-blank cells, Paste special with Skip blanks doesn't work as expected and inserts blank and non-blank cells, and you need to remove blank cells manually. However, a combination of filtering and copy/paste allows you to handle large ranges of cells effectively.

See Copy and paste only nonblank cells for more details.

   3.   For selecting all cells in the sheet, you need just one keystroke or mouse click.

See Quick way to select all cells for more details.

   4.   Filter, Sort, and some other functions don't work well with merged cells, and large unmerging ranges of cells can be tedious, but there is a trick to make it easier.

See Workaround for sorting and filtering of merged cells for more details.

   5.   Viewing the same worksheet in multiple windows arranged horizontally or vertically allows you to review and clean data quickly.

See Viewing a worksheet in multiple windows for more details.

   6.   You can group and ungroup sheets for fast copy/paste and format changes.

See Grouping and ungrouping sheets for more details.

See also this tip in French: Fonctions Excel utiles pour travailler avec de grandes quantités de données.