Microsoft Excel Intermediate
Starting dates and places
Description
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 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 it …
Frequently asked questions
There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.
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 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 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
Share your review
Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate £1.- to Stichting Edukans.There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.