Course code: 2E2ExcelI - call 0845 071 2801
Overview
Course duration: 2 days.
By the end of this course you will be able to manage lists, create an Excel model using logical and lookup formulae coupled will adding a third dimension. In addition you will also be able to audit a spreadsheet checking and preventing errors, using the provided manual if required.
This course is run in partnership with 2e2 Training.
Is it right for me?
This course is designed for students who have completed the Excel 2003 Fundamentals Course or have equivalent knowledge. It is not suitable as an introduction for people who have little or no experience with this software.
This course can be run in versions 2000 / 2002 / 2003 and 2007
What will I learn?
What will it cover?
Working With Large Worksheets
- Viewing Options
- Hiding And Displaying Data
- Printing Large Worksheets
Working With Multiple Worksheets
- Using Multiple Worksheets
- Linking Worksheets By Using 3-D Formulas
- Managing Workbooks
Advanced Formulae
- Lookups
- Logical Statements
Advanced Charting
- Chart Formatting Options
- Creating Combination Charts
- Using Graphic Elements
List Management
- Working With Lists
- Sorting And Filtering Lists
- Advanced Filtering
Advanced Formatting
- Borders And Shading
- Using Special Number Formats
- Working With Dates
- Working With Styles
- Other Advanced Formatting
Documenting And Auditing
- Comments And Text Boxes
- Auditing Features
- Protection
- Workgroup Collaboration
Customising Excel
- Changing Options
- Customising Toolbars And Menus