Intermediate Microsoft Excel
 |
|
Date: 30-09-2010 Duration: 1 Day Location: Limerick Cost: €100 Members, €130 Non Members To book this Event or make an enquiry click this button. |
 |
Course Overview:
This Microsoft Excel Intermediate Training Course, to be delivered in Limerick, is designed for anyone who wants to improve his or her knowledge of Microsoft Excel. Participants will learn topics, which will improve their efficiency and productivity in the work place.
Pre-requirements:
Basic knowledge of MS Excel is recommended. Basic PC skills an advantage.
Participants Study:
- Worksheets a further look
- Further Formatting Techniques
- Further Formulas and Functions
- Database and List Management
- Creating Charts
- Drawing and Picture Objects
- Ms Excel and other Microsoft Applications
Course Outline:
Worksheets, A Further Look
- Customising the View Option
- Hiding/Unhiding Workbooks & Worksheets
- Freezing & Unfreezing panes
- Grouping and ungrouping worksheets
Further Formatting Techniques
- Using Styles
- Conditional Formatting
- The Format Painter
- Printing Gridlines
Further Formulas and Functions
- Using the Series Command
- Using the Insert Function Wizard
- Using the Excel Function Categories
- Correcting Formulas
- The Formula Auditing Toolbar
- The Watch Window
Database and List Management
- What is a database?
- Excel database terminology
- Creating, Editing and Navigatging a Database
- Sorting an Excel Database
- AutoFilter
- Advanced Filters
- Using Filtered Data
- Creating Subtotals
- Using Data Forms
Creating Charts
- The Chart Wizard
- Selecting Chart Type
- Specifying the Data Source
- Customising the Chart
- Working with Charts
- Changing the Chart Type
- Adding and Removing Data
- Moving, Re-sizing and Deleting Charts
- Formatting Charts
Drawing and Picture Objects
- Working with Autoshapes
- Creating Text Boxes
- Adding Pictures
- Layering Objects
- Grouping and Ungrouping Objects
Ms Excel and other Ms Applications
- Converting Files
- Embedding and Linking Objects
- Hyperlinks
- Managing Links
