Please enter a date range below to find available courses
From to
Provider: 1816
Excel Learning CDs 2003 Intermediate
Course aim
This course aims to develop skills using Microsoft Excel to produce and spreadsheets to an Intermediate level.
Course outline
THIS COURSE IS DELIVERED VIA LEARNING CDS & CONTAINS THE FOLLOWING TRAINING TOPICS:
BASIC FORMULAS • Formula Syntax • Create Formula • Create & Edit Formulas • Relative Reference • Absolute Reference • Complex Formulas • Formula Rules
FORMULA AUDITING • Tracing • Evaluate Formula • Circle Invalid Data • Watch Window BASIC FUNCTIONS • Function Syntax • Common Functions • Building Functions • Paste Function Box • Paste Function Button • AutoCalculate • Date & Time Functions • Logical Functions
WORKING WITH NAMES • Create Names • Range Names • 3-D Names • Use Names • Range Functions • Paste References • Edit Range ORGANISATION • Worksheets • Copy Worksheets • Consolidate Data • Tab Naming CHARTS • Chart Wizard • Define Data • Layout Options • Position Options • Charting Toolbar • Format Options • 3-D Charts • Modify Data SAVE & PRINT • Save Options • Save As Web Page • View Saved Files • Print Setup • Page Setup Options • Print Area