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

learn excel in london - formatting

Forum home » Delegate support and help forum » Microsoft Excel Training and help » learn excel in london - Formatting

learn excel in london - Formatting

ResolvedVersion Standard

Addy has attended:
Excel Advanced course
Excel Intermediate course

Formatting

Formatting a worksheet

RE: formatting

Hi Addy,

If you want to format a worksheet you need to use the formatting toolbar. Make sure you can see it by going in to View Toolbar, formatting. It comes up on excel by default so you should see it. This toolbar contains bold, different type of fonts, different font sizes, underline and background and lots more ways to change the way you data looks.

Take a look and if there is anything specific you need to know get back to me.

Thanks

Tracy

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.09 secs.