Excel in an Hour

What is the difference between a formula and a function? What's the structure of each?

Determining when it's best to use formulas vs. functions. Learn how to copy and paste formulas and functions.

Solve common problems using essential functions.

Resize rows/columns, adjusting fonts, colors & alignment.

Change number formats to/from: date, currency/general.

Format cells dynamically based on criteria which you define.

Edit worksheet by adding and removing rows and columns.

Renaming, adding, deleting, moving and copying sheets.

Organize your data using sorts and filters.

Learn how to create title and various options for your chart, adjust data source and change chart type.

Change the way your worksheet appears onscreen. Customize the way data appears when printed.

Useful shortcuts and tips for working with Excel sheets

Useful shortcuts and tips for working with Excel sheets