Microsoft Excel Level 2
- Duration: 1 Day
- Who is it for: Existing Excel users wishing extend their knowledge to the next level.
This course is suitable for existing Excel users wishing to extend their knowledge and use more powerful analytical features including 3 dimensional (multi-sheet) applications.
Existing users of earlier versions of Excel and other spreadsheet programs, with a good working knowledge of Level 1 techniques, may find this a suitable conversion course.
Delegates should have attended the Level 1 course for this or a previous version of Excel or should have been using this or another spreadsheet package for some time and be fully acquainted with the basics.
On completion of this course, delegates will have gained a level of competence in using some of the more advanced features of Excel, including the linking of worksheets and workbooks, database facilities, lookup and logical test functions.
- Contents:
- Using Multiple Worksheets and Workbooks
- Managing multiple worksheets and workbooks
- Moving and copying data between worksheets
- Linking data between worksheets
- Creating a 3-D formula
- Charting
- Using charts
- Creating a chart
- Managing chart objects
- Advanced Functions
- Creating and using functions
- Working with arguments: the pmt function
- Creating a nested function (using the IF Function)
- Auditing worksheets
- Using the Circular Reference Toolbar
- The Watch Window
- The Formula Evaluator
- Tracing and correcting worksheet errors
- Advanced Formatting
- Using comments in a worksheet
- Working with styles
- Custom number formats
- Applying a conditional format
- Using templates
- Verifying your work
- Working with Lists
- Managing lists
- Using the data form
- Sorting, filtering and using Auto filter
- Using the top 10 feature
- Performing an advanced filter
- Copying filtered data to another location
- Using subtotals
- Using Multiple Worksheets and Workbooks
Computer skills courses