excel

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel

Excel

resolvedResolved · Low Priority · Version 2003

Eileen has attended:
Excel Intermediate course
Excel Introduction course

Excel

How practical os excel for personal use at home?

RE: excel

Hello Eileen

Thank you for your question and welcome to the forum.

Excel can be used at home for the following:
- creating budgets (recording income, expenses etc)
- tracking payments on mortgages
- to create a database of information that can be sorted or filtered

Kind regards
Amanda

Thu 19 Feb 2009: Automatically marked as resolved.


 

Excel tip:

Formst Excel to display leading zeroes

Select the cells that you want to have displaying leading zeroes.

From the 'Format' menu select 'Cells' (Or Right-click on the selected range and and select 'Format Cells').

In the 'Number' tab click on 'Custom' in the 'Category' window.

In the 'Type:' box enter zeroes that correspond to the size of the required number (eg 5 zeroes).

Click OK.

When you enter numbers into these cells, leading zeroes will be displayed.

eg 123 = 00123

View all Excel hints and tips


Server loaded in 0.08 secs.