Articles (11)

Avoid Merging Cells

Center across cells to save on sorting and formatting issues

Conditional Formatting

Use conditional formatting to highlight info

Flash Fill

Let Excel automatically fill data when it senses a pattern

How to Transpose Data

Use Transpose to flip data on its side

Keyboard Shortcuts (Excel)

Instead of accessing the toolbar with a mouse, two or three keystrokes are used to perform significant functions.

Number Formats

Control cell formatting from doing math or defaulting to dates

Text to Columns

Separate data into columns from the same cell

Tips for Printing Spreadsheets

How to make spreadsheets look good on paper

Using AutoSum

Let Excel do the math for you

Using the Fill Handle

You can quickly copy formulas into adjacent cells by using the fill handle

Using the Tab Key

Speed up your work with the Tab key