NEWCASTLE COMPUTER TRAINING

Microsoft  Excel – Introduction (4 Hours)

• Loading Windows and the application package.
• Basic concepts of spreadsheets.
• The Excel screen.
• Overview of the Excel menus, Icons, and Help.
• Opening a Workbook.
• Saving a Workbook.
• GoTo and other methods of moving around the workbook.
• Switching between files using Window.

·         Home.

• Selecting Cells/Ranges For Data Entry
• Named Cells/Ranges.
• Shortcut Menu.
• Entering, Editing, Copying & Moving.
• Copying non-contiguous ranges.
• Linking Spreadsheets
• Extending a series using AutoFill.
• Freezing Panes and Split Screens.
• Formulae including absolute & relative cells.
• Functions including SUM, AVG, MAX, MIN, NOW.
• Formatting: Alignment, Font, Pattern and Borders.
• Page Setup.
• Headers & Footers.
• Printing.