Course
Length: One Day
Fees: Training at Client Offices: One delegate: £395 per-day + VAT
Additional delegates attending: £75 each per-day + VATOverview:
Microsoft Excel 97 is a
software application that can be used as a spreadsheet, database, or charting
program. The spreadsheet portion of Excel allows you to perform
sophisticated calculations and create formulas that automatically calculate
answers.
The advantage of using formulas is that when data in the worksheet
changes, all the formulas recalculate automatically. This feature assists you in
developing budgets, forecasting models, creating sales plans, making financial
projections, calculating inventories calculations, generating banking
statements, and basically working with any format involving numbers. Excel can
sort lists and select specific pieces of information based on specified
conditions.
Exploring Excel
 | Working with Excel Windows |
| Working with Worksheets |
Using Basic Workbook Skills
| Creating, Save & Close a New Workbook |
| Selecting Cells with the Keyboard/Mouse |
| Entering data in a Worksheet |
| Using AutoComplete (speed up data entry) |
Working with Cell Ranges
| Selecting Cell Ranges (with Keyboard/Mouse) |
| Entering Values into Cells |
| Using AutoFill (create a series of names/numbers) |
Creating Simple Formulas
| Creating Simple Formulas (basics) |
| Using Sum/Max/Min/Average within Formulas |
| AutoSum Button (Automatically calculate the total of a range of
cells) |
| Formula AutoCorrect (help fix formula errors) |
| Paste Function Button (helps create formulas) |
| AutoCalculate (on-screen calculator) |
| Range Finder (identifies cells used in a formula) |
Formatting Numbers
| Formatting Numbers (bold/italic etc) |
| Currency Style (£/$) / Percent Style (%) |
| Using the Comma Style |
| Increasing/Decreasing Decimal Places |
Copying and Moving Data
| Copy/Cut and Paste |
| Creating an Absolute Reference (cell position does not change when
copied to another location) |
| Filling Cells (copy the contents of a single cell to an adjacent
cell(s)) |
Formatting Cells
| Align Right/Left/Centre Buttons |
| Using the Merge and Centre Button |
| Borders Button / Fill Colour Button |
| Clearing Formats (clear text & formula formats) |
| Conditional Formatting (to emphasise data that meets certain
conditions) |
| Adding/Changing/Deleting a Conditional Format |
Using Page Set-up
| Changing the Page Margins/ Page Orientation |
| Creating/Customising Headers and Footers |
| Printing With/Without Gridlines |
| Repeating Row and Column Headings |
| Using Page Break Preview |
Printing Worksheets
| Preview & Print a Worksheet/ Range |
Formatting Text
| Changing Text Font/Size/Colour |
| Rotating Text /Wrapping Text in a Cell |
Working with Columns and Rows
| Selecting Columns and Rows |
| Inserting/Deleting Columns/Rows |
| Changing the Width/Height of Rows |
| Hiding/Unhiding Columns/Rows (excellent feature for reporting
purposes) |
Using AutoFormat
| Applying an AutoFormat (assign pre-set formats to a range of cells
– coloured text, background, borders, lines etc) |
| Changing the AutoFormat Options (allow/disallow certain formatting
features) |
Using Multiple Workbooks
| Opening Multiple Workbooks |
| Tiling Workbooks (view multiple worksheets) |
| Copying Data between Workbooks/Worksheets |
Using Large Worksheets
| Increasing/Decreasing the Screen Magnification |
| Freezing/Unfreezing Panes (keep row & column headings in view as
you scroll) |
Working with Multiple Sheets
| Selecting & Renaming Worksheets |
| Inserting/Deleting/ Printing Worksheets |
Managing Worksheets
| Copying/Moving Worksheets |
| Using Grouped Worksheets |
| Moving/Copying Data between Sheets |
| Creating 3-D Formulas (totals several sheets) |
Using Paste Special
| Copying Formulas/Values between Sheets |
Creating Charts
| Creating Charts using the Chart Wizard |
| Changing the Chart Type (pie/bar/line) |
| Changing the Plot Direction (column to row) |
| Adding a Data Table |
| Formatting Chart Objects (colours/line styles etc) |
| Changing the Chart Range (selecting new data) |
Editing Charts
| Changing the Chart Type/Sub-Type |
| Adding Chart Titles / Moving the Legend |
If you have other questions, please contact us at
enquiry@it-uk.com or
complete
our response form |
