|
Lesson 1 : Getting To Know Excel
Starting Excel, Parts Of The Workbook Window, Moving Around The Worksheets, Office Assistant, Worksheet Terminology
Lesson 2: Working With Worksheets
Entering Data, Selecting Cells, AutoComplete, AutoCorrect, Smart Tags
Lesson 3. Managing Worksheets
Moving & Copying Worksheets, Saving Files, Closing Excel, Document Workspaces
Lesson 4. Improving the Look of Your Data
Formatting Rows & Columns, Formatting Numbers, Formatting Text, Applying Borders, Alignment, Autoformat
Lesson 5. Editing Your Worksheets
Cut, Copy & Paste Data, Naming Cells, Hide & Display Cells/Rows/Columns
Lesson 6. Formulae & Functions
Creating, Copying & Editing Formulae, Function Wizard, Absolute & Relative Cell References, AutoSum, AutoCalculate
Lesson 7. Printing
Headers & Footers, Page Set-Up, Page Break Preview, Print Preview, Margins
Lesson 8. Database & List Management
Sorting Data, AutoFilter
Lesson 9. Charts & Pictures
Creating Charts, Chart Wizard, Moving/Resizing Charts, Formatting Charts, Drawing Toolbar, Adding Pictures, Clipart & AutoShapes
Module
4 - ECDL
|
Lesson 1. Formulae & Functions
Creating, Copying & Editing Formulae, Function Wizard, Absolute & Relative Cell References, AutoSum, AutoCalculate
Lesson 2. Managing Worksheets
Moving , Copying & Renaming Worksheets, Templates, Linking Worksheets, Comparing WorkSheets, Document Workspace
Lesson 3. Improving the Look of Your Data
Autoformat, Using Styles, Conditional Formatting,
Lesson 4. Printing
Headers & Footers, Page Set-Up, Page Break Preview, Print Preview, Margins,
Lesson 5. Database & List Management
Sorting Data, AutoFilter, Subtotals, Data Forms,
Lesson 6. Charts & Pictures
Creating Charts, Chart Wizard, Moving/Resizing Charts, Formatting Charts, Drawing Toolbar, Adding Pictures, Clipart & AutoShapes
Lesson 7: Creating Links to Other Applications
Embedding & Linking Objects, Hyperlinks, Managing Links,
Lesson 8: Security & Proofing
Protecting Excel Files, Cell & Worksheet Protection, Digital Signatures, Data Validation, Documentation
|
Lesson 1: Summarise Data Using Consolidation
Using 3-D Formulas, Consolidate Data By Position, Consolidate Data By Category
Lesson 2: Creating Links to Other Applications
Embedding & Linking Objects, Hyperlinks, Managing Links,
Lesson 3: Templates
Using, Creating & Applying Templates
Lesson 4: Summarise & Analyse Data Using PivotTable Reports
PivotTable Reports, PivotChart Reports,
Lesson 5: Analysing Data
What-If Analysis, Goalseek, Data Tables, Scenario Manager, Solver,
Lesson 6: Macros & Custom Controls
About Macros, Creating & Running Macros, Assigning Buttons To Macros, Adding Custom Controls
Lesson 7: Security & Proofing
Protecting Excel Files, Cell & Worksheet Protection, Digital Signatures, Data Validation, Documentation
Lesson 8: Customising Excel
Configuring Excel Options, Customising the Excel Environment, Workspaces
Lesson 9: Collaboration & Consolidation
Sharing Workbook, Sending Workbooks
|
