Impress your coworkers with these nifty tricks.

Stop sacrificing screen space—Excel tables, Watch Window, Focus Cell, and split views keep context without locking rows.

The Pivot Table is a tool that Excel uses to create custom reports from your spreadsheet databases. Once you select the portion of your spreadsheet that contains the target data, then define it as a ...