|
|
| One Day | |
| Using Microsoft Excel To Display Financial Data | One Day |
Aim |
To enable the participant to design and generate a simple spreadsheet. |
Participants |
No prior knowledge of Microsoft Excel but a working knowledge of Windows. |
Content |
Autoformatting Basic charts Basic formulae Centering text over several columns Copying text and formulae Creating a spreadsheet Editing existing text Formatting a cell or range of cells Hiding rows and columns Inserting and deleting ranges, columns and rows Moving between spreadsheets Moving text Page layout Previewing a spreadsheet Printing a spreadsheet Replacing text Saving, closing and retrieving a spreadsheet Selecting text Spelling Text and numbers |
Using Microsoft Excel To Display Financial Data
Aim |
To enable the participant to design a financial spreadsheet using more complex calculations and display the data in a graph. |
Participants |
Working knowledge of Windows and Microsoft Excel. |
Content |
Autoformatting Centering text over several columns Charts Comparing data Copying text and formulae Custom series Formatting a cell or range of cells Formulae Freeze panes Functions Hiding rows and columns Inserting and deleting ranges, columns and rows Moving between spreadsheets Moving text Naming cells Page layout Protection Spelling Spreadsheet design Text and numbers Worksheets |
