Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

microsoft excel training - formatting

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel training - Formatting

microsoft excel training - Formatting

ResolvedVersion Standard

Andrea has attended:
Excel Introduction course
Excel Intermediate course

Formatting

how to autoformat in 2007

RE: formatting

Andrea

To Autoformat in Excel 2007 you use the Table Style Ribbon which contains a gallery of table styles.

To apply Table styles:

Create a table, and a default table style is applied as soon as a table is created.

If you don

Excel tip:

Calculate age or service

The DATEDIF() function in Excel calculates the number of days, months, or years between two dates. So, this function makes it easy to calculate a person's age. To try this tip:

In a blank worksheet, type the birth date in cell A1, using slashes to separate day, month, and year.
In cell A2, type =DATEDIF(A1,TODAY(),"y") and press ENTER.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.